cancel
Showing results for 
Search instead for 
Did you mean: 

Restoring oracle 9i to another server which has oracle 10g

WikiDonor
Level 6

Hello

 

We are using BE2012 and we are backing up oracle 9i on linux5.4. Just wanted to check if we can restore this data to another linux server which has newly installed oracle 10g on linux5.4.

 

If I get a technical article that will be helpful to show this to our management.

1 ACCEPTED SOLUTION

Accepted Solutions

VJware
Level 6
Employee Accredited Certified

Nopes, not possible unless you restore to existing 9i and then export to 10g.

Alternatively, you can restore 9i database to 10g host and then you'll have to upgrade the database.

Either ways, there isn't a simple in-place restore.

Oracle has an official doc for this with ID 369644.1

 

 

 

View solution in original post

3 REPLIES 3

pkh
Moderator
Moderator
   VIP    Certified

BE uses RMAN to backup and restore Oracle databases.  I think you should check with Oracle whether you can restore 9i data to 10g.  If Oracle says no, then that's it.

VJware
Level 6
Employee Accredited Certified

Nopes, not possible unless you restore to existing 9i and then export to 10g.

Alternatively, you can restore 9i database to 10g host and then you'll have to upgrade the database.

Either ways, there isn't a simple in-place restore.

Oracle has an official doc for this with ID 369644.1

 

 

 

WikiDonor
Level 6

Thank you