Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

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