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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top