ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

原创 Oracle 作者：wuweilong 时间：2014-09-03 22:55:54 0 删除 编辑
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode


问题现象：
我在执行开启归档命令后报错误ORA-00265
  1. SQL> alter database archivelog;
  2. alter database archivelog
  3. *
  4. ERROR at line 1:
  5. ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

问题分析：
     从如上错误我们可以看到是因为datafile，controlfile，redolog中的SCN号不一致导致无法开启归档，那么导致该问题的原因是因为我重启数据库到mount的时候采用的是startup force mount;因为这个命令实际上是做了两步操作，分别如下:
1、shutdown abort    ---强制关闭数据库
2、startup mount

      既然我们隐含的做了shutdown abort操作之后，也就意味着datafile，controlfile，redolog这里面的SCN号肯定不一致，需要在open数据库的过程中做recover，由于他们的SCN号不一致，所以会导致无法在mount状态下开启archivelog,如下:
  1. SQL> startup mount force;
  2. ORACLE instance started.

  4. Total System Global Area 2505338880 bytes
  5. Fixed Size 2255832 bytes
  6. Variable Size 620758056 bytes
  7. Database Buffers 1862270976 bytes
  8. Redo Buffers 20054016 bytes
  9. Database mounted.

  11. SQL> alter database archivelog;
  12. alter database archivelog
  13. *
  14. ERROR at line 1:
  15. ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

问题解决办法:
针对该问题，最简单的解决办法是，将数据库open，这个时候会进行recover操作，完成之后再进行shutdown immediate后启动到statup mount就可以开启归档了，详细见如下：

  1. SQL> alter database open;

  3. Database altered.

  5. ####recover日志信息如下
  6. alter database open
  7. Beginning crash recovery of 1 threads
  8.  parallel recovery started with 3 processes
  9. Started redo scan
  10. Completed redo scan
  11.  read 1522 KB redo, 175 data blocks need recovery
  12. Started redo application at
  13.  Thread 1: logseq 7, block 10941
  14. Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0
  15.   Mem# 0: /DBData/woo2/redo01.log
  16. Completed redo application of 0.44MB
  17. Completed crash recovery at
  18.  Thread 1: logseq 7, block 13985, scn 991198
  19.  175 data blocks read, 175 data blocks written, 1522 redo k-bytes read
  20. Wed Sep 03 22:39:35 2014
  21. Thread 1 advanced to log sequence 8 (thread open)
  22. Thread 1 opened at log sequence 8
  23.   Current log# 2 seq# 8 mem# 0: /DBData/woo2/redo02.log
  24. Successful open of redo thread 1
  25. MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
  26. Wed Sep 03 22:39:35 2014
  27. SMON: enabling cache recovery
  28. [13499] Successfully onlined Undo Tablespace 2.
  29. Undo initialization finished serial:0 start:3565124 end:3565194 diff:70 (0 seconds)
  30. Verifying file header compatibility for 11g tablespace encryption..
  31. Verifying 11g file header compatibility for tablespace encryption completed
  32. SMON: enabling tx recovery
  33. Database Characterset is AL32UTF8
  34. No Resource Manager plan active
  35. replication_dependency_tracking turned off (no async multimaster replication found)
  36. Starting background process QMNC
  37. Wed Sep 03 22:39:36 2014
  38. QMNC started with pid=23, OS id=16119
  39. Completed: alter database open
  40. Wed Sep 03 22:39:37 2014
  41. db_recovery_file_dest_size of 4182 MB is 0.00% used. This is a
  42. user-specified limit on the amount of space that will be used by this
  43. database for recovery-related files, and does not reflect the amount of
  44. space available in the underlying filesystem or ASM diskgroup.
  45. Wed Sep 03 22:39:37 2014
  46. Starting background process CJQ0
  47. Wed Sep 03 22:39:37 2014
  48. CJQ0 started with pid=24, OS id=16134
  49. Starting background process SMCO
  50. Wed Sep 03 22:39:43 2014
  51. SMCO started with pid=30, OS id=16149

#####immediate关闭数据库，重新开启归档,即可。
  1. SQL> shutdown immediate
  2. Database closed.
  3. Database dismounted.
  4. ORACLE instance shut down.
  5. SQL> startup mount;
  6. ORACLE instance started.

  8. Total System Global Area 2505338880 bytes
  9. Fixed Size 2255832 bytes
  10. Variable Size 620758056 bytes
  11. Database Buffers 1862270976 bytes
  12. Redo Buffers 20054016 bytes
  13. Database mounted.
  14. SQL> alter database archivelog;

  16. Database altered.

  18. SQL> alter database open;

  20. Database altered.

  22. SQL>

  24. ###打开归档alert日志信息如下
  25. ALTER DATABASE MOUNT
  26. Successful mount of redo thread 1, with mount id 3606990310
  27. Database mounted in Exclusive Mode
  28. Lost write protection disabled
  29. Completed: ALTER DATABASE MOUNT
  30. Wed Sep 03 22:45:06 2014
  31. alter database archivelog
  32. Completed: alter database archivelog
  33. alter database open
  34. Wed Sep 03 22:45:12 2014
  35. LGWR: STARTING ARCH PROCESSES
  36. Wed Sep 03 22:45:12 2014
  37. ARC0 started with pid=20, OS id=16867
  38. ARC0: Archival started
  39. LGWR: STARTING ARCH PROCESSES COMPLETE
  40. ARC0: STARTING ARCH PROCESSES
  41. Wed Sep 03 22:45:13 2014
  42. ARC1 started with pid=21, OS id=16871
  43. Wed Sep 03 22:45:13 2014
  44. ARC2 started with pid=22, OS id=16873
  45. Wed Sep 03 22:45:13 2014
  46. ARC3 started with pid=23, OS id=16875
  47. ARC1: Archival started
  48. ARC2: Archival started
  49. ARC1: Becoming the \


来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/20674423/viewspace-1263237/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： ORA-07274: spdcr: access error, access to oracle denied.
下一篇： expdp 导出多路径
请登录后发表评论 登录
全部评论
wuweilong
专家姓名：吴伟龙
Oracle ACE Associate； 12cOCM；11gOCM；MySQL OCP；PGCA；PGCE；KCA; KCP; 本人拥有十年以上运营商，广电传媒，能源，制造等行业DBA从业经验; 有着丰富的管理及运维经验，经历过国家级重点项目，省级标杆项目，新型试点项目

注册时间：2010-01-08

  • 博文量
    779
  • 访问量
    4931756

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593