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

Thread: RMAN Question

Threaded View

  1. #1
    Join Date
    Mar 2008
    Posts
    20

    RMAN Question

    Hi experts
    i have a question on incomplete recovery with RMAN, with UNTIL TIME CLAUSE.

    I have this situation:

    T1............. T2 ......T? ..............T3........................... T4......... T5
    ___________ __________________ ___________________ ________
    ................BKP.........................BKP...........................BKP


    T1 is initial time, T5 is now.
    T2, T3, T4 r the time in which i make backup (BKP)
    I'd like to restore my DB, at T? time. It's between T2 and T3.
    I make correct syntax but i receive this error:
    run {
    shutdown immediate;
    startup mount;
    sql "alter session set nls_date_format = ''DD-MON-YYYY HH24:MI:SS''";
    set until time '14-MAR-2008 12:11:00';
    restore database;
    recover database;
    alter database open resetlogs;
    }
    Error:
    RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME is before RESETLOGS time

    It's possibile this kind of recovery? or i can only recover the last version of backups?

    PS:Sorry for my poor english
    Last edited by master.jimmy; 03-18-2008 at 09:46 AM.

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