Home » RDBMS Server » Server Administration » Deviations in the databases (Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core))
Deviations in the databases [message #685292] Mon, 06 December 2021 00:33 Go to next message
BalajiDBA
Messages: 132
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Deviations?

Re: Deviations in the databases [message #685294 is a reply to message #685293] Mon, 06 December 2021 03:13 Go to previous messageGo to next message
BalajiDBA
Messages: 132
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
Re: Deviations in the databases [message #685296 is a reply to message #685294] Mon, 06 December 2021 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And the problem is?

Re: Deviations in the databases [message #685298 is a reply to message #685296] Mon, 06 December 2021 06:31 Go to previous messageGo to next message
BalajiDBA
Messages: 132
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
Re: Deviations in the databases [message #685304 is a reply to message #685298] Mon, 06 December 2021 09:16 Go to previous messageGo to next message
EdStevens
Messages: 1375
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?
Re: Deviations in the databases [message #685305 is a reply to message #685298] Mon, 06 December 2021 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Deviations in the databases [message #685306 is a reply to message #685304] Mon, 06 December 2021 19:22 Go to previous messageGo to next message
BalajiDBA
Messages: 132
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
Re: Deviations in the databases [message #685307 is a reply to message #685305] Mon, 06 December 2021 19:24 Go to previous messageGo to next message
BalajiDBA
Messages: 132
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
Re: Deviations in the databases [message #685309 is a reply to message #685307] Tue, 07 December 2021 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
BalajiDBA
Messages: 132
Registered: October 2018
Location: India
Senior Member
Sad
Re: Deviations in the databases [message #685707 is a reply to message #685310] Thu, 10 March 2022 04:20 Go to previous message
Andrey_R
Messages: 401
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:
  


Current Time: Mon Aug 08 00:19:40 CDT 2022