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/，如需轉載，請註明出處，否則將追究法律責任。