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

Thread: RMAN Restore

  1. #1
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110

    RMAN Restore

    Hi all,
    I have this restore that say time is 11/09/2007 but why would RMAN say it is starting the restore on the 14th Nov?. It did not complain about anything.
    thanks

    RMAN> run {
    shutdown immediate; startup mount;
    set until time="to_date('11/09/2007 21:39:37','mm/dd/yyyy hh24:mi:ss')";
    restore database;
    recover database;
    alter database open resetlogs;
    }
    database closed
    database dismounted
    Oracle instance shut down

    connected to target database (not started)
    Oracle instance started
    database mounted


    executing command: SET until clause

    Starting restore at 14-NOV-07
    allocated channel: ORA_SBT_TAPE_1
    channel ORA_SBT_TAPE_1: sid=542 devtype=SBT_TAPE
    Looking for the greatest evil in the world? Look in the mirror.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    That is the time when you asked ramn to start the restore the current date.
    Nothing to do with your point in time restore.

    If you do the same thing tomorrow it will show tomorrows date and so on

    regards
    Hrishy

  3. #3
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    Quote Originally Posted by hrishy
    Hi

    That is the time when you asked ramn to start the restore the current date.
    Nothing to do with your point in time restore.

    If you do the same thing tomorrow it will show tomorrows date and so on

    regards
    Hrishy
    Thanks
    Looking for the greatest evil in the world? Look in the mirror.

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