RE: rman restore problem RMAN-06026/RMAN-06102

  • From: "Arvind Kumar" <Arvind.Kumar@xxxxxxxxxxxxx>
  • To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 17 Mar 2009 22:40:42 +0200

When I took rman backup it backed log sequence from 29566 to 29816 and
while restoring with "restore archivelog all" it tried to restore log
sequence from 29517 to 29565 which was not there in the current backup
and produced that error RMAN-06026, RMAN-06102, please correct me if
wrong.

 

Would it be fine if I use "Restore archivelog  from sequence 29566 until
sequence 29816;" instead of "restore archivelog all".

 

Thanks & Regards, 
Arvind Kumar




________________________________

From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxx] 
Sent: Tuesday, March 17, 2009 8:41 PM
To: Arvind Kumar; oracle-l@xxxxxxxxxxxxx
Subject: RE: rman restore problem RMAN-06026/RMAN-06102

 

Can you show us the complete RMAN script that you executed?

 

It looks like the channels are all released, then it complains that
there are no channels available to restore the archivelog?

 

-Mark

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arvind Kumar
Sent: Tuesday, March 17, 2009 2:34 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: rman restore problem RMAN-06026/RMAN-06102

 

Hello All,

 

Env - Solaris 9, oracle 9.2.0.4

 

Getting the following while restoring archivelogs, all the datafiles get
restored successfully but fails at while restoring archivelogs

 

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 17-MAR-09

released channel: CH1

released channel: CH2

released channel: CH3

released channel: CH4

released channel: CH5

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 03/17/2009 03:39:42

RMAN-06026: some targets not found - aborting restore

RMAN-06102: no channel to restore a backup or copy of log thread 1 seq
29565 scn 8241683062885

 

Thanks & Regards, 
Arvind Kumar

 

 


Disclaimer
This e-mail and any attachments transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you have received this e-mail in error please notify the
sender and delete the original message. Any views or opinion expressed
in this e-mail are those of the author and do not necessarily represent
those of the Department of Labour. The recipient should check this
e-mail and any attachments for the presence of viruses and other
destructive codes. While all possible precautions have been taken, the
Department accepts no liability whatsoever for loss or damage resulting
from the opening of this message or attachments, or the use of the
information contained in this message or attachment.

Other related posts: