DR Switch Over
Check and run below on CURRENT PRODUCTION SERVER
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD READ WRITE
SQL> alter system switch logfile;
System altered.
SQL> alter system archive log current;
System altered.
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO STANDBY
connect / as sysdba
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
exit;
After completion of this Run below on Standby Server:
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD MOUNTED
SQL> recover managed standby database cancel;
Media recovery complete.
SQL> recover standby database;
ORA-00279: change 269114126 generated at 02/15/2013 13:27:20 needed for thread
1
ORA-00289: suggestion : /oradata/ABCPRD/arch/ABCPRD_1_5932_785326766.arc
ORA-00280: change 269114126 for thread 1 is in sequence #5932
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 269114341 generated at 02/15/2013 13:30:31 needed for thread
1
ORA-00289: suggestion : /oradata/ABCPRD/arch/ABCPRD_1_5933_785326766.arc
ORA-00280: change 269114341 for thread 1 is in sequence #5933
ORA-00278: log file '/oradata/ABCPRD/arch/ABCPRD_1_5932_785326766.arc' no longer
needed for this recovery
ORA-00308: cannot open archived log
'/oradata/ABCPRD/arch/ABCPRD_1_5934_785326766.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> alter database commit to switchover to primary;
Database altered.
SQL> alter database open;
Database altered.
SQL> select name , open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD READ WRITE
SQL> alter system set log_archive_dest_state_2=enable;
Actions to be performed on Standby Database(Past Primary):
SQL> shut immediate
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 2471931904 bytes
Fixed Size 2230872 bytes
Variable Size 1543505320 bytes
Database Buffers 905969664 bytes
Redo Buffers 20226048 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD MOUNTED
SQL> select name, log_mode, database_role, open_mode from v$database;
NAME LOG_MODE DATABASE_ROLE OPEN_MODE
--------- ------------ ---------------- --------------------
ABCPRD ARCHIVELOG PHYSICAL STANDBY MOUNTED
Check and run below on CURRENT PRODUCTION SERVER
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD READ WRITE
SQL> alter system switch logfile;
System altered.
SQL> alter system archive log current;
System altered.
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO STANDBY
connect / as sysdba
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
exit;
After completion of this Run below on Standby Server:
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD MOUNTED
SQL> recover managed standby database cancel;
Media recovery complete.
SQL> recover standby database;
ORA-00279: change 269114126 generated at 02/15/2013 13:27:20 needed for thread
1
ORA-00289: suggestion : /oradata/ABCPRD/arch/ABCPRD_1_5932_785326766.arc
ORA-00280: change 269114126 for thread 1 is in sequence #5932
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 269114341 generated at 02/15/2013 13:30:31 needed for thread
1
ORA-00289: suggestion : /oradata/ABCPRD/arch/ABCPRD_1_5933_785326766.arc
ORA-00280: change 269114341 for thread 1 is in sequence #5933
ORA-00278: log file '/oradata/ABCPRD/arch/ABCPRD_1_5932_785326766.arc' no longer
needed for this recovery
ORA-00308: cannot open archived log
'/oradata/ABCPRD/arch/ABCPRD_1_5934_785326766.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> alter database commit to switchover to primary;
Database altered.
SQL> alter database open;
Database altered.
SQL> select name , open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD READ WRITE
SQL> alter system set log_archive_dest_state_2=enable;
Actions to be performed on Standby Database(Past Primary):
SQL> shut immediate
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 2471931904 bytes
Fixed Size 2230872 bytes
Variable Size 1543505320 bytes
Database Buffers 905969664 bytes
Redo Buffers 20226048 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ABCPRD MOUNTED
SQL> select name, log_mode, database_role, open_mode from v$database;
NAME LOG_MODE DATABASE_ROLE OPEN_MODE
--------- ------------ ---------------- --------------------
ABCPRD ARCHIVELOG PHYSICAL STANDBY MOUNTED
No comments:
Post a Comment