OraFAQ Forum: Server Administration » Is there any way to find out if a database is a copy of another database?

Home » RDBMS Server » Server Administration » Is there any way to find out if a database is a copy of another database? (Oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is there any way to find out if a database is a copy of another database? [message #664428]

Mon, 17 July 2017 07:06

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.

Report message to a moderator

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

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?

Report message to a moderator

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

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)???

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 13:54:53 CST 2024