Re: Database error and couldn't be opened

From: Mostafa Eletriby <m_etrib_at_yahoo.com>
Date: Sun, 28 Dec 2014 07:35:40 +0000
Message-ID: <949300673.1905034.1419752139527.JavaMail.yahoo_at_jws10629.mail.bf1.yahoo.com>

Database is in mount point.Also I checked the disk but no corruption at file system.Unfortunately , there is no backup to restore.Is there any solution even to exclude this data file from database and open database. Regards,

     On Sunday, December 28, 2014 9:24 AM, Kenneth Naim <kennethnaim_at_gmail.com> wrote:    

 #yiv0345061510 #yiv0345061510 -- _filtered #yiv0345061510 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv0345061510 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv0345061510 {panose-1:2 5 6 4 5 5 5 2 2 4;}#yiv0345061510 #yiv0345061510 p.yiv0345061510MsoNormal, #yiv0345061510 li.yiv0345061510MsoNormal, #yiv0345061510 div.yiv0345061510MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0345061510 a:link, #yiv0345061510 span.yiv0345061510MsoHyperlink {color:blue;text-decoration:underline;}#yiv0345061510 a:visited, #yiv0345061510 span.yiv0345061510MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv0345061510 span.yiv0345061510EmailStyle17 {color:#1F497D;}#yiv0345061510 .yiv0345061510MsoChpDefault {font-size:10.0pt;} _filtered #yiv0345061510 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv0345061510 div.yiv0345061510WordSection1 {}#yiv0345061510 Check to see if the mount point it up and available first. If so shutdown the instance and copy the files to you can always restart the recovery. If it is not up fix the mount point issue then copy the files. Finally try a recover database and hope there is enough data in redo logs to have a successful recovery. If the database opens shut it down immediately and perform a backup and put it into archive log mode for the future.  Ken  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mostafa Eletriby (Redacted sender "m_etrib_at_yahoo.com" for DMARC) Sent: Sunday, December 28, 2014 2:14 AM
To: Oracle-l Digest Users

Subject: Database error and couldn't be opened  Hello DBAs,Please I need top resolve these errors at database as database is mounted but couldn't be open.There is no backup and database is in noarchivelog mode.Database version:- standard edition.O.s:- linux redhat v5  Please check.Thanks  SQL> select status from v$instance;  STATUS------------------------------------MOUNTED  SQL>SQL> alter database open;alter database open*ERROR at line 1:ORA-01115: IO error reading block from file 7 (block # 44988)ORA-01110: data file 7: '/oraData/cdsdbdata/ENRPGEST.dbf'ORA-27072: File I/O errorLinux-x86_64 Error: 5: Input/output errorAdditional information: 4Additional information: 44988Additional information: -1    SQL>    

   

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Dec 28 2014 - 08:35:40 CET