TAR backup in tape

[Deepu Chakravarty]

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]

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]

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]

script attached

[Steven E. Protter]

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