Ask the Expert

Privileges to use RMAN to create backup to another machine

Using RMAN to create a database backup to another machine is giving me an "unable to open file" error. What privileges should be granted?

    Requires Free Membership to View

RMAN can back up directly to tape or to local disk units. RMAN is not capable of backing up to a remote server unless you can make disk on that server appear to be local disk. If you are running your database on Windows, map a networked drive on the database server. If you are running your database on Unix/Linux, create a crossmount to the remote server. Once that is done, RMAN will need permissions to write to that remote filesystem. In Windows, the user that starts the OralceServiceSID service should have write permissions to the mapped drive. In Unix/Linux, the user or group that starts the database should have access to the remote filesystem.

This was first published in July 2006

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: