About restoring controlfiles, if I remember this correctly as I did just this a few months ago:
You have to startup database nomount. Then restore controlfile. Then alter database mount. Then restore database. ltiu DENNIS WILLIAMS wrote: >Babu > I agree with Jay, you need to create symbolic links that mimic the >locations RMAN hopes to find the backup files. > I was unable to get RMAN to restore the control file. The problem I >encountered was that RMAN required the target database to be mounted first, >but without a control file I couldn't mount the database. Someone the list >reported that this was possible, but I finally just said that it was easier >to create a backup control file outside RMAN and use that. > The RMAN information needed to restore is probably still available in the >control file. I found that to simplify the type of recovery you are >attempting. > RMAN will need the archive logs that were created during the time it was >performing the backup in order to get the data files back to the same SCN. > This task took me awhile, so be patient. > >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > >-----Original Message----- >Sent: Thursday, September 05, 2002 7:13 PM >To: Multiple recipients of list ORACLE-L > > >Dear List, > >Iam following the procedure to restore database from RMAN backup from HOST_A >to HOST_B with a recovery catalog. > >1. I copied the init.ora file to HOST_B >2. on HOST_B, I made an entry in oratab for 'rtest' database and switch to >'rtest' database using . oraenv >3. issued: rman target / catalog rman/rman@<Connect String> >4. startup nomount; >5. run { > allocate channel ch1 type 'sbt_tape'; > restore controlfile; > } > >It generates the following error. "list backup of controlfile" is showing up >the backup entries. > >RMAN-00571: =========================================================== >RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== >RMAN-00571: =========================================================== >RMAN-03002: failure during compilation of command >RMAN-03013: command type: restore >RMAN-03007: retryable error occurred during execution of command: IRESTORE >RMAN-07004: unhandled exception during command execution on channel ch1 >RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve >sequential file, handle="nre1u1kk_1_1", parms="" >ORA-27029: skgfrtrv: sbtrestore returned error >ORA-19511: sbtrestore: Backup file not found. >RMAN-10031: ORA-19624 occurred during call to >DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE > >Could someone help me in resolving the issue. > >Thanks, >-- Babu > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).