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




algotubeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sathyagiriConnect With a Mentor Commented:
Yes you're right

SHUTDOWN;

STARTUP MOUNT EXCLUSIVE;

ALTER DATABASE NOARCHIVELOG;

ALTER DATABASE OPEN;
0
 
johnsoneConnect With a Mentor Senior 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
All Courses

From novice to tech pro — start learning today.