Re: exp and archive available.... recover table

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 14 Jul 2007 13:26:12 +0200
Message-ID: <f7absf$ep9$1@news6.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alexander Skwar wrote:

>
> Yes. Backup of "/" incl. subdirs (sorta. Certain directories, like
> /tmp or /dev, are not part of the backup).
>
> Alexander Skwar

OK, got the picture - you basically shutdown everything, and make a file level copy of (about) everything. That's OK.

Now, back to the basic question: how to do this, making sure downtime is minimized?

Sorry, but here comes RMAN:
- - RMAN can take Oracle down for you, and make a backup. - - RMAN runs parallel processes, speeding up the process of safekeeping your data (getting anxious to use the word backup :) ) true for readers, as well as writers.
- - RMAN stores what is needed - an empty 1TB datafile is backed up in a matter of seconds - it's empty. RMAN knows, your file system copy (or tar, or dd) does not.

I'd consider RMAN, just for the sake of parallelism - the only way I can think of right now to speed up you backup procedure.

Hals und Beinbruch!
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGmLLULw8L4IAs830RAvwYAJ4/dCeDK0jOGzIVkko470QAx3BoDgCdFWw3 b34EpvCCXi59W1FU43oDRIo=
=cB3A
-----END PGP SIGNATURE----- Received on Sat Jul 14 2007 - 06:26:12 CDT