This discussion is archived
2 Replies Latest reply: Feb 9, 2013 5:43 AM by Richard Harrison . RSS

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

stuartu Explorer
Currently Being Moderated
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?....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points