haaa01
ADSM.ORG Member
- Joined
- Apr 22, 2003
- Messages
- 7
- Reaction score
- 0
- Points
- 0
tsm: TSM_SERV>
tsm: TSM_SERV>select * from backups where node_name='ORADB01' and ll_name='ORADB01_b_mrgq5pjc_23259_1'
ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) y
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
Return code 11 in other words object with ll_name not found in TSM
tsm: TSM_SERV>select * from backups where node_name='ORADB01'
ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) y
NODE_NAME: ORADB01
FILESPACE_NAME: /adsmorc
FILESPACE_ID: 1
STATE: ACTIVE_VERSION
TYPE: FILE
HL_NAME: //
LL_NAME: ORADB01_b_00gsqcsd_25600_1
OBJECT_ID: 201461790
BACKUP_DATE: 2005-08-23 14:43:27.000000
DEACTIVATE_DATE:
OWNER: oraoper
CLASS_NAME: DEFAULT
NODE_NAME: ORADB01
FILESPACE_NAME: /adsmorc
FILESPACE_ID: 1
STATE: ACTIVE_VERSION
TYPE: FILE
HL_NAME: //
LL_NAME: ORADB01_b_00gtuf57_26624_1
OBJECT_ID: 204425613
BACKUP_DATE: 2005-09-06 07:03:04.000000
DEACTIVATE_DATE:
OWNER: oraoper
CLASS_NAME: DEFAULT
Now a search with RMAN
rn03c7racle [/usr/local/tdp/oracle/ORADB01]
=>rman
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect catalog rman/ora_temp@rn03b9_COMERCV
connected to recovery catalog database
RMAN> connect target
connected to target database: ORADB01 (DBID=1157770758)
RMAN> list backuppiece 'ORADB01_b_mrgq5pjc_23259_1'
2> ;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
10477255 10477252 1 1 AVAILABLE SBT_TAPE ORADB01_b_mrgq5pjc_23259_1
So who can explain to me, what is correct: TSM_SERV or RMAN? What can cause the deletion of that object in TSM?
Oracle quys told me that they didn’t do a delete backuppiece.
tsm: TSM_SERV>select * from backups where node_name='ORADB01' and ll_name='ORADB01_b_mrgq5pjc_23259_1'
ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) y
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
Return code 11 in other words object with ll_name not found in TSM
tsm: TSM_SERV>select * from backups where node_name='ORADB01'
ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute.
Do you wish to proceed? (Yes (Y)/No (N)) y
NODE_NAME: ORADB01
FILESPACE_NAME: /adsmorc
FILESPACE_ID: 1
STATE: ACTIVE_VERSION
TYPE: FILE
HL_NAME: //
LL_NAME: ORADB01_b_00gsqcsd_25600_1
OBJECT_ID: 201461790
BACKUP_DATE: 2005-08-23 14:43:27.000000
DEACTIVATE_DATE:
OWNER: oraoper
CLASS_NAME: DEFAULT
NODE_NAME: ORADB01
FILESPACE_NAME: /adsmorc
FILESPACE_ID: 1
STATE: ACTIVE_VERSION
TYPE: FILE
HL_NAME: //
LL_NAME: ORADB01_b_00gtuf57_26624_1
OBJECT_ID: 204425613
BACKUP_DATE: 2005-09-06 07:03:04.000000
DEACTIVATE_DATE:
OWNER: oraoper
CLASS_NAME: DEFAULT
Now a search with RMAN
rn03c7racle [/usr/local/tdp/oracle/ORADB01]
=>rman
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect catalog rman/ora_temp@rn03b9_COMERCV
connected to recovery catalog database
RMAN> connect target
connected to target database: ORADB01 (DBID=1157770758)
RMAN> list backuppiece 'ORADB01_b_mrgq5pjc_23259_1'
2> ;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
10477255 10477252 1 1 AVAILABLE SBT_TAPE ORADB01_b_mrgq5pjc_23259_1
So who can explain to me, what is correct: TSM_SERV or RMAN? What can cause the deletion of that object in TSM?
Oracle quys told me that they didn’t do a delete backuppiece.