OraFAQ Forum: Server Administration » Turn off Archive log mode in oracle 9i

Home » RDBMS Server » Server Administration » Turn off Archive log mode in oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Turn off Archive log mode in oracle 9i [message #119490]

Thu, 12 May 2005 16:46

kapil2005
Messages: 44
Registered: March 2005

Member

How do I Turn off Archive log mode of database in Oracle 9i?

Report message to a moderator

Re: Turn off Archive log mode in oracle 9i [message #119494 is a reply to message #119490]

Thu, 12 May 2005 17:44

Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas

Senior Member

Follow the following steps:

1) Shutdown the database using Shutdown normal/immediate
2) Mount the database using startup mount
3) Issue: Alter database noarchivelog;
4) Issue: Alter database open;

Now you are in noarchivelog mode.

Optionally, you can remove all LOG_ARCHIVE_* parameters from your intialization file.

Daljit Singh

Report message to a moderator