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

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

相关内容

热门资讯

从预订便利性拆解:家庭游客如何... 从预订便利性拆解:家庭游客如何规划一场从容的新加坡滨海湾活动季之旅 很多计划家庭度假的游客在规划新加...
马尔代夫代理怎么选?从业内第一... 计划一趟马尔代夫之旅,动辄数万的支出,让你不得不慎之又慎。面对网络上五花八门的代理和平台,到底该怎么...
原创 烟... 天气越来越暖和,各种花儿陆续竞相开放,空气中浮动着喜洋洋暖融融的气息,春天的感觉越来越强烈了。经过了...
给陕西人一个饼,能夹起…… 今天(3月14日),西安首届菜夹饼大赛在西安音乐厅火热开赛。市民们围在展台前,热情高涨,选菜、加料、...
原创 别... 老话讲,“春吃野,夏吃苦”。进了三月,这地气一上升,地里的野菜就跟疯了似地往外窜。荠菜、蒲公英大家都...