Oracle启动失败startup 闪回空间满

2023年 4月 29日 28.6k 0

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 --------

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 20GSQL> 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 immediatestartup nomountalter 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 nocatalogconnect target /delete archivelog all completed before 'sysdate - 30';

启动失败日志ARC3 started with pid=24, OS id=2958 ARC1: Archival startedARC2: Archival startedARC3: Archival startedARC0: STARTING ARCH PROCESSES COMPLETEARC0: Becoming the 'no FAL' ARCHARC0: Becoming the 'no SRL' ARCHARC2: Becoming the heartbeat ARCHErrors 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 filesORA-19804: cannot reclaim 18508800 bytes disk space from 8589934592 limitARCH: 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.

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论