data gurad broker 问题出现自动开归档

一个网友在论坛发现这样一种奇怪情况：

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  1219136 bytes
Variable Size             402654656 bytes
Database Buffers          822083584 bytes
Redo Buffers               15556608 bytes
Database mounted.
SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  1219136 bytes
Variable Size             402654656 bytes
Database Buffers          822083584 bytes
Redo Buffers               15556608 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     69
Current log sequence           71
SQL> select count(*) from test;
select count(*) from test
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     69
Current log sequence           71
SQL> alter system switch logfile;

System altered.

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     70
Current log sequence           72
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     70
Current log sequence           72
SQL> shutdown immeidate;
SP2-0717: illegal SHUTDOWN option
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  1219136 bytes
Variable Size             402654656 bytes
Database Buffers          822083584 bytes
Redo Buffers               15556608 bytes
Database mounted.
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     70
Current log sequence           72

-------在这之前都没问题， 然后我在其它的窗口， 用rman 连接了一下， 结果就出现了下面的情况了：

[oracle@myxinnet-2 oracle]$ rman1 target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 27 14:42:05 2008

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

connected to target database: HUNTER (DBID=207206589)


SQL> archive log list;
ORA-01155: the database is being opened, closed, mounted or dismounted
SQL> archive log list;
ORA-01155: the database is being opened, closed, mounted or dismounted
SQL> conn / as sysdba
Connected.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     73
Next log sequence to archive   75
Current log sequence           75
SQL>
解决办法：

data gurad broker 问题，  这个系统在之前有人配置过data gurad broker
用dgmgrl > remover configuration 后 现在正常了。

错误原因：

SQL> archive log list;
ORA-01155: the database is being opened, closed, mounted or dismounted
SQL> archive log list;
ORA-01155: the database is being opened, closed, mounted or dismounted

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8334342/viewspace-366184/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8334342/viewspace-366184/