Hi,
Restore the corrupted datafile from Backup and start the DB. Pls check the Alert<sid>.log for more info.
Venkat
--
On Thu, 30 Jan 2003 19:38:46
shuan.tay(PCI¾G¸R³Ô) wrote:
>Dear DBAs,
>
>My DB was down just now.
>after checking the trace file, it was an CKPT error 1242,
>using oerr will show:
>"Cause: The database is in NOARCHIVELOG mode and a database file was
> detected as inaccessible due to media failure."
> Action: Restore accessibility to the file mentioned in the error stack
> and restart the instance."
>
>What's the error stack means in the "Action"?
>where can i find it?
>
>Thanks in advance.
_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: C.S.Venkata Subramanian
INET: csvenkata_at_lycos.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 - 03:34:38 CST
