Oracle Dataguard 误删日志处理
admin
2024-04-07 23:01:24

停电后忘记了开启备机,在加上主机日志盘的空间小,有定时作业删除文件,结果发现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

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

相关内容

热门资讯

穿越天山遇见四季童话:新疆深度... 穿越天山遇见四季童话:新疆深度旅行指南与秘境故事 序章:一封来自西域的情书 每年六月,当伊犁河谷的薰...
从戈壁到花海:一位新疆本地向导... 从戈壁到花海:一位新疆本地向导的四季旅行手记 在新疆生活了近二十年,我依然记得第一次被这片土地震撼的...
穿越军 - 穿越中国亲子挑战赛... 以前总带孩子去各地旅游,打卡景点、吃美食,回来之后孩子除了照片,什么都没留下,直到带他参加穿越军亲子...
2026最新山东旅行社综合实力... 随着 2026 年旅游市场持续升温,山东凭借 "一山一水一圣人" 的独特魅力和丰富的文旅资源,成为国...
二十年,再赴大熊山 人间忽晚,山河已秋。一别大熊山,已是整整二十载。 那时我匆匆登临,步履轻快,眼里只有山川壮阔、林木葱...