Re: Consequence of switching to ARCHIVE = False without Alter Database Noarch cmd

"Ton" <76434.1353_at_compuserve.com> wrote in message news:4477604.0211010313.7c9afb11_at_posting.google.com...
> Can someone tell me what will happen if:
>
> -The database is in automatic archive mode
> -I Change the parameter to LOG_ARCHIVE_START=FALSE
> -Shutdown the database
> -Restart the database without executing " alter database noarchivelog " ??

Why don't you try it on a scratch instance?

Actually what should happen is that the database will open and will work for a while until all the redo log groups have been cycled through. At this point the db will stop until the DBA *manually* archives the required logs.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************