No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

DB Validation
Next thread: bypass DNS
Prev thread: maximum processes

Message Score Author Date
Good Day I am looking for a script to compare d...... Stan M Oct 12, 2017, 15:24
Hi, check the object count and their status, wh...... Mirza Hidayathullah Baig Oct 12, 2017, 15:45
Hello stan, and the first thing is of course to...... Bruno Vroman Oct 12, 2017, 18:26
thanks Guys The refresh was -b- ... Stan M Oct 12, 2017, 20:03
Hello Stan, then just make sure that the schema...... Bruno Vroman Oct 13, 2017, 10:58
thanks for the tips... Stan M Oct 15, 2017, 07:59

Follow up by mail Click here


Subject: DB Validation
Author: Stan M, South Africa
Date: Oct 12, 2017, 15:24, 63 days ago
Os info: Linux
Oracle info: 11g
Message: Good Day

I am looking for a script to compare databases after a refresh to check if all objects are the same per schema if anyone has such a script.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: DB Validation
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Oct 12, 2017, 15:45, 63 days ago
Message: Hi,

check the object count and their status, which type of refresh you are using, RMAN or User managed or logical.

if it is particular schema refresh, please execute below query by passing schema name.

select owner,OBJECT_TYPE,status,count(1)
from dba_objects
where OWNER in ('&username')
group by owner,OBJECT_TYPE,status
order by count(1),OBJECT_TYPE;

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: DB Validation
Author: Bruno Vroman, Belgium
Date: Oct 12, 2017, 18:26, 63 days ago
Message: Hello stan,

and the first thing is of course to check the "logs" of the refresh operation.

How do you perform the refresh?
-a- RMAN DUPLICATE?
-b- datapump expdp + impdp of 1 or more schemas?
-c- datapump expdp + impdp "full"?
-d- other?

(if you use datapump, you must be careful: target must be "clean" before you start to import data from source)

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: DB Validation
Author: Stan M, South Africa
Date: Oct 12, 2017, 20:03, 62 days ago
Message: thanks Guys

The refresh was -b-

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: DB Validation
Author: Bruno Vroman, Belgium
Date: Oct 13, 2017, 10:58, 62 days ago
Message: Hello Stan,

then just make sure that the schema is "clean" on target before the import: either the schema must have been dropped, or it should not have any object -I prefer the second option: keep schema but drop objects, as this leaves the privileges intact.

There might be other points of attention, if for example the application makes use of PUBLIC SYNONYMS pointing to objects of the schema to refresh: these synonyms will NOT be included in the dmp files and you have to identify them in source to recreate them in target. Also to check: direct privileges on SYS objects.

Best regards,

Bruno
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: DB Validation
Author: Stan M, South Africa
Date: Oct 15, 2017, 07:59, 60 days ago
Message: thanks for the tips
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here