OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-00305

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

ORA-00305 [message #255540]

Wed, 01 August 2007 02:56

nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam

Member

Hi all,
I have a problem with oracle database. This is log file:
Errors in file c:\oracle\product\10.2.0\admin\test\bdump\test_arc1_3404.trc:
ORA-00305: ログ3(スレッド1)が矛盾しています。別のデータベースに属しています。
ORA-00312: オンライン・ログ3 スレッド1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\test\REDO03.LOG'

I think, problem because i was deleted Redo01, redo02, redo03 log file and after I copy redo01, redo02, redo03 from a other database. Can I recreate these files for database test?
Thanks,
NghiaNT

[Updated on: Wed, 01 August 2007 02:57]

Report message to a moderator

Re: ORA-00305 [message #255543 is a reply to message #255540]

Wed, 01 August 2007 03:00

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try:
- shutdown abort;
- startup mount;
- alter database open resetlogs;

Regards
Michel

Report message to a moderator

Re: ORA-00305 [message #255549 is a reply to message #255540]

Wed, 01 August 2007 03:23

nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam

Member

Thanks for you reply,
I was test but when execute alter database open resetlogs, that return error code: ora-01139. After search on Net, I was only execute with alter database open.
Sad

. Result is not better, still error: ora-00305 and ora-00312.
Please continue help me.
Thanks
NghiaNT1.

Report message to a moderator

Re: ORA-00305 [message #255556 is a reply to message #255549]

Wed, 01 August 2007 03:37

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try:
- shutdown abort;
- startup mount;
- recover database until cancel
- cancel
- alter database open resetlogs;

Regards
Michel

Report message to a moderator

Re: ORA-00305 [message #255562 is a reply to message #255556]

Wed, 01 August 2007 04:01

nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam

Member

Hi my friend,
My database is ok. Comment for you - cancel. Have fun.
Arigato gozaimasu. Smile

NghiaNT.

Report message to a moderator

Re: ORA-00305 [message #256859 is a reply to message #255556]

Mon, 06 August 2007 23:04

nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam

Member

Hello,
In my computer have a problem when shutdown and restart computer. After I shutdown computer in normal, and reconnect database, but can not login. In this case, I using current solution, it can ok.
Can you tell me the way to fix error when shutdown database.
Thanks,
NghiaNT.

Report message to a moderator

Re: ORA-00305 [message #256872 is a reply to message #256859]

Mon, 06 August 2007 23:40

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

YOu should check and change startup type from MANUAL to AUTO in services.msc windows.

Note: check OracleService<sid> ---- type in services window

start ---> run ----> services.msc <<press enter>>

Regards
Taj

Report message to a moderator

Re: ORA-00305 [message #257113 is a reply to message #256872]

Tue, 07 August 2007 10:46

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

oradim -edit -sid MYDB -startmode auto

Report message to a moderator

Previous Topic:	ORA-04043: object RAY.MTE_LOG does not exist
Next Topic:	does not autostart oracle (you can get back to me next year, if you have time)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 09:37:52 CST 2024