Database Backup and Recovery (MOSC)

MOSC Banner

request for help with cloning script

edited Jul 21, 2012 9:20PM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center