Re: Hot and Cold backups

On Wed, 13 Jul 2005 12:57:50 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>
>"Joel Garry" <joel-garry_at_home.com> wrote in message
>news:1121203510.487857.309420_at_g47g2000cwa.googlegroups.com...
>> See this now: http://www.dizwell.com/html/backing_up_redo.html
>>
>> jg
>> --
>> @home.com is bogus.
>>
>http://news.com.com/Stop+reading+this+headline+and+get+back+to+work/2100-1022_3-5783552.html?tag=nefd.ac
>
>The above (written by Howard Rogers I presume) emphatically states that I
>don't need (or even want) to backup the online redo logs even if I'm doing a
>cold backup. But if the db is run in noarchivelog mode, isn't it possible
>for there to be transactions in the online redo logs that have not been
>processed yet? If the database had been brought down "immediate" to perform
>the backup, it performed a checkpoint but is not necessarily current. It
>seems to me that there is the possibility of losing transactions? I know
>I'll get scolded for asking this, but I am confused and trying very hard to
>understand. Someone please clarify for me.

Open transactions in the redologs are only possible after a shutdown abort.
In all other modes all current transactions are rolled back. So you have a consistent database, so you don't need the online redo logs.
I don't see any value in making a cold backup of a database in noarchivelog after a shutdown abort.
Apart from that, to repeat HJR's words (or was it is Thomas Kyte?) 'I don't think a database running in noarchivelog is a production database'.

--
Sybrand Bakker, Senior Oracle DBA