Oracle Dataguard 误删日志处理

停电后忘记了开启备机，在加上主机日志盘的空间小，有定时作业删除文件，结果发现Dataguard备机开机后工作不正常，原因是缺少了几个归档日志。

不过全备是有的。

于是在主机使用Rman将归档日志还原到了LOG_ARCHIVE_DEST_1目录下。

RMAN> RESTORE ARCHIVELOG SEQUENCE BETWEEN 100262 AND 100263;

Starting restore at 14-NOV-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=818 device type=DISK

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=100262
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=100263
channel ORA_DISK_1: reading from backup piece /u01/nasbackup/rman_full_20221112_sv1cltsj_1_1
channel ORA_DISK_1: piece handle=/u01/nasbackup/rman_full_20221112_sv1cltsj_1_1 tag=TAG20221112T210504
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: reading from backup piece /u01/nasbackup/rman_full_20221112_sv1cltsj_2_1
channel ORA_DISK_1: piece handle=/u01/nasbackup/rman_full_20221112_sv1cltsj_2_1 tag=TAG20221112T210504
channel ORA_DISK_1: restored backup piece 2
channel ORA_DISK_1: restore complete, elapsed time: 00:01:10
Finished restore at 14-NOV-22

RMAN> quit

这两日志还原后，备机马上接收到了这个归档日志并应用，又正常工作了。