Networker

Re: [Networker] Cannot recover RMAN Oracle backup?

2007-05-01 14:44:14
Subject: Re: [Networker] Cannot recover RMAN Oracle backup?
From: David Dulek <ddulek AT FASTENAL DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Tue, 1 May 2007 13:42:34 -0500
Try specifying a time about 5 minutes after the Full finished.

On Tuesday 01 May 2007 13:32, George Sinclair wrote:
> We are unable to recover the data for an Oracle RMAN level 0 test backup
> from 04/26/2007.
>
> The NetWorker media database shows the save sets from that date, and
> there are no flags indicating any
> problems with the save sets. However, when we run the RMAN recover,
> specifying the SET UNTIL TIME
> to 04/26/07, it instead recovers a level 0 from 04/25/07. There are no
> errors indicated, and the recovery works,
> BUT we are mystified as to why it would be going back to 04/25/07 when
> there's another level 0 available from
> 04/26/07, and this is the date we explicitly specified.
>
> We're running Oracle 10g on Linux with NetWorker 7.2.2 client, and NMO
> 4.2. Primary backup server is
> running Solaris with NetWorker 7.2.2. We run level 0 cumulative and
> level 1 cumulative backups, no
> differentials.
>
> Here's the order of the events:
> 04-25-2007
> 1. Ran level 0 backup
> 2. Ran level 1 backup
> 3. Ran level 0 backup again
> 4. Ran level 1 backup
> 5. Ran level 1 backup again
>
> 04-26-2007
> 6. Ran level 0 backup
> 7. Ran level 1 backup
> 8. Ran level 1 backup again
>
> 04-27-2007
> 9. Shut down database
>
> 04-30-2007
> 10. Restarted database
> 11. Ran level 1backup
> 12. Ran level 1 backup again
> 13. Restored data without specifying any date which *SHOULD* have
> applied the latest incremental (step 12) to the
> latest full (step 6 from 04-26-2007). But, instead, it applied the full
> backup from 04-25-2007 and then the last
> incremental (step 12). We then tried again, but this time we specified a
> SET UNTIL TIME for 04-26-2007, and it still
> recovered the full from 04-25-2007. No errors, however.
>
> Any ideas why it wants to use the full from 04-25-2007 and completely
> and blithely ignore the one from the 26th?
> It's almost as if RMAN doesn't even know it's there, like it was never run!
>
> Thanks,
>
> George

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>