大家好:
我的日志组group 3的日志文件损坏后,执行了 alter database clear unarchived logfile group 3;
之后,执行多次alter system archive log current;,当需要切换到group 3时,就提示 group 3之前的日志序列号25不能归档,但当时日志序列号是27,
但想执行删除group 3,再重建时 alter database drop logfile group 3;又提示group 3需要归档。
执行 archive log list显示当时日志序列号是27,下一个要归档的日志序列号却是25,正常来说,下一个归档序列号应该也是27的。
麻烦各位大侠帮忙看看要怎么处理,怎么才能归档恢复好group 3?情况如下:SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
------------------ ------------------ ------------------ ------------------ ------------------ --------- ------------------------------------------------ ------------------ ------------------
1 1 26 52428800 2 NO INACTIVE 1645366 24-JAN-13
2 1 27 52428800 2 NO CURRENT 1645387 24-JAN-13
3 1 25 52428800 2 NO INACTIVE 1645325 24-JAN-13SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-16038: log 3 sequence# 25 cannot be archived
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03.log'
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03_2.log'
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
------------------ ------------------ ------------------ ------------------ ------------------ --------- ------------------------------------------------ ------------------ ------------------
1 1 26 52428800 2 NO INACTIVE 1645366 24-JAN-13
2 1 27 52428800 2 NO CURRENT 1645387 24-JAN-13
3 1 25 52428800 2 NO INACTIVE 1645325 24-JAN-13SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-00350: log 3 of instance demo (thread 1) needs to be archived
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03.log'
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03_2.log'
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ora01/oracle/oradata/demo/archivelog
Oldest online log sequence 25
Next log sequence to archive 25
Current log sequence 27
我的日志组group 3的日志文件损坏后,执行了 alter database clear unarchived logfile group 3;
之后,执行多次alter system archive log current;,当需要切换到group 3时,就提示 group 3之前的日志序列号25不能归档,但当时日志序列号是27,
但想执行删除group 3,再重建时 alter database drop logfile group 3;又提示group 3需要归档。
执行 archive log list显示当时日志序列号是27,下一个要归档的日志序列号却是25,正常来说,下一个归档序列号应该也是27的。
麻烦各位大侠帮忙看看要怎么处理,怎么才能归档恢复好group 3?情况如下:SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
------------------ ------------------ ------------------ ------------------ ------------------ --------- ------------------------------------------------ ------------------ ------------------
1 1 26 52428800 2 NO INACTIVE 1645366 24-JAN-13
2 1 27 52428800 2 NO CURRENT 1645387 24-JAN-13
3 1 25 52428800 2 NO INACTIVE 1645325 24-JAN-13SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-16038: log 3 sequence# 25 cannot be archived
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03.log'
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03_2.log'
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
------------------ ------------------ ------------------ ------------------ ------------------ --------- ------------------------------------------------ ------------------ ------------------
1 1 26 52428800 2 NO INACTIVE 1645366 24-JAN-13
2 1 27 52428800 2 NO CURRENT 1645387 24-JAN-13
3 1 25 52428800 2 NO INACTIVE 1645325 24-JAN-13SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-00350: log 3 of instance demo (thread 1) needs to be archived
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03.log'
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03_2.log'
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ora01/oracle/oradata/demo/archivelog
Oldest online log sequence 25
Next log sequence to archive 25
Current log sequence 27
解决方案 »
- ora-01017 invalid username/password;logon denied
- 一个SQL汇总拼接的问题
- linux安装Oracle9设置环境变量在哪设置?
- pl/sql 如何将查询结果集放在数组中
- SQL(ORACLE)中的条件和is not null问题
- 如果将这名MSSQL的UPDATE语句转为ORACLE
- oracle 表中有一date字段,要把系统当前时间插入表中,sql怎么写呢?
- ◎◎◎◎◎◎如何用SQL语句导出oracle数据库中的单个对象◎◎◎◎◎
- 如何使用CodeSmith生成存储过程?紧急求助
- 如何在本地执行impdp命令把dmp文件导入到服务器中,且服务器只能连接数据库
- 请教关于日志问题导致数据库无法打开
- oracle数据库执行update语句时弹出Execution time
之后,执行多次alter system archive log current;什么错误?怎么会执行alter system archive log current;这个命令?
切换日志是用switch logfile啊日志操作命令详细查看文章:http://blog.csdn.net/java3344520/article/details/7196433