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:
Post a Comment