Re: Minimizing backup induced downtime

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

Alexander Skwar wrote:

> Suppose you're doing a RMAN backup at 22:30. At 22:45 it's
> done, ie. also writing to tape is finished at that time.
> At 23:00, the server dies and the tapes are still intact.
> With that magical RMAN thing, how will you be able to recover
> anything that's changed in the database after 22:46? My, maybe
> incomplete, understanding of how RMAN works, is, that it can
> take a backup of an Oracle database without the need for having
> it shutdown (thus a hot backup). But how will RMAN allow me
> to recover something, which hasn't been backed up?

It does, actually - it will restore the backup, and recover the database up to the very point it crashed. Oracle is smart enough not to ask for archived redo log files, that are not yet backed up, but still on disk. (provided the disk survived, of course)

It will use the backup from RMAN, the backup archived redo log files from RMAN, the not yet backed up archived redo log files, and the online redo log files for the recovery - but you have read the concepts guide, too.

• -- Regards, Frank van Bortel

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

iD8DBQFGl8N4Lw8L4IAs830RAqaKAJ9wUXHFy3eexO4EXcUo75DgZpk7TgCeNyn9 BtLGY8gQRIxG+/TjzNvpuOI=
=yKkg
-----END PGP SIGNATURE----- Received on Fri Jul 13 2007 - 13:24:56 CDT