Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving Instance from One Server to Another (ERROR: ORA-01031)
2nd posting of this, right?
you were attemping
SQL> alter database open noresetlogs;
which complained that file#1 needs more recovery.
in which case its likely that the shutdown was unclean prior to the
cold backup.
more than likely, applying the current online redo log will give it
what it is asking for.
you can find the current redo log from the alert log on the original
server.
-bdbafh Received on Tue Mar 01 2005 - 20:26:53 CST
![]() |
![]() |