Restoring an Oracle database from a Unix environment to Windows environment
Hi,,
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?
LKBrwn_DBA, Thanks for the reply. All I can find about mixed platform support in data guard is from 11g onwards. Does you/anyone know if data guard in 10g supports mixed platform? I have looked but it is like searching through the proverbial haystack.
LKBrwn_DBA, Thanks for the reply. All I can find about mixed platform support in data guard is from 11g onwards. Does you/anyone know if data guard in 10g supports mixed platform? I have looked but it is like searching through the proverbial haystack.
I think you may want to check again Metalink Note:413484.1 ... as pointed out by LKBrwn_DBA
Metalink note is pretty clear about what is available in each Oracle version.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
if it's 10gR2, I did the opposite, copy the standby DB's data files from Windows to Linux, the create control file, startup upgrade, then invalidate and recompile all packages.
If the version is different, it needs to run $ORACLE_HOME/rdbms/admin/catalog.sql & catproc.sql
if it's 10gR2, I did the opposite, copy the standby DB's data files from Windows to Linux, the create control file, startup upgrade, then invalidate and recompile all packages.
If the version is different, it needs to run $ORACLE_HOME/rdbms/admin/catalog.sql & catproc.sql
if it's 10gR2, I did the opposite, copy the standby DB's data files from Windows to Linux, the create control file, startup upgrade, then invalidate and recompile all packages.
If the version is different, it needs to run $ORACLE_HOME/rdbms/admin/catalog.sql & catproc.sql
So not only are you just moving datafiles around different platforms at will, but you are just running catalog.sql & catproc.sql to account for different versions ??
ya. Linux 10.2.0.4 32-bit. Windows 10.2.0.3 64-bit.
I might be the same to move to Linux 10.2.0.3 first, then run startup upgrade to upgrade it to 10.2.0.4. But I already have Linux 10.2.0.4 binary installed.
Windows 64 bit => 32 bit needs to invalidate/recompile.
Reply With Quote
select platform_id, platform_name from v$database;
Originally Posted by Oracle_Nooby
Bookmarks