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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 13 Jul 2007 21:10:49 +0200
Message-ID: <f78ink$pvv$1@news2.zwoll1.ov.home.nl>

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

Alexander Skwar wrote:
> · Frank van Bortel <frank.van.bortel_at_gmail.com>:
>

>> Where would you import it into?

>
> Into a newly created and otherwise empty database.
>

That is where a backup comes in. Just restore. No reinstall, rerun scripts (which are never maintained anyway)

>> That is one major difference between backups and exports.
>>
>> Backups can be restored, recovered and everything is hunky-dory.

>
> Understood.
>

>> Exports (or any logical backup) must be read *into* something.
>> What if that something is gone?

>
> Recreate. It's a matter of size and SLA if that's a doable
> approach. For multi TB DBs with 5×9 requirements, it's most
> certainly not a doable approach. But for such a tiny DB like
> mine, it would be okay.

Nope - I'll restore a "tiny" db (couple of GB) faster than Oracle recreates the database. Actually, I can restore under a different name ("clone") a 3.5 GB 10G Rel 2 database in 12 minutes, on a single disk system.

Same would hold true for a multi TB database - you do not want to write those files more than once... And consider the time, an import would take. - --
Regards,
Frank van Bortel

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

iD8DBQFGl845Lw8L4IAs830RAhZKAJ4vtr+xHqwEHypB0R2Yt8r9NiWV/wCgmz99 m7wdabZdCeDkiUKKAnJ3IKA=
=wOEw
-----END PGP SIGNATURE----- Received on Fri Jul 13 2007 - 14:10:49 CDT