RE: rman restore problem RMAN-06026/RMAN-06102
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