Home » RDBMS Server » Backup & Recovery » ORA-00312: online log 1 thread (oracle 9i, WIN XP)
ORA-00312: online log 1 thread [message #336428] Sat, 26 July 2008 13:34 Go to next message
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
Re: ORA-00312: online log 1 thread [message #336430 is a reply to message #336428] Sat, 26 July 2008 13:42 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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!
Re: ORA-00312: online log 1 thread [message #336431 is a reply to message #336428] Sat, 26 July 2008 13:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: ORA-00312: online log 1 thread [message #336433 is a reply to message #336428] Sat, 26 July 2008 14:05 Go to previous messageGo to next message
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
Re: ORA-00312: online log 1 thread [message #336434 is a reply to message #336433] Sat, 26 July 2008 14:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Post all the commands you executed.

I precise BEFORE, ALL what you did, you what you have, all what is missing, all what is different from what was when it worked.

Regards
Michel
Re: ORA-00312: online log 1 thread [message #337720 is a reply to message #336434] Thu, 31 July 2008 18:38 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
well you can see this Smile

http://www.orafaq.com/forum/t/51251/0/

Previous Topic: undo data file is lost
Next Topic: Logical backups
Goto Forum:
  


Current Time: Sun Dec 11 00:26:08 CST 2016

Total time taken to generate the page: 0.08877 seconds