Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    53

    Unanswered: Restore from RMAN full backup

    Hi ,



    please guide me for restoring Oracle 10.2.0.5 database from RMAN full backup?



    Please help!

    full backup is from 8th and I have archive log from 8th to 12 (14:55).

    Can i use this

    RMAN:> shutdown immediate;
    RMAN:> startup mount;
    RMAN> run
    {
    set until time "to_date('2014-03-12:15:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
    restore database;
    recover database; }

    will it take RMN full backup and log after that till march 12 (14:55)


    Please guide

    thank

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    If you want to know what RMAN will do, then execute this command:
    Code:
    RESTORE DATABASE 
            UNTIL TIME "TO_DATE('201403121500','YYYYMMDDHH24MI')" 
            PREVIEW;
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •