开启物理备库操作命令

1.Cancel the media recovery on physical standby.

alter database recover managed standby database cancel;

2.Open the database [Physical Standby]

alter database open;

3.Start media recovery with real-time log apply[Physical Standby]

alter database recover managed standby database using current logfile disconnect from session;

4.Check the database status [Physical Standby]

select name,open_mode from v$database;

select process,status,sequence# from v$managed_standby;