| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
(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 ?
-- 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 - 10:25:03 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).
 |
 |