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

Home -> Community -> Usenet -> c.d.o.server -> Re: Control File Sequential Read - top wait

Re: Control File Sequential Read - top wait

From: omlet <notrolls_at_notrolls.omlet.org.notrolls>
Date: Mon, 26 Jul 2004 02:47:16 -0400
Message-ID: <3ebb89b686d410935a53fa8237a1c99e@localhost.talkaboutdatabases.com>


Ok Mr. crab! Back to your crappy advice about MR enqueues and locks. The mere existence of un-released MR lock would require a huge amount work from a PRODUCTION dba. SOMETHING YOU NEVER UNDERSTOOD and YOU WOULD NEVER UNDERSTAND! of course you can crash another stock market if we let you learn from your mistakes.

When a file in MR it is FUZZY! (similar to your azz status quo). Fuziness are recognized by markers that determine the point that recovery has applied redo.

If it dies the extent of fuzziness can not be determined; but it does not extend beyond any of the files were fuzzy.

Of course your database is not consistent!?! NOW TELL ME HOW COULD THIS BE NORMAL OPERATION? HOW CAN IGNORE SUCH A PROBLEM? DO YOU GO HOME; GET ASS FUCKED and assume every thing is OK? two months later, the database crash because of some timeout on some control file and you would not be able to recover your database; because your backups are not VALID.

try to pull your data from your indexes and your whole operation is busted; along with it the funds heavily invested in your customers; and then NASDAQ!

Now have a clue then a grip; never write a SPAM (unwanted mail) and intrude on others privacy.

The correct course of action is to check the 6 bits that determine the fuzziness of files: (KCVFHHBP, KCVFHHBM, KCVFHOFZ, KCVFHCRM, KCVFHMFZ, KCVFHCMF). The solution would be based on the arguments of kcvsmr: the first being fnos, the second being backup, the third being cancel.

If the fnos argument is null means all online files should be recovered.

The backup argument indicates that the next open must be a resetlogs open

...................etc
 

the meaning of those are really not meant for 2nd grade tulsa wacos with tonka trucks; but not completing media recovery of control files are a sure way to a cold hell! and YOU HAVE BEEN IN ONE!

Firing your azz probably originated from the Oracle Support analysts who you are repeatedly piss on; on every occasion! you self proclaimed experts who KNOW NOTHING literally other than hogwash.

YOU should be responsible for your actions.

Disclaimer: All refs included in this post are fictional and are not related to any existing product released or planned. Received on Mon Jul 26 2004 - 01:47:16 CDT

Original text of this message

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