Re: RMAN recovery question
Date: Wed, 7 May 2008 11:44:20 -0700 (PDT)
On May 7, 8:41 am, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> A cold backup was taken of a 10.2.0.3 database using rman. The database
> was shut down cleanly before the backup was started. When I tried to
> restore the backup a few days later, it would not let me open the
> database. It said that file 1 (system01.dbf) file needed further
> recovery. Why would a file need *any* recovery if it was a cold backup?
Sometimes this is a slightly misleading message, due to some other file needing recovery.
The other file may have been offline or read-only when the backup was taken (or, I'm guessing, the db was shut down).
Are any of your data files fuzzy? See metalink Note:337450.1 for some thoughts.
> These are the rman commands used to do the restore.
> startup force nomount;
> restore controlfile from '$mediahandle';
> alter database mount;
> restore database from tag $tag;
> alter database open resetlogs;
> The $variables are shell variables that specify the appropriate
> information needed to restore the correct control file and backup sets.
> It's part of a script that's worked dozens of times before. Everything
> worked fine up to the "alter database open resetlogs;" where it started
> complaining about needing recovery on one of the files. There were no
> errors in either the backup or the restore.
>Oddly if I use the backup reports in Grid Control for this database, it
>shows the status of the backup I restored from as "FAILED" (I think that
>status comes from v$rman_backup_job_details), but the RMAN output log
>from the backup itself shows no errors, all files backed up succesfully
>and the return code was 0.
Well, if grid control is confused, maybe something else is, too.
-- @home.com is bogus. D'Oh! http://www.signonsandiego.com/uniontrib/20080507/news_1b7saic.htmlReceived on Wed May 07 2008 - 13:44:20 CDT