Q

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?

Using RMAN to create a database backup to another machine is giving me an "unable to open file" error. What privileges should be granted?
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

1 comment

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close