Files
notes/tiddlywiki/RMAN restore UNTIL TIME.txt
2026-03-12 22:01:38 +01:00

25 lines
713 B
Plaintext
Executable File

rman target /
run
{
set until time "to_date('26-06-2019:09:00:00','DD-MM-YYYY:HH24:MI:SS')";
shutdown abort;
startup mount;
allocate channel ch01 device type disk;
allocate channel ch02 device type disk;
allocate channel ch03 device type disk;
allocate channel ch04 device type disk;
allocate channel ch05 device type disk;
allocate channel ch06 device type disk;
allocate channel ch07 device type disk;
allocate channel ch08 device type disk;
allocate channel ch09 device type disk;
allocate channel ch10 device type disk;
allocate channel ch11 device type disk;
allocate channel ch12 device type disk;
restore database;
recover database;
alter database open resetlogs;
}