ORA-00257: archiver error. Connect internal only, until freed
登录oracle显示上面的错误
以下是公司大师给出的步骤,谨记录备用:
1、手工删除归档日志的文件夹(按日期那种)
2、在oracle用户下以rman target /
3、crosscheck archivelog all;
4、delete expired archivelog all;--
这里删除了一些与第1步中删除的文件日期匹配的文件,目前研究还不深入,不清楚它们之间具体的联系
5、exit;
--如果发现归档日志的空间快使用完了,而没有出现00257的错误,只做到这一步就够了,不用再进行下面的步骤了
--查询归档日志使用的sql:select * from v$flash_recovery_area_usage;
6、接下来是在sqlplus中的操作:
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
ORA-01013: user requested cancel of current operation
//一直停不掉,就ctl+c中断了
//再试一次
SQL> shutdown immediate
ORA-01013: user requested cancel of current operation
//还是停不掉,再次ctl+c中断
//强行停止吧
SQL> shutdown abort
ORACLE instance shut down.
//再次启动
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 1267740 bytes
Variable Size 452986852 bytes
Database Buffers 1140850688 bytes
Redo Buffers 15507456 bytes
Database mounted.
ORA-16014: log 2 sequence# 101 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/oracle/oradata/orcl/redo02.log'
ORA-00312: online log 2 thread 1:
'/backup/oracle_archive/redo_data/redo2/redo021.log'
//数据库没有打开,报上面的错误
SQL> show parameter db_recovery_file_dest_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 4G
SQL> select group#,sequence#,archived,status from v$log;
GROUP# SEQUENCE# ARC STATUS
---------- ---------- --- ----------------
1 103 NO CURRENT
3 102 NO INACTIVE
2 101 NO INACTIVE
//搞一搞SEQUENCE号最小的一个
SQL> alter database clear logfile group 2;
alter database clear logfile group 2
*
ERROR at line 1:
ORA-00350: log 2 of instance orcl (thread 1) needs to be archived
ORA-00312: online log 2 thread 1: '/oracle/oradata/orcl/redo02.log'
ORA-00312: online log 2 thread 1:
'/backup/oracle_archive/redo_data/redo2/redo021.log'
SQL> alter database clear unarchived logfile group 2;
Database altered.
SQL> alter database open;
Database altered.
分享到:
相关推荐
归档日期满了报 ORA-00257 archiver error. Connect internal only, until freed 错误的处理方法
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
oracle数据库报错ORA-00257: archiver error. Connect internal only, until freed ,如何解决呢?此问题定位在归档日志满了,下面把具体解决办法总结分享给大家。 解决办法: SQL> select * from V$FLASH_RECOVERY_...
-- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... ...
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
ORA-32001:write to spfile requested but no spfile is in use请求写入spfile,但没有使用spfile的解决方法 在输入以下语句中报了这样的错误: SQL>alter system set control_files=’/u01/app/oracle/oradata/prod/...
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
ORA-12154: TNS: 无法解析指定的连接标识符的解决方法
NULL 博文链接:https://gembler.iteye.com/blog/346242
ORA-00031:标记要终止的会话解决方案; ORA-00031:标记要终止的会话解决方案;
oracle网络配置(listener_ora-sqlnet_ora-tnsnames_ora).mht
ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:sskgxp_select failed with status: 3 ORA-27301: OS ...
ORA-01036:非法的变量名/编号 oracle特有的错误
调整参数后引起,ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3 2768M 的解决方案
oracle12c程序连接时异常: ORA-01017: 用户名/口令无效; 登录被拒绝 的解决方案。
ora-00257问题处理.doc
Patch 8922013: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X93953434]
oracle19c缺少的函数
NULL 博文链接:https://springlin.iteye.com/blog/1520668
NULL 博文链接:https://3w1h.iteye.com/blog/1211779