archive mode 변경

SQL> alter system switch logfile;

System altered.

 

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/11.2.0/dbs/arch
Oldest online log sequence     23
Current log sequence             25

SQL>
SQL> !mkdir -p /u01/arch

SQL> alter system set log_archive_dest_1='location=/u01/arch/';

System altered.

 

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

SQL> startup mount
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2257840 bytes
Variable Size             541068368 bytes
Database Buffers          289406976 bytes
Redo Buffers                2371584 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

 

SQL> alter database open;

Database altered.

 

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/arch/
Oldest online log sequence      23
Next log sequence to archive   25
Current log sequence              25
SQL>
SQL> alter system switch logfile;

System altered.

 

SQL> !ls /u01/arch
1_25_915139467.dbf

 

 

 

alter system switch logfile; 명령어를 치면

 

Oldest online log sequence  23 --> log sequence number가 올라간다.
Current log sequence          25 --> log sequence number가 올라간다.