DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Control File Recovery

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    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
    Location
    UK
    Posts
    1,684
    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.

    http://download-west.oracle.com/docs...eco.htm#440115

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

    Tim...
    Tim...
    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