Oracle-L: Re: Error Stack

From: shuan.tay\(PCIé„ç¥ºå‹›\) <shuan.tay_at_pci.co.id>
Date: Fri, 31 Jan 2003 02:14:23 -0800
Message-ID: <F001.005402F3.20030131021423@fatcity.com>

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" <ORACLE-L_at_fatcity.com> Sent: Friday, January 31, 2003 4:34 PM

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

-- 
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: shuan.tay_at_pci.co.id

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 - 04:14:23 CST