What should you do to troubleshoot Error ? 00353 to recover Oracle database

Oracle is one of the most sophisticated Relational Database Management System (RDBMS), which is totally platform independent. It is highly scalable, very secure, fast, and extremely reliable when it comes to dealing with OLTP (Online Transactions Processing) techniques and data warehouse applications thereby making Oracle a true enterprise solution. But as they say, nothing is perfect in this world. Similarly, the Oracle databases too can get corrupt that can make all the database operations come to a halt. These situations can arise due to various causes such as failure in the storage media, system corruption, etc. You should adopt various corrective methods to recover Oracle database. If the methods do not work, then you should use a third-party Oracle database recovery software to repair Oracle database.

Let us consider a scenario in which you have taken a cold backup of the Oracle database on which you are working and archived it. However, the database fails to open when you try to do so. The following error message is displayed in this regard:

“ORA-00353: log corruption near block string change string time string”

Cause:

Such problems can occur if the database has damaged or is corrupt. It can happen due to failure in the storage media.

Resolution:

In cases when the online redo logs are having such problems, then the databases should be opened with the ‘RESETLOGS’ option to recreate the online redo logs. Then, to resolve this peculiar problem by restoring the database, you should use the following steps:

Perform a normal shutdown using ‘SHUTDOWN NORMAL’.
Do a “STARTUP MOUNT” and “ALTER DATABASE OPEN RESETLOGS;”
Use ‘UNTIL CANCEL’ recovery type if prompted for database recovery.
Apply all available archive and online redo logs.
Issue ‘CANCEL’ and reissue ‘ALTER DATABASE OPEN RESETLOGS;’ command.
Perform a normal shutdown using ‘SHUTDOWN NORMAL’.
Remove the applied parameter.
Check the ALERT.LOG for errors after performing a database ‘STARTUP’.
Extract the data after rebuilding the complete database.

In case you are still not able to access the Oracle database, then you should use a third-party Oracle database recovery to recover Oracle database. These DBF recovery tools are read-only in nature that do not modify the existing database while performing the recovery.

The most trusted and recommended Oracle database recovery tool that repairs Oracle database created for Oracle 9i, 10g, 11g is Stellar Phoenix Oracle Database Recovery. Compatible with Windows Server 2003 and XP, this DBF recovery software recovers DBF files by recovering several database objects like tables, table space, views, triggers, index, roles, schemas, synonyms, sequence, etc.

Tanvi Sharma is a database recovery expert and doing research on oracle recovery software.

Leave a Reply

Your email address will not be published. Required fields are marked *

Protected with IP Blacklist CloudIP Blacklist Cloud