Migrate Oracle Database From Windows To Linux Using RMAN

[@aminadachan4943]

Hello, thank you for this tutorial, is this the same procedure for Oracle 11 on windows or it's only from Oracle 12 and higher versions?

[@bharathkumar-ds8cd]

good session sir. please explain one more video Solaris to Linux please.

[@wysheid2009]

Sure , will try for it.. You can see complete steps of creating a database in AWS in this link kzbin.info/www/bejne/rH6ap5uhrLaliNE

[@ManojYadav-lw8tu]

Nice explanation

[@wysheid2009]

Thanks Manoj

[@tundeomosanya3650]

Great video! all steps simplified. But, what if the source (Windows) database is using Oracle Managed Files (OMF) .... in one of my practice, I found out that the RMAN convert script (Transport.sql) is unable to convert datafiles with OMF nomenclature. What is the solution to this constraint?

[@wysheid2009]

Hi Tunde, in that case you can use the format clause as the part of convert database command ,as in this example RMAN > convert database new database 'wysheid' transport script 'G:\wysheid\transport_convert.sql' db_file_name_convert 'G:\APP\WYSHEID\ORADATA\WYSHEID' 'G:\wysheid' to platform 'Linux x86 64-bit’ FORMAT='G:\wysheid\%U'; Please try and let me know

[@aravinthperumal6924]

@@wysheid2009 Seems we are hitting with ORA-01276 : file has omf file names, even after using format clause. My source is Linux X86-64 (target windows 64 bit). Even tried disabling omf features at db level, later couldnt rename system ts to non-omf format. Let me know this method of migration is possible, if OMF is enabled. Thanks in Advance.

[@mateuszoles248]

@@aravinthperumal6924 did you find the solution for the ORA-01276 OMF problem? Im having the exact same issue currently.

[@mateuszoles248]

@@aravinthperumal6924 i found the solution. Although Oracle recommends against it - you have to disable the hidden parameter with the use of alter system, here's an example: alter system set "_omf" = disabled scope=spfile;

[@shreyasuthar1973]

sir can you please share video on migrating Oracle Database From Windows To Linux (oracle cloud) Using RMAN?