Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Switch My DB to No Archive Log Mode in 11g

fadiwilliamApr 23 2013 — edited Apr 23 2013
I have a big database running on oracle 11g release 2 with a lot of users and huge of transactions per day running in the archivelog mode, I'm going to change the mode of the database to no archive log mode

using the following steps :-

SQL> shutdown immediate

SQL> startup mount

SQL> alter database noarchivelog;

SQL> alter database open;


is there any risk to do that

may the database after altered to noarchivelog mode, couldn't be opend?

what are the Reserves to be taken before conducting this work ?


thanks a lot.
This post has been answered by Mahir M. Quluzade on Apr 23 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2013
Added on Apr 23 2013
11 comments
2,175 views