topic Re: linux/oracle backups in Operating System - Linux

linux/oracle backups

Darrell Campbell — Thu, 02 Dec 2004 17:44:22 GMT

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.

Re: linux/oracle backups

Steven E. Protter — Thu, 02 Dec 2004 20:25:29 GMT

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

Re: linux/oracle backups

Andrea Rossi — Fri, 03 Dec 2004 08:34:57 GMT

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

Re: linux/oracle backups

Ranjith_5 — Fri, 03 Dec 2004 09:17:52 GMT

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

Re: linux/oracle backups

MattJ123 — Fri, 03 Dec 2004 10:02:12 GMT

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."