2 Replies Latest reply: Feb 9, 2013 7:43 AM by Richard Harrison . RSS

    alter database clear unarchived logfile group... who, what?

    stuartu
      I am the sole DBA for our site, all of them running RHEL 5, Oracle 11.2.0.3.

      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?....