Oracle DG日志丢失恢复
如何发现日志丢失?
col name format a30
col value format a30
col time_computed format a30
set linesize 200
select name,value,time_computed from V$dataguard_stats;
1. 检查日志应用情况:
set linesize 200 pagesize 999col name format a60
col applied format a3
col completion_time format a20
Select Name,Sequence#,applied,completion_time From v$archived_log Order By Sequence# Desc;
2. 对比查看主库和备库的归档日志
rman target /
Ramn>list archivelog all;
Rman>crosscheck archivelog all;
如何恢复?
1. 在另一正常的备库用rman备份缺失的归档日志
rman target /
RMAN>copy archivelog'+fra/htdb5/ARCHIVELOG/2017_03_24/thread_1_seq_328759.4592.939510649' to'/home/oracle/arcbak/thread_1_seq_328759.4592.939510649';
2. 备份完成后,把归档传输到丢失归档的备库
[oracle@hotel05 arcbak]