Re: Moving Instance from One Server to Another (ERROR: ORA-01031)

From: HARI OM <hari_om_at_hotmail.com>
Date: 1 Mar 2005 17:54:20 -0800
Message-ID: <1109728460.548082.7020@f14g2000cwb.googlegroups.com>

THANKS Rauf again...
I managed to pass this step.... but not far enough and I get ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> startup;
ORACLE instance started.

Total System Global Area 404193456 bytes

Fixed Size                   741552 bytes
Variable Size             369098752 bytes
Database Buffers           33554432 bytes
Redo Buffers                 798720 bytes

Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

I then tried running "Alter database open RESET LOGS" but then get : ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/dict/saturn/system01.dbf'

I then try:
SQL> recover database until cancel using backup controlfile; ORA-00279: change 73411563 generated at 02/24/2005 06:31:18 needed for thread 1
ORA-00289: suggestion : /usr/local/oracle/OraHome1/dbs/arch1_312.dbf ORA-00280: change 73411563 for thread 1 is in sequence #312

Any Hints? Received on Tue Mar 01 2005 - 19:54:20 CST