数据库ora-凯发k8官方网
提示ora-03113:通信通道的文件结尾解决
sql> exit
disconnected from oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
[oracle@cp07_nv1_db ~]$ sqlplus / as sysdba
sql*plus: release 11.2.0.3.0 production on mon dec 12 13:48:35 2016
凯发k8官方网 copyright (c) 1982, 2011, oracle. all rights reserved.
connected to an idle instance.
sql> startup mount
oracle instance started.
total system global area 4275781632 bytes
fixed size 2235208 bytes
variable size 822084792 bytes
database buffers 3439329280 bytes
redo buffers 12132352 bytes
database mounted.
sql> select * from v$log;
group# thread# sequence# bytes blocksize members arc
---------- ---------- ---------- ---------- ---------- ---------- ---
status first_change# first_tim next_change# next_time
---------------- ------------- --------- ------------ ---------
1 1 88281 52428800 512 1 no
inactive 1179936249 12-dec-16 1179945253 12-dec-16
4 1 88283 57671680 512 1 no
current 1179952814 12-dec-16 2.8147e 14
3 1 88280 52428800 512 1 no
inactive 1179929281 12-dec-16 1179936249 12-dec-16
group# thread# sequence# bytes blocksize members arc
---------- ---------- ---------- ---------- ---------- ---------- ---
status first_change# first_tim next_change# next_time
---------------- ------------- --------- ------------ ---------
2 1 88282 52428800 512 1 no
inactive 1179945253 12-dec-16 1179952814 12-dec-16
sql> alter database open resetlogs;
alter database open resetlogs
*
error at line 1:
ora-01139: resetlogs option only valid after an incomplete database recovery
sql> recover database until time '2016-12-11';
media recovery complete.
sql> alter database open resetlogs;
database altered.
sql> select open_mode from $database;
select open_mode from $database
*
error at line 1:
ora-00911: invalid character
sql> select * from v$log;
group# thread# sequence# bytes blocksize members arc
---------- ---------- ---------- ---------- ---------- ---------- ---
status first_change# first_tim next_change# next_time
---------------- ------------- --------- ------------ ---------
1 1 1 52428800 512 1 no
current 1179956666 12-dec-16 2.8147e 14
2 1 0 52428800 512 1 yes
unused 0 0
3 1 0 52428800 512 1 yes
unused 0 0
group# thread# sequence# bytes blocksize members arc
---------- ---------- ---------- ---------- ---------- ---------- ---
status first_change# first_tim next_change# next_time
---------------- ------------- --------- ------------ ---------
4 1 0 57671680 512 1 yes
unused 0 0
重置日志的序列号
sql> select member from v$logfile;
member
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/cp07nv1d/redo03.log
/u01/app/oracle/oradata/cp07nv1d/redo02.log
/u01/app/oracle/oradata/cp07nv1d/redo01.log
/u01/app/oracle/oradata/cp07nv1d/redo04.log
[oracle@cp07_nv1_db ~]$ sqlplus / as sysdba
sql*plus: release 11.2.0.3.0 production on mon dec 12 14:07:10 2016
凯发k8官方网 copyright (c) 1982, 2011, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
sql> select status from v$instance;
status
------------
open
sql> select * from scott.emp;
empno ename job mgr hiredate sal comm
---------- ---------- --------- ---------- --------- ---------- ----------
deptno
----------
7369 smith clerk 7902 17-dec-80 800
20
7499 allen salesman 7698 20-feb-81 1600 300
30
7521 ward salesman 7698 22-feb-81 1250 500
sql> select group#,sequence#,bytes,members,status from v$log;
group# sequence# bytes members status
---------- ---------- ---------- ---------- ----------------
1 1 52428800 1 inactive
2 2 52428800 1 current
3 0 52428800 1 unused
4 0 57671680 1 unused
sql> alter system switch logfile;
system altered.
sql> alter system switch logfile;
system altered.
sql> alter system switch logfile;
system altered.
sql> sql> select open_mode from v$database;
open_mode
--------------------
read write
sql> select open_mode from v$database;
open_mode
--------------------
read write
sql> select group#,sequence#,bytes,members,status from v$log;
group# sequence# bytes members status
---------- ---------- ---------- ---------- ----------------
1 5 52428800 1 inactive
2 6 52428800 1 inactive
3 7 52428800 1 current
4 4 57671680 1 inactive
sql> select member from v$logfile;
member
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/cp07nv1d/redo03.log
/u01/app/oracle/oradata/cp07nv1d/redo02.log
/u01/app/oracle/oradata/cp07nv1d/redo01.log
/u01/app/oracle/oradata/cp07nv1d/redo04.log
sql> select file#,checkpoint_change# from v$datafile;
file# checkpoint_change#
---------- ------------------
1 1180436432
2 1180436432
3 1180436432
4 1180436432
5 1180436432
6 1180436432
6 rows selected.
sql> select file#,checkpoint_change# from v$datafile_header;
file# checkpoint_change#
---------- ------------------
1 1180452436
2 1180452436
3 1180452436
4 1180452436
5 1180452436
6 1180452436
6 rows selected.
sql>
第二步：select * from v$recovery_file_dest;alter system set db_recovery_file_dest_size=10737418240 ---这里是改为10g。alter database openexit第三步：rman target /进入rman工具窗口rman target /rman>crosscheck archivelog all; -- 运行这个命令可以把无效的expired的archivelog标出来。rman>delete expired archivelog all; -- 直接全部删除过期的归档日志。rman>delete noprompt archivelog until time "sysdate -3"; -- 也可以直接用一个指定的日期来删除。 重新打开数据库就可以正常操作了。
总结
以上是凯发k8官方网为你收集整理的数据库ora-03113排查的全部内容，希望文章能够帮你解决所遇到的问题。
- 上一篇： openlayer 3 在layer上添
- 下一篇：