RE: full recovery

I haven't followed this whole thread, but here's the answer to restoring the control file from an RMAN backup pre-9i. In 9i it's much easier using controlfile autobackups.

Restoring the Control File from a Backup Set Without Using RMAN The following is taken straight from the Oracle documentation: "You must use a non-standard procedure to restore a control file from an RMAN backup set in the following situations: - You are using a pre-8.0.5 version of RMAN to restore a database when more than one database with the same name is registered in the recovery catalog (see "Restoring When Multiple Databases Share the Same Name" for a discussion of this problem). - You are not using a recovery catalog, and your only control file backup is in an RMAN backup set.
If you have no other backup of the control file except in a RMAN backup set, and you need the control file to perform a restore operation, use the following PL/SQL program to extract the control file from the backup set. Run this program from SQL*Plus while connected as SYSDBA to the target database:
DECLARE
devtype varchar2(256);
done boolean;
BEGIN
devtype := dbms_backup_restore.deviceallocate('devtype', params=>''); # Replace 'devtype' with the device type you used when creating the backup: NULL or
# sbt_tape. If you used an sbt_tape device and specified a 'parms' option on the RMAN
# allocate channel command, then put that parms data in the 'params' operand here.
dbms_backup_restore.restoresetdatafile;
dbms_backup_restore.restorecontrolfileto('/tmp/foo.cf'); # This path specifies the location for the restored control file. If there are multiple
# control files specified in the init.ora file, copy the control file to all specified
# locations before mounting the database. dbms_backup_restore.restorebackuppiece('handle',done=>done); # Replace 'handle' with the your backup piece handle. This example assumes that the
# backup set contains only one backup piece. If there is more than one backup piece in
# the backup set (which only happens if the RMAN command set limit kbytes is used), then
# repeat the restorebackuppiece statement for each backup piece in the backup set.
END;
/
After you have successfully restored the control file, you can mount the database and perform restore and recovery operations."

Andy Rivenes
arivenes_at_llnl.gov

At 12:24 PM 10/24/2003 -0800, you wrote:
>AK
> Since extracting the controlfile from your backup seems to be your major
>issue, perhaps someone on this list that mastered that issue will reply --
>how about it? You could also Google for Oracle-L and RMAN, you might find
>where they posted it.
> 8i? Check Appendix C of Freeman's book. The man thinks of everything.
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Andy Rivenes
  INET: arivenes_at_llnl.gov

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).