Programming/Oracle

아카이브로그 백업하고 지우기~

초록깨비 2008. 12. 3. 13:02
728x90

AIX Version 5
Copyright IBM Corporation, 1982, 2007.
login: root                      -----> ① root 계정으로 들어가기
root's Password:
*******************************************************************************
*                                                                             *
*                                                                             *
*  Welcome to AIX Version 5.3!                                                *
*                                                                             *
*                                                                             *
*  Please see the README file in /usr/lpp/bos for information pertinent to    *
*  this release of the AIX Operating System.                                  *
*                                                                             *
*                                                                             *
*******************************************************************************
Last unsuccessful login: Sun Sep  7 16:24:51 KORST 2008 on /dev/pts/6 from n4000
Last login: Mon Sep  8 06:53:10 KORST 2008 on /dev/pts/1 from 192.168.1.78

swerp/>df -k ---------> ② arch 용량 확인하기
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           131072     88796   33%     2399    11% /
/dev/hd2          2686976    199844   93%    49231    50% /usr
/dev/hd9var        262144    240236    9%      492     1% /var
/dev/hd3          1048576    834824   21%      956     1% /tmp
/dev/hd1            65536     65144    1%       13     1% /home
/proc                   -         -    -         -     -  /proc
/dev/hd10opt       131072     52772   60%     2627    18% /opt
/dev/arch        24379392  14223148   42%      105     1% /arch
/dev/dev1       141557760  48658560   66%       87     1% /dev1
/dev/dev2       141557760  24788952   83%      451     1% /dev2
/dev/data1       62914560  17594444   73%       23     1% /data1
/dev/data2       62914560  11136636   83%     1456     1% /data2
/dev/data3       62914560  11704336   82%       10     1% /data3
/dev/oracle      10485760   2137580   80%    82690    15% /oracle
/dev/data4      105906176  58341616   45%       75     1% /data4
/dev/fslv00        131072    127832    3%       39     1% /T650info

swerp/>cd /arch/SWERP -----> ③ 아카이브 디렉토리로 들어가기
swerp/arch/SWERP> dsmc incremental /arch/SWERP/   -------> ④ 증분 백업하기
Tivoli Storage Manager
Command Line Backup/Archive Client Interface - Version 5, Release 1, Level 5.0
(C) Copyright IBM Corporation 1990, 2002 All Rights Reserved.

Node Name: SWERP
Session established with server SHINWON: AIX-RS/6000
  Server Version 5, Release 1, Level 9.0
  Server date/time: 09/08/08   13:33:45  Last access: 09/08/08   03:35:12


Incremental backup of volume '/arch/SWERP/'
Expiring-->          104,857,088 /arch/SWERP/5440.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5441.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5442.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5443.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5444.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5445.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5446.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5447.arc [Sent]
.
.
.
Expiring-->          104,857,088 /arch/SWERP/5448.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5977.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5978.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5979.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5980.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5981.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5982.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5983.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5984.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5985.arc [Sent]
Expiring-->          104,857,088 /arch/SWERP/5986.arc [Sent]
Normal File-->       104,850,432 /arch/SWERP/6500.arc  ** Unsuccessful **
ANS1114I Waiting for mount of offline media.
Retry # 1  Normal File-->       104,850,432 /arch/SWERP/6500.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6501.arc  ** Unsuccessful **
ANS1114I Waiting for mount of offline media.
Normal File-->       104,857,088 /arch/SWERP/6502.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6503.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6504.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6505.arc  ** Unsuccessful **
Normal File-->       104,857,088 /arch/SWERP/6506.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6593.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6594.arc [Sent]
Normal File-->       104,854,528 /arch/SWERP/6595.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6596.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6597.arc [Sent]
Normal File-->       104,857,088 /arch/SWERP/6598.arc [Sent]
Successful incremental backup of '/arch/SWERP/*'


Total number of objects inspected:      426
Total number of objects backed up:       99
Total number of objects updated:          0
Total number of objects rebound:          0
Total number of objects deleted:          0
Total number of objects expired:        326
Total number of objects failed:           0   ---------> 0이면 정상 백업된 것임
Total number of bytes transferred: 9.87 GB
Data transfer time:                  340.59 sec
Network data transfer rate:        30,409.89 KB/sec
Aggregate data transfer rate:      23,789.27 KB/sec
Objects compressed by:                    0%
Elapsed processing time:           00:07:15

 

 


swerp/arch/SWERP>ls -lt    -----------> ⑤ 시간 역순으로 정렬하여 보기
.
.
.
-rw-r-----   1 oracle   dba       104857088 Sep 07 19:43 6505.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 19:28 6504.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 19:13 6503.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 18:54 6502.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 18:36 6501.arc
swerp/arch/SWERP>rm -f 650?.arc  
                 --------------> ⑥이 부분을 반복적으로 마지막 10번대가 남을때까지 확인
swerp/arch/SWERP>ls -lt
-rw-r-----   1 oracle   dba       104857088 Sep 07 22:46 6517.arc
-rw-r-----   1 oracle   dba       104843776 Sep 07 22:33 6516.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 22:18 6515.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 22:04 6514.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 21:50 6513.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 21:35 6512.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 21:20 6511.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 21:04 6510.arc
swerp/arch/SWERP>rm -f 651?.arc
swerp/arch/SWERP>ls -lt
-rw-r-----   1 oracle   dba       104857088 Sep 08 00:44 6525.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 00:24 6524.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 00:05 6523.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 23:50 6522.arc
-rw-r-----   1 oracle   dba       104835072 Sep 07 23:39 6521.arc
-rw-r-----   1 oracle   dba       104857088 Sep 07 23:25 6520.arc
.
.
.
.
swerp/arch/SWERP>rm -f 652?.arc   -----> 맨 마지막 10단위 번호만 남기고 지움
swerp/arch/SWERP>ls -lt  -----> ⑦확인(마직막 10단위 번호)
total 1843416
-rw-r-----   1 oracle   dba       104857088 Sep 08 12:50 6598.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 12:15 6597.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 11:56 6596.arc
-rw-r-----   1 oracle   dba       104854528 Sep 08 11:36 6595.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 11:11 6594.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 10:36 6593.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 09:40 6592.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 09:10 6591.arc
-rw-r-----   1 oracle   dba       104857088 Sep 08 08:37 6590.arc
swerp/arch/SWERP>df -k
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           131072     88788   33%     2399    11% /
/dev/hd2          2686976    199844   93%    49231    50% /usr
/dev/hd9var        262144    240236    9%      492     1% /var
/dev/hd3          1048576    834824   21%      956     1% /tmp
/dev/hd1            65536     65144    1%       13     1% /home
/proc                   -         -    -         -     -  /proc
/dev/hd10opt       131072     52772   60%     2627    18% /opt
/dev/arch        24379392  23352432    5%       15     1% /arch  ----> ⑧10%미만 인 것을 확인
/dev/dev1       141557760  48658560   66%       87     1% /dev1
/dev/dev2       141557760  24788952   83%      451     1% /dev2
/dev/data1       62914560  17594444   73%       23     1% /data1
/dev/data2       62914560  11136632   83%     1456     1% /data2
/dev/data3       62914560  11704336   82%       10     1% /data3
/dev/oracle      10485760   2137512   80%    82690    15% /oracle
/dev/data4      105906176  58341616   45%       75     1% /data4
/dev/fslv00        131072    127832    3%       39     1% /T650info

728x90