Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restoring RMAN backups to different host ......

Re: Restoring RMAN backups to different host ......

From: ltiu <>
Date: Fri, 06 Sep 2002 07:28:26 -0800
Message-ID: <>

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.



> 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
> 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
>Lifetouch, Inc.
>-----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
>Could someone help me in resolving the issue.
>-- Babu

Please see the official ORACLE-L FAQ:
Author: ltiu

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: (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).
Received on Fri Sep 06 2002 - 10:28:26 CDT

Original text of this message