오라클 on-line backup

---  테이블 스페이스에 대한 온라인 백업

 

 

SQL> archive log list
Database log mode              Archive Mode      <-------------  아카이브모드 확인
Automatic archival             Enabled
Archive destination            /oracle
Oldest online log sequence     261
Next log sequence to archive   263
Current log sequence           263

 

 

SQL> show parameter log

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_1          string
db_create_online_log_dest_2          string
db_create_online_log_dest_3          string
db_create_online_log_dest_4          string
db_create_online_log_dest_5          string
dblink_encrypt_login                 boolean     FALSE
log_archive_dest                     string      /oracle
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      arch_%t_%s.arc
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     TRUE       <---------- 온라인백업 가능
log_archive_trace                    integer     0

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_buffer                           integer     524288
log_checkpoint_interval              integer     0
log_checkpoint_timeout               integer     1800
log_checkpoints_to_alert             boolean     FALSE
log_file_name_convert                string
log_parallelism                      integer     1
logmnr_max_persistent_sessions       integer     1
remote_login_passwordfile            string      EXCLUSIVE

 

 

/ONLINE_BACKUP 디렉토리에 백업

 

 SQL> alter tablespace system begin backup;          <------- system 테이블

Tablespace altered.

 

SQL> host cp /oracle/oradata/chulani/system01.dbf /ONLINE_BACKUP

 

SQL> alter tablespace system end backup;

Tablespace altered.

 

 

SQL> alter tablespace temp begin backup;          <------- temp 테이블

Tablespace altered.

 

SQL> host cp /oracle/oradata/chulani/temp01.dbf /ONLINE_BACKUP

 

SQL> alter tablespace temp end backup;

Tablespace altered.

 

 

SQL> alter tablespace undotbs begin backup;          <------- undotbs 테이블

Tablespace altered.

 

SQL> host cp /oracle/oradata/chulani/temp01.dbf /ONLINE_BACKUP

 

SQL> alter tablespace undotbs end backup;

Tablespace altered.

 

 

SQL> alter tablespace query begin backup;          <------- query 테이블

Tablespace altered.

 

SQL> host cp /oracle/oradata/chulani/temp01.dbf /ONLINE_BACKUP

 

SQL> alter tablespace query end backup;

Tablespace altered.