Re: RMAN restore database preview vs actual restore
- From: Jeffery Thomas <jeffthomas24@xxxxxxxxx>
- To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 6 Aug 2009 10:32:11 -0400
Here's the actual recovery script, the target client is np02, source
client np06.
The source RAC database has two instances, so I'm trying to recover to
the max archive seq between the two threads with the least SCN:
RUN
{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
SEND
'NB_ORA_CLIENT=np06,NB_ORA_POLICY=Oracle_Database,NB_ORA_SERV=backupmaster';
SET UNTIL SEQUENCE 7885 THREAD 2;
SET NEWNAME FOR DATAFILE 1 TO NEW;
SET NEWNAME FOR DATAFILE 2 TO NEW;
SET NEWNAME FOR DATAFILE 3 TO NEW;
SET NEWNAME FOR DATAFILE 4 TO NEW;
SET NEWNAME FOR DATAFILE 5 TO NEW;
SET NEWNAME FOR DATAFILE 6 TO NEW;
SET NEWNAME FOR DATAFILE 7 TO NEW;
SET NEWNAME FOR DATAFILE 8 TO NEW;
SET NEWNAME FOR DATAFILE 9 TO NEW;
RESTORE DATABASE;
SWITCH DATAFILE ALL;
RECOVER DATABASE;
}
On Wed, Aug 5, 2009 at 4:42 PM, <troach@xxxxxxxxx> wrote:
> Can you give us the following?
>
> Output of
> Report backup summary
>
> Have you tried doing a crosscheck backup? May need to allocate 2 channels for
> maintenance.
>
> Allocate channel for maintenance device type sbt;
> Allocate channel for maintenance device type disk;
>
> Then give us report backup summary again.
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: Jeffery Thomas <jeffthomas24@xxxxxxxxx>
>
> Date: Wed, 5 Aug 2009 15:43:09
> To: ORACLE-L<Oracle-L@xxxxxxxxxxxxx>
> Subject: RMAN restore database preview vs actual restore
>
>
> I'm testing a D/R situation, specifically a Netbackup redirected
> client restore, source being a 10.2.0.4 RAC two-node instance;
> restoring to a single-instance.
>
> After restoring the spfile, restarting the instance, restoring the
> control file, and startup mount; I issue a "restore database preview"
> to validate that I have
> all backupsets necessary to perform an incomplete recovery.
>
> RMAN correctly lists all backupsets for the last complete backup, 580
> through 584.
>
> However, when I attempt to actually perform the recovery, RMAN starts
> at backupset 574, which is no longer available. So my general
> question would be, why
> would there be a discrepancy? 580-584 is the last complete backup
> and is available, why would RMAN try and go to an earlier backup,
> contrary to the
> results of the preview?
>
> Thanks,
> Jeff
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
