{"id":6157,"date":"2021-08-11T23:07:45","date_gmt":"2021-08-11T23:07:45","guid":{"rendered":"https:\/\/swiv.com.br\/solved-issue-ora-00349-during-incomplete-recovery\/"},"modified":"2026-05-27T20:02:30","modified_gmt":"2026-05-27T19:02:30","slug":"solved-issue-ora-00349-during-incomplete-recovery","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/08\/11\/solved-issue-ora-00349-during-incomplete-recovery\/","title":{"rendered":"[Solved] Issue: ORA-00349 During Incomplete Recovery"},"content":{"rendered":"\n

Estava realizando um Database Point-in-Time Recovery, e no momento de abrir o banco, me deparei com o seguinte erro:<\/p>\n\n\n

\n[oracle@cortex cortex]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 11 18:08:36 2021\n \nCopyright (c) 1982, 2010, Oracle.  All Rights Reserved.\n \n  \nConnected to:\nOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\n \nSQL> SELECT INSTANCE_NAME,STATUS FROM V$INSTANCE;\n \nINSTANCE_NAME    STATUS\n \n---------------- ------------\n \nASWAN            MOUNTED\n \nSQL> ALTER DATABASE OPEN RESETLOGS;\nALTER DATABASE OPEN RESETLOGS\n*\nERROR at line 1:\nORA-00349: failure obtaining block size for '+DG_DATA'\n<\/pre><\/div>\n\n
Na nota “‘ORA-00349: failure obtaining block size’ On ‘open resetlogs’ During Incomplete Recovery (Doc ID 356191.1)<\/strong>” (link AQUI<\/a>), vi que uma das solu\u00e7\u00f5es proposta \u00e9:<\/p>\n\n\n
\"\"<\/figure>\n\n\n\n
Desse modo, coleto a condi\u00e7\u00e3o atual dos meus online redo logs:<\/p>\n\n\n
\nSQL> l\n  1* SELECT GROUP#,MEMBER FROM V$LOGFILE\nSQL> col MEMBER format a50\nSQL> \/\n \n    GROUP# MEMBER\n     \n---------- --------------------------------------------------\n \n         4 +DG_DATA\/onlinelog\/group_4.350.846063515\n         8 +DG_DATA\/onlinelog\/group_8.356.846063929\n         6 +DG_DATA\/onlinelog\/group_6.352.846063857\n         7 +DG_DATA\/onlinelog\/group_7.353.846063879\n         1 +DG_DATA\/onlinelog\/group_1.349.846063485\n         2 +DG_DATA\/onlinelog\/group_2.354.846063589\n         5 +DG_DATA\/onlinelog\/group_5.351.846063517\n         3 +DG_DATA\/onlinelog\/group_3.355.846063593\n         9 +DG_DATA\/onlinelog\/group_9.357.846063955\n        10 +DG_DATA\/onlinelog\/group_10.358.846063959\n        11 +DG_DATA\/onlinelog\/group_11.359.846083125\n \n    GROUP# MEMBER\n \n---------- --------------------------------------------------\n \n        12 +DG_DATA\/oxip\/onlinelog\/group_12.360.846083129\n        13 +DG_DATA\/oxip\/onlinelog\/group_13.361.846083147\n        14 +DG_DATA\/oxip\/onlinelog\/group_14.362.846083151\n        15 +DG_DATA\/oxip\/onlinelog\/group_15.364.846083493\n        16 +DG_DATA\/oxip\/onlinelog\/group_16.363.846083497\n        17 +DG_DATA\/oxip\/onlinelog\/group_17.365.846083499\n        18 +DG_DATA\/oxip\/onlinelog\/group_18.366.846083503\n \n18 rows selected.\n<\/pre><\/div>\n\n\n
Realizando a altera\u00e7\u00e3o da localiza\u00e7\u00e3o dos Online Redo Logs:<\/p>\n\n\n
\nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_4.350.846063515' to '\/oracle\/redo\/redo_846063515';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_8.356.846063929' to '\/oracle\/redo\/redo_846063929';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_6.352.846063857' to '\/oracle\/redo\/redo_846063857';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_7.353.846063879' to '\/oracle\/redo\/redo_846063879';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_1.349.846063485' to '\/oracle\/redo\/redo_846063485';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_2.354.846063589' to '\/oracle\/redo\/redo_846063589';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_5.351.846063517' to '\/oracle\/redo\/redo_846063517';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_3.355.846063593' to '\/oracle\/redo\/redo_846063593';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_9.357.846063955' to '\/oracle\/redo\/redo_846063955';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_10.358.846063959' to 'oracle\/redo\/redo_846063959';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_11.359.846083125' to 'oracle\/redo\/redo_846083125';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_12.360.846083129' to 'oracle\/redo\/redo_846083129';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_13.361.846083147' to 'oracle\/redo\/redo_846083147';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_14.362.846083151' to 'oracle\/redo\/redo_846083151';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_15.364.846083493' to 'oracle\/redo\/redo_846083493';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_16.363.846083497' to 'oracle\/redo\/redo_846083497';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_17.365.846083499' to 'oracle\/redo\/redo_846083499';\n \nDatabase altered.\n \nSQL> alter database rename file '+DG_DATA\/onlinelog\/group_18.366.846083503' to 'oracle\/redo\/redo_846083503';\n \nDatabase altered.\n<\/pre><\/div>\n\n\n
Ap\u00f3s isso, consigo abrir o banco de dados conforme abaixo:<\/p>\n\n\n
\nSQL> ALTER DATABASE OPEN RESETLOGS;\n \nDatabase altered.\n \nSQL> SELECT NAME,OPEN_MODE FROM V$DATABASE;\n \nNAME      OPEN_MODE\n--------- ----------\nASWAN      READ WRITE\n \nSQL> ALTER SYSTEM CHECKPOINT;\n \nSystem altered.\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Estava realizando um Database Point-in-Time Recovery, e no momento de abrir o banco, me deparei com o seguinte erro: Na nota “‘ORA-00349: failure obtaining block size’ On ‘open resetlogs’ During Incomplete Recovery (Doc ID 356191.1)” (link AQUI), vi que uma das solu\u00e7\u00f5es proposta \u00e9: Desse modo, coleto a condi\u00e7\u00e3o atual dos meus online redo logs: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[],"class_list":["post-6157","post","type-post","status-publish","format-standard","hentry","category-administration","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=6157"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6157\/revisions"}],"predecessor-version":[{"id":9063,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6157\/revisions\/9063"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=6157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=6157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=6157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}