【oracle】ORA-16038: log 2 sequence# 98 cannot be archived

ORA-16038: log 2 sequence# 98 cannot be archived ORA-19502: write error on file "", block number  (block size=) ORA-00312: online log 2 thread 1: +DATA1/rac/onlinelog/group_2.262.761070195 ORA-00312: online log 2 thread 1: +DATA2/rac/onlinelog/group_2.258.761070195 Errors in file /opt/rac/oracle/diag/rdbms/rac/rac1/trace/rac1_arc1_18931.trc: 发现存储空间不足了： oracle@rac1:/home/oracle df -h 文件系统              容量  已用 可用 已用% 挂载点 /dev/sda3              21G   20G  9.9M 100% / /dev/sda1             190M   12M  169M   7% /boot tmpfs                 2.0G  1.2G  842M  58% /dev/shm /dev/sdb1             5.0G  2.5G  2.3G  53% /home/oracle/tmp 使用rman 删除过期的日志： oracle@rac1:/opt/rac/oracle/arch rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Sun Sep 11 20:20:45 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to target database: RAC (DBID=2349052205) RMAN crosscheck archivelog all; using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=74 instance=rac1 device type=DISK validation failed for archived log archived log file name=/opt/rac/oracle/arch/1_17_761070192.dbf RECID=1 STAMP=761306112 validation failed for archived log archived log file name=/opt/rac/oracle/arch/1_18_761070192.dbf RECID=6 STAMP=761311351 validation failed for archived log 。。。。。。 205     2    68      X 11-SEP-11         Name: /opt/rac/oracle/arch/2_68_761070192.dbf 206     2    69      X 11-SEP-11         Name: /opt/rac/oracle/arch/2_69_761070192.dbf Do you really want to delete the above objects (enter YES or NO)? yes deleted archived log archived log file name=/opt/rac/oracle/arch/1_17_761070192.dbf RECID=1 STAMP=761306112 deleted archived log archived log file name=/opt/rac/oracle/arch/1_18_761070192.dbf RECID=6 STAMP=761311351 deleted archived log archived log file name=/opt/rac/oracle/arch/1_19_761070192.dbf RECID=8 STAMP=761312078 。。。。。。。。。。。。。。 archived log file name=/opt/rac/oracle/arch/2_65_761070192.dbf RECID=197 STAMP=761594829 deleted archived log archived log file name=/opt/rac/oracle/arch/2_66_761070192.dbf RECID=201 STAMP=761597071 deleted archived log archived log file name=/opt/rac/oracle/arch/2_67_761070192.dbf RECID=204 STAMP=761597191 deleted archived log archived log file name=/opt/rac/oracle/arch/2_68_761070192.dbf RECID=205 STAMP=761599326 deleted archived log archived log file name=/opt/rac/oracle/arch/2_69_761070192.dbf RECID=206 STAMP=761599875 Deleted 120 EXPIRED objects RMAN exit Recovery Manager complete. oracle@rac1:/opt/rac/oracle/arch df -h 文件系统              容量  已用 可用 已用% 挂载点 /dev/sda3              21G   19G  849M  96% / /dev/sda1             190M   12M  169M   7% /boot tmpfs                 2.0G  1.2G  842M  58% /dev/shm /dev/sdb1             5.0G  2.5G  2.3G  53% /home/oracle/tmp oracle@rac1:/opt/rac/oracle/arch sqlplus "/as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 11 19:30:52 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL archive log list Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /opt/rac/oracle/arch Oldest online log sequence     98 Next log sequence to archive   98 Current log sequence           99 SQL alter system switch logfile; System altered. SQL exit
Oracle的sequence Oracle的sequence，就是序列号，它提供一系列的按照事先指定的方式进行增长的数字。oracle sequence的最大值是38个整数。【 Sequences are database objects from which multiple users can generate unique integers.】。一般来说，sequence常用于生成数据库的主键。 Oracle将sequence的定义存储在数据字典之中，因此，所有的sequence都在数据库的SYSTEM表空间里面。
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available 在使用rman duplicate复制standby数据库的时候，由于standby数据库实例必须处于非mount状态，所以主数据库直接连接是会报错的，需要在standby数据库服务上的监听器上配置静态的服务名，如下：$GRID_HOME/network/admin/listener.
序列是数据库对象一种。多个用户可以通过序列生成连续的数字以此来实现主键字段的自动、唯一增长，并且一个序列可为多列、多表同时使用。 序列消除了串行化并且提高了应用程序一致性。（想象一下没有序列的日子怎么办？） 2.   Creating Sequences（创建序列）