Wednesday, July 29, 2009

Turn off archive mode

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

0 Comments:

Disclaimer: Independent operated blog, feed backs at kaxxi.khan@gmail.com
© copyright 2011 info-logy.blogspot.com