Oracle DG日志丢失恢复

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 999
col 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]