在今年的对抚顺的数据库备份的例行检查的时候,查看rman日志,发现rman中报错,报错信息如下:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 04/12/2013 22:00:05
ORA-19506: failed to create sequential file, name="databaseF_T20130412_s568_p1_t
812584802", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
ANS1355E (RC55) Session rejected: Server disabled
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 04/12/2013 22:00:07
ORA-19506: failed to create sequential file, name="cntrl_T20130412_s569_p1_t8125
84806", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
ANS1355E (RC55) Session rejected: Server disabled
通过对问题的查看和分析,是TSM备份软件的问题,再登陆TSM的时候,无法登陆。在查找了相关的文档后,确定了此问题是因为小型机曾经修改过时间或者是因为TSM长时间不用,导致TSM软件无法正常工作,在进行相关的操作后,TSM可以正常的操作。因为数据库的全备会影响效率,而且当时正在工作时间,所以打算在定时任务执行后,查看数据库的全备是否正常。
在过了几天后再进行例行查看日志的时候,发现rman依旧在报错,不过这次的报错与上次的报错不一样,通过对rman日志的分析和对TSM的分析,是因为TSM在备份到磁带的时候,空间不够。问题确定了后在TSM中 通过 q content 查看下存储池中每个磁带的内容,分析出最陈旧的,然后将这个磁带的内容清除,更新后,重新加入到oracle备份的存储池中,这样这个问题就得到了解决,当然还是要等到rman备份后,查看rman全备是否正常。
当再次查看rman日志的时候,看到日志如下:
# cat db_back.log | more
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: FSSJ (DBID=2121101421)
RMAN> 2> 3> 4> 5> 6> 7>
using target database controlfile instead of recovery catalog
allocated channel: c1
channel c1: sid=99 devtype=SBT_TAPE
channel c1: Tivoli Data Protection for Oracle: version 5.2.0.0
Starting backup at 21-JUN-13
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00007 name=/dev/rora_rktx_lv1
input datafile fno=00008 name=/dev/rora_rktx_lv2
input datafile fno=00009 name=/dev/rora_rktx_lv3
input datafile fno=00010 name=/dev/rora_rktx_lv4
input datafile fno=00011 name=/dev/rora_rktx_lv5
input datafile fno=00012 name=/dev/rora_rktx_lv6
input datafile fno=00013 name=/dev/rora_rktx_lv7
input datafile fno=00014 name=/dev/rora_rktx_lv8
input datafile fno=00015 name=/dev/rora_rktx_lv9
input datafile fno=00017 name=/dev/rora_rksy_lv1
input datafile fno=00018 name=/dev/rora_rksy_lv2
input datafile fno=00019 name=/dev/rora_rksy_lv3
input datafile fno=00020 name=/dev/rora_rksj_lv1
input datafile fno=00021 name=/dev/rora_rksj_lv2
input datafile fno=00022 name=/dev/rora_rksj_lv3
input datafile fno=00023 name=/dev/rora_rksj_lv4
input datafile fno=00024 name=/dev/rora_rksfz_lv1
input datafile fno=00025 name=/dev/rora_rksfz_lv2
input datafile fno=00026 name=/dev/rora_rksfz_lv3
input datafile fno=00027 name=/dev/rora_rkls_lv1
input datafile fno=00002 name=/dev/rora_undotbs1_8g
input datafile fno=00005 name=/dev/rora_undotbs2_8g
input datafile fno=00001 name=/dev/rora_system_1g
input datafile fno=00016 name=/dev/rora_rktx_lv10
input datafile fno=00028 name=/dev/rora_users_500m
input datafile fno=00003 name=/dev/rora_indx_200m
input datafile fno=00004 name=/dev/rora_tools_200m
input datafile fno=00006 name=/dev/rora_users_200m
channel c1: starting piece 1 at 21-JUN-13
channel c1: finished piece 1 at 21-JUN-13
Version 5.2.0.0
channel c1: backup set complete, elapsed time: 00:59:27
Finished backup at 21-JUN-13
released channel: c1
RMAN> 2> 3> 4> 5> 6>
allocated channel: c1
channel c1: sid=99 devtype=SBT_TAPE
channel c1: Tivoli Data Protection for Oracle: version 5.2.0.0
Starting backup at 21-JUN-13
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current controlfile in backupset
channel c1: starting piece 1 at 21-JUN-13
channel c1: finished piece 1 at 21-JUN-13
ion 5.2.0.0
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 21-JUN-13
released channel: c1
RMAN>
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=99 devtype=SBT_TAPE
RMAN>
allocated channel: ORA_MAINT_DISK_2
channel ORA_MAINT_DISK_2: sid=112 devtype=DISK
RMAN>
released channel: ORA_MAINT_DISK_2
released channel: ORA_MAINT_SBT_TAPE_1
RMAN>
Recovery Manager complete.
以上,rman对数据库的全备终于正常,关于数据库备份的问题得到解决!