LOG_ARCHIVE_DEST_2 ERROR ORA-01033: ORACLE initialization or shutdown in progress

Problem:

on Primary database shows standby having error

SQL> select dest_name, status, error from gv$archive_dest;

DEST_NAME STATUS ERROR
————————————————– ——— —————————————————————–
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 ERROR ORA-01033: ORACLE initialization or shutdown in progress

SQL > Select db_unique_name, database_role,open_mode, switchover_status from v$database;

DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS
—————————— —————- ——————– ——————–
prmyc PRIMARY READ WRITE FAILED DESTINATION

Discovery:

I checked standby database and it is in mount mode and that is alright.

i can connect to standby from primary machine and standby machine itself so it looks good.

Solution:

it has problem with password file. i created password file with same password manually using srvctl command on standby and primary but it does not like that.

so i created new password file on primary and copy from primary to standby and then it worked fine.

• copy password file from ASM to local drive on primary

asmcmd -p

ASMCMD [+oradata1/prmyc/password] > pwcopy pwdprmyc.844.1007810343 /tmp
copying +oradata1/prmyc/password/pwdprmyc.844.1007810343 -> /tmp/pwdprmyc.844.1007810343

• Copy file from TEST to PROD

on test server

scp userid@server1.com:/tmp/pwdprmyc.844.1007810343 /tmp

• copy from local directory to ASM on standby

ASMCMD [+oradata1/prmyc/password]  pwcopy /tmp/pwdprmyc.844.1007810343 +dr_oradata1/PRMYCMDN/PASSWORD/orapwprmycmdn

• Add password file on standby

srvctl modify database -d prmycmdn -pwfile +dr_oradata1/PRMYCMDN/PASSWORD/orapwprmycmdn

srvctl config database -d prmycmdn

Now primary show correct status it started applying logs

SQL> select dest_name, status, error from gv$archive_dest;

DEST_NAME STATUS ERROR
————————————————– ——— —————————————————————–
LOG_ARCHIVE_DEST_1 VALID
LOG_ARCHIVE_DEST_2 VALID

SQL > Select db_unique_name, database_role,open_mode, switchover_status from v$database;

DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS
—————————— —————- ——————– ——————–
prmyc PRIMARY READ WRITE TO STANDBY

user this sql on both primary and standby to see progress

SQL> SELECT dest_id, sequence#, first_time, next_time, applied
FROM v$archived_log
ORDER BY sequence#;