Re: How to Alter NoARCHIVELOG mode to ARCHIVELOG

From: Kenneth C Stahl <kcstahl_at_ix.netcom.com>
Date: Sat, 19 Jun 1999 10:26:48 -0400
Message-ID: <376BA8A8.F6FE1C06@ix.netcom.com>

That is not necessarily true. You can place the database in archive mode without the archive process running. What will happen then is that you will keep running until all of your redo logs fill up and then the database will "hang" because it cannot use the first redo log until it has been archived. So, while it is a darned good idea to start the archive process, it isn't exactly required. Also, once you enter the command "alter database archivelog;", you can also enter a svrmgrl command to start archiving. At that point it is then a good idea to go to your init.ora file and change the parameter so that the next time you bounce the database it will start up immediately.

Ken

William Dangren wrote:
>
> You also need to have the archive process running. You can start it in
> the init file.
>
> Bill
> --
> William Dangren
> Navis Enterprises
> 407.348.6401
> 800.219.0207
Received on Sat Jun 19 1999 - 09:26:48 CDT