HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Showing results for 
Search instead for 
Did you mean: 

TAR backup in tape

Deepu Chakravarty
Regular Advisor

TAR backup in tape

We want to take complete online oracle database hot backup in external drive (tape - c2t3d0BEST). The hot database backup will be done as follows:
make the tablespace on backup mode
copy the database file in the tape
make the tablespace out of backup mode
This will be done for every database file.
What would be the correct hot database backup script to achive this? Thanks in advance.
T G Manikandan
Honored Contributor

Re: TAR backup in tape

sample script from metalink, customize as required.

if you use tar , you need to use GNU tar to overcome 2Gb file limitations


Else you can go with fbackup available on hpux.

Also, if you are using 10G you are take the database directly to hot backup mode which can be altered in the script. i.e.

SQL> alter database begin backup;

It will take all the datafiles in hot backup mode. We can verify that from V$BACKUP view.

SQL> alter database end backup;
Frequent Advisor

Re: TAR backup in tape

Try to use RMAN from oracle or tivoli TSM(it costs fortune)
please check this thread

T G Manikandan
Honored Contributor

Re: TAR backup in tape

script attached
Steven E. Protter
Exalted Contributor

Re: TAR backup in tape




Lots of other good examples out there.

Steven E Protter
Owner of ISN Corporation
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com