【12c】ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

Alen_Liu_SZ

于 2020-05-23 00:05:56 发布

阅读量5k

点赞数 1

分类专栏： Oracle 12c学习系列文章标签： ORA-00257 Archiver error

本文链接：https://blog.youkuaiyun.com/Alen_Liu_SZ/article/details/106293380

版权

当遭遇ORA-00257错误时，通常是因为闪回恢复区的空间被归档日志占满。解决方案包括扩大快闪恢复区大小或删除归档日志，但在删除前需确认是否安全。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1 问题描述

1）登录数据库出错

[oracle@odd agent]$ sqlplus alen/alen@prod2

SQL*Plus: Release 12.1.0.2.0 Production on Fri May 22 23:46:30 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

ERROR:

ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

2 问题查看

1）查看ORA错误

[oracle@odd agent]$ oerr ora 00257

00257, 00000, "Archiver error. Connect AS SYSDBA only until resolved."

// *Cause: The archiver process received an error while trying to archive

// a redo log. If the problem is not resolved soon, the database

// will stop executing transactions. The most likely cause of this

// message is that the destination device is out of space to store the

// redo log file. Another possible cause is that a destination marked

// as MANDATORY has failed.

// *Action: Check the alert log and trace files for detailed error

// information.</

最低0.47元/天解锁文章