Re: Restore of 8.0.4 Backup to 8.1.7 Database?

Johannes Bavendiek wrote:

> I have to do a systemcopy from Prod-DB to Test-DB before migration.
> Prod is Oracle 8.0.4, Test is already Oracle 8.1.7.
> Can I restore the backup of a 8.0.4 Oracle Database to a 8.1.7 Server?
> If yes what are the steps to migrate the datafiles?
> The machines are IBM RS/6000 with AIX 4.3.3.
>
> cu
> Johannes Bavendiek

Johannes,

You can not restore backup from one Oracle version to different one.

1. Use full consistent database export initiated from 8.1.7 servers againts 8.0.4 database.
2. Then import the export into 8.1.7 db
3. Open the database in restricted session mode and run $ORACLE_HOME/rdbms/admin/u0800040.sql to upgrade the data dictionary.

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

www.dbaclick.com Received on Fri Sep 28 2001 - 18:18:39 CDT