From Suhen.Pather@strandbags.com.au Mon, 05 Mar 2001 14:04:49 -0800 From: Suhen Pather Date: Mon, 05 Mar 2001 14:04:49 -0800 Subject: RE: Massive_Thangs !!!! Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 _______________________________________________________________ http://www.webmail.co.za the South-African free email service WIN R10 000 by registering for free online options for EasyMoney in http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas INET: tjaros@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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: Suhen.Pather@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@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).