If the database was shared in a AR server group, a look at the records on the table servergrp_ would reveal the servers that were part of the AR Server Group.
You might even want to check with your DBA if the backup script inncludes the control file of the database. This control file provides vital information about the database Satya On Fri, Jul 24, 2009 at 5:00 PM, Grooms, Frederick W < [email protected]> wrote: > The only suggestion I can give you is to look for something distinct > between the environments. In our case on Oracle we have different dbLinks > (which are different on dev/test/...) > > Another way might be to look for different data in one of the tables (i.e. > I use a different login on each environment so that would be different on > dev/test/...) > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of manoj jain > Sent: Friday, July 24, 2009 10:41 AM > To: [email protected] > Subject: very interesting issue > > Hi Remedians, > > I need to restore the database from a backup copy. I have 20 backup copies > with just date and no name. > I need to login into each database and need to identify if this is the > right database. > These 20 db can belong to prod or qa or dev. > > So is there any way to identify right backup? > > Thanks & Regards, > Manoj Jain > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > -- Regards Satya The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
