select max(sequence#) from v$archived_log;
select sequence#,archived from v$archived_log;
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sequence#,archived from v$archived_log;
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select name,controlfile_time from v$database;
先停止备库的日志应用。
sql>alter database recover managed standbydatabase cancel;
standby redo log日志情况
select group#, dbid, sequence#, archived, status from v$standby_log;