Skip to content

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#;

 

 

 

 

 

One Comment Post a comment
  1. Riad B #

    Don’t forget also to copy orapwd password file to the other primary nodes if it is not the current or not in ASM.

    Like

    May 12, 2020

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: