ITLife365 生活 互动学习空间 - 互动学习空间

今天在虚拟机的oracle上,修改索引,结果空间不够了,刚开始还不能连接,删除了几个文件,释放空间之后,就能连接
连接之后,立即执行shutdown immediate 半天没动静,是不是在归档啊,马上Ctrl+C 换成了shutdown abort 命令
结果在startup启动时,mount上了,可是开不了 报ORA-16038: log 3 sequence# 6 cannot be archived

SQL> startup
ORACLE instance started.
Total System Global Area 1342177280 bytes
Fixed Size                  1273564 bytes
Variable Size             637534500 bytes
Database Buffers          687865856 bytes
Redo Buffers               15503360 bytes
Database mounted.
ORA-16038: log 3 sequence# 252 cannot be archived
ORA-19502: write error on file "", blockno  (blocksize=)
ORA-00312: online log 3 thread 1:
'/home/db/oracle/oradata/itlife365db/rredo_3_01_512m'
ORA-00312: online log 3 thread 1:
'/home/db/oracle/oradata/itlife365db/rredo_3_02_512m'
应该是日志没有归档,执行了
alter database clear unarchived logfile group 3;
alter database open;
启动正常.