Rman - Restore/recover van een database

Full restore en recovery

 startup nomount; 
run {   
allocate channel  t1 type disk; 
allocate channel  t2 type disk;   
allocate channel  t3 type disk;
allocate channel  t4 type disk;   
restore controlfile;
restore archivelog all;   
alter database mount;   
restore database; 
recover database; 
} 
sql 'alter database open resetlogs';  

Restore en point in time recovery

startup nomount; 
run { 
set until time ="to_date('30/08/2006 12:00','dd/mm/yyyy hh24:mi')";
allocate channel  t1 type disk;   
allocate channel  t2 type disk; 
allocate channel  t3 type disk;   
allocate channel  t4 type disk;   
restore controlfile;   
restore archivelog all;   
alter database mount; 
restore database;   
recover database; 
} 
sql 'alter database open resetlogs';

Als de archivelogs al op hun plaats staan:

startup mount;
run {   
set until time ="to_date('08/02/2007 14:00','dd/mm/yyyy hh24:mi')";   
allocate channel  t1 type disk;   
allocate channel  t2 type disk;   
allocate channel  t3 type disk; 
allocate channel  t4 type disk; 
restore database;   
recover database; 
}
sql 'alter database open resetlogs';

startup mount; 
run {
allocate channel  t1 type disk;  
recover database;
}