Cpio Backup inc and tot

[uadm26]

Hi, Guys

I'm trying to create a script to backup a full server, that runs DB oracle. The question is i need to do a diary incremental backup, and a weekend full backup, a oracle cold backup. I think the command cpio is the better, because can copy open files. How can write a good script for a incremental backup with cpio, saving only in one tape. And the restore of data is simple?

[Peter Godron]

Joel,
whatever you do I would advise against just backing up open oracle files. You have to either shut everything down (cold backup) or switch to archive mode (hot). Restores can only be done to the status that is on the tapes, so establish first how often you want to back up and what overhead of archiving you can afford.
Sorry to be this vague, but there are a lot of different solutions documented already.

[Patrick Wallek]

I would absolutely not use cpio as a backup method.

You would be much better off looking into using either fbackup or some commercial backup software that is designed to work with Oracle.

As said above, just backing up an Oracle data file will do you absolutely no good unless: 1) The DB is in archive log mode already, and prior to starting the backup you put it into backup mode, or 2) You completely shut down the DB. If you just try to backup the DB, your backup will be useless.

[uadm26]

Hi,

On incremental backup, i don't care about open oracle files, but user files. I've readed, but what's the best command to make backup to a system files and in same time user files, cpio or fbackup. fbackup it's better then cpio?

Thanks

[Patrick Wallek]

fbackup is much better than cpio. fbackup CAN actually do full and incremental backups. As far as I know, cpio cannot.

fbackup, when tuned correctly, will be much faster than cpio. Your restores (frecover) should be much faster as well.

Also, fbackup can handle files larger than 2GB. I don't think cpio can.

[uadm26]

So, tell me what can cpio do that fbackup don't? Why people use so many times cpio, for backup files?

[Paul_481]

Hi,

Check this link for different backup command in unix.

http://www.uwsg.iu.edu/usail/backups/backup/

Regards,
Paul

[Paul_481]

Hi,

Here's the link that describes the fbackup command.

http://www.uwsg.iu.edu/usail/backups/backup/hp/

Regards,
Paul