互联网服务

关于mount retention expired的设置

小弟在还原oracle的时候总是tsm总是报错。rman错误如下:RMAN> restore database;Starting restore at 18-FEB-11allocated channel: ORA_SBT_TAPE_1channel ORA_SBT_TAPE_1: sid=144 instance=erpdb1 devtype=SBT_TAPEchannel ORA_SBT_TAPE_1: Data Protection for Oracle...显示全部
小弟在还原oracle的时候总是tsm总是报错。

rman错误如下:
RMAN> restore database;

Starting restore at 18-FEB-11
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=144 instance=erpdb1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=147 instance=erpdb1 devtype=DISK

channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /dev/rdb_users
restoring datafile 00006 to /dev/rdb_erp_data_01
restoring datafile 00008 to /dev/rdb_erp_data_03
restoring datafile 00010 to /dev/rdb_erp_data_05
restoring datafile 00012 to /dev/rdb_erp_data_07
restoring datafile 00014 to /dev/rdb_erp_data_09
restoring datafile 00016 to /dev/rdb_erp_data_11
restoring datafile 00018 to /dev/rdb_erp_data_13
restoring datafile 00020 to /dev/rdb_erp_data_15
restoring datafile 00022 to /dev/rdb_erp_data_17
restoring datafile 00024 to /dev/rdb_erp_data_19
restoring datafile 00026 to /dev/reas_tmp_tab
channel ORA_SBT_TAPE_1: reading from backup piece Full_ERPDB_02_17_lim4tj88_1_1_743361800.dbf
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
   ANS1235E (RC-71)  An unknown system error has occurred from which TSM cannot recover.
ORA-19870: error reading backup piece Full_ERPDB_02_17_lim4tj88_1_1_743361800.dbf
ORA-19501: read error on file "Full_ERPDB_02_17_lim4tj88_1_1_743361800.dbf", blockno 316309505 (blocksize=512)
ORA-27190: skgfrd: sbtread2 returned erro
channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /dev/rdb_system
restoring datafile 00002 to /dev/rdb_undotbs1
restoring datafile 00003 to /dev/rdb_sysaux
restoring datafile 00004 to /dev/rdb_undotbs2
restoring datafile 00007 to /dev/rdb_erp_data_02
restoring datafile 00009 to /dev/rdb_erp_data_04
restoring datafile 00011 to /dev/rdb_erp_data_06
restoring datafile 00013 to /dev/rdb_erp_data_08
restoring datafile 00015 to /dev/rdb_erp_data_10
restoring datafile 00017 to /dev/rdb_erp_data_12
restoring datafile 00019 to /dev/rdb_erp_data_14
restoring datafile 00021 to /dev/rdb_erp_data_16
restoring datafile 00023 to /dev/rdb_erp_data_18
restoring datafile 00025 to /dev/rdb_erp_data_20
channel ORA_SBT_TAPE_1: reading from backup piece Full_ERPDB_02_17_ljm4tkrc_1_1_743363436.dbf
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
   ANS1235E (RC-71)  An unknown system error has occurred from which TSM cannot recover.
ORA-19870: error reading backup piece Full_ERPDB_02_17_ljm4tkrc_1_1_743363436.dbf
ORA-19501: read error on file "Full_ERPDB_02_17_ljm4tkrc_1_1_743363436.dbf", blockno 317855233 (blocksize=512)
ORA-27190: skgfrd: sbtread2 returned erro
failover to previous backup

creating datafile fno=1 name=/dev/rdb_system
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/18/2011 17:18:54
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/dev/rdb_system'


还原期间TSM server的日志如下:
ANR0408I Session 2 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for storage agent.
ANR8439I SCSI library TS3310LIB is ready for operations.
ANR0406I Session 3 started for node ERPDB1 (TDP Oracle AIX) (Tcp/Ip 10.1.3.10(41776)).
ANR0403I Session 3 ended for node ERPDB1 (TDP Oracle AIX).
ANR0406I Session 4 started for node ERPDB1 (TDP Oracle AIX) (Tcp/Ip 10.1.3.10(41779)).
ANR0408I Session 5 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for storage agent.
ANR0415I Session 5 proxied by STAGNODE1 started for node ERPDB1.
ANR0408I Session 6 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 6 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 7 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0408I Session 8 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 7 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 9 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 8 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 10 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0408I Session 11 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for event logging.
ANR0409I Session 9 ended for server STAGNODE1 (AIX-RS/6000).
ANR8468I LTO volume 000052L3 dismounted from drive LTO3_DEV (/dev/IBMtape0) in library TS3310LIB.
ANR8337I LTO volume 000052L3 mounted in drive LTO3_DEV (/dev/IBMtape0).
ANR0409I Session 10 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 12 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 12 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 13 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 13 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 14 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 14 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 15 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 15 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 16 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 16 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 17 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 17 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 18 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 18 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 19 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 19 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 20 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0408I Session 21 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 20 ended for server STAGNODE1 (AIX-RS/6000).
ANR0403I Session 5 ended for node ERPDB1 (TDP Oracle AIX).
ANR0409I Session 21 ended for server STAGNODE1 (AIX-RS/6000).
ANR0403I Session 4 ended for node ERPDB1 (TDP Oracle AIX).
ANR0406I Session 22 started for node ERPDB1 (TDP Oracle AIX) (Tcp/Ip 10.1.3.10(41849)).
ANR0403I Session 22 ended for node ERPDB1 (TDP Oracle AIX).
ANR0406I Session 23 started for node ERPDB1 (TDP Oracle AIX) (Tcp/Ip 10.1.3.10(41852)).
ANR0408I Session 24 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for storage agent.
ANR0415I Session 24 proxied by STAGNODE1 started for node ERPDB1.
ANR0408I Session 25 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 25 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 26 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 26 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 27 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 27 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 28 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 28 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 29 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 29 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 30 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 30 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 31 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 31 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 32 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 32 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 33 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 33 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 34 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 34 ended for server STAGNODE1 (AIX-RS/6000).
ANR0408I Session 35 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0408I Session 36 started for server STAGNODE1 (AIX-RS/6000) (Tcp/Ip) for library sharing.
ANR0409I Session 35 ended for server STAGNODE1 (AIX-RS/6000).
ANR0403I Session 24 ended for node ERPDB1 (TDP Oracle AIX).
ANR0409I Session 36 ended for server STAGNODE1 (AIX-RS/6000).
ANR0403I Session 23 ended for node ERPDB1 (TDP Oracle AIX).
ANR0406I Session 37 started for node ERPDB1 (TDP Oracle AIX) (Tcp/Ip 10.1.3.10(41913)).
ANR0403I Session 37 ended for node ERPDB1 (TDP Oracle AIX).


请问是什么问题呢。
如果我再次输入restore database,rman会再次继续往下还原数据文件。可是大约还原了100G后,又会出现这个错误,如此反复,我需要执行三次restore database才能将400G的数据库完成还原。

另外同样的数据库,做备份的时候却没有任何问题,一口气可以完成400G的备份

请高手解惑。十分感谢。收起
参与4

查看其它 3 个回答scau_2005的回答

scau_2005scau_2005数据库管理员金蝶软件
顶上去~~~
互联网服务 · 2011-02-18
浏览1051

回答者

scau_2005
数据库管理员金蝶软件

scau_2005 最近回答过的问题

回答状态

  • 发布时间:2011-02-18
  • 关注会员:0 人
  • 回答浏览:1051
  • X社区推广