restore point_in_time
All,
the scenario is restoring a backup from month ago to a new host. The backup is taken around 07:00 PM and I want to restore it until 11:00 AM. I do not have archive log, so I do not care about recovery.
here is how coded:
I open the instance through pfile in nomount state
- restore controlfile from 11/02 backup
- mount the database
- check available backups
-check incarnation
then set the run block as follow
run
2> { set until time "to_date('2011-10-02 20:00:00','YYYY-MM-DD:hh24:mi:ss')";
3> restore database;
4> }
and got this :
creating datafile fno=1 name=+DGROUP1/live/datafile/system.260.629893483
the scenario is restoring a backup from month ago to a new host. The backup is taken around 07:00 PM and I want to restore it until 11:00 AM. I do not have archive log, so I do not care about recovery.
here is how coded:
I open the instance through pfile in nomount state
- restore controlfile from 11/02 backup
- mount the database
- check available backups
-check incarnation
then set the run block as follow
run
2> { set until time "to_date('2011-10-02 20:00:00','YYYY-MM-DD:hh24:mi:ss')";
3> restore database;
4> }
and got this :
creating datafile fno=1 name=+DGROUP1/live/datafile/system.260.629893483
0