Home » RDBMS Server » Backup & Recovery » Restore Database Using RMAN on Different OS Version (9i,10g,W2K3)
Restore Database Using RMAN on Different OS Version [message #382108] Wed, 21 January 2009 00:18 Go to next message
dedythea
Messages: 4
Registered: January 2009
Location: Tokyo
Junior Member
I have Oracle 9i Server runs on Windows 2003 Std edition.
I am planning to copy the database to another server running Windows 2003 Std x64 with Oracle 10gR2.
Is it possible to do this with RMAN ? Sad
Kindly explain the step if it possible.
Re: Restore Database Using RMAN on Different OS Version [message #382109 is a reply to message #382108] Wed, 21 January 2009 00:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have Oracle 9i Server runs on Windows 2003 Std edition.
Not a supported combination.

>I am planning to copy the database to another server running >Windows 2003 Std x64 with Oracle 10gR2.
>Is it possible to do this with RMAN ?

what have your test revealed?
Re: Restore Database Using RMAN on Different OS Version [message #382113 is a reply to message #382109] Wed, 21 January 2009 00:33 Go to previous messageGo to next message
dedythea
Messages: 4
Registered: January 2009
Location: Tokyo
Junior Member
I haven't perform any test yet.
Looking at Oracle Doc 369644.1 it seems not possible.
Re: Restore Database Using RMAN on Different OS Version [message #382123 is a reply to message #382113] Wed, 21 January 2009 01:06 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Quote:

4) Can I restore or duplicate my RMAN backup between two different platforms such as Solaris to Linux?

No, you cannot restore or duplicate between two different platforms unless you use the RMAN convert command (referenced below).

In versions previous to 10g the only option to migrate from one platform to another was using export / import. With 10g, using the RMAN convert commands, you can cross between platforms using the 10g Cross-Platform Transportable Tablespaces option. For more details review this note:



metalink note 369644.1
https://metalink.oracle.com/metalink/plsql/f?p=130:14:2913343708573543002::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,369644.1,1,0,1,helvetica

So that, if your database is Version 9, you've got only option export/import.

And if you want to test, try with 10gR2:

-- Creating a Transportable Tablespace Set with RMAN
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/ontbltrn.htm#sthref972

-- Transportable Tablespaces Across Different Platforms
https://metalink.oracle.com/metalink/plsql/f?p=130:14:2913343708573543002::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,243304.1,1,0,1,helvetica


Re: Restore Database Using RMAN on Different OS Version [message #382126 is a reply to message #382108] Wed, 21 January 2009 01:13 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Looking at Oracle Doc 369644.1 it seems not possible.
Are you bragging or complaining?
Reality is what reality is.
Previous Topic: use_db_recovery_file_dest
Next Topic: ORA-1146 signalled during: alter tablespace SYSTEM begin backup.
Goto Forum:
  


Current Time: Thu Nov 28 17:26:59 CST 2024