dataguard ORA-01033错误

原创许玉冲 2022-08-20

948

SQL> /

ERROR STATUS
----------------------------------------------------------------- ---------
VALID
VALID
VALID
ORA-01033: ORACLE initialization or shutdown in progress ERROR

#错误原因主库更改密码：

重新同步主，备密码,状态恢复正常：

SQL> alter system set log_archive_dest_state_4=defer;

System altered.

SQL> alter system set log_archive_dest_state_4=enable;

select error,status from v$archive_dest
/
$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 20 14:28:22 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> @error

ERROR                                                             STATUS
----------------------------------------------------------------- ---------
                                                                  VALID
                                                                  VALID
                                                                  VALID
                                                                  VALID

oracle

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

dataguard ORA-01033错误

评论