Copy password file from primary to standby in RAC Environment
Errors:
--PRODDB - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database
--DRDB - Physical standby database
Error: ORA-01017: invalid username/password; logon denied
--PRODB - Primary database
ORA-16191: Primary log shipping client not logged on standby
*** 2018-07-26 16:04:50.817626 4929 krsh.c
PING[ARC5]: Heartbeat failed to connect to standby 'PRODDB_REPL'. Error is 16191.
Thu Jul 26 16:30:24 2018
Errors in file /u01/app/oracle/diag/rdbms/proddb/PRODDB/trace/PRODDB_tt00_329234.trc:
ORA-16191: Primary log shipping client not logged on standby
Error 16191 for archive log file 1 to 'PRODDB_REPL'
Cause:
Problems seems to be in password file mismatch in Primary and Standby Server.
Solution:
1. Disable the DG broker service.
alter system set dg_broker_start =false
alter system set log_archive_dest_state_2=defer;
-- Manually start for debugging
alter system set log_archive_dest_state_2=enable;
2. Steps to copy the password file from primary to Standby.
Check configuration of RAC environment with SRVCTL command.
--At Primary :
srvctl config database -d PRODDB
Database unique name: PRODB
Database name:
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1
Oracle user: oracle
Spfile: +DG_1/PRODB/PARAMETERFILE/spfilePRODB.ora
Password file: +DG_1/PRODB/PASSWORD/pwdPRODB.455.982492525
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DG_1
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: racoper
Database instances: PRODB1,PRODB2
Configured nodes: b1xlvdb8a-adm,b1xlvdb8b-adm
Database is administrator managed
Check for Standby Database
-- At Standby
srvctl config database -d DRDB
Database unique name: DRDB
Database name: DRDB
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1
Oracle user: oracle
Spfile: +DG_1/DRDB/PARAMETERFILE/spfile.288.947968565
Password file: +DG_1/DRDB/PASSWORD/pwdDRDB.289.982492821
Domain:
Start options: mount
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DG_1
Mount point paths:
Services: IBASE_BATCH_SVC,IBASE_SVC
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: racoper
Database instances: DRDB1,DRDB2
Configured nodes: b1xlvdb6a-adm,b1xlvdb6b-adm
Database is administrator managed
3. Copy the ASM Password file from Primary to local disk.
pwcopy D+DG_1/PRODB/PASSWORD/pwdPRODB.455.982492525 /tmp/primary_passwd
4. SCP the file from primary to standby.
copy /tmp/primary_passwd to standby side
5. Remove current password file from Standby Server present at ASM location.
pwdelete +DG_1/DRDB
6. Copy the primary password file to Standby ASM location.
pwcopy /tmp/primary_passwd +DG_1/DRDB/PASSWORD/pwdDRDB
7. Modify the Setting with SRVCLT
srvctl modify database DRDB -pwfile +DG_1/DRDB/PASSWORD/pwdDRDB
8. Check the Standby and start the recovery process.
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
9. Enable the DB Services by stop manually process of apply.