Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple hot backup script with RMAN

Status
Not open for further replies.

sgwisby

Technical User
Apr 13, 2005
148
US
Hi, new to Oracle but have been given task of setting up DR for Oracle db. Only have one database(instance I believe is the term).
Can someone verify this simple script will work for backing up the database online with RMAN?

{
allocate channel c1 device type disk maxpiecesize 10G;
backup database format ‘/backup/ouprd/rm_bk/%d_%t_%s_%p’
include current controlfile;
sql ‘alter system archive log current;
backup archivelog all format ‘/backup/ouprd/rm_bk/%d_%t_%s_%p’

delete noprompt obsolete;
release channel c1;
}

Thanks for any suggestions
 
Also, is this sufficient for restore and recovery?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top