No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
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 users48052
Total active users1733
Act. users last 24h10
Act. users last hour1
Registered user hits last week395
Registered user hits last month1204
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, 4 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, 4 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, 4 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, 4 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, 4 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, 2 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