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

Probably a long shot but I bumped into the exact same message before. In my case I use a different user ( instead of oracle ) to do the dbf file copying. I also have to re-copy all the dbf file again ( instead of just chown and chmod to the dbf ) before it all works fine again.

hth ..

"HARI OM" <hari_om_at_hotmail.com> wrote:

>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 Thu Mar 10 2005 - 18:00:07 CST