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.
Hours:
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
cancel
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.
4 REPLIES
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

http://hpux.connect.org.uk/hppd/hpux/Gnu/tar-1.22/

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;
inukoti
Frequent Advisor

Re: TAR backup in tape


Try to use RMAN from oracle or tivoli TSM(it costs fortune)
or
please check this thread
http://forums13.itrc.hp.com/service/forums/questionanswer.do?threadId=1133049&admit=109447627+1238754660543+28353475

bobby
T G Manikandan
Honored Contributor

Re: TAR backup in tape

script attached
Steven E. Protter
Exalted Contributor

Re: TAR backup in tape

Shalom,

http://searchoracle.techtarget.com/news/article/0,289142,sid41_gci940894,00.html

http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ


Lots of other good examples out there.

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