Restoring an Oracle database from a Unix environment to Windows environment
I am new to all of this so sorry if it seems like a dumb question. Also I looked through the forum to see if anyone had asked a similar question...couldn't find a similar one so here goes..
The organisation I work for has a 10g Oracle database situated on a unix box, we are building a reporting solution for it. However our (development and reporting live environment) is Windows based (We have a windows based version of O10g installed there).
Will we have problems moving a backup of the live system from Unix environment to Windows environment and will we be able to apply the re-do logs in the normal fashion? (We plan on keeping an up to date version on our windows server so management can run their reports without hurting the transactional system)
Is it impossible to do? Or just plain complicated and difficult? Or should it be a breeze?
Thanks in advance for any replies
select platform_id, platform_name from v$database;
Data Guard can support specific mixed Oracle Platform combinations, check out Metalink Note:413484.1.
Maybe a logical standby would be more acceptable. ;)