Home » RDBMS Server » Backup & Recovery » cloning script request (, win 2008 r2)
cloning script request [message #561153] Thu, 19 July 2012 02:36
Messages: 52
Registered: December 2009
Location: Hyderabad,India

Oracle, Win 2008

I am taking full backup thru rman using the below script.

run {

allocate channel d1 type disk;

backup filesperset 5

format 'R:\backup\df_t%t_s%s_p%p'


sql 'alter system archive log current';

backup format 'R:\backup\al_t%t_s%s_p%p' (archivelog all delete input);

crosscheck backup;

delete obsolete;

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

Previous Topic: Recovery Terminate due to log corruption.
Next Topic: Data missed from table
Goto Forum:

Current Time: Mon Sep 20 15:30:31 CDT 2021