>----- Original Message ----- >From: "=?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?=" ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Thu, 30 Jan 2003 19:38:45 > >Dear DBAs,=0D >=0D >My DB was down just now.=0D >after checking the trace file, it was an CKPT error >1242,=0D >using oerr will show:=0D >"Cause: The database is in NOARCHIVELOG mode and a >database file was=0D > detected as inaccessible due to media >failure."=0D > Action: Restore accessibility to the file >mentioned in the error stack=0D > and restart the instance."=0D >=0D >What's the error stack means in the "Action"?=0D >where can i find it?=0D >=0D >Thanks in advance.
Have you checked the trace file or the alert log ? The error stack is simply a list of functions calling each other and returning errors (f1 calls f2 calls f3 calls f4, f4 detects an error, prints a message, returns an error status to f3 which prints a message, returns an error status to f2, etc.... - 'de-stacking' errors, so to speak, hence the name). This kind of information should normally be found in the trace file generated by ckpt. Short of that, what you can do is use some kind of hex editor to look at the names of files in the control file (or use 'strings' under Unix) and check, one by one, that all the datafiles referenced in it are accessible and have the size you would expect. Simplest of all would probably be to try to restart your database, the error message should explictily name the file ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
