Guys,
Running Oracle 8.1.7
RMAN with automated backups - no problem
Wish to recover
recovered controlfile from backup then issued following:
MAN> run {execute script alloc_all_tapes;
> restore database;
> recover database noredo;
> execute script rel_all_tapes;}
It failed with:
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 173 found to restore
Yet, when I query the target database mounted and look for
1* select file#,ts#,status,name from v$datafile
SQL> i
2 where file#=173;
no rows selected
MAKES NO SENSE AT ALL!!! WHERE IS IT COMING FROM WITH FILE#173 - IF THE MOUNTED TARGET DATABASE DOESN'T LIST 173 FROM V$DATAFILE OR V$RECOVER_FILE!!!