DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Control File Recovery

    i am using 8i and create a backup set with the following script without recovery catalog
    run {allocate channel c1 type disk
    format 'c:\backup\test_db_%U';
    backup database include current controlfile;
    copy current controlfile to 'c:\backup\control1.ctl';}

    Now i have lost all of my control files and want to restore control file by using the following steps

    1-C:\>rman nocatalog

    2-RMAN> connect target sys/gateway@wizmen
    RMAN-06193: connected to target database (not started)

    3-RMAN> set dbid=3460708078
    4-RMAN> startup nomount

    5- RMAN> run{allocate channel c1 type disk;
    restore controlfile;
    sql 'alter database mount';}

    And i got the error

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: c1
    RMAN-08500: channel c1: sid=10 devtype=DISK

    RMAN-03022: compiling command: restore

    RMAN-03022: compiling command: IRESTORE
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: c1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: restore
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: IRESTORE
    RMAN-06003: ORACLE error from target database: ORA-01507: database not mounted
    ORA-06512: at "SYS.X$DBMS_RCVMAN", line 4461
    ORA-06512: at line 1
    RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upp
    er ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ;
    RMAN-06099: error occurred in source file: krmk.pc, line: 9196

    I have tried all to recover the control files but unable to do so
    can anybody help me in this regard?
    thanx in advance

  2. #2
    Join Date
    Dec 2001
    Another post across multiple forums!

    Personally, if I wanted to restore a controlfile I would look in the Oracle 8i Backup and Recovery manual to see if there was a section entitled "Restoring Controlfiles". When I found that section I would read it.


    Having read it I would follow its advice and not need to post the same question to every Oracle forum I could find.

    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.