dataguard 验证语句

startup nomount

 

alter database mount standby database

 

select name,database_role from v$database;

 

alter database recover managed standby database disconnect from session;

 

alter system archive log current;

 

alter database recover managed standby database cancel;

 

alter database open read only;

 

select sequence#,first_time,next_time from v$archived_log order by sequence#;

 

select sequence#,applied from v$archived_log order by sequence#