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

From: Arvind Kumar <Arvind.Kumar_at_labour.gov.za>
Date: Tue, 17 Mar 2009 22:40:42 +0200
Message-ID: <71F683BA2EDB1743A1AE143D5D9D1B9E4299F3_at_zadoluifmsg04.resource.labour.net>



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_at_proquest.com] Sent: Tuesday, March 17, 2009 8:41 PM
To: Arvind Kumar; oracle-l_at_freelists.org 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arvind Kumar Sent: Tuesday, March 17, 2009 2:34 PM
To: oracle-l_at_freelists.org
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.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 17 2009 - 15:40:42 CDT

Original text of this message