- 最后登录
- 2018-9-14
- 在线时间
- 47 小时
- 威望
- 205
- 金钱
- 2327
- 注册时间
- 2011-10-13
- 阅读权限
- 150
- 帖子
- 90
- 精华
- 0
- 积分
- 205
- UID
- 26
|
2#
发表于 2017-8-3 16:57:30
本帖最后由 biotwang 于 2017-8-3 16:59 编辑
下文类似情况可做参考:
问题: 数据库启动时发生ORA-00354错误:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 32768 change 6715041179 time 04/23/2012 13:33:51
如何解决此ORA-00354报错?
回答: 你的日志文件头存在讹误损坏。如果这是个生产库,那么可以在MOS上开个SR寻求帮助。
oerr显示的ORA-00354信息如下:- ORA-00354: Corrupt redo log block header.
- Cause: The block header on the redo block indicated by the accompanying error, is not reasonable.
- Action: Do recovery with a good version of the log or do time based recovery up to the indicated time.
- If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option.
- This must be followed by a backup of every datafile to insure recoverability of the database.
复制代码 Oracle会推荐你使用隐藏参数来开库:- alter system set "_allow_restlogs_corruption"=true scope=both;
复制代码 之后检查为归档redo日志:
SQL> select * from v$log;
如果看到未归档日志文件,那么尝试使用以下命令进行归档清理::- SQL> alter database clear unarchived logfile 'logilename';
复制代码 这样做,很明显你会丢一个重做日志,因此在开库后,一个全备是需要的。 |
|