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

Article: 100020372
Last Published: 2014-05-12
Ratings: 0 0
Product(s): Backup Exec

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
 
 

 

Was this content helpful?