Enable or Disable Archivelog in oracle:
Enable:
C:\>SQLPlus
SQL> Shutdown immediate SQL> startup mount SQL> ALTER DATABASE archivelog; SQL> ALTER DATABASE OPEN; |
Disable:
C:\>SQLPlus
SQL> Shutdown immediate SQL> startup mount SQL> ALTER DATABASE noarchivelog; SQL> ALTER DATABASE OPEN; |
Check the status:
C:\>SQLPlus
SQL> SELECT log_mode FROM v$database; |