For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hello Experts,
We are on Data Management and using file based interface for data loading. We are trying to the load the same data on both Local and USD currencies at one go.
How can we achieve this?
Any idea?
Beauty_and_dBest wrote:Hi ALL,Can I restore an RMAN backup from Windows to Linux? or vice-versa?Thanks a lot,jc
Beauty_and_dBest wrote:
Hi ALL,
Can I restore an RMAN backup from Windows to Linux? or vice-versa?
Thanks a lot,
jc
yes, but you need to actually Read The Fine Manuals to see required step to do as desired
Can you give me link to the right Manual? I might get the wrong one
Thanks!
Yes, it's possible but the methods varies a bit depending on your database version.
I'd start here: RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support (Doc ID 1079563.1)
edit: offical documentation is docs.oracle.com - you'll find everything there. E.g https://docs.oracle.com/database/121/BRADV/rcmxplat.htm#BRADV89983
AJ
Beauty_and_dBest wrote:Can you give me link to the right Manual? I might get the wrong oneThanks!
how can you be sure any posted manual here is correct?
unwilling or incapable to use GOOGLE yourself?
Beauty, I suggest you review the following notes.
- -
Clone Database from Windows To Linux (Lower patchset to Higher) using RMAN (Doc ID 2143991.1)
Restore From Windows To Linux using RMAN Fails (Doc ID 2003327.1)
The export/import process may be easier.
HTH -- Mark D Powell --
From 12c you also need to be using Enterprise Edition Oracle, so hopefully you're not using Standard Edition
Hi All,
We are only in 11gR2, so is it easier to do?
Beauty, did you read the references I posted for you? The first support note I referenced shows the step by step process using an 11.2 database.
Thanks Mark,
But why do you say export/import process is easier?
Based on the docs it seems its not that simple to to RMAN restore, I know lost of errors will be encountered there.
Our database is 2Tb, is it still manageable by export/import?
Can you share me docs guide on how to do expdp/impdp full database from Windows to Linux or Vice versa?
Regards,
Beauty_and_dBest wrote:Thanks Mark,But why do you say export/import process is easier? Based on the docs it seems its not that simple to to RMAN restore, I know lost of errors will be encountered there.Our database is 2Tb, is it still manageable by export/import?
No, it is not "managed by export/import." No database is, Ever has been. Ever will be. Export/import are utilities for transporting data, not managing databases.
After all this time and you are still asking where to find the docs?
https://docs.oracle.com/database/121/index.html
And the 12c Utilities manual: https://docs.oracle.com/database/121/SUTIL/toc.htm
And the Section on DataPump: https://docs.oracle.com/database/121/SUTIL/GUID-501A9908-BCC5-434C-8853-9A6096766B5A.htm#SUTIL2877
Why do you think you need instructions specific to "do expdp/impdp full database from Windows to Linux or Vice versa?" I know you've dealt with export/import before. Have you ever seen one single thing that indicated that moving across OS's requires any special consideration?
I'd hope by now you'd know:
1) where to find the docs
2) that import/export works exactly the same regardless of OS.
Beauty, with a 2T database and if both the source and target are the same release of Oracle then the closed rman backup, binary transfer, and rman restore is your best option. The export/import process gains in value when you also upgrade in the same operation but works better with smaller databases. The 'better' being subjective but mostly has to do with time. There are techniques to reduce the time requirement with export/import. If you are on standard edition verse Enterprise also matters since with EE rman supports multiple channels (parallelism).
Let us know how the process goes.
Thanks Mark and ALL,
But can you me with the actual or specific process being done like in blogs or white papers or support notes.
Usually Generic docs can stray me far away and prone to lots of errors.
Kind regards,
Beauty, again the first Oracle support I referenced is step by step for performing the rman backup and restore.
Ok thanks Mark, I will start reading it
My brain getting stressed reading Oracle docs or have phobia on it because of its complexity.