Best way to do a full backup

[CSP_ALGERIA]

Hello,

We need to recrate lvm structure on other disks.
The customer is using large files, and oracle and he may do a full backup before. I think that tar utility in not a good command when using large files, can we use for example fbackup/frecover to do the backup and restore?
If yes, we need all option for those commands to restore the data.

If not what is the best way to do it.

Best regards

Omar

[Alex Lavrov.]

To keep it simple, you can use "gtar". Gtar can handle files larger than 2GB.

If you choose gtar, it's here:
http://hpux.connect.org.uk/hppd/hpux/Gnu/tar-1.15/

Alex

[Mohanasundaram_1]

Hi Omar,

Yes, fbackup + frecover is an option to backup and restore the files. All you have to do to check the available option is

man fbackup
man frecover

There is no better document than the man pages.

With regards,
Mohan.

[Alessandro Pilati]

Here it is some useful disk for you:

http://docs.hp.com/en/5187-0151/ch01s11.html

http://docs.hp.com/en/B2355-90681/fbackup.1M.html

http://docs.hp.com/en/B2355-90681/frecover.1M.html

You can also use make_tape_recovery with the options "-x inc_entire=vgname" to include all VGs you want

Then the recovery is doable rebooting with installation CD and then recovery from tape.

Rgds,
Alex

[Geoff Wild]

Yes, you can use fbackup/frecover.

Sounds like you are migrating the db to new disks?

You could use vxdump/vxrestore for that like so:

vxdump -0 -f - -s 1000000 -b 16 /oracle | (cd /zmnt/oracle ; vxrestore rf -)

where zmnt is a temporary place to mount your new disks.

You will have to build your lvm structure manually first, then mount the "new" disks under say /zmnt/

db must be down for this.

after the copy is finished, unmount both the old and new, make a backup of /etc/lvmtab, then edit /etc/lvmtab and point the mounts to the new disks.

Rgds...Geoff

[Pedro Cirne]

Hi Omar,

An obvious (sometimes not so obvious...) remind is that you can't use tar, fbackup, gtar or something similar to backup you Oracle DB on-line.

Check that with your DBAs, one month ago in Lisbon a server crashed in the main hospital of the city and when they wanted to restore from backups, all DB backups where made on-line with tar. It was caos!

Enjoy :)

Pedro

[Ranjith_5]

with fbackup following is the procedure.

fbackup -0 -f /dev/rmt/c?t?d?BEST -I /tmp/index -v

0 = Or "1" - (0 = full, 1 = incremental)
f = Device file to use
I = Directory to place index
v = Verbose


Other option is to use GNUtar

available @ http://www.gnu.org/software/tar/

Regards,
Syam