Re: Minimizing backup induced downtime

From: Alexander Skwar <usenet_at_alexander.skwar.name>
Date: Sat, 14 Jul 2007 14:44:35 +0200
Message-ID: <25206382.dsiXf6SBpl@m-id.message-center.info>

· Frank van Bortel <frank.van.bortel_at_gmail.com>:

> -----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.

You're right. Compared to an EXP dump + IMP import, an RMAN restore+recover is certainly faster/easier to accomplish.

Alexander Skwar

-- 
<Knghtbrd> 2fort5 sucks enough to have its own gravity ...

Received on Sat Jul 14 2007 - 07:44:35 CDT