Monday, January 24, 2011

Hidden Parameters to Access Corrupt Oracle Databases

Is your Oracle database inaccessible due to corruption? Are you unable to open a corrupt database and extract information from it? You may face critical situations, if you are an Oracle data base administrator. Being a database administrator, it is a big responsibility on you to keep your database up to date and running. Database corruption leads to severe data loss and affects working of entire organization. In such critical situations, you must restore the data from current backup to fix the issue. But if backup is not available, Oracle database recovery becomes need of hour.

You must keep in mind that in case of emergency, you can open your corrupt database and access some data from it. It is possible using some special hidden parameters. This database corruption generally occurs due to database block corruption. Such hidden parameters enable you to easily ignore the damaged data blocks if the database is severely damaged. Some of the hidden parameters of the database are as given below:

_allow_resetlogs_corruption- This parameters is the only method to initialize 'db backed-up open without setting backup' on the tablespace. It makes your system unsupported.

_corrupted_rollback_segments- It is the only method to start up your database with damaged public rollback segments. You can use this undocumented parameter without concerning about invalidating support.

_allow_read_only_corruption- It enables the database to be accessed even if it is corrupt. You should use this option only while exporting as much information from your damaged Oracle database as possible before you re-create the database. You must not use the database in normal manner, which is opened in this manner.

_corrupt_blocks_on_stuck_recovery - You can use this database to start your damaged database. But, it is possibly not supported if you do it without blessing of Oracle. You should immediately expert database tables in such cases and rebuild it.

You should use the above hidden parameters to recover database only in case of emergency. The must be used by taking help from technical support of Oracle as improper use of these hidden parameters can cause further data loss.

In such cases, You need to repair Oracle database using third-party applications. They use most efficient scanning methods to ensure absolute recovery. Such database repair software are completely safe and easy to use.

Stellar Phoenix Oracle Recovery software repairs and restores damaged objects of Oracle database. The dbf recovery software supports recovery of tables, table spaces, views, schemas, roles, cluster tables, sequences, roles, indexes, and all other Oracle database objects. It salvages all the databases, created using Oracle 9i.

Source

No comments:

Post a Comment