Restore Database Using RMAN on Different OS Version [message #382108] |
Wed, 21 January 2009 00:18 |
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 ?
Kindly explain the step if it possible.
|
|
|
|
|
Re: Restore Database Using RMAN on Different OS Version [message #382123 is a reply to message #382113] |
Wed, 21 January 2009 01:06 |
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
|
|
|
|