1748170 Members
4211 Online
108758 Solutions
New Discussion юеВ

Oracle hotbackup

 
aaronleung_1
Occasional Advisor

Oracle hotbackup

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
5 REPLIES 5
Volker Borowski
Honored Contributor

Re: Oracle hotbackup

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

Volker
Andreas D. Skjervold
Honored Contributor

Re: Oracle hotbackup

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Justo Exposito
Esteemed Contributor

Re: Oracle hotbackup

Hi,

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

Regards,

Justo.
Help is a Beatiful word
Printaporn_1
Esteemed Contributor

Re: Oracle hotbackup

Hi,

Use
- alter tablespace begin backup.
- use fbackup to backup the corresponding datafiles
- alter tablespace end backup.
enjoy any little thing in my life
aaronleung_1
Occasional Advisor

Re: Oracle hotbackup

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