Re: RMAN recovery question

From: hpuxrac <>
Date: Wed, 7 May 2008 10:11:30 -0700 (PDT)
Message-ID: <>

On May 7, 11:41 am, Chuck <> wrote:
> A cold backup was taken of a 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?
> 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.
For wild stab's in the dark, I would ask these questions:

  1. is it possible that the control file that you restored is not the correct one?
  2. is it possible that what you describe as a clean shutdown was not exactly in that manner?
Received on Wed May 07 2008 - 12:11:30 CDT

Original text of this message