I am the sole DBA for our site, all of them running RHEL 5, Oracle 126.96.36.199.
I recently (within the last hour), received a text message from one of our databases that poll the alert.log...
ORA-1031 signalled during: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3
Unfortunately, the 'audit database' was not enabled (it is now!), and the trace file generated did not contain anything of use.
I know someone has been loading data since 1:30pm up until near the time I received this text, and I'm wondering if he is mucking in the system, or if this command can somehow be generated automatically by Oracle. If so, I certainly wouldn't expect an ORA-1031insufficient permissions error....
I checked my v$log, v$logfile, and did a log switch just to check if any possibility of redo log corruption, but all looks fine.
Has anyone else ever had random Oracle errors like this?....
That's someone manually doing something when they really don't know what they are doing. I've only had to run that command once in 16 years as a dba. Oracle wouldn't ever run that itself.