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.
|