dataguard ORA-01033错误

简介: dataguard ORA-01033错误

1,错无信息

selecterror,statusfrom v$archive_dest;

ERROR STATUS

----------------------------------------------------------------- ---------

VALID

VALID

VALID

ORA-01033: ORACLE initialization or shutdown in progress ERROR

2,处理方法

更新备库密码;重启日志进程;


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



相关文章
|
数据库
控制文件不一致报错ORA-00214处理
控制文件不一致报错ORA-00214处理
1180 0
控制文件不一致报错ORA-00214处理
|
SQL
DATAGUARD(11.2.0.4) ORA-04021
DATAGUARD(11.2.0.4) ORA-04021
243 0
|
Oracle 关系型数据库 数据库