Re: Alter System Archive log start

vkwan_at_news.dorsai.org (Vito Kwan) wrote:

>Hi all,
> Our database was running in noarchive log mode, then we decided to
>move it to archive log mode. Here what I did:
> 1. shutdown the DB
> 2. Start up the instance and mount exclusive
> 3. Alter datbase archive log
> 4. Alter database open
> 5. Alter system archive log start
> 6. *** Problems happened ***

"alter system archive log start/stop" are commands to perform _manual_ archiving. For automatic archiving, you need to set log_archive_start=true in your init.ora file, then restart the instance.

Paul Baumgartel, Principal Consultant              paulb_at_pcnet.com 
Adept Computer Associates, Inc.                                    
********************************************************************