- 浏览: 238622 次
最新评论
测试上面的一个库
plsql报错:shared memory realm does not exist
startup报错:ORA-03113:end-of-file on communication channel
SQL> startup;
ORACLE instance started.
Total System Global Area 2.8327E+10 bytes
Fixed Size 2214176 bytes
Variable Size 1.6375E+10 bytes
Database Buffers 1.1811E+10 bytes
Redo Buffers 139182080 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 18352
Session ID: 35 Serial number: 5
error:
Errors in file /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_23390.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 9413066752 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 -需要增加磁盘空间并且调大参数db_recovery_file_dest_size
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 /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_23390.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 27262976 bytes disk space from 9413066752 limit
ARCH: Error 19809 Creating archive log file to '+RECOVERY'
Errors in file /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_23390.trc:
ORA-16038: log 1 sequence# 213 cannot be archived ---不能被归档,可见是归档日志满了,数据库无法启动了
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '+DATA/racdb/onlinelog/group_1.257.779192545'
ORA-00312: online log 1 thread 1: '+RECOVERY/racdb/onlinelog/group_1.257.779192545'
USER (ospid: 23390): terminating the instance due to error 16038
Fri Mar 30 09:32:18 2012
System state dump is made for local instance
System State dumped to trace file /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_diag_23157.trc
处理过程:
1:由spfile生成pfile,增大pfile中的db_recovery_file_dest_size参数的值
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> create pfile='/opt/app/oracle/admin/racdb/pfile/pfilerac1.ora' from spfile;
File created.
2:由修改过的pfile生成spfile,启动数据库
SQL> startup pfile='/opt/app/oracle/admin/racdb/pfile/pfilerac1.ora';
SQL> create spfile='/opt/app/oracle/product/11.2.0/dbs/spfileracdb1.ora' from pfile;
RAC2 节点同样要建立一个SPFILE:
在RAC2节点执行:
SQL> startup pfile='/opt/app/oracle/admin/racdb/pfile/pfilerac1.ora';
SQL> create spfile='/opt/app/oracle/product/11.2.0/dbs/spfileracdb1.ora' from pfile;
--修改PFILE 中的db_recovery_file_dest_size
vi /opt/app/oracle/admin/racdb/pfile/pfilerac1.ora
*.db_recovery_file_dest_size=100g
3:使用rman,清理过期的数据
[oracle@localhost ~]$ rman target/
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 25 14:18:53 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ONLINE (DBID=2094135012)
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
cat /dba/oracle/diag/rdbms/wbepinterfacest/wbepinterfac/trace/alert_wbepinterfac.log
发现确实是归档日志满了,使用率100%造成的。
但是由于库现在起不来,我们可以如上,改大参数,也可以手动清理一些,然后起库,
再使用rman工具--
delete archivelog all completed before 'sysdate-2';
这个库是用是asm,因此
su - grid
asmcmd
cd FRA_DG/WBEPINTERFACEST/ARCHIVELOG/2013_10_10
rm -fr thread*
然后startup mount
alter database noarchivelog;
alter database open;
监听可能没起来,
我们可以
crsctl start res wbepinterfac.head -n test01
plsql报错:shared memory realm does not exist
startup报错:ORA-03113:end-of-file on communication channel
SQL> startup;
ORACLE instance started.
Total System Global Area 2.8327E+10 bytes
Fixed Size 2214176 bytes
Variable Size 1.6375E+10 bytes
Database Buffers 1.1811E+10 bytes
Redo Buffers 139182080 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 18352
Session ID: 35 Serial number: 5
error:
Errors in file /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_23390.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 9413066752 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 -需要增加磁盘空间并且调大参数db_recovery_file_dest_size
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 /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_23390.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 27262976 bytes disk space from 9413066752 limit
ARCH: Error 19809 Creating archive log file to '+RECOVERY'
Errors in file /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_ora_23390.trc:
ORA-16038: log 1 sequence# 213 cannot be archived ---不能被归档,可见是归档日志满了,数据库无法启动了
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '+DATA/racdb/onlinelog/group_1.257.779192545'
ORA-00312: online log 1 thread 1: '+RECOVERY/racdb/onlinelog/group_1.257.779192545'
USER (ospid: 23390): terminating the instance due to error 16038
Fri Mar 30 09:32:18 2012
System state dump is made for local instance
System State dumped to trace file /opt/app/oracle/diag/rdbms/racdb/racdb1/trace/racdb1_diag_23157.trc
处理过程:
1:由spfile生成pfile,增大pfile中的db_recovery_file_dest_size参数的值
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> create pfile='/opt/app/oracle/admin/racdb/pfile/pfilerac1.ora' from spfile;
File created.
2:由修改过的pfile生成spfile,启动数据库
SQL> startup pfile='/opt/app/oracle/admin/racdb/pfile/pfilerac1.ora';
SQL> create spfile='/opt/app/oracle/product/11.2.0/dbs/spfileracdb1.ora' from pfile;
RAC2 节点同样要建立一个SPFILE:
在RAC2节点执行:
SQL> startup pfile='/opt/app/oracle/admin/racdb/pfile/pfilerac1.ora';
SQL> create spfile='/opt/app/oracle/product/11.2.0/dbs/spfileracdb1.ora' from pfile;
--修改PFILE 中的db_recovery_file_dest_size
vi /opt/app/oracle/admin/racdb/pfile/pfilerac1.ora
*.db_recovery_file_dest_size=100g
3:使用rman,清理过期的数据
[oracle@localhost ~]$ rman target/
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 25 14:18:53 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ONLINE (DBID=2094135012)
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
cat /dba/oracle/diag/rdbms/wbepinterfacest/wbepinterfac/trace/alert_wbepinterfac.log
发现确实是归档日志满了,使用率100%造成的。
但是由于库现在起不来,我们可以如上,改大参数,也可以手动清理一些,然后起库,
再使用rman工具--
delete archivelog all completed before 'sysdate-2';
这个库是用是asm,因此
su - grid
asmcmd
cd FRA_DG/WBEPINTERFACEST/ARCHIVELOG/2013_10_10
rm -fr thread*
然后startup mount
alter database noarchivelog;
alter database open;
监听可能没起来,
我们可以
crsctl start res wbepinterfac.head -n test01
发表评论
-
ETL工具--kettle简介
2016-02-24 11:21 0oracle ETL工具---数据迁移 常用的有:OWB(o ... -
oracle 游标实例
2015-12-31 17:23 1199oracle游标 游标-----内存 ... -
10053事件分析
2015-12-25 17:37 7821)10053介绍: 10053 事件是oracle 提供的用 ... -
oracle绑定变量学习
2015-12-25 17:01 1586绑定变量(binding variable) ... -
oracle 绑定变量
2015-12-24 17:26 0关键词: 绑定变量(binding variable),共享池 ... -
oracle插入大量数据
2015-12-23 17:35 1411oracle插入大量数据 1.生 ... -
oracle分区表【转】
2015-12-23 14:20 433oracle分区表 1.表空间及 ... -
迁移数据文件到ASM【转】
2015-12-23 11:53 7661.迁移数据文件到ASM 1) ... -
adrci命令
2015-12-23 11:46 3049一、adrci说明 在oracle11g中,dump ... -
用户+角色+权限
2015-12-21 17:58 892角色与用户权限的学习 ... -
oracle database link
2015-12-21 17:08 872目前我的数据库里只有tinadb一个实例,要创建db link ... -
oracle回收站
2015-12-21 14:22 426oracle回收站 1.drop table books; ... -
使用nid修改sid和dbname
2015-12-21 15:29 761如非必要,不建议在生产库上对dbid进行修改 1、修改dbi ... -
rman模拟故障恢复实验
2015-12-18 16:08 1147补充1:restore database和recover da ... -
rman命令学习-tina(下)
2015-12-18 16:07 1152五、rman删除 delete命令 删除相关的 ... -
rman命令学习-tina(上)
2015-12-18 16:06 874RMAN学习-tina rman的功能非常强大,下面我们来一 ... -
oracle profile介绍
2015-12-16 17:34 620profile文件的介绍: Oracle系统中的profi ... -
oracle缩小表空间
2015-12-18 16:59 1755oracle缩小表空间: oracle常用的此类命令Alte ... -
oracle数据库的启动和关闭【转】
2015-12-16 15:02 1131数据库的启动和关闭 Or ... -
oracle的主要进程
2015-12-16 14:21 1180[size=small]oracle的主要进程 Oracle实 ...
相关推荐
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-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
调整参数后引起,ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3 2768M 的解决方案
ORA-12154: TNS: 无法解析指定的连接标识符的解决方法
ORA-32001:write to spfile requested but no spfile is in use请求写入spfile,但没有使用spfile的解决方法 在输入以下语句中报了这样的错误: SQL>alter system set control_files=’/u01/app/oracle/oradata/prod/...
ORA-00031:标记要终止的会话解决方案; ORA-00031:标记要终止的会话解决方案;
ORA-01036:非法的变量名/编号 oracle特有的错误
oracle12c程序连接时异常: ORA-01017: 用户名/口令无效; 登录被拒绝 的解决方案。
oracle 12 c ORA-01017: 用户名/口令无效; 登录被拒绝
-- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... ...
NULL 博文链接:https://3w1h.iteye.com/blog/1211779
oracle 回闪日志 满了 ORA-03113 通信信道结束 进入 rman 删除日志
oracle报错ora-12541:TNS无监听程序
解决ORACLE TNS: 无法解析指定的连接标识符; 里面有步骤
ora-03113错误
最近在工作中遇到了一个问题,错误是Oracle dbca时报错:ORA-12547: TNS:lost contact,通过查找相关的资料终于找到了解决的方法,下面分享给大家,话不多说了,来一起看看详细的介绍吧。 环境: OS:RHEL6.5 x86-...
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
ORA-27303: additional information: MTU could not be verified. Did not receive valid message. These errors are caused by more aggressive checking introduced in 10.2.0.4. Likelihood of Occurrence ...
ora-12514:TNS:监听程序当前无法识别连接描述符中请求的服务bug,解决文档.