728x90
# 압축 백업
l 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 …………………………………………………………………… |
'빅데이터과정 > WORKSHOP 2 ' 카테고리의 다른 글
#27_140721_WSHOP2_CURRENT REDO LOG FILE 복구 (0) | 2014.07.22 |
---|---|
#27_140721_WSHOP2_NON CRITICAL FILE 복구 (0) | 2014.07.22 |
#27_140721_WSHOP2_아카이브 백업 관리 (0) | 2014.07.22 |
#27_140721_WSHOP2_INCREMENTAL BACKUP (0) | 2014.07.22 |
#27_140721_WSHOP2_IMAGE COPY (0) | 2014.07.22 |