oracle10G突然断电后出現ORA-00214,
而在同一台上9i却沒有此类情况!
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
ORA-00214: controlfile '/opt/oracle/oradata/ora10g/control03.ctl' version
883315 inconsistent with file '/opt/oracle/oradata/ora10g/control01.ctl'
version 883277
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> host cp /opt/oracle/oradata/ora10g/control02.ctl /opt/oracle/oradata/ora10g/control03.ctl
SQL> host cp /opt/oracle/oradata/ora10g/control02.ctl /opt/oracle/oradata/ora10g/control01.ctl
SQL> startup
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-16038: log 1 sequence# 653 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/ora10g/redo01.log'
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 653
Next log sequence to archive 653
Current log sequence 655
SQL> alter database backup controlfile to trace;
Database altered.
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> startup force
ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
阅读更多内容:1 · 2 · 下一页>>