The answer; Yeah, probably…..
I have often thought that there is no good reason why Linux and Windows could not share a database of the same version because after-all they are the same endian type.
And so, when a DSP customer posed the question to the DBA team, i decided it was time to prove (or disprove) the possibility.
I took a Windows 7 Ultimate! edition 64-bit VM, and loaded 188.8.131.52 SE with grid infrastructure for stand-alone server and a single ASM disk (+DATA), and then knocked up an Oracle Enterprise Linux 6.7 VM, and loaded it with 184.108.40.206 GI & RDBMS and got to work!
I used RMAN to backup the MS Win database to a normal NTFS filesystem, got a backup of the SPFILE, created a standby control file, and then loaded the lot onto my NAS before SCP’ing the files across to the waiting OEL 7.
I edited the PFILE for path changes (F:\app\ turned into /u01/app), recreated the password file, and inserted a line into /etc/oratab.
Exported my ORACLE_HOME, ORACLE_SID and PATH variables in my .bash_profile, jumped into SQLPlus, and startup nomount pfile=‘/u01/app/backup/test.pfile’
Create spfile from pfile=‘/u01/app/backup/test.pfile’;
Restarted with no mount, and then switched to RMAN for the moment of truth.
Once in RMAN, I restored the controlfile from ‘/u01/backup/test.ctl’;
alter database mount;
catalog start with ‘/u01/backup/‘ noprompt;
and then performed a crosscheck to get rid of those pesky windows paths out of the control file.
After that, it was a simple matter of restoring and recovering the database, I switched logs a few times on the source (shipped them using the same method – I couldn’t be bothered installing Cygwin).
I only restored one of the logs to the FRA on the new host, and rolled that single new log into the database (SQLPlus> recover standby database) and ….. POINT PROVEN!!!!!!!
After ‘alter database activate standby database;’ and ‘alter database open;’, it was time to start gloating 🙂
For more information or to schedule a demo please contact usContact us
DSP firmly established itself as one of the UK’s fastest growing proactive Database MSPs during 2016, signing £2.1m of new contracts and making its second acquisition, the Oracle DBA support division of IT Services provider ITSB.Read more
A main goal... how to future proof your applications environment through Oracle while becoming more efficient in terms of costs and productivity.
As well as the option of developing the fundamental steps you need to take to get ...Read more
In the age of big data, public cloud, private cloud it’s easy to be pushed into constantly thinking about the future... What should you optimise though and how can you be sure it’ll make a difference? Would knowing it could give you a competitive edge be worth considering?Read more