| Invalid Password File error while performing Restore [message #326806] |
Thu, 12 June 2008 11:38  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
