Wednesday, August 12, 2009

Incomplete Restore

First time I actually did this:

A dev DB was faulty and the Developers asked me to restore it to one week before (05.08.2009 - 20:00)

Action plan:

- startup force mount
- Delete datafiles via asmcmd
- rman target /
- run {
set until time "to_date('2009-08-05:20:00:00','YYYY-MM-DD:hh24:mi:ss')";
restore database;
recover database;
}
Easy =)

Labels: , , , ,