Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Minimizing backup induced downtime

Re: Minimizing backup induced downtime

From: Frank van Bortel <>
Date: Fri, 13 Jul 2007 20:41:25 +0200
Message-ID: <f78h0g$7g1$>

Hash: SHA1

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!

> interested - how can that be done? I mean, on tape (or on some
> other secure location/medium) there's the database the way it
> was up until 22:45, at best. Isn't it? From where does RMAN/Oracle
> pull the data about what has been done between 22:46 and 22:59,
> if archive logs aren't available?

OK - I'll take you up on that one - your server is lost due to the raging, blazing firestorm. So is your diskfarm. Luckely, I have my RMAN backup stored off-site. You were as wise as me - your export dumps are also off-site.

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?

You do not have a backup you can restore - you have a file in which you dumped data.

I have a backup of the database, you do not. You have data. And that is all you have.


>> turn 40." It's not the age, it's the unwillingness to learn and apply >> the better technology where it's appropriate that wrecks careers.

Thank you, Roger. Turned 50. Still willing.
> It's all nice, that I can do a PIT of Oracle - but really, what
> do I do with that? Not in general or in a Oracle only world, but
> in the scenario I described.

Correct - in your scenario, you export some data. That is sufficient for your environment, and it will work in many environments. It is a valid addition to making copies of file systems, running RMAN, or home brew scripts.

But please, do not call that export "a backup". It is only "a" "backup" - feel the difference? The latter is a scenario. Sigh - English is not my native tongue, I cannot explain the subtle difference.

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

iD8DBQFGl8dVLw8L4IAs830RArjvAJ9DH6RjIpVzktXD6SD0xHgPIUmijwCeIEyl duvQXKZMFvvuqC5m/Y5eE08=
-----END PGP SIGNATURE----- Received on Fri Jul 13 2007 - 13:41:25 CDT

Original text of this message