I am sure that my scripts backs up the logs, database and current control
file:

database: backup database filesperset 4 format='FULL_%d_%u_%s';
logs: backup archivelog all delete input format='ARCH_%d_%u_%s';
controlFile: ( copy to disk ) copy current controlfile to '/nsr/oracle/controlDWP.ctl';





Your script on;y backs up the logs

________________________________

From: slopezt
[mailto:oracledba-ezmlmshield-x41438080.[Email address protected]
Sent: Wed 11/10/2004 12:32 PM
To: LazyDBA Discussion
Subject: Re: I require a script to perform a hot backup on unix.


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