RE: rman restore problem RMAN-06026/RMAN-06102
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,
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?
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arvind Kumar Sent: Tuesday, March 17, 2009 2:34 PM
Subject: rman restore problem RMAN-06026/RMAN-06102
Env - Solaris 9, oracle 220.127.116.11
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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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,
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