Oracle ArchiveMode 설정

아카이브모드 설정

SQL> show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string


SQL> alter system set log_archive_dest_1='LOCATION=/arch'  scope=both;

System altered.

SQL> alter system set log_archive_format='%s_%t_%r.rac' scope=spfile;

System altered.

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

Total System Global Area 4294967296 bytes
Fixed Size                  8628936 bytes
Variable Size            1090520376 bytes
Database Buffers         3187671040 bytes
Redo Buffers                8146944 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;



SQL> select instance_name , status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl12se         OPEN


아카이브 경로변경

SQL> alter system set log_archive_dest_1='LOCATION=/oradata/backup/arch/12cse' scope=both;

System altered.


SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oradata/backup/arch/12cse
Oldest online log sequence     80
Next log sequence to archive   82
Current log sequence           82
SQL> alter system switch logfile;

System altered.


SQL> show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      LOCATION=/oradata/backup/arch/
                                                 12cse
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string