Home » RDBMS Server » Backup & Recovery » ORA-01135 and ORA-01110 (Oracle 11.2.0.1.0 with two node RAC using ASM on SOLARIS 10 Platform)
ORA-01135 and ORA-01110 [message #560453] Fri, 13 July 2012 01:25 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
i have noticed the following error in my alert log
Quote:
ORA-01135: File 156 accessed from DML/query is offline
and when i check the data file so it is in recovery mode, now how can i recover it without taking downtime,

please Guide

Regards
Re: ORA-01135 and ORA-01110 [message #560456 is a reply to message #560453] Fri, 13 July 2012 01:29 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
recover datafile 156;
Re: ORA-01135 and ORA-01110 [message #560607 is a reply to message #560456] Sun, 15 July 2012 23:53 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi john,
well we have a problem as the error appeared in alert log on 13 Jun 2012 and it has been reported now and from 13 jun till now NO Physical backup are taken which is a mess, but the logical backup are ok. we have created tablespaces quaterly i.e (Jan to Marc) is M12 and so on, so we have datafile offline at J12 (Apr-Jun) tablespace and after working out it reveals that this datfile size is 2 gb and it was created on 13 jun and got corrupted on the same date, so may be it dont have data but we need to recover it so how can i recover this file and why the export of this quarter is successful as there is one datafile offline of J12 tablespace.

Kindly guide



Regards
Re: ORA-01135 and ORA-01110 [message #560619 is a reply to message #560607] Mon, 16 July 2012 01:54 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Presumably you are in archivelog mode? Then no problem:

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#i1006226

restore and recover when no backup is available is a standard exercise in any decent Oracle admin class.
Re: ORA-01135 and ORA-01110 [message #560641 is a reply to message #560619] Mon, 16 July 2012 03:14 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
No, We don;t have any archive log before file corruption, and if a datafile is corrupt so its logical backup of that tablespace should fail, but here the logical backup is successful, what you say about this


Regards
Re: ORA-01135 and ORA-01110 [message #560645 is a reply to message #560641] Mon, 16 July 2012 03:20 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
a datafile is corrupt so its logical backup of that tablespace should fail,
Why should it fail? Think about what it is doing, and all will become clear.

The real question is why you are not running in archivelog mode. If the database is considered important enough to need RAC, then it is surprising that you are happy to lose all the data entered between backups.
Re: ORA-01135 and ORA-01110 [message #560665 is a reply to message #560645] Mon, 16 July 2012 05:03 Go to previous messageGo to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
off course the database is in archive log mode but what happend that we have scheduled which backup the archive log and that is not happend and when the +FG1 fills so that has been deleted and i know its crime done by that dba but now we have sit, so what i ma trying to ask is that is there any way to have my data back being in this scenario


Regards
Re: ORA-01135 and ORA-01110 [message #560667 is a reply to message #560665] Mon, 16 July 2012 05:15 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I see.
Well, there is no way to recover that datafile. You only option is to drop the tablespace, including contents and datafiles. You say the logical backup went through OK, so presumably the file went bad before it had been used. In that case you should be able to create a new tablespace and import the logical backup.
You were lucky! But not as lucky as your DBA is, to still have a job.
Re: ORA-01135 and ORA-01110 [message #560958 is a reply to message #560453] Wed, 18 July 2012 00:26 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
thank you john, as i go through the alert log so i found that data file was created and then it straight away off line so no data in it and then i simply drop the file , so things are fine now,


thank You for your time


Regards
Previous Topic: RMAN-06403
Next Topic: Recovery Terminate due to log corruption.
Goto Forum:
  


Current Time: Thu Mar 28 16:28:39 CDT 2024