Home » RDBMS Server » Backup & Recovery » Backup in 9i Restore in 10g.
Backup in 9i Restore in 10g. [message #181599] Mon, 10 July 2006 14:50 Go to next message
NYCSTEVE
Messages: 3
Registered: July 2006
Junior Member

Hi,

I am new to this forum. I am in the process of migrating to Oracle 10g database. I overheard that one can backup their database in 9i and recover in 10g as a method for migration.

Is this true? If it is, are there any special procedures?

Thanks in advance for your answers.

Steve
Re: Backup in 9i Restore in 10g. [message #181609 is a reply to message #181599] Mon, 10 July 2006 16:14 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export data using the Oracle 9 EXPORT utility.
Import data using the Oracle 10 IMPORT utility.
Re: Backup in 9i Restore in 10g. [message #181780 is a reply to message #181599] Tue, 11 July 2006 08:38 Go to previous messageGo to next message
NYCSTEVE
Messages: 3
Registered: July 2006
Junior Member

Littlefoot,

I am backing up with RMAN on 9i. If I encounter a problem, can I recover (from RMAN backup) onto 10g datatbase platform?

Thanks in advance for your advice.

Steve
Re: Backup in 9i Restore in 10g. [message #181833 is a reply to message #181780] Tue, 11 July 2006 15:35 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, but I don't know that ...
Re: Backup in 9i Restore in 10g. [message #181962 is a reply to message #181833] Wed, 12 July 2006 06:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not possible.
You cannot use 9i backupset against a 10g binaries.
Re: Backup in 9i Restore in 10g. [message #182191 is a reply to message #181599] Thu, 13 July 2006 09:03 Go to previous message
NYCSTEVE
Messages: 3
Registered: July 2006
Junior Member

I figured so but just wanted to confirm. Thanks Mahesh.
Previous Topic: ORA-12535: TNS:operation timed out
Next Topic: 1 year backups
Goto Forum:
  


Current Time: Fri Mar 29 07:11:57 CDT 2024