Quick & Efficient Switchover in a RAC Environment!!

 Author: Michael Jim

Page: 1 2 3

Put New Standby to Recovery Mode:

Now we will put our new standby database into recovery mode.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.

Run SWITCHOVER on old Standby:

Now we will switch old standby database to become new primary by running a switchover on the old standby database. If your old standby database is already in the recovery mode then you need to do nothing otherwise you might need to perform some media recovery.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
Database altered.

SQL> ALTER DATABASE OPEN;
Database altered.

Set LOG_ARCHIVE_DESTS Parameter:

Now our new primary database is open and available but still we need to set the LOG_ARCHIVE_DESTS parameter.

Show LOG_ARCHIVE_DEST parameter:

First we will see the value of LOG_ARCHIVE_DEST parameter.

SQL> SHOW PARAMETER LOG_ARCHIVE_DEST

           NAME                               TYPE                               VALUE
------------------------------------     --------                  ------------------------------
log_archive_dest                      string
log_archive_dest_1                 string                  LOCATION=+DATA/PROD/
log_archive_dest_10               string
log_archive_dest_2                 string
log_archive_dest_3                 string
log_archive_dest_4                 string
log_archive_dest_5                 string
log_archive_dest_6                 string
log_archive_dest_7                 string
log_archive_dest_8                 string
log_archive_dest_9                 string

log_archive_dest_state_1      string                             enable
log_archive_dest_state_10    string                             enable
log_archive_dest_state_2      string                             enable
log_archive_dest_state_3      string                             enable
log_archive_dest_state_4      string                             enable
log_archive_dest_state_5      string                             enable
log_archive_dest_state_6      string                             enable
log_archive_dest_state_7      string                             enable
log_archive_dest_state_8      string                             enable
log_archive_dest_state_9      string                             enable Continued...

Page: 1 2 3

 More Oracle Articles, Database Articles and DBA Tips
   Database Security: Step by step guideline
   Some Facts about Oracle Business Strength
   Effective Tips for Materialized Views!!
   Determining Oracle TEMP Size Usage!!
   Some Great Tips on Oracle 11g Encrypted Tablespaces!!