8月17日数据库问题的妥协的处理方法

8月17日的数据库故障, 维护无进展,开发无进展.

只好采取以下方法解决目前数据库遇到的问题.

就是不知道未来 维护的执行力如何了.十分担心.

 

 

各位好：
  由于设备维保到期，TSM备份管理故障无法在短期内及时解决，进展缓慢。
故采用折衷的方法，来解决以下三个问题：
  1、归档磁盘空间日益撑满。
  2、自5月23日数据库无备份。
  3、磁带中备份还保留09年11月份。

此次三个问题解决后，需要维护人员定期执行脚本：
以root 用户登录，然后执行。
每2天执行一次
/usr/tivoli/tsm/client/api/bin64/ora_archbak.sh
每5天执行一次
/usr/tivoli/tsm/client/api/bin64/ora_dbbak.sh
每10天执行一次
/usr/tivoli/tsm/client/api/bin64/ora_delbak.sh

脚本的具体内容可以用 cat 查看。

执行的日志在,对应以上三个 脚本。
/tmp/tsmbkarch.log
/tmp/tsmbkdb.log
/tmp/tsmdeldb.log
请项目经理和质量同时监督，维护人员认真执行以上数据库备份维护计划。

维护部分： 备份的问题可以临时解决

开发部分：  RAC的有效使用
     被删除的临时表无限增多
     非关键操作，不记录日志，减少归档量
也请项目组和质量尽快解决。    

临时解决方案实施步骤概要：
1、杀死5月23日rman 僵死进程，包括TSM的调用脚本。
2、切换到oracle用户，进入RMAN，处理数据备份问题。
    A、删除磁带里面过期备份集
    B、删除旧的备份以后开始备份数据库
    C、删除磁带里面过期归档备份集
   D、删除旧的归档备份以后开始备份归档

临时解决方案实施步骤细节：
1、杀死5月23日rman 僵死进程，包括TSM的调用脚本。
# ps -ef |grep 573840
    root 1015896  532798   0 10:57:35  pts/3  0:00 grep 573840
    root  573840  184386   0   May 23      -  0:00 /bin/sh -c /usr/tivoli/tsm/client/api/bin64/ora_archbak.sh
  oracle 1208720  573840   0   May 23      -  0:03 rman target bckmgr/bckmgr@ybzdb1 catalog rman/rman@rman log /tmp/tsmbkarch.log
 
#kill 573840
#kill 1208720

2、切换到oracle用户，进入RMAN，处理问题
#su - oracle
$rman

连接目标数据库
RMAN> connect target /

连接恢复目录数据库
RMAN> connect catalog rman/rman@rman

报告废弃备份集
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 6
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          287    12-NOV-09          /arch/2_15_702581932.dbf
Backup Set           454    12-NOV-09        
  Backup Piece       456    12-NOV-09          db_YBZDB_0fku6k2i_15_20091112
Backup Set           455    12-NOV-09        
  Backup Piece       457    12-NOV-09          db_YBZDB_0gku6k57_16_20091112
。。。。。。
。。。。。。
。。。。。。
Backup Set           50572  20-MAY-11        
  Backup Piece       50592  20-MAY-11          db_YBZDB_gvmcqd5c_1567_20110520
Backup Set           50861  22-MAY-11        
  Backup Piece       50880  22-MAY-11          db_YBZDB_h5mcvl9l_1573_20110522
Backup Set           63860  15-AUG-11        
  Backup Piece       63884  15-AUG-11          c-1079391788-20110815-00
Backup Set           64119  16-AUG-11        
  Backup Piece       64143  16-AUG-11          c-1079391788-20110816-00
Backup Set           64385  17-AUG-11        
  Backup Piece       64410  17-AUG-11          c-1079391788-20110817-00
Backup Set           64597  18-AUG-11        
  Backup Piece       64616  18-AUG-11          c-1079391788-20110818-00
Backup Set           64803  19-AUG-11        
  Backup Piece       64822  19-AUG-11          c-1079391788-20110819-00
Backup Set           65015  20-AUG-11        
  Backup Piece       65034  20-AUG-11          c-1079391788-20110820-00
Backup Set           65068  21-AUG-11        
  Backup Piece       65070  21-AUG-11          c-1079391788-20110821-00
Backup Set           65199  22-AUG-11        
  Backup Piece       65212  22-AUG-11          c-1079391788-20110822-00
Backup Set           65423  23-AUG-11        
  Backup Piece       65441  23-AUG-11          c-1079391788-20110823-00
Backup Set           65622  24-AUG-11        
  Backup Piece       65640  24-AUG-11          c-1079391788-20110824-00
 
 

编写脚本删除磁带上的备份集： 此操作失败，因为磁带上的对象状态和备份目录库和实际目录三者之间的状态不匹配。
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> delete obsolete;
4> release channel t1;
5> };

allocated channel: t1
channel t1: sid=754 instance=ybzdb1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 6
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          287    12-NOV-09          /arch/2_15_702581932.dbf
Backup Set           454    12-NOV-09        
  Backup Piece       456    12-NOV-09          db_YBZDB_0fku6k2i_15_20091112
Backup Set           455    12-NOV-09        
  Backup Piece       457    12-NOV-09          db_YBZDB_0gku6k57_16_20091112
。。。。。。
。。。。。。
。。。。。。
Backup Set           65423  23-AUG-11        
  Backup Piece       65441  23-AUG-11          c-1079391788-20110823-00
Backup Set           65622  24-AUG-11        
  Backup Piece       65640  24-AUG-11          c-1079391788-20110824-00

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/arch/2_15_702581932.dbf recid=34 stamp=702760962
Deleted 1 objects
deleted backup piece
backup piece handle=arch_YBZDB_0hku6kqr_17_20091112 recid=16 stamp=702763868
deleted backup piece
。。。。。。
。。。。。。
。。。。。。
deleted backup piece
backup piece handle=db_YBZDB_h5mcvl9l_1573_20110522 recid=1568 stamp=751818038
Deleted 766 objects

RMAN-06207: WARNING: 769 objects could not be deleted for SBT_TAPE channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece    db_YBZDB_0fku6k2i_15_20091112
RMAN-06214: Backup Piece    db_YBZDB_0gku6k57_16_20091112
。。。。。。
。。。。。。
。。。。。。
RMAN-06214: Backup Piece    c-1079391788-20110822-00
RMAN-06214: Backup Piece    c-1079391788-20110823-00
RMAN-06214: Backup Piece    c-1079391788-20110824-00

released channel: t1

配置缺省的设备类型为磁带
RMAN> configure default device type to sbt_tape ;

new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

对备份做交叉检查
RMAN> crosscheck backup;

allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=754 instance=ybzdb1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=702 instance=ybzdb1 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=db_YBZDB_0fku6k2i_15_20091112 recid=14 stamp=702763090
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=db_YBZDB_0gku6k57_16_20091112 recid=15 stamp=702763176
crosschecked backup piece: found to be 'EXPIRED'
。。。。。。
。。。。。。
。。。。。。
backup piece handle=arch_YBZDB_knml6r5m_1687_20110829 recid=1682 stamp=760442039
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=c-1079391788-20110829-00 recid=1683 stamp=760442216
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=arch_YBZDB_kpml9gsk_1689_20110830 recid=1684 stamp=760529813
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=c-1079391788-20110830-00 recid=1685 stamp=760529990
Crosschecked 906 objects

列出过期的备份：
RMAN> list expired backup;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
454     Incr 0  773.50M    SBT_TAPE    00:01:16     12-NOV-09     
        BP Key: 456   Status: EXPIRED  Compressed: NO  Tag: TAG20091112T195810
        Handle: db_YBZDB_0fku6k2i_15_20091112   Media:
  List of Datafiles in backup set 454
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 700741     12-NOV-09 /dev/rsystem_2g_01
  2    0  Incr 700741     12-NOV-09 /dev/rundo1_4g_01
  3    0  Incr 700741     12-NOV-09 /dev/rsysaux_2g_01
  4    0  Incr 700741     12-NOV-09 /dev/rundo2_4g_01
  5    0  Incr 700741     12-NOV-09 /dev/rusers_256m_01
。。。。。。
。。。。。。
。。。。。。 最后一次0级增量全库备份 2011年 5月15日
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
49824   Incr 0  79.92G     SBT_TAPE    00:09:22     15-MAY-11     
        BP Key: 49843   Status: EXPIRED  Compressed: NO  Tag: TAG20110515T135628
        Handle: db_YBZDB_ggmcd58c_1552_20110515   Media:
  List of Datafiles in backup set 49824
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 12031452734715 15-MAY-11 /dev/rsystem_2g_01
  2    0  Incr 12031452734715 15-MAY-11 /dev/rundo1_4g_01
  3    0  Incr 12031452734715 15-MAY-11 /dev/rsysaux_2g_01
  4    0  Incr 12031452734715 15-MAY-11 /dev/rundo2_4g_01
  5    0  Incr 12031452734715 15-MAY-11 /dev/rusers_256m_01
  6    0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_001
  7    0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_002
  8    0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_003
  9    0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_004
  10   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_005
  11   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_006
  12   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_007
  13   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_008
  14   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_009
  15   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_010
  16   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_011
  17   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_012
  18   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_013
  19   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_014
  20   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_015
  21   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_016
  22   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_017
  23   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_018
  24   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_019
  25   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_020
  26   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_021
  27   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_022
  28   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_023
  29   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_024
  30   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_025
  31   0  Incr 12031452734715 15-MAY-11 /dev/rlvoraops_4g_026
。。。。。。
。。。。。。
。。。。。。5月15日，
BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
66444   256.00K    SBT_TAPE    00:02:46     30-AUG-11     
        BP Key: 66447   Status: EXPIRED  Compressed: NO  Tag: TAG20110830T101652
        Handle: arch_YBZDB_kpml9gsk_1689_20110830   Media:

  List of Archived Logs in backup set 66444
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    3443    12124088227662 29-AUG-11 12124091164464 29-AUG-11
  2    3444    12124091164464 29-AUG-11 12124091710511 29-AUG-11
  2    3445    12124091710511 29-AUG-11 12124092115037 29-AUG-11
  2    3446    12124092115037 29-AUG-11 12124093115759 29-AUG-11
  2    3447    12124093115759 29-AUG-11 12124093345679 29-AUG-11
  2    3448    12124093345679 29-AUG-11 12124093566728 29-AUG-11
  2    3449    12124093566728 29-AUG-11 12124093764255 29-AUG-11
  2    3450    12124093764255 29-AUG-11 12124093938558 29-AUG-11
  2    3451    12124093938558 29-AUG-11 12124094158844 29-AUG-11
  2    3452    12124094158844 29-AUG-11 12124094388727 30-AUG-11
  2    3453    12124094388727 30-AUG-11 12124095303342 30-AUG-11
  2    3454    12124095303342 30-AUG-11 12124095547462 30-AUG-11
  2    3455    12124095547462 30-AUG-11 12124095835375 30-AUG-11
  2    3456    12124095835375 30-AUG-11 12124096065482 30-AUG-11
  2    3457    12124096065482 30-AUG-11 12124096636355 30-AUG-11
  2    3458    12124096636355 30-AUG-11 12124098501500 30-AUG-11
  2    3459    12124098501500 30-AUG-11 12124098729851 30-AUG-11
  2    3460    12124098729851 30-AUG-11 12124098961656 30-AUG-11
  2    3461    12124098961656 30-AUG-11 12124098992863 30-AUG-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
66471   Full    11.75M     SBT_TAPE    00:00:40     30-AUG-11     
        BP Key: 66491   Status: EXPIRED  Compressed: NO  Tag: TAG20110830T101949
        Handle: c-1079391788-20110830-00   Media:
  Control File Included: Ckp SCN: 12124098993252   Ckp time: 30-AUG-11
  SPFILE Included: Modification time: 04-MAY-11
 
删除过期备份：
RMAN> delete expired backup;

using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
456     454     1   1   EXPIRED     SBT_TAPE    db_YBZDB_0fku6k2i_15_20091112
457     455     1   1   EXPIRED     SBT_TAPE    db_YBZDB_0gku6k57_16_20091112
492     490     1   1   EXPIRED     SBT_TAPE    arch_YBZDB_0iku6kct_18_20091112
506     504     1   1   EXPIRED     SBT_TAPE    arch_YBZDB_0jku85qd_19_20091113
552     549     1   1   EXPIRED     SBT_TAPE    arch_YBZDB_0nkuapr9_23_20091114   
。。。。。。
。。。。。。
。。。。。。
66258   66255   1   1   EXPIRED     SBT_TAPE    arch_YBZDB_knml6r5m_1687_20110829
66266   66264   1   1   EXPIRED     SBT_TAPE    c-1079391788-20110829-00
66447   66444   1   1   EXPIRED     SBT_TAPE    arch_YBZDB_kpml9gsk_1689_20110830
66491   66471   1   1   EXPIRED     SBT_TAPE    c-1079391788-20110830-00

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=db_YBZDB_0fku6k2i_15_20091112 recid=14 stamp=702763090
deleted backup piece
backup piece handle=db_YBZDB_0gku6k57_16_20091112 recid=15 stamp=702763176
。。。。。。
。。。。。。
。。。。。。
deleted backup piece
backup piece handle=arch_YBZDB_kpml9gsk_1689_20110830 recid=1684 stamp=760529813
deleted backup piece
backup piece handle=c-1079391788-20110830-00 recid=1685 stamp=760529990
Deleted 889 EXPIRED objects

删除磁带里面过旧的备份以后开始备份
切换到 root 用户
$su - root
到脚本路径
#cd /usr/tivoli/tsm/client/api/bin64/
执行当前路径下脚本 备份数据库
#./ora_dbbak.sh
在脚本运行的时候可以另外开一个会话 看 备份的日志
#tail -f  tsmbkdb.log

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Aug 30 18:24:31 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: YBZDB (DBID=1079391788)
connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6>
allocated channel: t1
channel t1: sid=1061 instance=ybzdb2 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

Starting backup at 30-AUG-11
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00002 name=/dev/rundo1_4g_01
input datafile fno=00004 name=/dev/rundo2_4g_01
input datafile fno=00006 name=/dev/rlvoraops_4g_001
input datafile fno=00007 name=/dev/rlvoraops_4g_002
input datafile fno=00008 name=/dev/rlvoraops_4g_003
input datafile fno=00009 name=/dev/rlvoraops_4g_004
input datafile fno=00010 name=/dev/rlvoraops_4g_005
input datafile fno=00011 name=/dev/rlvoraops_4g_006
input datafile fno=00012 name=/dev/rlvoraops_4g_007
input datafile fno=00013 name=/dev/rlvoraops_4g_008
input datafile fno=00014 name=/dev/rlvoraops_4g_009
input datafile fno=00015 name=/dev/rlvoraops_4g_010
input datafile fno=00016 name=/dev/rlvoraops_4g_011
input datafile fno=00017 name=/dev/rlvoraops_4g_012
input datafile fno=00018 name=/dev/rlvoraops_4g_013
input datafile fno=00019 name=/dev/rlvoraops_4g_014
input datafile fno=00020 name=/dev/rlvoraops_4g_015
input datafile fno=00021 name=/dev/rlvoraops_4g_016
input datafile fno=00022 name=/dev/rlvoraops_4g_017
input datafile fno=00023 name=/dev/rlvoraops_4g_018
input datafile fno=00024 name=/dev/rlvoraops_4g_019
input datafile fno=00025 name=/dev/rlvoraops_4g_020
input datafile fno=00026 name=/dev/rlvoraops_4g_021
input datafile fno=00027 name=/dev/rlvoraops_4g_022
input datafile fno=00028 name=/dev/rlvoraops_4g_023
input datafile fno=00029 name=/dev/rlvoraops_4g_024
input datafile fno=00030 name=/dev/rlvoraops_4g_025
input datafile fno=00031 name=/dev/rlvoraops_4g_026
input datafile fno=00001 name=/dev/rsystem_2g_01
input datafile fno=00003 name=/dev/rsysaux_2g_01
input datafile fno=00005 name=/dev/rusers_256m_01
channel t1: starting piece 1 at 30-AUG-11
channel t1: finished piece 1 at 30-AUG-11
piece handle=db_YBZDB_krmlacre_1691_20110830 tag=TAG20110830T181406 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:10:46
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
channel t1: starting piece 1 at 30-AUG-11
channel t1: finished piece 1 at 30-AUG-11
piece handle=db_YBZDB_ksmladfk_1692_20110830 tag=TAG20110830T181406 comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:36
Finished backup at 30-AUG-11

Starting Control File and SPFILE Autobackup at 30-AUG-11
piece handle=c-1079391788-20110830-01 comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 30-AUG-11

released channel: t1

RMAN>

Recovery Manager complete.

 

备份完数据库，然后对归档文件的有效性，交叉检查
$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Aug 30 18:46:15 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: YBZDB (DBID=1079391788)

RMAN> connect catalog rman/rman@rman

connected to recovery catalog database

RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=736 instance=ybzdb1 devtype=DISK
validation failed for archived log
archive log filename=/arch/1_4967_702581932.dbf recid=6991 stamp=751901889
validation failed for archived log
archive log filename=/arch/1_4968_702581932.dbf recid=6993 stamp=751902104
validation failed for archived log
archive log filename=/arch/1_4969_702581932.dbf recid=6994 stamp=751917565
。。。。。。
。。。。。。
。。。。。。
validation succeeded for archived log
archive log filename=/arch/1_9092_702581932.dbf recid=12557 stamp=760558537
validation succeeded for archived log
archive log filename=/arch/1_9093_702581932.dbf recid=12559 stamp=760558763
validation succeeded for archived log
archive log filename=/arch/1_9094_702581932.dbf recid=12560 stamp=760560152
validation failed for archived log
archive log filename=/arch/2_3462_702581932.dbf recid=12534 stamp=760533214
validation failed for archived log
archive log filename=/arch/2_3463_702581932.dbf recid=12539 stamp=760537046
validation failed for archived log
archive log filename=/arch/2_3464_702581932.dbf recid=12542 stamp=760543322
validation failed for archived log
archive log filename=/arch/2_3465_702581932.dbf recid=12546 stamp=760546997
validation failed for archived log
archive log filename=/arch/2_3466_702581932.dbf recid=12550 stamp=760550690
validation failed for archived log
archive log filename=/arch/2_3467_702581932.dbf recid=12554 stamp=760554374
validation failed for archived log
archive log filename=/arch/2_3468_702581932.dbf recid=12558 stamp=760558112
Crosschecked 4135 objects

 

删除过期归档：
RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=736 instance=ybzdb1 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
51039   1    4967    X 23-MAY-11 /arch/1_4967_702581932.dbf
51041   1    4968    X 23-MAY-11 /arch/1_4968_702581932.dbf
51042   1    4969    X 23-MAY-11 /arch/1_4969_702581932.dbf
。。。。。。
。。。。。。
。。。。。。
64032   1    8482    X 15-AUG-11 /arch/1_8482_702581932.dbf
64034   1    8483    X 15-AUG-11 /arch/1_8483_702581932.dbf
64035   1    8484    X 15-AUG-11 /arch/1_8484_702581932.dbf
64036   1    8485    X 15-AUG-11 /arch/1_8485_702581932.dbf
66519   2    3462    X 30-AUG-11 /arch/2_3462_702581932.dbf
66534   2    3463    X 30-AUG-11 /arch/2_3463_702581932.dbf
66548   2    3464    X 30-AUG-11 /arch/2_3464_702581932.dbf
66568   2    3465    X 30-AUG-11 /arch/2_3465_702581932.dbf
66586   2    3466    X 30-AUG-11 /arch/2_3466_702581932.dbf
66600   2    3467    X 30-AUG-11 /arch/2_3467_702581932.dbf
66618   2    3468    X 30-AUG-11 /arch/2_3468_702581932.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/arch/1_4967_702581932.dbf recid=6991 stamp=751901889
deleted archive log
archive log filename=/arch/1_4968_702581932.dbf recid=6993 stamp=751902104
。。。。。。
。。。。。。
。。。。。。
deleted archive log
archive log filename=/arch/2_3467_702581932.dbf recid=12554 stamp=760554374
deleted archive log
archive log filename=/arch/2_3468_702581932.dbf recid=12558 stamp=760558112
Deleted 3526 EXPIRED objects

开始备份归档日志
 ./ora_archbak.sh

# tail -2000f /tmp/tsmbkarch.log |more

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Aug 30 18:54:22 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: YBZDB (DBID=1079391788)
connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6>
allocated channel: t1
channel t1: sid=754 instance=ybzdb1 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

sql statement: alter system archive log thread 1 current

Starting backup at 30-AUG-11
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=8669 recid=11985 stamp=759533216
input archive log thread=1 sequence=8670 recid=11986 stamp=759533412
input archive log thread=1 sequence=8671 recid=11988 stamp=759533624
。。。。。。
。。。。。。
。。。。。。
archive log filename=/arch/1_9093_702581932.dbf recid=12559 stamp=760558763
archive log filename=/arch/1_9094_702581932.dbf recid=12560 stamp=760560152
archive log filename=/arch/1_9095_702581932.dbf recid=12561 stamp=760560865
Finished backup at 30-AUG-11

Starting Control File and SPFILE Autobackup at 30-AUG-11
piece handle=c-1079391788-20110830-02 comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 30-AUG-11

released channel: t1

RMAN>
Recovery Manager complete.
#

归档完以后
/arch 目录下 9096 序号 ，磁带备份里面有9095序号的归档备份
# cd /arch
# ls -l
total 3030920
-rw-r-----    1 oracle   oinstall  517175296 Aug 30 19:15 1_9096_702581932.dbf
-rw-r-----    1 oracle   oinstall  517168128 Aug 30 19:20 1_9097_702581932.dbf
-rw-r-----    1 oracle   oinstall  517175296 Aug 30 20:14 1_9098_702581932.dbf
drwxr-xr-x    2 oracle   dba             256 Nov 07 2009  lost+found

磁盘空间检查：
# df -k
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4          2097152   2004948    5%     6193     2% /
/dev/hd2          3145728   1168700   63%    38368    13% /usr
/dev/hd9var       2097152   1910720    9%     4758     2% /var
/dev/hd3          4194304   3795528   10%     1124     1% /tmp
/dev/hd1          2097152   2096468    1%       10     1% /home
/proc                   -         -    -         -     -  /proc
/dev/hd10opt     20971520  20856748    1%     3230     1% /opt
/dev/lvarch     523960320 522364000    1%        7     1% /arch
/dev/lvoracle    20971520   5585296   74%    40611     4% /oracle
/dev/lvdata      31457280  15640848   51%    48900     2% /data