From oracle-l-bounce@freelists.org Mon Aug 16 13:46:00 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i7GIjwN00348 for ; Mon, 16 Aug 2004 13:45:59 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i7GIjwI00341 for ; Mon, 16 Aug 2004 13:45:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C464E72C7BA; Mon, 16 Aug 2004 13:50:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16984-67; Mon, 16 Aug 2004 13:50:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 18D6D72C5C3; Mon, 16 Aug 2004 13:50:55 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 16 Aug 2004 13:49:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1EF7C72C069 for ; Mon, 16 Aug 2004 13:49:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16668-57 for ; Mon, 16 Aug 2004 13:49:20 -0500 (EST) Received: from imcsvr-2.aetvn.com (imcsvr-2.aetvn.com [216.89.67.159]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CAB3E72C065 for ; Mon, 16 Aug 2004 13:49:19 -0500 (EST) Received: by imcsvr-2.aetvn.com with Internet Mail Service (5.5.2653.19) id ; Mon, 16 Aug 2004 14:49:51 -0400 Message-ID: <30462D80AA52E74698512ADCC4F7EAA31223965F@exchange.aetvn.com> From: "Gogala, Mladen" To: "'oracle-l@freelists.org'" Subject: RE: ora 1115 error Date: Mon, 16 Aug 2004 14:49:49 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 7670 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mladen.Gogala@aetn.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Restore the datafile from backup, restore all archive logs from the last backup on, mount the database and then just do it! RECOVER DATAFILE '/u11/oradata/htmp88/amapp.dbf' AUTO FROM ''; or RECOVER DATAFILE '/u11/oradata/htmp88/amapp.dbf' UNTIL CANCEL; Don't forget to apply the online redo log, too. -- Mladen Gogala Oracle DBA email:mladeng@aetvn.com Ext: 9787 > -----Original Message----- > From: DGoodson@SolanoCounty.com [mailto:DGoodson@SolanoCounty.com] > Sent: Monday, August 16, 2004 2:38 PM > To: oracle-l@freelists.org > Subject: ora 1115 error > > > Hi List, > > When I startup database, I am getting the following error: > > ORA-01110: data file 4: '/u11/oradata/htmp88/amapp.dbf' > ORA-01115: IO error reading block from file 4 (block # 1) > ORA-27063: skgfospo: number of bytes read/written is > incorrect IBM AIX RISC System/6000 Error: 5: I/O error > Additional information: -1 Additional information: 8192 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------