Re: Hot and Cold backups

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Jul 2005 22:19:16 +0200
Message-ID: <p1idd193h6kf8a29fa4mokfspedf6effr8@4ax.com>

On Thu, 14 Jul 2005 19:29:41 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>Thanks for the explanation. As I posted earlier, I was under the impression
>that shutdown immediate was safe, no transactions could be lost. I
>understand now that is not the case. If I want to be certain that no data
>is lost, I need to use shutdown transactional.

Obviously you still don't understand what is going on. You won't loose transactions. An uncommitted transaction is simply not a transaction. And of course, using shutdown transactional, will make sure you can't shut down the database, ever.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Jul 14 2005 - 15:19:16 CDT