I trying to recover from loss of all
controlfiles and a datafile which was not backed up using RMAN
.
these are the steps i followed
>startup nomount
These are the RMAN commands
executed.
{
allocate channel c1 type disk;
restore
controlfile;
sql 'alter database mount';
restore database;
recover
database;
release channel c1;
}
the recover fails wit the following error
RMAN-03022: compiling command:
recover(2)
RMAN-03022: compiling command:
recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054:
starting media recovery
RMAN-03022: compiling command:
recover(4)
RMAN-03026: error recovery releasing channel
resources
RMAN-08031: released channel: c1
RMAN-00571:
===========================================================
RMAN-00569: =
ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03015:
error occurred in stored script case14
RMAN-03002: failure during
compilation of command
RMAN-03013: command type: recover
RMAN-03002:
failure during compilation of command
RMAN-03013: command type:
recover(4)
RMAN-06003: ORACLE error from target database: ORA-19634:
filename required for this function
ORA-06512: at
"SYS.X$DBMS_BACKUP_RESTORE", line 1977
ORA-06512: at line 1
RMAN-06097:
text of failing SQL statement: begin :valrc := sys . dbms_backup_restore .
validateArchivedLog ( :recid , :stamp , :fname , :thd , :seq , :resetscn ,
:lowscn , :blksize ) ; end ;
RMAN-06099: error occurred in source file:
krmk.pc, line: 8517
Does anyone have any idea what this error is
about?
I think in this case the recovery is failiing
while trying to recover the non-existent datafile.But how would one know
looking at this error stack.
If we perform recovery without RMAN ,Oracle would
normally give a decent error
like
ORA-00283:
recovery session canceled due to errors
ORA-01244:
unnamed datafile(s) added to controlfile by media recovery
but
with RMAN the error stack given is totally vague. Has anyone encountered this
one?
TIA