ORA-16014 空间足够

ORA-16014: log 3 sequence# 28 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/oracle/oradata/pszx_db/redo03.log'

网上查都是说flash recovery area不够导致，但是我是刚建的库
flash recovery area 有足够剩余剩余空间，后来将所有redo备份，删除，再用resetlogs启动，重建redo即可



[code][oracle@localhost pszx_db]$ mkdir redo
[oracle@localhost pszx_db]$ mv redo0* ./redo/
[oracle@localhost pszx_db]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 28 16:25:46 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle/oradata/pszx_db/redo01.log'

SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

SQL> exit[/code]