fbackup and large files limitation

[Ali Kouider]

Hi

I am doing backup for my database with fbackup command and we need to know if their any limitation regarding the files that is great than 2gb.

Also I have the following error.
129: /ora1/oradata/baantemp02.dbf 9379856
fbackup(3009): WARNING: File number 129 (/ora1/oradata/baantemp02.dbf)
was not successfully backed up
the application is stopped during the backup any idea.

Thank you, for the help
Ali

[Khalid A. Al-Tayaran]

Hi,

fbackup can backup latge files. It is the solution instead of tar for file > 2GB. Your warning message came because the file(s) you backed up are open. It seems you are using oracle. You have to SHUTDOWN Oracle to take backup of data files (not just stopping the application) if the only solution is to backup using fbackup at the OS level. You need advanced tools such as OmniBackII for Oracle databases. Also in SAP env. you can use BR* tools provided with SAP...

[Khalid A. Al-Tayaran]

Clarification:
You need advanced tools such as OmniBackII for Oracle databases ONLINE WITHOUT SHUTDOWN.

[Fragon]

Hi Ali, fbackup can backup files larger than 2GB, there will be no problem!
For an alternative way to use tar, you can use GNUtar, it support files larger than 2 GB and compatible with tar.
fbackup can't backup some files which are in using and usually give the message just like "xxx was not successfully backed up".
Omniback II ,of course ,is a good backup system but not free. If the budget hasn't been made, you can shutdown the DB service first then do the backup, it also work fine.

-ux

[Steven E. Protter]

fbackup can do the big files as long as they aren't bigger than your tape.

fbackup can not do a successful hot backup of oracle databases.

As noted by my predecessors, the only way to get a backup is to shut down that database first and make sure its really down before you start.

SEP

[Alexander M. Ermes]

Hi there.
First we take a look at your error message.
This means, that the backup for your Oracle database is not worth something, because you miss a file.
To avoid this you either do a shutdown before the backup or you get some backupsoftware, which can handle online backups of Oracle. Legato or OmniBack should do it, but these products are not for free.
So think carefully, what you will do.
Rgds
Alexander M. Ermes

[twang]

- fbackup support large file (> 2GB)
( The filesystem you are writing to must support largefiles. Do this to check # fsadm -F vxfs /data)
- Omniback can support Oracle online backup, but no free
- without Omniback, you still can perform online backup on oracle:
1. DB must be in Archive log mode
2. take tablespace offline
3. backup corresponding datafiles (don't use fbackup because it will fails)
4. take the tablespace online
5. backup the archive logs.