Monday, February 14, 2011

Enable Disable Archivelog

I use this sequence to enable and disable archivelog mode in 10g and 11g:

==================================
ENABLE ARCHIVELOG
==================================
SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
NOARCHIVELOG

SQL> ALTER SYSTEM SET log_archive_dest_1='location=C:\ARCH01' SCOPE=both;

System altered.

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP MOUNT;
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 721420752 bytes
Database Buffers 343932928 bytes
Redo Buffers 4603904 bytes
Database mounted.

SQL> ALTER DATABASE ARCHIVELOG;

Database altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL>


==================================
DISABLE ARCHIVELOG
==================================

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 721420752 bytes
Database Buffers 343932928 bytes
Redo Buffers 4603904 bytes
Database mounted.

SQL> alter database NOARCHIVELOG;

Database altered.

SQL> alter database open;

Database altered.

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

SQL>

No comments: