归档日志满以后引起的错误
今天在目录服务程序中出现Caused by: java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed.
修复:
sql> conn / as sysdba
sql> shutdown abort;
sql> startup mount;
sql> recover database until cancel;
sql> alter database open resetlog
用pl/sql developer登陆后仍然有
archiver error. Connect internal only, until freed.
的错误
查看archive log list
发现Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 3
原因是archive destination空间满的问题
alter system set log_archive_dest_1='location=/home/oracle/oradata/fondo/ optional';
问题解决,
归档日志满以后引起的错误 Caused by: java.sql.SQLException: ORA-00257:
最新推荐文章于 2023-09-15 15:32:37 发布