Friday 10 January 2014

Standby common sqls

select thread#, max(sequence#) as "Last_Applied_Log" from v$log_history group by thread#; select process, status, sequence# from v$managed_standby; alter database recover managed standby database disconnect from session; alter database register logfile '/u02/oracle/backup_arch/o1_mf_1_57518_93s5gop2_.arc'; alter database register logfile '/u02/oracle/backup_arch/o1_mf_1_57519_93s5v0pm_.arc'; ... or you can try to use rman to register a group of them e.g. RMAN> catalog start with '/u01/oracle/arch/arc'; Shutdown Standby select process, status, sequence# from v$managed_standby; alter database recover managed standby database cancel; shutdown immediate Restore archivelog from RMAN backup. restore archivelog from logseq 69124 until logseq 69134; -- or restore archivelog from logseq 69135;