數(shù)據(jù)庫：oracle 11.2.0.4

系統(tǒng)：AnolisOS7.9

問題描述：Rman恢復后，以resetlogs方式打開數(shù)據(jù)庫，報錯ORA-00392、ORA-00312，如下所示：

SQL>alter database open resetlogs;

alterdatabase open resetlogs

*

ERROR atline 1:

ORA-00392:log 3 of thread 1 is being cleared, operation not allowed

ORA-00312:online log 3 thread 1: '/u01/app/oracle/oradata/orcl/redo03.log'

異常原因：在線日志文件log 3正在被清除，無法open數(shù)據(jù)庫.

解決過程如下：

SQL>select group#,status from v$log;

GROUP# STATUS

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

1 CLEARING

2 CLEARING

3 CLEARING_CURRENT

4 CLEARING

5 CLEARING

6 CLEARING

7 CLEARING

8 CLEARING

9 CLEARING

10 CLEARING

11 CLEARING

GROUP# STATUS

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

12 UNUSED

12 rows selected.

SQL>alter database clear logfile group 4;

Databasealtered.

SQL>alter database clear logfile group 3;

Databasealtered.

SQL>alter database clear logfile group 5;

Databasealtered.

SQL>select group#,status from v$log;

GROUP# STATUS

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

1 CLEARING

2 CLEARING

3 CURRENT

4 UNUSED

5 UNUSED

6 CLEARING

7 CLEARING

8 CLEARING

9 CLEARING

10 CLEARING

11 CLEARING

GROUP# STATUS

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

12 UNUSED

12 rowsselected.

SQL>alter database open resetlogs;

Databasealtered.

說明：成功以resetlogs方式打開數(shù)據(jù)庫.