Solved

Changing from ARCHIVELOG mode to NOARCHIVELOG mode

Posted on 2006-07-19
2
11,035 Views
Last Modified: 2012-05-05
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
Comment
Question by:algotube
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
sathyagiri earned 60 total points
ID: 17139299
Yes you're right

SHUTDOWN;

STARTUP MOUNT EXCLUSIVE;

ALTER DATABASE NOARCHIVELOG;

ALTER DATABASE OPEN;
0
 
LVL 35

Assisted Solution

by:johnsone
johnsone earned 40 total points
ID: 17139930
You can also set log_archive_start to false.  When you are not archiving, it is not necessary to start that process.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question