A flashback restore point is handy for deployments of new code and testing.

Remember: You cannot properly shutdown a RAC database using sqlplus command. Use srvctl commands instead.

Flashback to Restore Point (RAC)

  1. >$ srvctl stop database -d myDB -o immediate
  2. >$ srvctl start instance -d myDB -i myDB1 -o mount
  3. SQL> flashback database to restore point <name of restore point>;
  4. SQL> alter database open resetlogs;
  5. >$ srvctl start instance –d myDB –i myDB2
  6. SQL> select open_mode from v$database;
Tagged: ,