OraFAQ Forum: Backup & Recovery » ORA-00312: online log 1 thread

Home » RDBMS Server » Backup & Recovery » ORA-00312: online log 1 thread (oracle 9i, WIN XP)

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

ORA-00312: online log 1 thread [message #336428]

Sat, 26 July 2008 13:34

sathireddy1001@gmail.com
Messages: 3
Registered: July 2008
Location: virginia

Junior Member

Hello,
when im dong the backup, i renamed a datafile ro recover the database after STARTUP.But, when i OPEN the DB, its showing an error:
ORA-16068: redo log file activation identifier mismatch
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO01.LOG
can anybody help me with the solution

Report message to a moderator

Re: ORA-00312: online log 1 thread [message #336430 is a reply to message #336428]

Sat, 26 July 2008 13:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above

It is not clear to this reader what you did.
It appears you made changes & now Oracle is not pleased with the current collections of files.

>i renamed a datafile
Which file did you rename & why did you do that?

>ro recover the database after STARTUP
What exactly does this mean & why did database need to be recovered?

I hope you have good backups for this database or that it did not contain data anyone cares about.

Good Luck!

Report message to a moderator

Re: ORA-00312: online log 1 thread [message #336431 is a reply to message #336428]

Sat, 26 July 2008 13:43

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Without knowing what you EXACTLY did and your database structure, we can't answer.

Post all the commands you executed.

Regards
Michel

Report message to a moderator

Re: ORA-00312: online log 1 thread [message #336433 is a reply to message #336428]

Sat, 26 July 2008 14:05

sathireddy1001@gmail.com
Messages: 3
Registered: July 2008
Location: virginia

Junior Member

Hello,
actually i was practicing the BACKUP nad RECOVERy process, and i'm doing the HOT BACKUp procedure, im successful in doing with DB ONLINE i,e Up and running and when i try doing the BacKUp in DB OFFLINE, i,e shutting DB DOWN by deleting a datafile XDB01.DBF from the PATH-'C:\oracle\oradata\orcl\XDB01.DBF'.

and when i tries to STARTUP, its showing an error:

SQL> startup;
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-16068: redo log file activation identifier mismatch
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO01.LOG'

how to recover from this error, please help me out

Report message to a moderator