restore control file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: restore control file

  1. #1
    Join Date
    Jan 2002
    Posts
    94

    Lightbulb

    Dear fellows in misery,

    Im 'playing' with different crash szenarious to be prepared for the worsed case:

    master data:
    os: Win2000
    db: oracle8i version: 8.1.7.0.0
    rman uses with nocatalog
    backup: full offline backup with rman

    situation:
    - I renamed all control files
    - run the following script on rman:

    run {
    allocate channel channel1 type disk format 'd:\oracle8i\oradata\RecTest\backup\b_%u_%s_%p';
    restore controlfile;

    }

    The error message is:

    ORA-06512: in "SYS.X$DBMS_RCVMAN", Zeile 4461
    ORA-06512: in Zeile 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


    What have I done wrong?

    Chris

  2. #2
    Join Date
    Nov 2001
    Posts
    335
    Did you start database in nomount state?
    Did you try to allocate channel type disk and not provide full path to location of backup?. It just occured to me that you are not using recovery catalog, is that cou be a problem?

    [Edited by BV1963 on 05-16-2002 at 10:38 AM]
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  3. #3
    Join Date
    Jan 2002
    Posts
    94
    > Did you start database in nomount state?
    Yes, I did.
    > Did you try to allocate channel type disk and not provide full > path to location of backup?. It just occured to me that you are > not using recovery catalog, is that cou be a problem?

    O.k., I rman has no Information abbout backups and so on because he gets it from the controlfile of the database. But for what reason rman provides backup for controlfile if one can not restore the database without any conrol file?!

    Maybe it would be better to use an catalog...

    Chris

  4. #4
    Join Date
    Jan 2002
    Posts
    94
    The second problem I have is, that I can not use the auto chanal feature. Every time I do a backup or something else, I have to allocate a chanel. Hmm. Could the reason be the not existing catalog as well?

    Chris

  5. #5
    Join Date
    Nov 2001
    Posts
    335
    O.k., I rman has no Information abbout backups and so on because he gets it from the controlfile of the database. But for what reason rman provides backup for controlfile if one can not restore the database without any conrol file?!


    It gives you a choice, either use recovery catalog or backup control file yourself. In case you do not use catalog your controlfile backup becomes very important.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  6. #6
    Join Date
    Jan 2002
    Posts
    94
    But I got a backup of controfile and Im not able to use it.

    Chris

  7. #7
    Join Date
    Jan 2002
    Posts
    94
    hallo,

    my solution for the problem is to create an catalog and use him: Situation: Database is started but not mounted:

    C:\ rman target internal/*****@target_db_name

    Microsoft Windows 2000 [Version 5.00.2195]
    (C) Copyright 1985-2000 Microsoft Corp.

    C:\>rman target internal/*****@target_db_name

    Recovery Manager: Version 8.1.7.0.0 - Production

    RMAN-06006: Verbindung mit Zieldatenbank: RecTest (nicht angeschlossen)

    RMAN> connect catalog rman_db/*****@catalog_db_name

    RMAN-06008: Verbindung mit Datenbank des Wiederherstellungskatalogs

    RMAN> run {
    allocate channel c1 type disk format 'D:\oracle8i\oradata\RecTest\backup\b_%u_%s_%p';
    3> restore controlfile;
    4> }

    Some information is in german language. I hope even though you anderstand it.

    Chris

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