upgrade and moving to another server in one stop

From: charles <dshproperty_at_gmail.com>
Date: Thu, 3 Feb 2011 14:48:57 -0800 (PST)
Message-ID: <f5a28f9d-e36f-4711-b8fc-3396d6e41992_at_a28g2000prb.googlegroups.com>



Dear group,

We are moving our Oracle database on redhat 4 10.2.0.4 to redhat 5 and upgrade it to 10.2.0.5

so, on server A(redhat 4), i took a hot backup using RMAN, 10.2.0.4

on server B, (redhat 5), i installed 10.2.0.5, i can restore and recover the database without problem. But i cannot start the database. I tried

alter database open resetlogs;
alter database open upgrade resetlogs;
alter database open upgrade;

None of them seems working. Could somebody help me out?

Thanks very much for your help Received on Thu Feb 03 2011 - 16:48:57 CST

Original text of this message