This is a nsr-rman backup script.

It writes the backup in tape. The <parameters> are particullary for your
BD.


connect target <user>/<password>@<oracle_sid>

run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=<server>,
NSR_DATA_VOLUME_POOL=<pool>)';

allocate channel t2 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=<server>,
NSR_DATA_VOLUME_POOL=<pool>)';

allocate channel t3 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=<server>,
NSR_DATA_VOLUME_POOL=<pool>)';

allocate channel t4 type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=<server>,
NSR_DATA_VOLUME_POOL=<pool>)';

backup database filesperset 4 format='FULL_%d_%u_%s';
sql 'alter system archive log current';
backup archivelog all delete input format='ARCH_%d_%u_%s';
allocate channel d1 type disk;
copy current controlfile to '/nsr/oracle/controlDWP.ctl';

release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel d1;
}





"ron"
<oracledba-ezmlmshield-x34236173.x1100113 Para: "LazyDBA
[Email address protected] Discussion"
<[Email address protected]
cc:
10/11/2004 20:12 Asunto: I
require a script to perform a
hot backup on unix.






I've been trying to find a good hot backup script but my attempts have
fallen short.
I've just registered on the LazyDBA so note sure how to find it in the
archives.

Does somebody have a good hot backup script.

Thanks in advance



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




Oracle LazyDBA home page