| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
