RE: Error Stack
- 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).
Re: Error Stack
Hi, Restore the corrupted datafile from Backup and start the DB. Pls check the Alertsid.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=plusref=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).
Re: Error Stack
Dear all, Only CKPT: terminating instance due to error 1242 Instance terminated by CKPT, pid = 1507 in alert log - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 31, 2003 4:34 PM Hi, Restore the corrupted datafile from Backup and start the DB. Pls check the Alertsid.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=plusref=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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?utf-8?Q?shuan.tay\=28PCI=E9=84=AD=E7=A5=BA=E5=8B=9B\=29?= 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).
