Confusion Over Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Confusion Over Recovery

  1. #1
    Join Date
    Sep 2007
    Posts
    42

    Confusion Over Recovery

    DEAR FRIENDS,
    I HAVE TAKEN A RMAN BACKUP OF MY DATABASE WHILE IT WAS OPEN BY WRITING THE CODE
    run
    {
    allocate channel c1 type disk;
    backup database format 'db_%u_%d_%s';
    release channel c1;
    }

    BUT WHILE I AM TRYING TO RESTORE AND RECOVER THE DATABASE WHILE IT IS OPEN USING RMAN IT IS GETTING FAILED.THE DATABASE IS IN ARCHIVE LOG MODE.
    PLEASE HELP.WHAT SHOULD I DO?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    post your full restore script and errors

  3. #3
    Join Date
    Sep 2007
    Posts
    42

    confusion over recovery

    THE SCRIPT OF RECOVERY IS

    run
    {
    allocate channel c1;
    restore database;
    recover database;
    }

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    and the error?

  5. #5
    Join Date
    Sep 2007
    Posts
    42

    confusion over recovery

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 09/17/2007 18:23:48
    ORA-19573: cannot obtain exclusive enqueue for datafile 1

  6. #6
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    What state is the database in?

    The generic steps for media recovery using RMAN are as follows:

    Place the database in the appropriate state: mounted or open. For example, mount the database when performing whole database recovery, or open the database when performing online tablespace recovery.

    http://download.oracle.com/docs/cd/B...2.htm#BGBCIGHG

  7. #7
    Join Date
    Sep 2007
    Posts
    42
    The Database Was In Open State And In Archive Log Mode

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Shouldn't the database be in mount state for rman database recovery?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    it sure should

  10. #10
    In gneral, it can be open as long as you don't need to recover the system tablespace. You need to offline the affected tablespace before you can restore / recover it though. That error indicates that the tablespace being restored is still online.

    However, for a general restore / recover, it can't be open.

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