Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: What does _allow_read_only_corruption do?

RE: What does _allow_read_only_corruption do?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 06 Apr 2001 06:41:57 -0700
Message-ID: <F001.002E3ECB.20010406063053@fatcity.com>

Hi Tom,

If you have a media failure and for some reason (such as having lost an archived log file) you cannot perform a complete recovery on some datafiles, then you might need this parameter. It is new for 8i. Previously there was only '_allow_resetlogs_corruption' which allowed you to do a RESETLOGS open of the database in such situations. Of course, a database forced open in this way would be in a crazy state because the current SCN would reflect the extent of the incomplete recovery, but some datafiles would have blocks in the future, which would lead to lots of nasty ORA-00600 errors (although there is an ADJUST_SCN event that could be used for relief). Once in this position, the only thing to do would be to do a full database export, rebuild the database, import and then assess the damage.

The new '_allow_read_only_corruption' provides a much cleaner solution to the same problem. You should only use it if all other recovery options have been exhausted, and you cannot open the database read/write. Once again, the intent is to export, rebuild and import. Not pleasant, but sometimes better than going back to an older usable backup and performing incomplete recovery to a consistent state. Also, the read only open allows you to assess better which recovery option you want to take without committing you to either.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
Sent: Friday, 6 April 2001 8:32
To: Multiple recipients of list ORACLE-L

Yes,

I know it's a hidden parameter that should only be used at the advice of counsel and Oracle Support.

But has anyone used it?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tom Pall (E-mail)
  INET: tom_at_cdproc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 06 2001 - 08:41:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US