본문 바로가기

빅데이터과정/WORKSHOP 2

#27_140721_WSHOP2_압축 백업

728x90

# 압축 백업




full backup 을 수행하는 압축으로 백업하시오

RMAN> backup as compressed backupset database;
RMAN> list backupset;
 # 압축 설정 여부 확인


……………………………………………………………………
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
48      Full    9.67M      DISK        00:00:03     21-JUL-14     
        BP Key: 48   Status: AVAILABLE  Compressed: NO  Tag: TAG20140721T113644
        Piece Name: /home/oracle/DBDB/autobackup/2014_07_21/o1_mf_s_853501004_9wrz5zb0_.bkp
  SPFILE Included: Modification time: 21-JUL-14
  SPFILE db_unique_name: DBDB
  Control File Included: Ckp SCN: 2707581      Ckp time: 21-JUL-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
49      Full    21.48M     DISK        00:00:16     21-JUL-14     
        BP Key: 49   Status: AVAILABLE  Compressed: YES  Tag: TAG20140721T114259
        Piece Name: /home/oracle/DBDB/backupset/2014_07_21/o1_mf_nnndf_TAG20140721T114259_9wrzkncy_.bkp
  List of Datafiles in backup set 49
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 2707865    21-JUL-14 /u01/app/oracle/oradata/dbdb/example01.dbf
6       Full 2707865    21-JUL-14 /u01/app/oracle/oradata/dbdb/user06.dbf
……………………………………………………………………