• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11447
  • Last Modified:

Changing from ARCHIVELOG mode to NOARCHIVELOG mode

Hello experts:
Running
Oracle9i Enterprise Edition Release 9.2.0.7.0
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
--------------------------------------------

I need to change from ARCHIVELOG mode to NOARCHIVELOG mode on my test box. Just need to clarify the steps needed:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;

ALTER DATABASE
NOARCHIVELOG;

ALTER DATABASE OPEN;

Are these all the steps needed????

Thanks for your time




0
algotube
Asked:
algotube
2 Solutions
 
sathyagiriCommented:
Yes you're right

SHUTDOWN;

STARTUP MOUNT EXCLUSIVE;

ALTER DATABASE NOARCHIVELOG;

ALTER DATABASE OPEN;
0
 
johnsoneSenior Oracle DBACommented:
You can also set log_archive_start to false.  When you are not archiving, it is not necessary to start that process.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now