Re: Minimizing backup induced downtime

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 14 Jul 2007 13:35:39 +0200
Message-ID: <f7ace6$ep9$4@news6.zwoll1.ov.home.nl>

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

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

>> Alexander Skwar wrote:

>

>>> It's possible that I don't understand something here. But how
>>> can you recover the database, so that it is in the state it was at
>>> 22:55? Remember, the archive log files are lost. I'm really
>> Ah - now that is a change in scenario!

>
> Yes, maybe. It's a change which is necessary, to make the scenarios
> at least somewhat comparable.
>

>> What I will do, after the new hardware is installed:
>> * Install the Oracle software
>> * Fire up RMAN
>> * issue the restore command
>> * issue the recover command until I think it's 22:45 again.
>> * open the database.
>>
>> What will you do?

>
> * Install the Oracle software
> * Create an empty database
> * Issue the IMP command
> * Open the database.
>

Ok, OK - but that would take a whole lot more time than RMAN restores would - and the subject of the thread is minimizing downtime.

>> But please, do not call that export "a backup".
>> It is only "a" "backup" - feel the difference?

>
> Yes, I do. Let's call it a "logical backup", okay? And
> call the RMAN thing a "physical backup". Which is also
> the terminology used by Oracle.
>
> Alexander Skwar

Touche - should have used that.
- --
Regards,
Frank van Bortel

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

iD8DBQFGmLULLw8L4IAs830RAoBLAJ4ul3te2dACfa+DXwrxc8/b40YlZQCfYi/4 s+zQXdfU7AqLzNkJGSTx8jg=
=VXR8
-----END PGP SIGNATURE----- Received on Sat Jul 14 2007 - 06:35:39 CDT