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.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.