Home » RDBMS Server » Server Administration » Is there any way to find out if a database is a copy of another database? (Oracle 12c)
Is there any way to find out if a database is a copy of another database? [message #664428] Mon, 17 July 2017 07:06 Go to next message
muniraj_tomar
Messages: 7
Registered: July 2017
Junior Member
Hi Ora experts,
we need to find out if a database is a copy of some other database, on what database attributes we can say that this database is copy of some other database.
Is there any query to find the same. Please reply soon.
Re: Is there any way to find out if a database is a copy of another database? [message #664430 is a reply to message #664428] Mon, 17 July 2017 07:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
muniraj_tomar wrote on Mon, 17 July 2017 05:06
Hi Ora experts,
we need to find out if a database is a copy of some other database, on what database attributes we can say that this database is copy of some other database.
Is there any query to find the same. Please reply soon.
which metrics, please enumerate, must be identical match for 2 databases to be considered a copy?

What business problem are you trying to solve?

What will you do differently after your question has been answered?
Re: Is there any way to find out if a database is a copy of another database? [message #664431 is a reply to message #664430] Mon, 17 July 2017 07:19 Go to previous messageGo to next message
muniraj_tomar
Messages: 7
Registered: July 2017
Junior Member
on what metrics we can say that two databases are identical to each other and how to find that information? that is the question here.
We want to delete the copied databases on a system if those are same as the source database.

Is there any query to find out that this is a copied database and get the information about the source database(from where it is copied)???
Re: Is there any way to find out if a database is a copy of another database? [message #664435 is a reply to message #664431] Mon, 17 July 2017 07:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Not every procedural problem has a technical solution.

Why are databases being created if they are NOT needed?

Rather than cleaning up after the fact, consider to NOT make any unneeded databases in the first place.
Re: Is there any way to find out if a database is a copy of another database? [message #664438 is a reply to message #664431] Mon, 17 July 2017 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

muniraj_tomar wrote on Mon, 17 July 2017 14:19
on what metrics we can say that two databases are identical to each other and how to find that information? that is the question here.
We want to delete the copied databases on a system if those are same as the source database.

Is there any query to find out that this is a copied database and get the information about the source database(from where it is copied)???

If databases are real copies that is if they have no difference then you can delete all of them but one as all can be viewed as the source.

[Updated on: Fri, 21 July 2017 01:20]

Report message to a moderator

Re: Is there any way to find out if a database is a copy of another database? [message #664525 is a reply to message #664428] Thu, 20 July 2017 16:53 Go to previous messageGo to next message
scottyyu
Messages: 7
Registered: July 2017
Junior Member
if dbid is the same, most likely database is the same


SQL> select dbid from v$database;

DBID
----------
1448032483
Re: Is there any way to find out if a database is a copy of another database? [message #664527 is a reply to message #664438] Thu, 20 July 2017 17:12 Go to previous message
scottyyu
Messages: 7
Registered: July 2017
Junior Member
if you are doing rman backup and restore, as long as there is no error in backup and restore in V$RMAN_BACKUP_JOB_DETAILS.

the restored target database should be identical timewise to source .

scott
Previous Topic: How to find out Database Owner in Oracle?
Next Topic: transportable tablespace RHEL to Solaris
Goto Forum:
  


Current Time: Thu Mar 28 08:37:57 CDT 2024