查看: 1938|回复: 0

[Oracle数据库] ORACLE 12C ORA-00312 redo故障处理

发表于 2018-1-28 10:08:16

一、描述
DB版本:12.1.0.2
system版本:7.0

二、处理过程
1、报错,数据库启动就实例就会异常终止

  1. ORA-00312: online log 3 thread 1: '+DATADG/ORCLDG/ONLINELOG/group_3.403.962961193'
  2. ORA-00312: online log 3 thread 1: '+DATADG/ORCLDG/ONLINELOG/group_3.405.962961193'
  3. Mon Jan 08 13:35:53 2018
  4. USER (ospid: 15155): terminating the instance due to error 16014
  5. Mon Jan 08 13:35:53 2018
  6. System state dump requested by (instance=1, osid=15155), summary=[abnormal instance termination].
  7. System State dumped to trace file /u01/app/oracle/diag/rdbms/orcldg/orcldg/trace/orcldg_diag_15110_20180108133553.trc
  8. Mon Jan 08 13:35:53 2018
  9. Dumping diagnostic data in directory=[cdmp_20180108133553], requested by (instance=1, osid=15155), summary=[abnormal instance termination].
  10. Mon Jan 08 13:35:53 2018
  11. Instance terminated by USER, pid = 15155
  12. Mon Jan 08 13:39:58 2018
  13. Starting ORACLE instance (normal) (OS id: 16121)
  14. Mon Jan 08 13:39:58 2018
  15. CLI notifier numLatches:3 maxDescs:519
  16. Mon Jan 08 13:39:58 2018
复制代码

2、处理过程

  1. SQL> startup mount;
  2. ORACLE instance started.
  3. Total System Global Area 1241513984 bytes
  4. Fixed Size 2923872 bytes
  5. Variable Size 452985504 bytes
  6. Database Buffers 771751936 bytes
  7. Redo Buffers 13852672 bytes
  8. Database mounted.
  9. SQL>
  10. SQL> select group#,sequence#,archived,status from v$log;
  11. GROUP# SEQUENCE# ARC STATUS
  12. ---------- ---------- --- ----------------
  13. 1 356 NO INACTIVE
  14. 3 355 NO INACTIVE
  15. 2 357 NO CURRENT
  16. SQL> alter database clear logfile group 3 ;
  17. alter database clear logfile group 3
  18. *
  19. ERROR at line 1:
  20. ORA-00350: log 3 of instance orcldg (thread 1) needs to be archived
  21. ORA-00312: online log 3 thread 1:
  22. '+DATADG/ORCLDG/ONLINELOG/group_3.403.962961193'
  23. ORA-00312: online log 3 thread 1:
  24. '+DATADG/ORCLDG/ONLINELOG/group_3.405.962961193'
  25. SQL>
  26. SQL> alter database clear unarchived logfile group 3 ;
  27. Database altered.
  28. SQL> alter database open;
  29. Database altered.
复制代码

3、说明
我这里是一个ADG,主库这样操作会导致GAP,备库需要增量恢复。



回复

使用道具 举报