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: 6
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: 25523
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: 6
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: 25523
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: 65079
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 they you delete all of them but one as all can be viewed as the source.

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: 3
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: 3
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: upgrading 11g to 12c on new windows server
Goto Forum:
  


Current Time: Fri Jul 21 00:19:28 CDT 2017

Total time taken to generate the page: 0.09548 seconds