Social Icons

Pages

1.18.2012

ORA-00257: archiver error


ERROR:
ORA-00257: archiver error. Connect internal only, until freed.

Recently, there's an issue at the development database saying, user cannot connect although sysdba is able to connect. The following error is logged in the alert log file.

When the archiver state is queried from v$database, it says - stopped.

The reason for the error is that the mountpoint of the archived logs is 100%. So we need to backup the archive logs to a different location and free-up the disk usage.

With this the archiver starts to run.

0 comments:

Post a Comment