Hi Brian. Just some background information before my question. I am in a bit of trouble here at work with too many clients' db copies to maintain on the in-house server -- mostly for trouble-shooting purposes and testing client-specific software releases. Usually we get a full export dump of the database, which I do an import from onto a properly set-up empty Oracle shell here on my db server, which works fine. But now, I have been given a backup copy by a client in RMAN format. RMAN is totally new to me.
My question is, can the RMAN backup from one server be restored in another db server? Specific to my situation here, I am trying to set up RMAN in-house with little help in-house, mainly for the purpose of implementing client databases here. Could you please give some guidelines? I also need to know whether it is worth doing. Your advice is much appreciated. Thank you very much.
For RMAN help, I'd like to point you to a document titled "RMAN Notes" on my Web site that I wrote some time ago. These are the notes I took when I was learning RMAN. This document is not a polished white paper, but I have heard from many individuals that this paper helped them understand RMAN. Keep in mind that the paper is dated as RMAN in Oracle 10g has some nice new features you might want to employ in your environment.
RMAN does have the capability of copying your database to another server. Using RMAN to clone your database is a feature it is good at performing. Have a look at this Oracle document on how to use RMAN to duplicate your database to another server.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading