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

Thread: RMAN restore: UNTIL TIME error

  1. #1
    Join Date
    Dec 2000
    Posts
    75

    Angry

    I have a hot backup from yesterday. Try to do point-in-time recovery and get the following:

    RMAN-08031: released channel: d2
    RMAN-08031: released channel: d3
    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-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME is
    before RESETLOGS time


    I do confirm that backupsets are in the catalog database. Here is my recovery script.
    run {
    allocate channel d1 type 'SBT_TAPE';
    allocate channel d2 type 'SBT_TAPE';
    allocate channel d3 type 'SBT_TAPE';
    restore database
    until time "to_date('Aug 27 2001 02:00:00','Mon DD YYYY HH24:MI:SS')";
    recover database
    until time "to_date('Aug 27 2001 1:25:00','Mon DD YYYY HH24:MI:SS')";
    sql "alter database open resetlogs";
    release channel d1;
    release channel d2;
    release channel d3;
    }
    ## If successful, need to run reset database below
    ##reset database
    goodhealth

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your oracle version, backup client that you use and etc?

    Need more information...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2000
    Posts
    75
    Oracle 8.1.7 running on HP-UX 11.

    goodhealth

  4. #4
    Join Date
    Oct 2000
    Posts
    467

    remove until time after recover

    Hi,
    This is because your restore is till 2. Try to give a restore till the point-in-time.

    Your script should b something like -
    restore until time 1.25
    recover database

    RMAn will take the backups taken before 1.25 and apply the logs so as to make it recover till 1.25. Hope you do have all the logs since then.

    Cheers
    Vinit

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