Oracle Redirected Restore is failing with error: ORA-01991: invalid password file

Problem

While performing Oracle Control file redirected restore to another server it fails with error: ORA-01991: invalid password file

Error Message

The above error message can occur when performing an Oracle Control file redirected restore to another server. The actual control files will be restored but then the restore operation will fail when restoring the data files.
 
The Job Log will report below error (Figure 1)
 

 
Figure 1.
 

 
 
 
 
 

 
Example of the RMAN Section within the Job Log.
 
Starting restore at 29-APR-09
 
starting up daemon
 
starting up daemon
 
channel ch0: restoring controlfile
 
starting up daemon
 
channel ch0: restore complete
 
replicating controlfile
 
input filename=/u01/InstanceName/sbtproddata/cntrl01.dbf
 
output filename=/u01/InstanceName/sbtproddata/cntrl02.dbf
 
output filename=/u01/InstanceName/sbtproddata/cntrl03.dbf
 
Finished restore at 29-APR-09
 
released channel: ch0
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03002: failure of alter db command at 04/29/2009 11:10:25
 
ORA-01991: invalid password file '/u01/InstanceName/sbtproddb/9.2.0/dbs/orapwInstanceName'
 

Cause

This issue is due to the parameter "Remote_Login_Password_File" set to 'Exclusive ' in Init<SID>.ora file
 

Solution

Recreate password file using ORAPWD utility and set the parameter "Remote_Login_Password_File to value 'Shared' by editing Init<SID>.ora file
 
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)