Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN error

RMAN error

From: Sona <sona_us_at_hotmail.com>
Date: Tue, 29 Jan 2002 12:58:46 -0800
Message-ID: <F001.003FF78F.20020129125049@fatcity.com>

hi
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 resourcesRMAN-08031: released channel: c1RMAN-00571:

===========================================================RMAN-00569: = 
ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571:
===========================================================RMAN-03015: error 
occurred in stored script case14RMAN-03002: failure during compilation of commandRMAN-03013: command type: recoverRMAN-03002: failure during compilation of commandRMAN-03013: command type: recover(4)RMAN-06003: ORACLE error from target database: ORA-19634: filename required for this functionORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 1977ORA-06512: at line 1RMAN-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
 <SPAN

style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 12.0pt">ORA-00283: recovery session canceled due to errors
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 12.0pt"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 12.0pt">ORA-01244: unnamed datafile(s) added to controlfile by media recovery <SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 12.0pt">  <SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 12.0pt">but with RMAN the error stack given is totally vague. Has anyone encountered this one?
<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 12.0pt">  <SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 12.0pt">TIA<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> Received on Tue Jan 29 2002 - 14:58:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US