Ask the Expert

Making the move to RMAN

I keep hearing RMAN is the way to go, however, since I have been a DBA for such a long while, I am a little connected to my scripts. Is there a good source you can suggest to learn how to setup RMAN that provides straightforward steps?

    Requires Free Membership to View

I have a few good sources for you. First, you might want to visit my Web site ( I have a white paper titled "RMAN notes." These notes are what I recorded when I was trying to learn RMAN for the first time. I would also suggest a book titled "Oracle9i RMAN backup & recovery" by Robert Freeman on Oracle Press. And as always, I do have to recommend reading the RMAN documentation. It can be boring and dry, but it does contain tons of information.

You are embarking on RMAN at a good time. After you've set it up and configured RMAN, backing up your databases is as easy as issuing "backup database." RMAN is a mature product now that only appears to be complicated. Once you've used it for a while, RMAN will the only backup and recovery tool you'll want to use for your Oracle databases.

This was first published in May 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: