大家好:
我之前为数据库做过 alter database clear unarchived logfile group... 的操作。
现在发现当时数据库序列号是34,下一个归档的日志序列号是0,如下:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ora01/oracle/oradata/demo/archivelog
Oldest online log sequence 34
Next log sequence to archive 0
Current log sequence 34
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
------------------ ------------------ ------------------ ------------------ ------------------ --------- ------------------------------------------------ ------------------ ------------------
1 1 34 52428800 2 YES INACTIVE 1644109 23-JAN-13
3 1 0 52428800 2 NO CLEARING_CURRENT 1644161 23-JAN-13
2 1 0 52428800 2 YES UNUSED 0