Home » RDBMS Server » Backup & Recovery » problem in undo file
problem in undo file [message #162422] Fri, 10 March 2006 02:54 Go to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member

i couldn't open database. so i recreate control file . after recreating control file, i try to open database. but i got below error ..

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00314: log 1 of thread 1, expected sequence# doesn't match
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\TESTDB1\REDO01.LOG'




can anyone help me to solve this problem.
Re: problem in undo file [message #162430 is a reply to message #162422] Fri, 10 March 2006 03:32 Go to previous messageGo to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
i solved this problem..

SQL> recover database until cancel;
SQL> alter database open resetlogs;


after giving above two statements , i can open ths database.
icon14.gif  Re: problem in undo file [message #226918 is a reply to message #162422] Mon, 26 March 2007 23:13 Go to previous message
truefriendsravi
Messages: 1
Registered: March 2007
Junior Member
THANKS SO MUCH NOW i AM ABLE TO OPEN MY DB BECAUSE OF UR HELP Razz

Previous Topic: Error...........
Next Topic: Problem during export backup of a particular table
Goto Forum:
  


Current Time: Sat Dec 03 03:48:45 CST 2016

Total time taken to generate the page: 0.12089 seconds