This discussion is archived
2 Replies Latest reply: Dec 27, 2012 5:59 AM by Pinela RSS

Recovery when 1 of the redo log is missing

user2015671 Newbie
Currently Being Moderated
I am using below procedure to recover redo log files when all the redo log are missing.

================================================
Question:Do i need to follow same procedure when 1 of the redo log is missing?
================================================

RMAN> run {
set until sequence 54;
restore database;
recover database;
alter database open resetlogs;
}
2> 3> 4> 5> 6>
executing command: SET until clause

Starting restore at 25-DEC-12
using channel ORA_DISK_1

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 /qa/data/obt/QA112QA/data/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /qa/data/obt/QA112QA/data/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /qa/data/obt/QA112QA/data/rbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /qa/data/obt/QA112QA/data/temp01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /qa/data/obt/QA112QA/data/tools01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /qa/data/obt/QA112QA/data/users01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /qa/data/obt/QA112QA/data/vindx.dbf
channel ORA_DISK_1: restoring datafile 00008 to /qa/data/obt/QA112QA/data/incre1.dbf
channel ORA_DISK_1: restoring datafile 00009 to /qa/data/obt/QA112QA/data/rman_tbs.dbf
channel ORA_DISK_1: reading from backup piece /qa/data/obt/rmanbackup/01ntofrc_1_1
channel ORA_DISK_1: piece handle=/qa/data/obt/rmanbackup/01ntofrc_1_1 tag=LEVEL0BACKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 25-DEC-12

Starting recover at 25-DEC-12
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 53 is already on disk as file /qa/data/obt/QA112QA/admin/arch/1_53_802911384.log
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=51
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=52
channel ORA_DISK_1: reading from backup piece /qa/data/obt/rmanbackup/03ntofs3_1_1
channel ORA_DISK_1: piece handle=/qa/data/obt/rmanbackup/03ntofs3_1_1 tag=TAG20121225T132211
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/qa/data/obt/QA112QA/admin/arch/1_51_802911384.log thread=1 sequence=51
archived log file name=/qa/data/obt/QA112QA/admin/arch/1_52_802911384.log thread=1 sequence=52
archived log file name=/qa/data/obt/QA112QA/admin/arch/1_53_802911384.log thread=1 sequence=53
media recovery complete, elapsed time: 00:00:01
Finished recover at 25-DEC-12

database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points