ORA-03113 end-of-file…
来源:互联网 发布:netty 内存管理 源码 编辑:程序博客网 时间:2024/06/05 15:19
ORA-03113:end-of-file on communication channel
兰德马克数据库启动不了,
cd /pb/lmoracle/product/diag/rdbms/owlmk/OWLMK/trace
vi alert_OWLMK.log
cd /pb/lmoracle/product/diag/rdbms/owlmk/OWLMK/trace
vi alert_OWLMK.log
Errors in file/pb/lmoracle/product/diag/rdbms/owlmk/OWLMK/trace/OWLMK_ora_4938.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 38654705664 bytesis 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recoveryarea:
1. Consider changing RMAN RETENTION POLICY. If you are using DataGuard,
then consider changing RMANARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREAcommand.
3. Add disk space and increase db_recovery_file_dest_size parameterto
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If anoperating
system command was used todelete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
2. Back up files to tertiary device such as tape using RMAN
3. Add disk space and increase db_recovery_file_dest_size parameterto
4. Delete unnecessary files using RMAN DELETE command. If anoperating
************************************************************************
显示 db_recovery_file_dest_size36个G已经满了
数据库启动不了,rman target/ 不行
先用root到/pb/oracle_recovery/OWLMK/archivelog删除几个最老的目录。
然后
sqlplus "/as sysdba"
startup;
仍然启动不了。
startup mount;
能启动
先用root到/pb/oracle_recovery/OWLMK/archivelog删除几个最老的目录。
然后
sqlplus "/as sysdba"
startup;
仍然启动不了。
startup mount;
能启动
另外打开一个窗口:
su - lmoracle
rman target /
crosscheck archivelog all;
delete expired archivelog all;
delete noprompt archivelog until time "sysdate -3";
在sqlplus中执行
shutdown;
退出重新进入 sqlplus "/as sysdba"
startup;
正常启动
show parametersdb_recovery_file_dest_size;
NAME TYPE VALUE
------------------------------------ -----------------------------------------
db_recovery_file_dest_size big integer 36G
alter system set db_recovery_file_dest_size=80Gscope=both;
------------------------------------ -----------------------------------------
db_recovery_file_dest_size
alter system set db_recovery_file_dest_size=80Gscope=both;
显示flash_recovery_area用量:
select * from v$flash_recovery_area_usage;
select * from v$recovery_file_dest;
欢迎转载和交流,有问题可联系 QQ: 83555727 或Email
0 0
- ORA-03113 end-of-file…
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- 遇到ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113 end-of-file on communication channel 问题解决
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113end-of-file on communication channel解决
- ORA-03113: end-of-file on communication channel 解决方法
- ORA-03113: end-of-file on communication channel解决方法
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- Redhat扫描硬件
- Linux 增加交换分区
- RedHat Linux下安装Python3
- solaris重启识别硬件改变
- redhat重启后硬盘号变动的问题
- ORA-03113 end-of-file…
- 使用dbca建库出现ORA-04031错误
- 修改oracle memory_target
- Sql Server 2008 视图不排序
- SQL Server2008只能编辑前面2…
- 3G上网卡和局域网共用-路由设置
- redhat Linux 设置nfs共享
- Landmark 5000.8.3 TAR…
- 安装OYO 24 绘图仪 IKON 驱动安装