Re: Backup file style?!

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Mon, 04 Oct 1999 13:24:28 -0400
Message-ID: <37F8E2CC.B4DBFFDC@Unforgettable.com>

Don't use tar. Use cpio it is more reliable. The documentation with most modern versionx of Unix state specifically that tar is an obsolete/archaic tool that is retained for backwards compatibility only and that cpio is the prefered tool going forward.

When I do a hot backup I put copies of my control file, the initxxx.ora and copies of the database files into a directory and then compress them. I then build file containing the names of all those files plus the names of all archived redo logs. I then run this list through cpio to create a cpio archive on the tape.

jsnj1910_at_my-deja.com wrote:
>
> New to Oracle.
>
> When do hot backup (or cold backup), is this a good way that backup
> entire database to a single file? (Using 'tar cvf', then 'tar rvf'). If
> yes, what about a big database, such as 100G? For a single file with
> 100GB, it's no good?
>
> If we have to backup big database to several file, then what's the
> backup file style? Tablespace one by one? or simply datafile one by one?
>
> Thanks a lot! More detail is helpful.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 04 1999 - 12:24:28 CDT