Let’s system of a down :) Beware… highly advisable to TURN OFF sound if you don’t like hard rock :P
can be done easily with the following statements:
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
If your database version is prior 10g then after shutdown and before open database you must set log_archive_start = TRUE in your init.ora and/or spfile.ora. After that, login as "sys" and you can check it out with:
SQL> archive log list;
SQL> select log_mode from v$database;
Note: In this case, we need to do a quick restart of the database to enable it to "Archive Log Mode". So please ensure your the required outage window.
No comments:
Post a Comment