ORA-01033: ORACLE initialization or shutdown in progress

• 主库报错：ORA-01033: ORACLE initialization or shutdown in progress

col DEST_NAME format a30；
select dest_name,status,error from /* 主库查看有没有报错 */ v$archive_dest;


----------------------------------------------------------------------------------
SYS@CRMDB2> select dest_name,error from v$archive_dest;

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

备库日志报错
# 备库日志报错
2023-07-13T10:29:47.104761+08:00
ARC1 (PID:3565): Error 1017 received logging on to the standby
ARC1 (PID:3565): -------------------------------------------------------------------------
ARC1 (PID:3565): Check that the source and target databases are using a password file
ARC1 (PID:3565): and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
ARC1 (PID:3565): and that the SYS password is same in the password files,
ARC1 (PID:3565): returning error ORA-16191
ARC1 (PID:3565): -------------------------------------------------------------------------
ARC1 (PID:3565): FAL: Error 16191 connecting to crmdb for fetching gap sequence
2023-07-13T10:29:47.140115+08:00

• 根据备库日志分析，因备库密码不比配导致
• # 重新在主库把密码文件传到DG备库

• 主库操作

-- alter system set log_archive_dest_state_2='defer';

-- alter system set log_archive_dest_state_2='enable';

• 检查

alter system archive log current;

alter system checkpoint;

• -- 检查rac主库和备库的日志号是否一致

SELECT UNIQUE THREAD#, MAX(SEQUENCE#) OVER(PARTITION BY THREAD#) LAST FROM V$ARCHIVED_LOG;

• -- 检查主库

col DEST_NAME format a30;
select ARCHIVED_THREAD#,ARCHIVED_SEQ#,APPLIED_THREAD#,APPLIED_SEQ#, DEST_NAME,error from v$archive_dest_status;

col DEST_NAME format a30;
select dest_name,status,error from /* 主库查看有没有报错 */ v$archive_dest;

• -- 查看进程状态

select process,client_process,thread#,sequence#,status from v$managed_standby;

 

• -- 主要在备库检测：归档应用 

select thread#,sequence#,first_time,next_time,applied from /* 主要在备库检测：归档应用 */ v$archived_log where applied='NO';