Re: Disable rollbacks

Robert A Peters <peters_at_io.cpg.cdc.com> wrote:
>Roderick Manalac (rmanalac_at_oracle.com) wrote:
>:
>: Please be very very careful in using undocumented parameters.
>: There probably should at least be some sort of implied disclaimer
>: that DBA's are at their own risk when playing around with an
>: undocumented feature.
>
>I would like to support what Roderick says. Using undocumented
>features is fine for testing but will kill you in production.

While I fully agree with the above and the conclutions drawn, It should be noted that use_async_io is not documented under AIX 7.0.16 but is recommened for use by the port manager.

Further, the _corrupted_rollback_segments option has been the difference for me in salvaging or not salvaging a DB.

And their aren't many of use who dont have little piece of paper with all the events that they have set in the past.

Therefor, all undocumented parameters are not created equal and _allow_resetlogs_corruption does NOT = _db_block_compute_checksums

I think better advice would be: Use the brain you were born with. Be very careful. And don't whine to us or Oracle when you toast your database.

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com