手机版
你好,游客 登录 注册 搜索
背景:
阅读新闻

Oracle启动失败startup - 闪回空间满

[日期:2020-03-23] 来源:Linux社区  作者:zhijiancanxue [字体: ]

Oracle启动失败startup - 闪回空间满

登录失败

sqlplus / as sysdb登录后:
startup

失败,ORA-03113: end-of-file on communication channel
 
查看日志:
SQL> show parameter db_recovery_file_dest_size;

NAME        TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size      big integer 20G
SQL> show parameter background_dump;

NAME        TYPE  VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest      string  /home/oracle/app/11g/diag/rdbm
      s/orcl/orcl/trace


${ORACLEHOME}/app/11g/diag/rdbms/orcl/orcl/trace/alert_orcl.log

增大闪回空间
shutdown immediate
startup nomount
alter system set db_recovery_file_dest_size=20480M;

启动:
alter database open;
或者:
shutdown immediate;
startup

查询闪回空间的大小
show parameter db_recovery_file_dest_size;

查询闪回空间使用情况
SQL> select * from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/home/oracle/app/11g/flash_recovery_area
 2.1475E+10 4539396608        0      209

删除30天以前的归档日志:
rman nocatalog
connect target /
delete archivelog all completed before 'sysdate - 30';

启动失败日志
ARC3 started with pid=24, OS id=2958
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Errors in file /home/oracle/app/11g/diag/rdbms/orcl/orcl/trace/orcl_ora_2942.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
  then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
  BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
  reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
  system command was used to delete files, then use RMAN CROSSCHECK and
  DELETE EXPIRED commands.
************************************************************************
Errors in file /home/oracle/app/11g/diag/rdbms/orcl/orcl/trace/orcl_ora_2942.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 18508800 bytes disk space from 8589934592 limit
ARCH: Error 19809 Creating archive log file to '/home/oracle/app/11g/flash_recovery_area/ORCL/archivelog/2017_09_18/o1_mf_1_1591_%u_.arc'
Errors in file /home/oracle/app/11g/diag/rdbms/orcl/orcl/trace/orcl_arc2_2954.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 8589934592 bytes is 100.00% used, and has 0 remaining bytes available.

Linux公社的RSS地址https://www.linuxidc.com/rssFeed.aspx

本文永久更新链接地址https://www.linuxidc.com/Linux/2020-03/162668.htm

linux
相关资讯       Oracle启动失败startup 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款