Home » RDBMS Server » Server Administration » ORA-00305
ORA-00305 [message #255540] Wed, 01 August 2007 02:56 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try:
- shutdown abort;
- startup mount;
- alter database open resetlogs;

Regards
Michel

Re: ORA-00305 [message #255549 is a reply to message #255540] Wed, 01 August 2007 03:23 Go to previous messageGo to next message
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.
Re: ORA-00305 [message #255556 is a reply to message #255549] Wed, 01 August 2007 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try:
- shutdown abort;
- startup mount;
- recover database until cancel
- cancel
- alter database open resetlogs;

Regards
Michel
Re: ORA-00305 [message #255562 is a reply to message #255556] Wed, 01 August 2007 04:01 Go to previous messageGo to next message
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.
Re: ORA-00305 [message #256859 is a reply to message #255556] Mon, 06 August 2007 23:04 Go to previous messageGo to next message
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.
Re: ORA-00305 [message #256872 is a reply to message #256859] Mon, 06 August 2007 23:40 Go to previous messageGo to next message
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
Re: ORA-00305 [message #257113 is a reply to message #256872] Tue, 07 August 2007 10:46 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
oradim -edit -sid MYDB -startmode auto
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:
  


Current Time: Fri Dec 09 13:47:46 CST 2016

Total time taken to generate the page: 0.13244 seconds