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