Re: upgrade and moving to another server in one stop
From: onedbguru <onedbguru_at_yahoo.com>
Date: Thu, 3 Feb 2011 16:47:31 -0800 (PST)
Message-ID: <284f287c-755c-4559-b4c3-3ec374cfab00_at_x1g2000yqb.googlegroups.com>
On Feb 3, 5:48 pm, charles <dshprope..._at_gmail.com> wrote:
> 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
Date: Thu, 3 Feb 2011 16:47:31 -0800 (PST)
Message-ID: <284f287c-755c-4559-b4c3-3ec374cfab00_at_x1g2000yqb.googlegroups.com>
On Feb 3, 5:48 pm, charles <dshprope..._at_gmail.com> wrote:
> 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
When asking a "what's wrong" question, it is customary to include error messages with EXACT commands issued. Without the error codes and state of your db, the answer to your problem is purple. Received on Thu Feb 03 2011 - 18:47:31 CST