Previous Topic: Backups of Remote Oracle Instances Fail in RMAN ModeNext Topic: Restore the Oracle Data Files in a Different Directory


Oracle Permission Error

Symptom

While trying to perform a restore operation with the Until End of Logs option enabled, I get Oracle permission errors. How can I prevent the errors?

Solution

Ensure that the Oracle user name and password you use to connect to Oracle through the Restore Manager has the permission to connect to Oracle using the as sysdba clause.

You can verify your permissions by running the following commands:

sqlplus /nolog
connect username/password as sysdba

If you do not have permission, ask the Oracle DBA to configure the security for you.