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

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 17 Mar 2009 14:41:11 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F0E1DDE62_at_AAPQMAILBX02V.proque.st>

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 - 13:41:11 CDT