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


Oracle 10.2.0.4, 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'

database;

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.


Thanks,

[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: Thu Mar 28 12:46:27 CDT 2024