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.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
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
Originally Posted by Oracle_Nooby
Metalink note is pretty clear about what is available in each Oracle version.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
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.
I can think of three options:
- Data Pump (or emp/imp)
- Transportable Tablespace(s)
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
Streams will be the best option if you are looking for almost real time data.
Satheesh Babu S
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 ??
Originally Posted by sql888
Click Here to Expand Forum to Full Width