SQL>shutdown immediate
or
SQL> shutdown abort
SQL> startup mount
SQL> alter database noarchivelog
SQL> alter database open
SQL> archive log list;
and see that archive status will be in no archive log mode.
Waqas Rafi
Wednesday, July 29, 2009
Turn off archive mode
Subscribe to:
Post Comments (Atom)
0 Comments:
Post a Comment