Re: Recovery possible?

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Fri, 2 Jul 1999 21:43:07 -0300
Message-ID: <qRdf3.932$jl.10788938@newscontent-01.sprint.ca>

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:3786d1c5.150939018_at_newshost.us.oracle.com...

> If you shutdown normal or shutdown immediate yes.
>
> If you shutdown abort and back it up -- you will not be able to roll this
backed
> up instance forward.

The rollback event does not appears when you make SHUTDOWN ABORT. In other it looks like SHUTDOWN IMMEDIATE. The transaction information is written in the current redo log file any way, was it commited or not.

Therefore you can backup datafiles shutdowned rudely. At next start Oracle will ARCH will switch redo log and write the recent current redo log file into archive log. You can roll forward this archive in the future.
Of cource, uncommited transaction will be rollbacked after rollforward.

Regards,
Mark Malakanov Received on Fri Jul 02 1999 - 19:43:07 CDT