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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
