我看到了几篇帖子是关于这个问题的,但是我这的情况和之前的还不一样,之前备份都是正常的,就是从18号开始不正常了,备份数据库失败了,具体表现是数据库的旧的归档日志都没有删除,于是上来查问题,在RMAN里看到的错误是
skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12)
Server media mount not possible
在 actlog里看到有这样的错误:
ANR8311E An I/O error occurred while accessing drive
DRIVE01 (mt0.0.0.1) for READ operation, errno = 170.
(PROCESS: 149)
现在用q drive和q path看到的都是正常的,我的两个drive---drive01和drive02也都是on-line的,但就是q drive f=d的时候看到的设备状态都是unknown,之后按照之前帖子里的做法,我试着update了一下path,结果发现连接带库有问题,
现在带库的SERVER用的是windows server的系统,我在设备管理器里面看了,有两个磁带驱动器,看不出来什么不正常啊。
各位大侠,怎么办呀!
tsm: SGTSMJR_SERVER1>q drive
Library Name Drive Name Device Type On-Line
------------ ------------ ----------- -------------------
TS3310 DRIVE01 LTO Yes
TS3310 DRIVE02 LTO Yes
tsm: SGTSMJR_SERVER1>q drive f=d
Library Name: TS3310
Drive Name: DRIVE01
Device Type: LTO
On-Line: Yes
Read Formats: ULTRIUM4C,ULTRIUM4,ULTRIUM3C,ULTRIUM3,ULTRIUM2C,ULTRIUM2
Write Formats: ULTRIUM4C,ULTRIUM4,ULTRIUM3C,ULTRIUM3
Element: 256
Drive State: UNKNOWN
Volume Name:
Allocated to:
WWN: 500308C0A1281000
Serial Number: 1310232445
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 12:23:01
Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE
Library Name: TS3310
Drive Name: DRIVE02
Device Type: LTO
On-Line: Yes
Read Formats: ULTRIUM4C,ULTRIUM4,ULTRIUM3C,ULTRIUM3,ULTRIUM2C,ULTRIUM2
Write Formats: ULTRIUM4C,ULTRIUM4,ULTRIUM3C,ULTRIUM3
Element: 257
Drive State: UNKNOWN
Volume Name:
Allocated to:
WWN: 500308C0A1281004
Serial Number: 1310232459
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 12:23:34
Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE
tsm: SGTSMJR_SERVER1>q path
Source Name Source Type Destination Destination On-Line
Name Type
----------- ----------- ----------- ----------- -------
SGTSMJR_SE- SERVER TS3310 LIBRARY Yes
RVER1
SGTSMJR_SE- SERVER DRIVE01 DRIVE Yes
RVER1
SGTSMJR_SE- SERVER DRIVE02 DRIVE Yes
RVER1
DJR197_SER SERVER DRIVE01 DRIVE Yes
DJR197_SER SERVER DRIVE02 DRIVE Yes
JRA193_SER SERVER DRIVE01 DRIVE Yes
JRA193_SER SERVER DRIVE02 DRIVE Yes
JRB194_SER SERVER DRIVE01 DRIVE Yes
JRB194_SER SERVER DRIVE02 DRIVE Yes
QJR196_SER SERVER DRIVE01 DRIVE Yes
QJR196_SER SERVER DRIVE02 DRIVE Yes
tsm: SGTSMJR_SERVER1>q path f=d
Source Name: SGTSMJR_SERVER1
Source Type: SERVER
Destination Name: TS3310
Destination Type: LIBRARY
Library:
Node Name:
Device: lb1.1.0.1
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 12:21:05
Source Name: SGTSMJR_SERVER1
Source Type: SERVER
Destination Name: DRIVE01
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: mt0.0.0.1
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 12:23:01
Source Name: SGTSMJR_SERVER1
Source Type: SERVER
Destination Name: DRIVE02
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: mt1.0.0.1
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 12:23:34
Source Name: DJR197_SER
Source Type: SERVER
Destination Name: DRIVE01
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt1
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
more... (
to continue, 'C' to cancel)
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/09/11 22:09:29
Source Name: DJR197_SER
Source Type: SERVER
Destination Name: DRIVE02
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt2
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/09/11 22:09:34
Source Name: JRA193_SER
Source Type: SERVER
Destination Name: DRIVE01
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt1
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 17:46:21
Source Name: JRA193_SER
Source Type: SERVER
Destination Name: DRIVE02
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt2
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 17:46:39
Source Name: JRB194_SER
Source Type: SERVER
Destination Name: DRIVE01
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt1
External Manager:
LUN:
Initiator: 0
more... ( to continue, 'C' to cancel)
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 15:23:38
Source Name: JRB194_SER
Source Type: SERVER
Destination Name: DRIVE02
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt2
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 15:23:47
Source Name: QJR196_SER
Source Type: SERVER
Destination Name: DRIVE01
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt1
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 15:19:42
Source Name: QJR196_SER
Source Type: SERVER
Destination Name: DRIVE02
Destination Type: DRIVE
Library: TS3310
Node Name:
Device: /dev/rmt2
External Manager:
LUN:
Initiator: 0
Directory:
On-Line: Yes
Last Update by (administrator): ADMIN
Last Update Date/Time: 11/08/11 15:20:18
tsm: SGTSMJR_SERVER1>update library ts3310 shared=yes serial=autodetect
ANR8465I Library TS3310 updated.
update path SGTSMJR_SERVER1 ts3310 srctype=server desttype=library device=/dev/smc0 online=yes
ANR8418E UPDATE PATH: An I/O error occurred while accessing library TS3310.
ANS8001I Return code 15.