OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01092 (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01092 (merged) [message #376203]

Tue, 16 December 2008 08:20

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,

Report message to a moderator

Re: ORA-01092 [message #376205 is a reply to message #376203]

Tue, 16 December 2008 08:23

joy_division
Messages: 4963
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.

Report message to a moderator

Re: ORA-01092 (merged) [message #376401 is a reply to message #376203]

Wed, 17 December 2008 04:00

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

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,

Report message to a moderator

Re: ORA-01092 (merged) [message #376505 is a reply to message #376203]

Wed, 17 December 2008 11:15

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

Report message to a moderator

Re: ORA-01092 (merged) [message #376507 is a reply to message #376412]

Wed, 17 December 2008 11:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>It works.
Yes. It will. You just loose whatever that was stored in that datafile.

Report message to a moderator

Re: ORA-01092 (merged) [message #377201 is a reply to message #376507]

Sun, 21 December 2008 11:31

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

Report message to a moderator

Previous Topic:	importing stats from 9i to 10g database
Next Topic:	Applying patchset 9.2.0.4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 06:15:57 CDT 2024