This content has been marked as final. Show 8 replies
Since you have 2 different DBs with different software levels, I don't think you can do that, or anything similar to that, even after (cat)upgrading the restore from site A on site B.
You could, if all you want is an ocasional refresh, do a backup from site A (easier, with both sites at the same software level), do a duplicate operation and keep recovering site B (through sqlplus) as long as you want to.
But at the end you need to open the db for querying.
It seems that what you want is a typical Data Guard configuration (without factoring the costs).
Hope this helps.
Yes and you can do this:
- either as manual standby with Oracle Standard Edition One or Oracle Standard Edition (see http://www.databasejournal.com/features/oracle/article.php/3682421/Manual-Standby-Database-under-Oracle-Standard-Edition.htm)
- or as Data Guard standby with Oracle Entreprise Edition.
You Can't do physical replication ( Arhive log apply ) across different versions , platforms ( with some exceptions )
In shore the software you have installed (oracle 10g or oracle 11g or oracle 10g for linux or oracle 11g for solaris ) should be same across source and target
For instance on primary if you install binaries oracle 10g for solaris on target also it should be oracle 10g for solaris ( even linux on same version or 11g won't work)
If you want to setup replication across versions , platforms you have to go with logical replication methods like Golden gate ,logical standby , streams,AQ etc..
Let me know if you have any questions
Mark helpful if this reply is helpful
Mark correct if i answered your questions
Even if you downgrade and make versions equal it will not work,because it has to be identical block to block
Ok, Imagine if I upgrade or downgrade one of the DBs so they stay on the same platform, same oracle release, same patchset, same everything. Would be possible to transport the archived redo logs and apply them?
So you have to recreate the standby DB using physical backup of primary
Ok,Imagine if I upgrade or downgrade one of the DBs so they stay on the same platform, same oracle release, same patchset, same everything.
Would be possible to transport the archived redo logs and apply them?