Q
Problem solve Get help with specific problems with your technologies, process and projects.

New to RMAN

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?

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close