('binary' encoding is not supported, stored as-is)
>----- Original Message -----
>From: "=?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?="
><shuan.tay_at_pci.co.id>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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: sfaroult_at_oriolecorp.com
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: 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 Jan 31 2003 - 02:43:59 CST
