Re: rman error

On 15 Dec 2005 14:25:48 -0800, epipko_at_gmail.com wrote:

>Hi all,
>I made a valid backup of Oracle 9i on Win2003.
>I am trying to test restore and recovery using the following script:
>shutdown;
>startup mount;
>restore database;
>recover database;
>alter database open resetlogs;
>
>Here is what I get:
>---------------------------
>RMAN> restore database;
>
>Starting restore at 15-DEC-05
>
>using target database controlfile instead of recovery catalog
>allocated channel: ORA_DISK_1
>channel ORA_DISK_1: sid=12 devtype=DISK
>RMAN-00571: ======================================================
>RMAN-00569: ========= ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ======================================================
>RMAN-03002: failure of restore command at 12/15/2005 08:52:27
>RMAN-06026: some targets not found - aborting restore
>RMAN-06023: no backup or copy of datafile 108 found to restore
>RMAN-06023: no backup or copy of datafile 107 found to restore
>RMAN-06023: no backup or copy of datafile 106 found to restore
>RMAN-06023: no backup or copy of datafile 105 found to restore
>RMAN-06023: no backup or copy of datafile 104 found to restore
>......................................................................................
>.......................................
>........................
>RMAN-06023: no backup or copy of datafile 35 found to restore
>RMAN-06023: no backup or copy of datafile 34 found to restore
> MAN-060
>RMAN>
>
>Why can't Rman find a backup files in the backup set?
>
>Thanks,
>Eugene

I assume you made a backup of the controlfile *prior* to backing up the database.
So the backup is not in the controlfile you restored prior to running this scipt.

Been there, done that.
You make mistakes like these only once.

--
Sybrand Bakker, Senior Oracle DBA