请教:这个问题怎么处理?ORA-16038: log 1 sequence# 59 cannot be archived
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/dev/vgdata/rora9_redo111'
ORA-00312: online log 1 thread 1: '/dev/vgdata/rora9_redo121'
使用alter system archive log stop以后还是无法打开数据库。
请大侠们支招。谢谢◎!
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/dev/vgdata/rora9_redo111'
ORA-00312: online log 1 thread 1: '/dev/vgdata/rora9_redo121'
使用alter system archive log stop以后还是无法打开数据库。
请大侠们支招。谢谢◎!
已经解决了。过程是:
SQL> select group#, sequence# from v$log;
GROUP# SEQUENCE#
---------- ----------
1 59
2 60
3 62
4 61
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database open;
Database altered.
当时没能创建归档日志的原因是对归档文件夹的操作权限不够。赋予足够权限以后
SQL> alter system archive log start;
System altered.
就恢复正常了。
SQL> select group#, sequence# from v$log;
GROUP# SEQUENCE#
---------- ----------
1 59
2 60
3 62
4 61
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database open;
Database altered.
当时没能创建归档日志的原因是对归档文件夹的操作权限不够。赋予足够权限以后
SQL> alter system archive log start;
System altered.
就恢复正常了。