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