DBV-00201: Block, DBA 21065723, marked corrupt for invalid redo application解决

来源:互联网 发布:屋面找坡层计算软件 编辑:程序博客网 时间:2024/06/16 18:30

今天有一个人在群里直接贴出这一个问题,从报错看起来写着,无效的重做应用被标记坏块,

下面是具体的官方信息:

DBV-00201: Block, DBA number, marked corrupt for invalid redo application
Cause: The block was marked corrupt by the Oracle database server for invalid redo application, ex: media recovery of a NOLOGGING object or direct loaded data.
Action: If the block is not currently allocated to a database object, then no action is required. If the block is allocated, then the object will need to be rebuilt, or data to be reloaded.
仔细想了下:日志应用?咦?这不是只用在dataguard等软件才需要么,进一步询问。果然是在搭建dataguard,在上面的Cause信息中NOLOGGING关键字中,并且在网上查找了下信息。明白了是他没有开启force logging。之后开启数据库的force logging就好了。alter database force logging

0 0
原创粉丝点击