have you tested recovery of database done on e.g. Windows with DB 10.1 and placed on Linux RH with DB 11.2 latest SPU?
I'd like to use it for migration (using RMAN and no other method).
I assume the source DB should be patched and upgraded first to the level of target DB ie. 11.2 latest SPU. Then backup, transfer of the backup sets and recovery.
Do you think it's save? What hindrances could be there?
Yes you can migrate the database from windown OS to linux OS.
To restore the database you need to use set newname while your rman restoration.
But the problem which i faced was, that couldnot apply the archive logfile. As the format of the OS is different. To overcome the issue i backed up archive logfile using rman and then recovered.
After that you need to open the database using RESETLOG option
Database migration for Cross Platform using RMAN check this :https://blogs.oracle.com/AlejandroVargas/resource/Database-Migration-Windows-Linux-with-RMAN.pdf
If Your Db is size is small then you can go with datapump Method without upgrading your source database.
how about differences of versions? one is 10.1, the latter is 11.2.
should it be upgraded and patched before the migration?
in fact in this scenario, the source DB shouldn't be upgraded, so the only option is to install equal version/patch on target machine, migrate backup sets, and then upgrade to the latest 11g level.
is it necessary, or the migration can be run at once on the latest 11g on target machine (w/o any uprading/patching)?
and I found finally the answer
using expdp/impdp the direct upgrade is allowed cross-platform: 10.2.0.4 -> 11.2
Thanks every one for your input.
I will test RMAN method also but datapump seems to be the best solution for my case (no upgrade of versions, no extra patching).