恢复之全部在线日志组丢失

最新推荐文章于 2021-04-28 16:35:40 发布

原创最新推荐文章于 2021-04-28 16:35:40 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个Oracle数据库在丢失在线重做日志文件后的恢复过程。通过使用最近的全库备份进行数据文件恢复，并采用不完全恢复到特定SCN的方法解决缺失归档日志的问题，最后以resetlogs方式打开数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[oracle@linuxoracle orcl]$ ls
arc.dbf example01.dbf redo02.log sde.dbf system01.dbf test.txt users01.dbf
control01.ctl redo01.log redo03.log sysaux01.dbf temp01.dbf undotbs01.dbf

--模拟丢失
[oracle@linuxoracle orcl]$ rm -rf redo0*
[oracle@linuxoracle orcl]$ ls
arc.dbf example01.dbf sysaux01.dbf temp01.dbf undotbs01.dbf
control01.ctl sde.dbf system01.dbf test.txt users01.dbf
--从最近的全库备份中还原
RMAN> restore database;

Starting restore at 06-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=135 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /home/gyh/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /home/gyh/oracle/oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/gyh/oracle/oradata/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/gyh/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /home/gyh/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /home/gyh/oracle/oradata/orcl/sde.dbf
channel ORA_DISK_1: restoring datafile 00007 to /home/gyh/oracle/oradata/orcl/arc.dbf
channel ORA_DISK_1: reading from backup piece /home/gyh/oracle/fast_recovery_area/ORCL/backupset/2012_11_06/o1_mf_nnndf_TAG20121106T213136_89mwkrr9_.bkp
channel ORA_DISK_1: piece handle=/home/gyh/oracle/fast_recovery_area/ORCL/backupset/2012_11_06/o1_mf_nnndf_TAG20121106T213136_89mwkrr9_.bkp tag=TAG20121106T213136
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:29
Finished restore at 06-NOV-12
RMAN> recover database;

Starting recover at 07-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK

starting media recovery

unable to find archived log
archived log thread=1 sequence=15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/07/2012 00:36:58
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 15 and starting SCN of 2367048
--之前在线日志文件未生成
--确认在mount状态下做基于时间点或者scn的不完全恢复
RMAN> recover database until scn 2367048;

Starting recover at 07-NOV-12
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 07-NOV-12
--resetlogs方式打开数据库
RMAN> alter database open resetlogs;

database opened
--备份数据库删除过时的归档日志
RMAN> backup database plus archivelog delete input;
RMAN> exit