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 last published in July 2006

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close