|cloning script request [message #561153]
||Thu, 19 July 2012 02:36
Registered: December 2009
Oracle 10.2.0.4, Win 2008
I am taking full backup thru rman using the below script.
allocate channel d1 type disk;
backup filesperset 5
sql 'alter system archive log current';
backup format 'R:\backup\al_t%t_s%s_p%p' (archivelog all delete input);
release channel d1;
Inorder to clone the live database daily on clone machine, I copy the backup files to Auxilliary machine to the same directory as Live theu script.
My question is:
how can i restore the database from beginning thru script. I mean
they cmd prompt, set ORACLE_SID and ORACLE_HOME
start the database in nomount
how to include the scn number automatically in the restore script.
I have same directory structure on both Live and Auxiliary machines and nocatalog. Database name and sid can be same on both servers
Please guide me.
[Updated on: Thu, 19 July 2012 02:39]
Report message to a moderator