| ORA-01135 and ORA-01110 [message #560453] |
Fri, 13 July 2012 01:25  |
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 #560607 is a reply to message #560456] |
Sun, 15 July 2012 23:53  |
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 #560641 is a reply to message #560619] |
Mon, 16 July 2012 03:14 |
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 |
John Watson
Messages: 8962
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 |
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 |
John Watson
Messages: 8962
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
