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



相关文章
|
SQL
DATAGUARD(11.2.0.4) ORA-04021
DATAGUARD(11.2.0.4) ORA-04021
272 0
|
SQL Oracle 关系型数据库
Oracle shutdown immediate遭遇ORA-24324 ORA-24323 ORA-01089
一数据库服务器执行shutdown immediate时,遇到了下面ORA错误,如下所示: $ sqlplus / as sysdba   SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 5 10:56:24 2016   Copyright (c) 1982, 2007, Oracle.
1674 0
|
Oracle 关系型数据库 数据库
ORACLE 12C连接时报ORA28040和ORA01017的错误
【一】环境说明 1.1 Oracle服务端版本:12.2.0.1 1.2 Oracle客户端版本:11.2.0.1 【二】问题说明 2.1 客户端连接服务端的时候报ORA-28040的错误。
4261 0
|
Oracle 关系型数据库 数据库
|
Oracle JavaScript 关系型数据库