Mon, 14 May 2007
ORA-00257: archiver error. Connect internal only, until freed.
I run Oracle-XE on Ubuntu and got the error message:
ORA-00257: archiver error. Connect internal only, until freed.
I had previously enabled the archive mode and it seems that the logs had filled up my disk. Now, this is almost certainly the wrong thing to do, but I just deleted the log directories in /usr/lib/oracle/xe/app/oracle/flash_recovery_area/XE/archivelog.
The directory can be determined by running
select member from v$logfile;
Well, the first part of it can, anyway.
Then I restarted the database and the world was put in order. Or at least a small part of it was.
Anyway, archive mode can be enabled with:
shutdown immediate; startup mount; alter database archivelog; alter database open; select log_mode from v$database; alter system archive log start;
and disabled with:
shutdown immediate; startup mount; alter database noarchivelog; alter database open; select log_mode from v$database;
You can see interesting information about the archives with:
archive log list
