Home » RDBMS Server » Backup & Recovery » I major problem, ORA-00312 and ORA-16068
icon13.gif  I major problem, ORA-00312 and ORA-16068 [message #135566] Thu, 01 September 2005 04:42 Go to next message
IngRMP
Messages: 7
Registered: September 2005
Location: Spain
Junior Member
I have a major problem.

I have a datawarehouse database, and now it won't start
I get 2 ora-errors.

ORA-00312
and
ORA-16068

I do not have a valid backup.
I have some archive files, but my database are running in
archive mode.

Is there any way to get the database up and running again.

Thanks for all.

PLEASE HELP ME.
Re: I major problem, ORA-00312 and ORA-16068 [message #135571 is a reply to message #135566] Thu, 01 September 2005 05:04 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

ORA-00312: online log string thread string: 'string'
Cause: This message reports the file name for details of another message.
Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
(oracode.com)

ORA-16068: redo log file activation identifier mismatch
Cause: The activation identifier of the indicated redo log file does not match the activation identifier of the database.
(oracode.com)

Your logfile seems to be corrupted.
Have you tried "STARTUP NOMOUNT" then "RECOVER DATABASE"/ "ALTER DATABASE OPEN RESETLOGS".

Regds
Girish
Re: I major problem, ORA-00312 and ORA-16068 [message #135574 is a reply to message #135571] Thu, 01 September 2005 05:10 Go to previous messageGo to next message
IngRMP
Messages: 7
Registered: September 2005
Location: Spain
Junior Member
Thanks Girish

We resolved the problem using the next

1.- Startup Mount
2.- Recover Until Cancel
3.- Alter Database Open Reselogs

Now te database is running.

Thanks really

Smile
Re: I major problem, ORA-00312 and ORA-16068 [message #437823 is a reply to message #135566] Wed, 06 January 2010 02:56 Go to previous messageGo to next message
oracle.abhijeet
Messages: 1
Registered: December 2009
Location: mumbai
Junior Member

sql> startup mount

sql> recover database until cancle

sql> Alter Database Open Reselogs

then backup full database
Re: I major problem, ORA-00312 and ORA-16068 [message #437829 is a reply to message #437823] Wed, 06 January 2010 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you just register to repeat the previous answer 4 months later (with a typo in addition)?

Regards
Michel

[Updated on: Wed, 06 January 2010 03:10]

Report message to a moderator

Re: I major problem, ORA-00312 and ORA-16068 [message #483082 is a reply to message #135574] Thu, 18 November 2010 04:41 Go to previous messageGo to next message
satishpuglia
Messages: 2
Registered: November 2009
Location: delhi
Junior Member

thanks. i have faced same problem and solved by it.
Re: I major problem, ORA-00312 and ORA-16068 [message #535938 is a reply to message #135574] Sat, 17 December 2011 19:06 Go to previous message
jcho360
Messages: 1
Registered: December 2011
Location: miami
Junior Member
u save my life!!!.... if u were next to me I'll kiss u!!... thanks a lot!
Previous Topic: user managed recovery
Next Topic: backup level issue
Goto Forum:
  


Current Time: Thu Mar 28 08:38:20 CDT 2024