Home » RDBMS Server » Backup & Recovery » Invalid Password File error while performing Restore (Oracle 9.2.0.7.0, Solaris 10)
Invalid Password File error while performing Restore [message #326806] Thu, 12 June 2008 11:38 Go to next message
kaustubh
Messages: 26
Registered: June 2007
Junior Member
Hi,
We have started seeing an intermittent error ORA-01991 while performing a restore. Whiel restoring we follow below steps:

1) Delete the original password file.
2) Re-create the passowrd file using command:
orapwd file=/opt/oracle/u01/app/oracle/product/9.2.0/dbs/orapw password=xxxx entries=1

3) Validate database backup via RMAN.
RMAN> SET DBID xxxxxx;
RMAN> RESTORE CONTROLFILE FROM 'xxxxxx/control_primary';
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE VALIDATE;
RMAN> EXIT;

4) Restore Database using RMAN.
5) Recover Database using RMAN.
6) Open database with RESETLOGS option.

We observed that at times our restore fails at step number 3 (Validate database backup) with the following error:
*****************************************************************
RMAN-00571: ===========================================================

RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS ======

RMAN-00571: ==================================================

RMAN-03002: failure of alter db command at 06/11/2008 11:14:27

ORA-01991: invalid password file '/opt/oracle/u01/app/oracle/product/9.2.0/dbs/orapw'
*******************************************************************


Once we start getting this error, we continue getting it for some time on each restore attempt. And after sometime the error disappears and restore can be done successfully.

Few details related to Oracle password file (orapw):
=====================================================
1) The value of the REMOTE_LOGIN_PASSWORDFILE in out init.ora file is "EXCLUSIVE".

2) The name of the Oracle password file present in /opt/oracle/u01/app/oracle/product/9.2.0/dbs is "orapw"
3) We have only one Oracle instance on our systems.

Could someone please provide some information.
Re: Invalid Password File error while performing Restore [message #326807 is a reply to message #326806] Thu, 12 June 2008 11:44 Go to previous message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
>Could someone please provide some information
I have always used the naming convention of "orapw<SID>" for my password file; such as orapwtest.
Previous Topic: RMAN output logs
Next Topic: RMAN backups
Goto Forum:
  


Current Time: Mon Dec 05 14:59:00 CST 2016

Total time taken to generate the page: 0.05731 seconds