Home » RDBMS Server » Server Administration » ORA-01092 (merged)
ORA-01092 (merged) [message #376203] Tue, 16 December 2008 08:20 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
During startup it give the error like,

SQL> startup
ORACLE instance started.

Total System Global Area 1090519040 bytes
Fixed Size                  1218920 bytes
Variable Size             134219416 bytes
Database Buffers          939524096 bytes
Redo Buffers               15556608 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

Alert log message
Tue Dec 16 16:13:00 2008
Errors in file /home/oracle/product/admin/ora01/bdump/ora01_smon_8734.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 39 cannot be read at this time
ORA-01110: data file 39: '/u06/oracle/oradata/ora01/UNDOTBS/undotbs_11.dbf



I tried to start in every way but was not got the success.
How can i resolve it?
Thanks,
Re: ORA-01092 [message #376205 is a reply to message #376203] Tue, 16 December 2008 08:23 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
And did you check the information in the error messages? You show errors but you don't seem to take the next step.

From the error messages, there are two things I would immediately check. Let's see if you can figure them out.
Re: ORA-01092 (merged) [message #376401 is a reply to message #376203] Wed, 17 December 2008 04:00 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I come to solve untill the last error.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01190: control file or data file 22 is from before the last RESETLOGS
ORA-01110: data file 22: '/u04/oracle/oradata/ora01/INDX/INDX_01.dbf'



Solution Action :restore the file from most recent backup


But the thing is i dont hwve backup with me.
And archive logs are not available Sad
What would be another solution?

Thanks,

[Updated on: Wed, 17 December 2008 04:01]

Report message to a moderator

Re: ORA-01092 (merged) [message #376412 is a reply to message #376203] Wed, 17 December 2008 04:28 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I got the solution.

SQL> alter database datafile 22 offline;

SQL> alter database open;


It works.

Thanks,

Re: ORA-01092 (merged) [message #376505 is a reply to message #376203] Wed, 17 December 2008 11:15 Go to previous messageGo to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Hi,

I think it would produce various errors in alert log, though the database will continue to run.

Please let me know the post effect of the same.

Regards,
Sam G
Re: ORA-01092 (merged) [message #376507 is a reply to message #376412] Wed, 17 December 2008 11:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>It works.
Yes. It will. You just loose whatever that was stored in that datafile.
Re: ORA-01092 (merged) [message #377201 is a reply to message #376507] Sun, 21 December 2008 11:31 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

@OP,
Means that is not a solution except an alternative for the error. Smile
Previous Topic: importing stats from 9i to 10g database
Next Topic: Applying patchset 9.2.0.4
Goto Forum:
  


Current Time: Mon Dec 05 23:48:11 CST 2016

Total time taken to generate the page: 0.06336 seconds