| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Massive_Thangs !!!!
Maestros I've got some questions.
(1) There was a schema dropped on one of the databases, some where
around November 2000. Now another lady was working on it, she never up
with any positive result and eventually she left the Company, now they
are saying I must take over. The actually thing is to find out who
dropped the schema with it's objects. This database is using RMAN. I
am not really much clued with RMAN but I reckon it's gonna be a nice
experience. The thing is, they are suggesting that I use Oracle 8i to
find out who dropped the Schema. Seeing that I am not really clued up
with 8i is there a way I can get this considering that AUDITING was
not enabled except that it was enabled for only SESSION (i.e. who
logged on, not who logged on and what was he/she doing) or a tool that
can help me find out who dropped the Schema ?
I will appreciate any form of help.
Are you using Oracle 8i?
The only way to tell who dropped the schema is if you have auditing
switched on.
If you are on Oracle 8i you can use logminer. You can interegate your
archive logs and extract all DDL statements logged.
But since it is so long time ago it may not be possible.
(2) Last but not least: Something nasty happened here a week ago or
so.
All objects of two databases (One Production and the other
Development) went invalid and these are running on two separate
machines (boxes). They even went on to become corrupt and we had to
recreate some packages and procedures. Well to give you an idea, the
development database is created by using an export (dump file) from
the Production database. What's strange is that they became invalid
and corrupt at almost the same time. The Production one is running on
Oracle 806 while the Development one is running on 805.
I doubt that this is Software related but I am not 100% sure.
I logged the call with Oracle Support but they couldn't help me except
to tell me that it's impossible that objects became invalid without
anyone having done something on them. Now I am stuck, there is bokorol
that I can get from the database which might suggest that someone
dropped or fiddled with it, I checked all logs or whatever. One senior
guy here couldn't come up with the cause of that.
It's strange and I hope someone out there will be able to help me.
Where do I start now ?
It is very strange that the objects became invalid. Objects do not become
invalid
unless someone made some structural changes.
Eg. a view, procedure, package, etc would become invalid if the underlying
tables or referenced
objects have undergone a structural change or dropped.
Check the Oracle alert logs and trace files.
Since both the prod and dev databases objects became invalid at the same
time I think it
may be someone was testing something on both databases and this may have
caused the objects
to become invalid.
Keep a close eye and monitor for future occurences. If this is a common problem switch on tracing to monitor what is causing this.
Hope this helps
Suhen
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas INET: tjaros_at_webmail.co.za Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Mar 05 2001 - 16:04:49 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: Suhen.Pather_at_strandbags.com.au Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |