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
--
George Sinclair - NOAA/NESDIS/National Oceanographic Data Center
SSMC3 4th Floor Rm 4145 | Voice: (301) 713-3284 x210
1315 East West Highway | Fax: (301) 713-3301
Silver Spring, MD 20910-3282 | Web Site: http://www.nodc.noaa.gov/
- Any opinions expressed in this message are NOT those of the US Govt. -
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
|