Re: ORA-01589:must use RESETLOGS or NORESETLOGS , 01194, 01110

THANKS everyone for the input.

It is working now... this is what I did:

After getting above ERRORS, I opened the ALERT File of my Soucrce Machine and found out which of the REDO File was being used (Example in my case it weas redo01.log) I htne executed following commands:

SQL> Recover database using backup controlfile;

file:/u/redo/1/sid/redo01.log

Log Applied. Media Recovery Complete.

SQL> Alter database open resetlogs.
Database Altered.

Thanks again! Received on Mon Mar 07 2005 - 16:51:30 CST