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.
Requires Free Membership to View
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.
This was first published in March 2006
Join the conversationComment
Share
Comments
Results
Contribute to the conversation