oracle 11g physical standby switchover(二)
------- ------------------------------ --------------------
PRIMARY tgg READ WRITE
将新备库ogg 开启为read only --real time apply
SQL> alter database open;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL>
select database_role,db_unique_name,open_mode from v$database;
DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE
---------------- ------------------------------ --------------------
PHYSICAL STANDBY ogg READ ONLY WITH APPLY