OS:Windos 7 64bit
DB:11.2.0.4 64bit
问题现象:
SQL> startup; ORACLE 例程已经启动。 Total System Global Area 5344731136 bytes Fixed Size 2290648 bytes Variable Size 2281704488 bytes Database Buffers 3053453312 bytes Redo Buffers 7282688 bytes 数据库装载完毕。 ORA-03113: 通信通道的文件结尾 进程 ID: 3312 会话 ID: 385 序列号: 3
查看alter告警日志: 定位到错误根源:ora-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 100.00% used, and has 0 remaining bytes available
解决方法: 关闭数据库实例 SQL> shutdown abort; ORACLE 例程已经关闭。
装载数据库 SQL> startup mount; ORACLE 例程已经启动。 Total System Global Area 5344731136 bytes Fixed Size 2290648 bytes Variable Size 2281704488 bytes Database Buffers 3053453312 bytes Redo Buffers 7282688 bytes
数据库装载完毕。
查看归档日志位置SQL> select * fromv$recovery_file_dest; NAME ----------------------------------------------------------------------- SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLENUMBER_OF_FILES ----------- ---------- -------------------------------- H:\app\Administrator\flash_recovery_area
5.3687E+10 5.3646E+10 0 640
查看归档日志大小 SQL> show parameter db_recovery_file_dest_size; NAME TYPE VALUE ----------------------------------------------- ------------------ db_recovery_file_dest_size big integer 50G
增加归档日志大小
SQL> alter system setdb_recovery_file_dest_size=60G scope=spfile; 系统已更改。
在RMAN中通过删除flash recovery area中不必要的的备份来释放缓冲区的空间 H:\app\Administrator\product\11.2.0\dbhome_1\BIN>rmantarget / 恢复管理器: Release 11.2.0.4.0 - Production on 星期一 8月 13 17:07:452018 Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
已连接到目标数据库: HIS (DBID=3306462041, 未打开)
找出状态为expired的归档日志 RMAN>crosscheck archivelog all; 删除3天前的归档文件 RMAN> delete archivelog all completed before 'sysdate -3';
启动数据库到open状态
SQL> alter database open; 数据库已更改。
|