OraFAQ Forum: Backup & Recovery » problem in undo file

Home » RDBMS Server » Backup & Recovery » problem in undo file

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

problem in undo file [message #162422]

Fri, 10 March 2006 02:54

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.

Report message to a moderator

Re: problem in undo file [message #162430 is a reply to message #162422]

Fri, 10 March 2006 03:32

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.

Report message to a moderator

Re: problem in undo file [message #226918 is a reply to message #162422]

Mon, 26 March 2007 23:13

truefriendsravi
Messages: 1
Registered: March 2007

Junior Member

THANKS SO MUCH NOW i AM ABLE TO OPEN MY DB BECAUSE OF UR HELP Razz

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 13:48:00 CST 2024