KB labels


Ticket Product Version

Ticket Category

Ticket Assignee


Hot Fixes

Published Fixes
Your Arcserve Support User Profile
First Name:
Last Name:
email:
Phone:
Company:*
Customer Type:
Language:

Country:
Region:

Time zone:
Follow

arcserve-KB : How can I determine if a given backuppiece is in the ARCServe database?

Last Update: 2015-08-27 08:09:03 UTC

CA ARCSERVE BACKUP FOR WINDOWS COMMON: 12.0, 12.5
Last Modified Date:    04/20/2011
Document ID:    TEC545708
Tech Document
Title:  How can I determine if a given backuppiece is in the ARCServe database?

Description:

Sometimes, while taking backup of an Oracle database residing on UNIX or on Windows, using RMAN, the product comes back indicating that 'The requested backuppiece cannot be found in the media management catalog', namely that it can't be found in the database. This document provides the queries necessary to determine if a certain backuppiece has been stored in the database

Solution:

To check if the backuppiece has been properly included in the database, we nee to query a few tables. If you are using SQL Express, install the SQL Server Management Studio Express to be able to issue commands against the database. Go to the ARCSERVE_DB and issue the following queries (assuming, for instance, you need to know if backuppiece xyz is in the database ):


select jobid from asdb.dbo.astpses where id in (select sesid from asdb0.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where   filename like '%xyz%'));        

select jobid from asdb.dbo.astpses where id in (select sesid from asdb1.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%')); 

select jobid from asdb.dbo.astpses where id in (select sesid from asdb2.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

select jobid from asdb.dbo.astpses where id in (select sesid from asdb3.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

select jobid from asdb.dbo.astpses where id in (select sesid from asdb4.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

select jobid from asdb.dbo.astpses where id in (select sesid from asdb5.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

select jobid from asdb.dbo.astpses where id in (select sesid from asdb6.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

select jobid from asdb.dbo.astpses where id in (select sesid from asdb7.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

select jobid from asdb.dbo.astpses where id in (select sesid from asdb8.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

select jobid from asdb.dbo.astpses where id in (select sesid from asdb9.dbo.astpdat where filenameid in (select id from asfile.dbo.asfilename where  filename like '%xyz%'));

The field returned by this query is the jobid for the job to which this session backup belongs. You need to see if this jobid is same as shown on the GUI.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments