Meaning of undocumented parameters in oracle

Meaning of Undocumented parameters in Oracle

These parameters allow you to ignore corrupt data blocks when your database is corrupted. These should only be used in emergencies.

_allow_resetlogs_corruption – This parameter may be the only way to start a db backed-up open without setting backup on tablespace, it will result in an unsupported system.
_corrupted_rollback_segments – The only way to start up with corrupted public rollback segments. This undocumented parameter can be used without fear of invalidating support.
_allow_read_only_corruption – This parameter allows the database to be opened even if it has corruption. This should only be used to export as much data from a corrupted database as is possible before re-creating a database. A database that has been opened in this manner should not be used in a normal manner, as it will not be supported.
_corrupt_blocks_on_stuck_recovery – This parameter can sometimes be useful for getting a corrupted database started. However, it probably won’t be supported if done without Oracle’s blessing. Immediately export the tables needed and rebuild the database if used.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.