Re: Hot and Cold backups

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Jul 2005 00:37:40 +0200
Message-ID: <2q5bd190hhios54f4lmo663697jp1qu3iu@4ax.com>

On Wed, 13 Jul 2005 20:37:30 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>If shutdown immediate is used and uncommitted transactions are rolled back.
>Won't those transactions be kept in the online redo logs to be processed
>when the database comes back on line?

Definitely not, as they are being rolled back during the shutdown immediate. And even if they would be kept, they would still be uncommitted transactions, and get rolled back. A transaction ends with a commit marker. Anything without a commit marker can be safely rolled back.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Jul 13 2005 - 17:37:40 CDT