linux/oracle backups

[Darrell Campbell]

I have a linux redhat es2.1 OS (filesystem ext3)with Blackboard 6.1 utilizing a stripped version of Oracle 9i. I need to do a full backup to a tape device. Does anybody have any suggestions on the best method/tools to accomplish this.

[Steven E. Protter · Accepted solution]

Best method:

bring the database down.

Do an OS backup, tar, whatever to tape.

Second:
Oracle ships with a utility called rman that can also be scripted to do hot backups while the database is runing or cold, with the database down.

Third:
Third party tools like HP Data Protector 5.1 or Veritas Netbackup contain tools that use rman to do hot or cold backups of the oracle data.

SEP

[Andrea Rossi]

if you can stop the db you'd better to perform a full export and backup the dump file.

[Ranjith_5]

Hi Darrell,

Go for a full backup ,after stopping all your database instances.

RMAN can be used for taking backup of online databases as well. But in your case COLD backup is the best option.

See oracle backup and recovery here.

http://www.oracle.com/technology/deploy/availability/pdf/backup_recovery_twp.pdf

http://www.orafaq.com/faqdbabr.htm

Regards,
Syam

[MattJ123]

Aside from the Oracle stuff, tape backups are fairly straight forward. Pax would do the job well. I've heard good things about taper:
http://taper.sourceforge.net/

"It allows backups to tape drives, filesystems, floppy drives, removable devices... In fact, any device that Linux supports.

Incremental backup & selective restores are available, as well as backup verifies."