need help with few questions on recovery
I am using Oracle 10.2.0.4 on win 2008 server. I take online backup using RMAN (Nocatalog) thru below script.
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
backup
filesperset 5
format 'R:\Rman_Backup\df_t%t_s%s_p%p'
database;
sql 'alter system archive log current';
backup format 'R:\Rman_Backup\al_t%t_s%s_p%p' (archivelog all delete input);
host "copy E:\oracle\product\10.2.0\db_1\database\*.ora R:\Rman_Backup\ ";
crosscheck backup;
delete obsolete;
release channel d1;
release channel d2;
}
I have to update the development server on daily basis. So i copy all the backup files from live server to development server and restore it using clone.