I executed the sql below on TSM version 5.3, the result is also show below I got the error RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archive from rman while trying to restore a database restore for a particular day from this tapes.
1. How can I resync the TSM db with RMAN ? 2. How can I restore any of these oracle backupset file without going through RMAN? select node_name as Node, filespace_name as Filespace, file_name as Filename, file_size as Size from contents where volume_name='FCM004' and node_name='DBSRV_ORACLE' NODE FILESPACE FILENAME SIZE ------------------ ------------------ ------------------ -------------------- DBSRV_ORACLE /adsmorc // AR_FCMFIN_1392- 3774548543 2_1 DBSRV_ORACLE /adsmorc // c-947519746-20- 7603653 090630-00 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1392- 19037911487 6_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1392- 21493714175 7_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1392- 20372387359 8_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1392- 22132637087 9_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 18082279935 0_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 19112893823 1_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 19948710943 2_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 21921585407 3_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 18630752127 4_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 21234159903 5_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 20212722175 6_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 21127454271 7_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 17863625119 8_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1393- 20502164479 9_1 DBSRV_ORACLE /adsmorc // c-947519746-20- 7603653 090701-00 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1394- 7550669599 1_1 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1394- 7453402303 2_1 DBSRV_ORACLE /adsmorc // c-947519746-20- 7603653 090701-01 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1394- 18604272351 4_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1394- 20239988479 5_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1394- 20579244223 6_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1394- 19421474975 7_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1394- 19934291263 8_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1394- 17752724671 9_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 20709807903 0_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 19844627071 2_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 21286857279 1_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 22036418495 3_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 19224842975 4_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 21933645503 5_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 21848962655 6_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1395- 18698655711 7_1 DBSRV_ORACLE /adsmorc // c-947519746-20- 7603653 090701-02 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1395- 2726631039 9_1 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1396- 2629363743 0_1 DBSRV_ORACLE /adsmorc // c-947519746-20- 7603653 090701-03 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 18638355231 2_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 20240512831 3_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 20602840063 4_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 19483348511 5_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 19956314047 6_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 17775009631 7_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 20761456575 8_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1396- 21290789919 9_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1397- 19919609407 0_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1397- 22050838175 1_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1397- 19285405631 2_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1397- 21940986431 3_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1397- 21894056927 4_1 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1397- 18743225631 5_1 DBSRV_ORACLE /adsmorc // c-947519746-20- 7603653 090702-00 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1397- 6501965567 7_1 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1397- 6232448639 8_1 DBSRV_ORACLE /adsmorc // c-947519746-20- 7603653 090702-01 DBSRV_ORACLE /adsmorc // DF_FCMFIN_1398- 19551252095 1_1 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1399- 3985075871 1_1 DBSRV_ORACLE /adsmorc // AR_FCMFIN_1399- 3742825247 2_1 ________________________________ This email and any attachments are confidential and may also be privileged. If you are not the addressee, do not disclose, copy, circulate or in any other way use or rely on the information contained in this email or any attachments. If received in error, notify the sender immediately and delete this email and any attachments from your system. Emails cannot be guaranteed to be secure or error free as the message and any attachments could be intercepted, corrupted, lost, delayed, incomplete or amended. First City Monument Bank Plc and its subsidiaries do not accept liability for damage caused by this email or any attachments and may monitor email traffic.