topic Re: Oracle hotbackup in Operating System - HP-UX

Oracle hotbackup

aaronleung_1 — Tue, 09 Apr 2002 07:38:25 GMT

hello all

We are using fbackup to performance oracle hotbackup, but some tablespace is always saying the fbackup commnad that "it is unsuccessfuly backup by fbackup"

What OS backup command is good to use in hp-ux for oracle hotbakcup ??
Can you tell me what OS backup command are you using for Oracle Hotbackup. ??
Our tablespace size is about 10GB.

Regards,

Aaron

Re: Oracle hotbackup

Volker Borowski — Tue, 09 Apr 2002 07:41:35 GMT

tar, cpio and dd do the job quite well.
Be sure to set Oracle tablespaces to BACKUP mode.

Volker

Re: Oracle hotbackup

Andreas D. Skjervold — Tue, 09 Apr 2002 07:59:29 GMT

Hi

A better solution for hotbackup is using Oracle Recovery Manager (RMAN), as this performs online databasebackup without having to set the tablespaces in backup mode. (Which inturn can create large rollback)

RMAN can backup to local tapedrives or to disk. For remote tapedrives you have to purchase a Media Manager that fits your tapesystem, such as "Networker Module for Oracle" for Legato systems (approx $4000!)

RMAN backups without influence on database performance, and keeps trace of previous backups and archivefiles.
You also have the posibility to run incremental backup that works on the Oracle block level.

Andreas

Re: Oracle hotbackup

Justo Exposito — Tue, 09 Apr 2002 08:11:08 GMT

Hi,

You can use OmnibackII or Veritas Netbackup product in order tu backup Oracle, but this product have aditional cost for you.

Regards,

Justo.

Re: Oracle hotbackup

Printaporn_1 — Tue, 09 Apr 2002 08:35:53 GMT

Hi,

Use
- alter tablespace begin backup.
- use fbackup to backup the corresponding datafiles
- alter tablespace end backup.

Re: Oracle hotbackup

aaronleung_1 — Tue, 16 Apr 2002 00:50:50 GMT

hello, all

I have use this method.
---------
Use
- alter tablespace begin backup.
- use fbackup to backup the corresponding datafiles
- alter tablespace end backup.

--------------
But still have fbackup error.
If I use tar, can tar backup file that is larger that 2GB in size.

Does anyone use fbakcup to perform hotbackup