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

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 18 Mar 2009 09:46:01 -0700
Message-ID: <bf46380903180946w4143f098t6f5b6a59ab48a3ae_at_mail.gmail.com>

On Tue, Mar 17, 2009 at 1:40 PM, Arvind Kumar <Arvind.Kumar_at_labour.gov.za>wrote:

> 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”.
>
>

Looking at this again, the 'restore archivelogs all' is unnecessary.

This command tells RMAN to restore all archivelogs that are in the catalog.

You don't need all of them, only those that occurred from the beginning of the backup that is being restored.

ie. use some command syntax to restore only the logs needed for the recovery.

You may also want to run a crosscheck against archive logs on the backup media.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 18 2009 - 11:46:01 CDT