flash_recovery_area空间压力导致ORA-01033:ORACLE 正在初始化
处理方法如下: ????????? SQL> conn / as sysdba????????? 已连接。????????? SQL> conn hr/hr????????? ERROR:????????? ORA-01033: ORACLE 正在初始化或关闭????????? ????????? ????????? 警告: 您不再连接到 ORACLE。????????? ????????? SQL> shutdown immediate????????? ORA-01109: 数据库未打开????????? ????????? ????????? 已经卸载数据库。????????? ORACLE 例程已经关闭。????????? SQL> startup????????? ORACLE 例程已经启动。????????? ????????? Total System Global Area????????????????????????? 612368384 bytes????????? Fixed Size????????????????????????????????????????? 1250428 bytes????????? Variable Size???????????????????????????????????? 180358020 bytes????????? Database Buffers????????????????????????????????? 423624704 bytes????????? Redo Buffers??????????????????????????????????????? 7135232 bytes????????? 数据库装载完毕。????????? ORA-16038: 日志 3 序列号 108 无法归档????????? ORA-19809: 超出了恢复文件数的限制????????? ORA-00312: 联机日志 3 线程 1:????????? 'D:ORACLEPRODUCT10.2.0ORADATAORCLONLINELOGO1_MF_3_7TQZWZOY_.LOG'????????? ORA-00312: 联机日志 3 线程 1:????????? 'D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_AREAORCLONLINELOGO1_MF_3_7TQZX11D_.L????????? OG'????????? SQL> alter system set db_recovery_file_dest_size=5g;????????? ????????? 系统已更改。????????? ????????? SQL> archive log start;????????? 已处理的语句????????? SQL> archive log next;????????? 已存档一个日志。????????? SQL> alter database open;????????? ????????? 数据库已更改。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |