Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    6

    Unanswered: Restore the control file

    Dear Friends ,

    I am going to delete my one of the control file (among 3) and restore it from RMAN for testing purpose . But I can't . For this reason I m doing the following steps :

    1)My controlfile autoback is ON Like follwoing :


    RMAN> show all; (This output shows only when database is in mount & open
    status )

    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\TEMP\ctrl_file%F';

    2) I take a full database backup using following script (in mount stage) :

    run
    {
    allocate channel t1 type disk;
    backup format 'df_%t_%s_%p'
    (database);}

    AND the output is :

    ------------------------------------------------------------------
    using target database control file instead of recovery catalog
    allocated channel: t1
    channel t1: sid=154 devtype=DISK

    Starting backup at 10-APR-08
    channel t1: starting full datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM0 1.DBF
    input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX0 1.DBF
    input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE 01.DBF
    input datafile fno=00006 name=C:\TEMP\RECOVERY01.DBF
    input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS 01.DBF
    input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01 .DBF
    channel t1: starting piece 1 at 10-APR-08
    channel t1: finished piece 1 at 10-APR-08
    piece handle=C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DF_6 51694987_49_1 tag=TAG20080410T182307 comment=NONE
    channel t1: backup set complete, elapsed time: 00:01:35
    Finished backup at 10-APR-08

    Starting Control File and SPFILE Autobackup at 10-APR-08
    piece handle=C:\TEMP\CTRL_FILEC-1178861114-20080410-09 comment=NONE
    Finished Control File and SPFILE Autobackup at 10-APR-08
    released channel: t1
    ------------------------------------------------------------


    3)
    Now I have to Delete one of my control file from 'orcl' path .
    And startup the database in nomount stage . In this stage when
    I execute show all , then it shows :

    CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

    (Here in nomount stage ,I dont know why it shows Autobackup Off ? )

    4) And at the Last stage : when I recover the control file in 'nomount' stage using following
    command then it shows the following error :

    RMAN> set DBID=1178861114;
    executing command: SET DBID


    RMAN> restore controlfile from autobackup db_recovery_file_dest='C:\TEMP\CTRL_FILEC-1178861114-20080410-09';

    Starting restore at 10-APR-08
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=156 devtype=DISK

    recovery area destination: C:\TEMP\CTRL_FILEC-1178861114-20080410-09
    database name (or database unique name) used for search: ORCL
    channel ORA_DISK_1: no autobackups found in the recovery area
    channel ORA_DISK_1: looking for autobackup on day: 20080410
    channel ORA_DISK_1: looking for autobackup on day: 20080409
    channel ORA_DISK_1: looking for autobackup on day: 20080408
    channel ORA_DISK_1: looking for autobackup on day: 20080407
    channel ORA_DISK_1: looking for autobackup on day: 20080406
    channel ORA_DISK_1: looking for autobackup on day: 20080405
    channel ORA_DISK_1: looking for autobackup on day: 20080404
    channel ORA_DISK_1: no autobackup in 7 days found
    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-03002: failure of restore command at 04/10/2008 18:50:17
    RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

    Plz help regarding this problem . Is these steps are right ?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It appears you fail to understand how Oracle actually works & how futile & silly it is to try to restore an old copy of the control file.

    One of the KEY data elements stored in the control file is the CURRENT SCN.
    The value of the SCN within the copy of the control file saved by RMAN will NOT match the current SCN & render that copy of the file to be useless.

    If/when you lose a control file a supported recovery procedure is to shutdown the database & then copy one of the remain control files "on top of" the damaged or missing control file & start the data base.

    Hope This Helps.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •