RE: I require a script to perform a hot backup on unix.

RE: I require a script to perform a hot backup on unix.

 

  

I'm looking for a non RMAN script. Which performs all database checking,
eg check to make sure db is up, tablespace is not already in hotbackup
mode, etc

-----Original Message-----
From: slopezt
[mailto:oracledba-ezmlmshield-x41438080.[Email address protected]
Sent: November 10, 2004 2:33 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





--------
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