OraFAQ Forum: Server Administration » Deviations in the databases

Home » RDBMS Server » Server Administration » Deviations in the databases (Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core))

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

Deviations in the databases [message #685292]

Mon, 06 December 2021 00:33

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Hi ,

We support 200 databases. Could you please let me know an easy way to find the deviations in the databases.

Regards,
Balaji.C

[Updated on: Mon, 06 December 2021 00:34]

Report message to a moderator

Re: Deviations in the databases [message #685293 is a reply to message #685292]

Mon, 06 December 2021 02:36

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

Senior Member
Account Moderator

Deviations?

Report message to a moderator

Re: Deviations in the databases [message #685294 is a reply to message #685293]

Mon, 06 December 2021 03:13

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Deviations means to find the differences in the databases.

Let us say I have 3 databases all with the schema HR. On databases A and B, schema HR has 300 objects but on database C
it has 310 objects then highlight C as being different by 10 objects.

I need to find the deviations on database parameters,database backups like full,incremental and archivelogs,Archivelog destination,
tablespaces with datafiles as well.

I have gathered all the database information for all the databases. This information is required to find the deviations in the databases
and take necessary actions to make sure all databases are set appropriately.

Regards,
Balaji

Report message to a moderator

Re: Deviations in the databases [message #685296 is a reply to message #685294]

Mon, 06 December 2021 05:49

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

Senior Member
Account Moderator

And the problem is?

Report message to a moderator

Re: Deviations in the databases [message #685298 is a reply to message #685296]

Mon, 06 December 2021 06:31

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

The method I know to find the deviations is to login to every database one at a time and find the deviations.
But I am looking for an easy method to find the deviations in all the 200 databases. Could you please help me with this.

FYI -- I have extracted all the values from the databases. I just need to find the deviations in all the databases.

Regards,
Balaji

Report message to a moderator

Re: Deviations in the databases [message #685304 is a reply to message #685298]

Mon, 06 December 2021 09:16

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

BalajiDBA wrote on Mon, 06 December 2021 06:31

FYI -- I have extracted all the values from the databases. I just need to find the deviations in all the databases.

So where and in what form is this extracted data?

Report message to a moderator

Re: Deviations in the databases [message #685305 is a reply to message #685298]

Mon, 06 December 2021 11:03

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

Senior Member
Account Moderator

If, for one measure, you have 50 'A', 75 'B', 30 'C', 40 'D' and 15 'E', what is the expected output?

Note: if you already extracted the desired information from your databases, this is no more an Oracle question.

Report message to a moderator

Re: Deviations in the databases [message #685306 is a reply to message #685304]

Mon, 06 December 2021 19:22

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Quote:

So where and in what form is this extracted data?

This was extracted by using select queries like

To find the information about auditing I use
SELECT parameter,value FROM v$option WHERE parameter = 'Unified Auditing';

For controlfile, I use
select name from v$controlfile;

For archive log file destination, I use
archive log list

And so on.

Regards,
Balaji

Report message to a moderator

Re: Deviations in the databases [message #685307 is a reply to message #685305]

Mon, 06 December 2021 19:24

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Quote:

If, for one measure, you have 50 'A', 75 'B', 30 'C', 40 'D' and 15 'E', what is the expected output?

Could you please explain your sentence in detail.

Quote:

Note: if you already extracted the desired information from your databases, this is no more an Oracle question.

Does it mean there is no other easy way to find solution to my issue.

Regards,
Balaji

Report message to a moderator

Re: Deviations in the databases [message #685309 is a reply to message #685307]

Tue, 07 December 2021 00:24

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

Senior Member
Account Moderator

Quote:

Could you please explain your sentence in detail.

What do you not understand in my sentence?
Taking yours:

Quote:

Let us say I have 3 databases all with the schema HR. On databases A and B, schema HR has 300 objects but on database C
it has 310 objects then highlight C as being different by 10 objects.

If you have 200 databases, as you said, and have, in schema HR, 300 objects in 50 databases, 310 objects in 75 databases, 320 objects in 40 databases, 290 objects in 15 databases, what is highlighted?

Quote:

Does it mean there is no other easy way to find solution to my issue.

There is no other way to know what's inside a database than to connect to it, of course, if this what you meant.

And about Ed's question, he didn't mean how you extracted but in what form there are now once extracted? csv files, for instance?
But, as I said, it is no more an Oracle question, just how you will crunch the result of your results OUTSIDE the databases, so how you will crunch texts.

[Updated on: Tue, 07 December 2021 02:32]

Report message to a moderator

Re: Deviations in the databases [message #685310 is a reply to message #685309]

Tue, 07 December 2021 01:46

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Report message to a moderator

Re: Deviations in the databases [message #685707 is a reply to message #685310]

Thu, 10 March 2022 04:20

Andrey_R
Messages: 441
Registered: January 2012
Location: Israel

Senior Member

BalajiDBA, You can, for example, establish 200 DB links on a central, secured ( arguable point ) oracle instance that has access to all of them.

Then you can write and execute comparison queries on their V$RMAN_STATUS (for backups, for example) , DBA_TABLESPACES & DBA_DATA_FILES ( for data storage ), V$PARAMETER ( for parameters ) and so on...

Andrey

[Updated on: Thu, 10 March 2022 04:51]

Report message to a moderator

Previous Topic:	upgrade database from 11G to 19C
Next Topic:	ORA-01805 Timezone files error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 08:39:59 CST 2024