ORA-00257: archiver error. Connect internal only,

ORA-00257: archiver error. Connect internal only, until freed.

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 16 11:16:24 2006

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

SQL> connect /as sysdba
Connected.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
Database mounted.
ORA-16038: log 3 sequence# 9 cannot be archived   **** 注意到 这里是log3 不行了
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/opt/oracle/product/oradata/orcl/redo03.log'

SQL> alter database clear unarchived logfile group 3;  *****

Database altered.

SQL> alter database open;

Database altered.

ORA-01552: 非系统表空间'USERS'无法使用系统回退段

解决办法：

  PLSQL中：

   select segment_name,status from dba_rollback_segs;

segment_name,status

--------------------------------

1 SYSTEM ONLINE
12 RBS_SMALL OFFLINE

alter rollback segment "RBS_SMALL" online