Home » RDBMS Server » Server Administration » Turn off Archive log mode in oracle 9i
Turn off Archive log mode in oracle 9i [message #119490] Thu, 12 May 2005 16:46 Go to next message
kapil2005
Messages: 44
Registered: March 2005
Member
How do I Turn off Archive log mode of database in Oracle 9i?
Re: Turn off Archive log mode in oracle 9i [message #119494 is a reply to message #119490] Thu, 12 May 2005 17:44 Go to previous messageGo to next message
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
Re: Turn off Archive log mode in oracle 9i [message #211869 is a reply to message #119494] Tue, 02 January 2007 15:18 Go to previous messageGo to next message
Rustican
Messages: 51
Registered: July 2006
Member
Will this process also work for 10g?
Re: Turn off Archive log mode in oracle 9i [message #211876 is a reply to message #211869] Tue, 02 January 2007 17:10 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Pretty much yes.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/archredo.htm#i1006246
Previous Topic: Audit file filed
Next Topic: error in import
Goto Forum:
  


Current Time: Tue Dec 06 02:46:53 CST 2016

Total time taken to generate the page: 0.09778 seconds