Tuesday, July 23, 2013

ORACLE - Data Guard End-of-Redo

How to verify switchover in primary and standby alert log files ?
alter database commit to switchover to physical standby with session shutdown;

On OLD primary database:Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/hmwprd02/HMWPRD02/trace/HMWPRD02_ora_15117.trc
Clearing standby activation ID 3663711578 (0xda5fcd5a)
The primary database controlfile was created using the
'MAXLOGFILES 40' clause.
There is space for up to 31 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl6.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl7.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl8.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl9.f' SIZE 314572800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl10.f' SIZE 314572800;
Archivelog for thread 1 sequence 4670 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Completed: alter database commit to switchover to physical standby with session shutdown

Old Standby Databse:Tue Jul 23 11:56:28 2013
Media Recovery Log /ArchLog/oracle/HMWPRD02/arch/arch_1_4678_810055494.arc
Identified End-Of-Redo (switchover) for thread 1 sequence 4678 at SCN 0x0.f988595
Resetting standby activation ID 3675145693 (0xdb0e45dd)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Continuing
Media Recovery Waiting for thread 1 sequence 4679

No comments:

Post a Comment