Home » RDBMS Server » Backup & Recovery » RMAN-06053: unable to perform media recovery because of missing log (11.2.0.4 oracle enterprise edition )
RMAN-06053: unable to perform media recovery because of missing log [message #647935] Fri, 12 February 2016 01:28 Go to next message
manishdba007
Messages: 27
Registered: September 2014
Location: India
Junior Member
Hello all,

We are planing to do DR in our env. So we have taken full backup to stag and restored . Now at the time of recovery i am having troubles like below -

RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 86365 and starting SCN of 1248570236 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86364 and starting SCN of 1248558389 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86363 and starting SCN of 1248546741 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86362 and starting SCN of 1248533780 found to restore


We are using HP data protector and sys admin has confirmed that correct tape has been mounted in server pool which are including archive logs .

Please help me out on this.

Manish
Re: RMAN-06053: unable to perform media recovery because of missing log [message #647938 is a reply to message #647935] Fri, 12 February 2016 01:39 Go to previous messageGo to next message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
You know as well as I do that you have not provided enough information to get any help.
Re: RMAN-06053: unable to perform media recovery because of missing log [message #647940 is a reply to message #647938] Fri, 12 February 2016 01:43 Go to previous messageGo to next message
manishdba007
Messages: 27
Registered: September 2014
Location: India
Junior Member
Hi,

Yes i know , i am in a bit hurry . Please ask me what exact information you want from me ?

Thanks in advance
Manish
Re: RMAN-06053: unable to perform media recovery because of missing log [message #647941 is a reply to message #647940] Fri, 12 February 2016 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is on the tape?
What command did you execute?
What is the COMPLETE log?
Post FORMATTED.

[Updated on: Fri, 12 February 2016 01:46]

Report message to a moderator

Re: RMAN-06053: unable to perform media recovery because of missing log [message #647942 is a reply to message #647941] Fri, 12 February 2016 02:08 Go to previous messageGo to next message
manishdba007
Messages: 27
Registered: September 2014
Location: India
Junior Member
Hmm .

We have two tapes DB_Monthly and DB_archive_daily . Now from DB_Monthly we have done restoration . while trying to recover archivelogs from tape DB_archive_daily we are getting issues.

I have executed below command(Until time we used time when archovelogs backup completion time -

connect target /
spool log to rman_smp_recover.log
run
{

allocate channel 'dev_0' type 'sbt_tape'
parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SMPREP,OB2BARLIST=SMPREP_Archive_Daily)';
set until time= "to_date('30/01/2016 10:10:21','dd/mm/yyyy hh24:mi:ss')";
RECOVER DATABASE;
release channel 'dev_0';
}

Log-

executing command: SET until clause

Starting recover at 11-FEB-16

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u15/oradata/DRSMP/system01.dbf'

released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/11/2016 18:59:13
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 86365 and starting SCN of 1248570236 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86364 and starting SCN of 1248558389 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86363 and starting SCN of 1248546741 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86362 and starting SCN of 1248533780 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86361 and starting SCN of 1248522356 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86360 and starting SCN of 1248510389 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86359 and starting SCN of 1248507598 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86358 and starting SCN of 1248495258 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86357 and starting SCN of 1248483249 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86356 and starting SCN of 1248472798 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86355 and starting SCN of 1248459705 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86354 and starting SCN of 1248448242 found to restore

Recovery Manager complete.

Now we have used below command but still we are getting error -

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=SMP,OB2BARLIST=SMP_Archive_Daily)';
set archivelog destination to '/u15/oraarch/DRSMP';
restore archivelog sequence between 86354 and 86359;
restore archivelog sequence between 86360 and 86366;
release channel 'dev_0';
}
exit;


Error-

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 12-FEB-16

released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/12/2016 15:00:40
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86359 and starting SCN of 1248507598 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86358 and starting SCN of 1248495258 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86357 and starting SCN of 1248483249 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86356 and starting SCN of 1248472798 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86355 and starting SCN of 1248459705 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 86354 and starting SCN of 1248448242 found to restore


RMAN> exit;

Recovery Manager complete.


Thank in advance
Manish
Re: RMAN-06053: unable to perform media recovery because of missing log [message #647943 is a reply to message #647942] Fri, 12 February 2016 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If these backup are in the tape then CATALOG them otherwise you lost and have to recover to a date previous to the last archived log you have.

Re: RMAN-06053: unable to perform media recovery because of missing log [message #647945 is a reply to message #647943] Fri, 12 February 2016 02:30 Go to previous message
manishdba007
Messages: 27
Registered: September 2014
Location: India
Junior Member
Thank you .

appreciate your advise

Manish
Previous Topic: Why Do Redo Log Remain Active Even After alter system archive log current
Next Topic: Oracle folders to backup
Goto Forum:
  


Current Time: Mon Oct 22 04:38:40 CDT 2018