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: [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).