Re: 9i to 10g migration

<bdbafh_at_gmail.com> wrote in message
news:1132608215.870440.229690_at_g49g2000cwa.googlegroups.com...
> Dave,
>
> Are you attempting an rman duplicate across oracle database server
> software versions?

Yep.

> That sounds like a very bad idea to me.

Im beginning to get that idea. (It seemed like a good idea at the time.)

> What Oracle homes are installed on the new host?

old: c:\oracle\ibase001\product\901
new: d:\oracle\product\10.2.0\db_1

> A cold backup set copied to the new host is the safe way to go.

I was hoping to avoid the additional downtime involved in a cold backup set.

> If any recovery is required on the new host running with the new
> ORACLE_HOME, you're likely to see substantial errors.

The duplicate seems to get past the recovery portion fine. It performs the restore, the recover, then a shutdown and restart, followed by a number of datafile name changes, and finally attempts alter database open resetlogs. Each as a seperate script. The failure is only for the last script.

>
> Are you performing a "startup upgrade" or "startup migrate"?

No. And I am suspecting that is my problem. But I am unsure how to insert that into the duplicate command, unless I manually create a the set of scripts that duplicate appears to create. Received on Mon Nov 21 2005 - 15:55:06 CST