Oracle 10g에서 Archive Log Mode를 변경하는 절차입니다.
1. No Archive Mode -> Archive Mode 노 아카이브 모드에서 아카이브 모드로
2. Archive Mode -> No Archive Mode 아카이브 모드에서 노 아카이브 모드로
This is how to enable archiving: 아카이브 모드로 변신 (-ㅂ- )/
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> archive log list : 현재 모드를 우선 확인합니다. 노 아카이브가 맞군용 .. !!!
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 26
Current log sequence 28
SQL> shutdown immediate : 우선 DB를 Shutdown 합니다.
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount : Mount 시킵니다.
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 96469696 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database archivelog; 아카이브 모드로 설정합니다.
Database altered.
SQL> alter database open; DB를 Open 합니다.
Database altered.
SQL> archive log list : 모드를 확인 해 보니, 아카이브로 변경됐군요 ~ ^^
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 26
Next log sequence to archive 28
Current log sequence 28
SQL>
===================================================================================
위에 설명해 놨으니, 이건 그냥 누워서 떡먹기죠 ?!!
( 사실상, 누워서 떡을 먹기란 매우 힘들다.. (-_,-a)
This is how to disable archiving:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 100664000 bytes
Database Buffers 180355072 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 26
Current log sequence 28
SQL>