ADSM-L

[ADSM-L] TSM rman restore

2009-08-14 08:51:10
Subject: [ADSM-L] TSM rman restore
From: Abayomi Oni <Abayomi.Oni AT FIRSTCITYGROUP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 14 Aug 2009 13:46:35 +0100
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.

<Prev in Thread] Current Thread [Next in Thread>
  • [ADSM-L] TSM rman restore, Abayomi Oni <=