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

From: HARI OM <hari_om_at_hotmail.com>
Date: 1 Mar 2005 18:03:06 -0800
Message-ID: <1109728986.865777.255840@o13g2000cwo.googlegroups.com>

I am using IBM AIX 5.1L and ORACLE 9.2.0.2

I moved the database from one machine to another machine using COLD BACKUP...i.e "alter database backup controlfile..." and then moved the files from one server to another etc etc... BUT when I start my database I get following :

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 Received on Tue Mar 01 2005 - 20:03:06 CST