ORA-00349: failure obtaining block size for '+fra_grp01_d
有一次恢复库以后，open时报错ORA-00349,如下。最后通过删除这个log group解决。 SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00349: failure obtaining block size for '+fra_grp01_d select group#,name,bytes,status from v$logfile; SQL> / 1 /paic/hq/bk/restore/data/oradata/aims/group_1.257.788444161 1 /paic/hq/bk/restore/data/oradata/aims/group_1.257.788444163 2 /paic/hq/bk/restore/data/oradata/aims/group_2.258.788444163 2 +fra_grp01_dg INVALID 3 /paic/hq/bk/restore/data/oradata/aims/group_3.259.788444163 3 /paic/hq/bk/restore/data/oradata/aims/group_3.259.788444165 4 /paic/hq/bk/restore/data/oradata/aims/group_4.266.788744427 4 /paic/hq/bk/restore/data/oradata/aims/group_4.448.788744427 5 /paic/hq/bk/restore/data/oradata/aims/group_5.267.788744443 5 /paic/hq/bk/restore/data/oradata/aims/group_5.449.788744443 6 /paic/hq/bk/restore/data/oradata/aims/group_6.268.788744443 6 /paic/hq/bk/restore/data/oradata/aims/group_6.450.788744443 7 /paic/hq/bk/restore/data/oradata/aims/group_7.271.789784501 7 /paic/hq/bk/restore/data/oradata/aims/group_7.1047.789784501 50 rows selected. SQL> SQL> alter database drop logfile group 2; Database altered. SQL> alter database open resetlogs; Database altered.
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。