Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hot and Cold backups
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 DBAReceived on Wed Jul 13 2005 - 17:37:40 CDT