Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving Instance from One Server to Another (ERROR: ORA-01031)

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

From: <bdbafh_at_gmail.com>
Date: 1 Mar 2005 18:26:53 -0800
Message-ID: <1109730413.257541.203420@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US