--Current main library PROD3, standby library aux--View Primary Reserve log transmission sys@prod3> select Max (sequence#) from V$archived_log;
MAX (sequence#)--------------sys@aux> Select sequence#,applied from V$archived_log ORDER by 1 desc; sequence# Applied-------------------Yes to Yes--view the primary repository status Sys@prod3>. ;
Select Name,database_role,switchover_status from V$database; NAME database_role switchover_status---------------------------------------------PROD3 PRIMARY to STANDBY S
Ys@aux> select Name,database_role,switchover_status from V$database; NAME database_role switchover_status---------------------------------------------PROD3 physical STANDBY Not all
Owed-Piontes library switches to the repository sys@prod3> ALTER DATABASE commit to switchover to physical standby with session shutdown;
Database altered. --in-store trace file excerpt rfs[2]: Possible network disconnect with primary database sys@aux> Select Name,database_role,switcho
Ver_status from V$database; NAME DATAbase_role switchover_status---------------------------------------------PROD3 physical STANDBY to PRIMARY--ready for library cut
Switch to the main library sys@aux> ALTER DATABASE commit to switchover to primary;
Database altered.
sys@aux> ALTER DATABASE open;
Database altered.
--Start the standby for recovery sys@prod3> startup ORACLE instance started. Total System Global area 958341120 bytes Fixed Size 1348972 bytes Variable Size 281021076 bytes Database buffers
671088640 bytes Redo buffers 4882432 bytes Database mounted.
Database opened.
Sys@prod3> select Open_mode from V$database;
Open_mode--------------------READ only sys@prod3> select Name,database_role,switchover_status from V$database; NAME database_role switchover_status---------------------------------------------PROD3 physical STANDBY RECOVER
Y NEEDED sys@prod3> ALTER DATABASE recover managed standby database disconnect from session;
Database altered. Sys@prod3> Select Name,database_role,switchover_status from V$database; NAME database_role switchover_status---------------------------------------------PROD3 physical STANDBY Not all
Owed sys@prod3> select Open_mode from V$database;
Open_mode--------------------Read Only with APPLY--View the main library status sys@aux> select Open_mode from V$database;
Open_mode--------------------READ WRITE sql> select Name,database_role,switchover_status from V$database;
NAME database_role switchover_status---------------------------------------------PROD3 PRIMARY to STANDBY