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 15:44:25 -0800
Message-ID: <F001.003FFC26.20020129154055@fatcity.com>

HI 
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   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 Received on Tue Jan 29 2002 - 17:44:25 CST

Original text of this message

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