Switch My DB to No Archive Log Mode in 11g
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.