今天同事的笔记本上的一个oracle 10g实例出现了错误，同事无法处理，我就接过来看了下并解决之。
解决过程记录如下。
检查了下alter日志：
-------------------------------------------------------------------------------------------------------------
Fri Apr 02 09:56:09 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_5392.trc:
ORA-16014: log 1 sequence# 93 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 09:56:09 2010
ARCH: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_89_U_.ARC'
Fri Apr 02 09:56:09 2010
ARCH: Failed to archive thread 1 sequence 89 (19809)
ORA-16038 signalled during: alter database open...
Fri Apr 02 09:57:09 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 09:58:09 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 09:59:09 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 09:59:44 2010
alter database datafile 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' offline
Fri Apr 02 09:59:44 2010
ORA-1516 signalled during: alter database datafile 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' offline...
Fri Apr 02 10:00:09 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 10:00:56 2010
alter database datafile 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' offline drop
Fri Apr 02 10:00:56 2010
ORA-1516 signalled during: alter database datafile 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' offline drop...
Fri Apr 02 10:01:08 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 89 (4)
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 10:01:23 2010
alter database datafile 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' offline drop
Fri Apr 02 10:01:23 2010
ORA-1516 signalled during: alter database datafile 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' offline drop...
Fri Apr 02 10:02:09 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_5392.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Fri Apr 02 10:02:09 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:02:09 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_5392.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
ARC1: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_89_U_.ARC'
ARC1: Failed to archive thread 1 sequence 89 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:02:10 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_5392.trc:
ORA-16038: log 2 sequence# 89 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
Fri Apr 02 10:02:56 2010
Archive Log Next
ARCH: Archiving not possible: No primary destinations
ARCH: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 10:02:56 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_5404.trc:
ORA-16014: 日志 2 的序列号 89 未归档, 没有可用的目的地
ORA-00312: 联机日志 2 线程 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
Archive Log Next
ARCH: Archiving not possible: No primary destinations
ARCH: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 10:02:59 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_5404.trc:
ORA-16014: 日志 2 的序列号 89 未归档, 没有可用的目的地
ORA-00312: 联机日志 2 线程 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
Archive Log Next
ARCH: Archiving not possible: No primary destinations
ARCH: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 10:03:00 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_5404.trc:
ORA-16014: 日志 2 的序列号 89 未归档, 没有可用的目的地
ORA-00312: 联机日志 2 线程 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
Fri Apr 02 10:03:09 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 89 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:03:09 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_4208.trc:
ORA-16014: log 2 sequence# 89 not archived, no available destinations
ORA-00312: online log 2 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
Fri Apr 02 10:04:09 2010
alter database drop logfile member 'D:/oracle/product/10.2.0/oradata/orcl/REDO02.LOG'
Fri Apr 02 10:04:09 2010
ORA-361 signalled during: alter database drop logfile member 'D:/oracle/product/10.2.0/oradata/orcl/REDO02.LOG'...
Fri Apr 02 10:04:09 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 89 (4)
Fri Apr 02 10:04:36 2010
alter database clear unarchived logfile 'D:/oracle/product/10.2.0/oradata/orcl/REDO02.LOG'
Fri Apr 02 10:04:36 2010
WARNING! CLEARING REDO LOG WHICH HAS NOT BEEN ARCHIVED. BACKUPS TAKEN
BEFORE 03/31/2010 09:16:02 (CHANGE 3059992) CANNOT BE USED FOR RECOVERY.
Clearing online log 2 of thread 1 sequence number 89
Completed: alter database clear unarchived logfile 'D:/oracle/product/10.2.0/oradata/orcl/REDO02.LOG'
Fri Apr 02 10:04:50 2010
alter database open
Fri Apr 02 10:04:56 2010
Thread 1 advanced to log sequence 95
Thread 1 opened at log sequence 95
Current log# 2 seq# 95 mem# 0: D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG
Successful open of redo thread 1
Fri Apr 02 10:04:57 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 02 10:04:58 2010
ARC0: Archiving not possible: No primary destinations
Fri Apr 02 10:04:58 2010
SMON: enabling cache recovery
Fri Apr 02 10:04:58 2010
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:04:58 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:04:59 2010
Successfully onlined Undo Tablespace 1.
Fri Apr 02 10:04:59 2010
SMON: enabling tx recovery
Fri Apr 02 10:05:00 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=21, OS id=4272
Fri Apr 02 10:05:09 2010
Completed: alter database open
Fri Apr 02 10:05:12 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:05:15 2010
Starting background process EMN0
EMN0 started with pid=28, OS id=5144
Fri Apr 02 10:05:15 2010
Shutting down instance: further logons disabled
Fri Apr 02 10:05:16 2010
ksvcreate: Process(q001) creation failed
Fri Apr 02 10:05:17 2010
Stopping background process QMNC
Fri Apr 02 10:05:18 2010
Stopping background process CJQ0
Fri Apr 02 10:05:19 2010
Stopping background process MMNL
Fri Apr 02 10:05:23 2010
Stopping background process MMON
Fri Apr 02 10:05:27 2010
Shutting down instance (immediate)
License high water mark = 7
Fri Apr 02 10:05:27 2010
Stopping Job queue slave processes
Fri Apr 02 10:05:27 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Apr 02 10:05:35 2010
ALTER DATABASE CLOSE NORMAL
Fri Apr 02 10:05:36 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Apr 02 10:05:39 2010
LGWR: Waiting for ORLs to be archived...
Fri Apr 02 10:06:08 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:06:11 2010
Shutting down archive processes
Fri Apr 02 10:06:16 2010
ARCH shutting down
ARC2: Archival stopped
Fri Apr 02 10:06:16 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:06:39 2010
LGWR: Archiving did not complete within timeout
for log 1, seq 93 on thread 1
Shutting down archive processes
Archiving is disabled
Fri Apr 02 10:06:44 2010
ARCH shutting down
ARC1: Archival stopped
Fri Apr 02 10:06:49 2010
ARCH shutting down
ARC0: Archival stopped
Fri Apr 02 10:06:50 2010
Thread 1 closed at log sequence 95
Successful close of redo thread 1
Fri Apr 02 10:06:53 2010
Completed: ALTER DATABASE CLOSE NORMAL
Fri Apr 02 10:06:53 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Apr 02 10:06:57 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 184549376
__large_pool_size = 4194304
__java_pool_size = 8388608
__streams_pool_size = 0
spfile = D:/ORACLE/PRODUCT/10.2.0/DB_1/DBS/SPFILEORCL.ORA
sga_target = 612368384
control_files = D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/CONTROL01.CTL, D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/CONTROL02.CTL, D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 406847488
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:/oracle/product/10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_allow_resetlogs_corruption= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/ADUMP
background_dump_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/BDUMP
user_dump_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/UDUMP
core_dump_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=4504
PSP0 started with pid=3, OS id=5072
MMAN started with pid=4, OS id=6084
DBW0 started with pid=5, OS id=4876
LGWR started with pid=6, OS id=5876
CKPT started with pid=7, OS id=4172
SMON started with pid=8, OS id=4136
RECO started with pid=9, OS id=5700
CJQ0 started with pid=10, OS id=5012
MMON started with pid=11, OS id=5940
Fri Apr 02 10:06:57 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Apr 02 10:06:57 2010
starting up 1 shared server(s) ...
Fri Apr 02 10:06:57 2010
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=4708
Fri Apr 02 10:07:01 2010
Setting recovery target incarnation to 2
Fri Apr 02 10:07:02 2010
Successful mount of redo thread 1, with mount id 1243018945
Fri Apr 02 10:07:02 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Apr 02 10:07:02 2010
ALTER DATABASE OPEN
Fri Apr 02 10:07:05 2010
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=4880
ARC1 started with pid=17, OS id=4600
Fri Apr 02 10:07:05 2010
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 95
Current log# 2 seq# 95 mem# 0: D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG
Successful open of redo thread 1
Fri Apr 02 10:07:07 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 02 10:07:07 2010
ARC0: STARTING ARCH PROCESSES
Fri Apr 02 10:07:07 2010
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Apr 02 10:07:07 2010
ARC2: Archival started
Fri Apr 02 10:07:07 2010
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=19, OS id=964
Fri Apr 02 10:07:07 2010
SMON: enabling cache recovery
Fri Apr 02 10:07:08 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_4880.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Fri Apr 02 10:07:08 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:07:08 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_4880.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
ARC0: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_93_U_.ARC'
Fri Apr 02 10:07:08 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_4600.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Fri Apr 02 10:07:08 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:07:08 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_4600.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
ARC1: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_94_U_.ARC'
Fri Apr 02 10:07:09 2010
ARC0: Failed to archive thread 1 sequence 93 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:07:09 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_4880.trc:
ORA-16038: log 1 sequence# 93 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:07:09 2010
ARC1: Failed to archive thread 1 sequence 94 (19809)
Fri Apr 02 10:07:09 2010
Successfully onlined Undo Tablespace 1.
Fri Apr 02 10:07:09 2010
SMON: enabling tx recovery
Fri Apr 02 10:07:10 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=5444
Fri Apr 02 10:07:20 2010
Completed: ALTER DATABASE OPEN
Fri Apr 02 10:08:05 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:08:05 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_4880.trc:
ORA-16014: log 1 sequence# 93 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:08:26 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2212K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Fri Apr 02 10:08:27 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2063K exceeds notification threshold (2048K)
Details in trace file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_5824.trc
KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==
Fri Apr 02 10:09:05 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:10:05 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:11:06 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:12:05 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:12:06 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:13:06 2010
Shutting down archive processes
Fri Apr 02 10:13:11 2010
ARCH shutting down
ARC2: Archival stopped
Fri Apr 02 10:13:11 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_4600.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Fri Apr 02 10:13:11 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:13:11 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_4600.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
ARC1: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_93_U_.ARC'
ARC1: Failed to archive thread 1 sequence 93 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:13:11 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_4600.trc:
ORA-16038: log 1 sequence# 93 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:14:11 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:14:11 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_4880.trc:
ORA-16014: log 1 sequence# 93 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Dump file d:/oracle/product/10.2.0/admin/orcl/bdump/alert_orcl.log
Fri Apr 02 10:17:26 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1675M/2042M, Ph+PgF:3208M/3413M, VA:1940M/2047M
Fri Apr 02 10:17:26 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 192937984
__large_pool_size = 4194304
__java_pool_size = 8388608
__streams_pool_size = 0
spfile = D:/ORACLE/PRODUCT/10.2.0/DB_1/DBS/SPFILEORCL.ORA
sga_target = 612368384
control_files = D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/CONTROL01.CTL, D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/CONTROL02.CTL, D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 398458880
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:/oracle/product/10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_allow_resetlogs_corruption= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/ADUMP
background_dump_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/BDUMP
user_dump_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/UDUMP
core_dump_dest = D:/ORACLE/PRODUCT/10.2.0/ADMIN/ORCL/CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
MMAN started with pid=4, OS id=2940
DBW0 started with pid=5, OS id=2960
LGWR started with pid=6, OS id=2972
CKPT started with pid=7, OS id=2976
SMON started with pid=8, OS id=2992
RECO started with pid=9, OS id=2980
CJQ0 started with pid=10, OS id=2536
MMON started with pid=11, OS id=2540
Fri Apr 02 10:17:27 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2500
Fri Apr 02 10:17:27 2010
starting up 1 shared server(s) ...
PSP0 started with pid=3, OS id=2936
Fri Apr 02 10:17:29 2010
alter database mount exclusive
PMON started with pid=2, OS id=2924
Setting recovery target incarnation to 2
Fri Apr 02 10:17:34 2010
Successful mount of redo thread 1, with mount id 1242989625
Fri Apr 02 10:17:34 2010
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Apr 02 10:17:34 2010
alter database open
Fri Apr 02 10:17:37 2010
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Apr 02 10:17:41 2010
Started redo scan
Fri Apr 02 10:17:42 2010
Completed redo scan
1526 redo blocks read, 142 data blocks need recovery
Fri Apr 02 10:17:42 2010
Started redo application at
Thread 1: logseq 95, block 43281
Fri Apr 02 10:17:42 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 95 Reading mem 0
Mem# 0 errs 0: D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG
Fri Apr 02 10:17:42 2010
Completed redo application
Fri Apr 02 10:17:43 2010
Completed crash recovery at
Thread 1: logseq 95, block 44807, scn 3290326
142 data blocks read, 142 data blocks written, 1526 redo blocks read
Fri Apr 02 10:17:49 2010
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=2816
ARC1 started with pid=18, OS id=2828
Fri Apr 02 10:17:49 2010
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Apr 02 10:17:49 2010
ARC0: STARTING ARCH PROCESSES
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Fri Apr 02 10:17:49 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Apr 02 10:17:49 2010
ARC1: Becoming the heartbeat ARCH
ARC2 started with pid=19, OS id=2836
Fri Apr 02 10:17:51 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_3364.trc:
ORA-19815: ??: db_recovery_file_dest_size ?? (? 2147483648 ??) ??? 100.00%, ?? 0 ?????
Fri Apr 02 10:17:51 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:17:51 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_3364.trc:
ORA-19809: ???????????
ORA-19804: ???? 47716352 ?????? (? 2147483648 ???)
ARCH: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_93_U_.ARC'
ARCH: Failed to archive thread 1 sequence 93 (19809)
Fri Apr 02 10:17:52 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Fri Apr 02 10:17:52 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:17:52 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
ARC0: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_94_U_.ARC'
ARC0: Failed to archive thread 1 sequence 94 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:17:53 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-16038: log 3 sequence# 94 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO03.LOG'
Fri Apr 02 10:17:53 2010
ORA-16038 signalled during: alter database open...
Fri Apr 02 10:18:49 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:18:49 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-16014: log 1 sequence# 93 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:19:51 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:20:03 2010
alter database clear unarchived logfile group 3
Fri Apr 02 10:20:04 2010
WARNING! CLEARING REDO LOG WHICH HAS NOT BEEN ARCHIVED. BACKUPS TAKEN
BEFORE 04/02/2010 10:04:56 (CHANGE 3260451) CANNOT BE USED FOR RECOVERY.
Clearing online log 3 of thread 1 sequence number 94
Completed: alter database clear unarchived logfile group 3
Fri Apr 02 10:20:11 2010
alter database open
Fri Apr 02 10:20:20 2010
Thread 1 advanced to log sequence 96
Thread 1 opened at log sequence 96
Current log# 3 seq# 96 mem# 0: D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO03.LOG
Successful open of redo thread 1
Fri Apr 02 10:20:23 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 02 10:20:23 2010
ARC0: Archiving not possible: No primary destinations
Fri Apr 02 10:20:23 2010
SMON: enabling cache recovery
Fri Apr 02 10:20:24 2010
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:20:25 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:20:29 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Apr 02 10:20:31 2010
Successfully onlined Undo Tablespace 1.
Fri Apr 02 10:20:31 2010
SMON: enabling tx recovery
Fri Apr 02 10:20:34 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=1496
Fri Apr 02 10:20:52 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:21:05 2010
Completed: alter database open
Fri Apr 02 10:21:51 2010
alter database noarchivelog
Fri Apr 02 10:21:51 2010
ORA-1126 signalled during: alter database noarchivelog...
Fri Apr 02 10:21:53 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:22:07 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2253K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Fri Apr 02 10:22:50 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:22:52 2010
Shutting down archive processes
Fri Apr 02 10:22:57 2010
ARCH shutting down
ARC2: Archival stopped
Fri Apr 02 10:22:58 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Fri Apr 02 10:22:58 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:22:58 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
ARC0: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_93_U_.ARC'
ARC0: Failed to archive thread 1 sequence 93 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:22:58 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-16038: log 1 sequence# 93 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:23:59 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:24:00 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_2828.trc:
ORA-16014: log 1 sequence# 93 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:25:01 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:26:01 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:27:01 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:27:50 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:28:01 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_2828.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Fri Apr 02 10:28:01 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Apr 02 10:28:01 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_2828.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
ARC1: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_93_U_.ARC'
ARC1: Failed to archive thread 1 sequence 93 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:28:01 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_2828.trc:
ORA-16038: log 1 sequence# 93 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:29:01 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
ARCH: Archival stopped, error occurred. Will continue retrying
Fri Apr 02 10:29:01 2010
Errors in file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_2816.trc:
ORA-16014: log 1 sequence# 93 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
Fri Apr 02 10:30:01 2010
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 93 (4)
Fri Apr 02 10:31:01 2010
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive thread 1 sequence 93 (4)
-------------------------------------------------------------------------------------------------------------
再检查了下dump文件：
-------------------------------------------------------------------------------------------------------------
Dump file d:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc1_5392.trc
Fri Apr 02 09:56:09 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1146M/2042M, Ph+PgF:2150M/3413M, VA:1276M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 17
Windows thread id: 5392, image: ORACLE.EXE (ARC1)
*** SERVICE NAME:() 2010-04-02 09:56:09.203
*** SESSION ID:(155.1) 2010-04-02 09:56:09.203
kcrrwkx: work to do 0x1 (start)
*** 2010-04-02 09:56:09.281 20146 kcrr.c
ORA-16014: log 1 sequence# 93 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'
*** 2010-04-02 09:57:09.312
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 09:58:09.390
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 09:58:09.453 20146 kcrr.c
*** 2010-04-02 09:59:09.468
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:00:09.546
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:00:09.593 20146 kcrr.c
*** 2010-04-02 10:01:09.578
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:02:09.656
kcrrwkx: work to do 0x1 (end)
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
*** 2010-04-02 10:02:09.812
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 47716352 bytes disk space from 2147483648 limit
*** 2010-04-02 10:02:09.828 60680 kcrr.c
ARC1: Error 19809 Creating archive log file to 'D:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ORCL/ARCHIVELOG/2010_04_02/O1_MF_1_89_%U_.ARC'
*** 2010-04-02 10:02:09.828 58942 kcrr.c
kcrrfail: dest:10 err:19809 force:0 blast:1
*** 2010-04-02 10:02:10.000 20146 kcrr.c
ORA-16038: log 2 sequence# 89 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
*** 2010-04-02 10:03:09.750
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:04:09.828
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:04:09.890 20146 kcrr.c
*** 2010-04-02 10:04:58.687
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:04:58.984 20146 kcrr.c
*** 2010-04-02 10:05:11.500
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:06:11.500
tkcrrxmp: Stopping ARC2 to reduce ARCH processes from 3 to 2
kcrrwkx: work to do 0x1 (end)
*** 2010-04-02 10:06:16.640 20146 kcrr.c
-------------------------------------------------------------------------------------------------------------
出现这个问题的原因，在没看相关的日志和dump文件之前猜测是archive造成，同事的本子只是简单的搭了个环境，没必要使用归档，因此使用如下操作过程解决了该问题，记录下。
--------------------------------got it process----------------------------
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 197135236 bytes
Database Buffers 406847488 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
ORA-16038: 日志 2 序列号 89 无法归档
ORA-19809: 超出了恢复文件数的限制
ORA-00312: 联机日志 2 线程 1:
'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
SQL> shutdown immediate;
ORA-01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 197135236 bytes
Database Buffers 406847488 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> archive log list;
数据库日志模式 存档模式
自动存档 启用
存档终点 USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列 89
下一个存档日志序列 89
当前日志序列 94
SQL> archive log stop;
已处理的语句
SQL> shutdown immediate;
ORA-01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 197135236 bytes
Database Buffers 406847488 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> show parameter arch;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string ARC%S_%R.%T
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string %ORACLE_HOME%/RDBMS
SQL> archive log list;
数据库日志模式 存档模式
自动存档 启用
存档终点 USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列 89
下一个存档日志序列 89
当前日志序列 94
SQL> alter system switch logfile;
alter system switch logfile
*
第 1 行出现错误:
ORA-01109: 数据库未打开
SQL> clear
SQL> clear scr;
C:/Documents and Settings/lenovo>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 4月 2 09:55:25 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn /as sysdba
已连接。
SQL> shutdown immediate;
ORA-01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 197135236 bytes
Database Buffers 406847488 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16038: 日志 2 序列号 89 无法归档
ORA-19809: 超出了恢复文件数的限制
ORA-00312: 联机日志 2 线程 1:
'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
SQL> select * from log;
select * from log
*
第 1 行出现错误:
ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询
SQL> select * from logfile;
select * from logfile
*
第 1 行出现错误:
ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询
SQL> archive log next;
ORA-16014: 日志 2 的序列号 89 未归档, 没有可用的目的地
ORA-00312: 联机日志 2 线程 1: 'D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG'
SQL> alter database drop logfile member 'D:/oracle/product/10.2.0/oradata/orcl/
EDO02.LOG';
alter database drop logfile member 'D:/oracle/product/10.2.0/oradata/orcl/REDO0
.LOG'
*
第 1 行出现错误:
ORA-00361: 无法删除最后一个日志成员
D:/oracle/product/10.2.0/oradata/orcl/REDO02.LOG (组 2)
SQL> alter database clear unarchived logfile 'D:/oracle/product/10.2.0/oradata/
rcl/REDO02.LOG';
数据库已更改。
SQL> alter database open;
数据库已更改。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 197135236 bytes
Database Buffers 406847488 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
数据库已经打开。
SQL>
----------------------------------------------------------------------------------------------------
由于是同事的本子的实例，解决过程中并没有考虑其他因素，时候检阅其他文档发现可以如下处理：
(1).flash recovery area的使用情况：
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:/oracle/product/10.2.0/flash
_recovery_area
db_recovery_file_dest_size big integer 2G
SQL> select * from v$flash_recovery_area_usage;
(2).计算flash recovery area已经占用的空间：
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
2.1231
可以看到，这里已经有2.1231G使用了，这说明我们刚开始设置的db_recovery_file_dest_size=2G不足，导致 online redo log无法归档;
通过设置db_recovery_file_dest_size参数，增大了flash recovery area来解决这个问题。
SQL> alter system set db_recovery_file_dest_size=3G scope=both;
系统已更改。
(3).也可以通过删除flash recovery area中不必要的备份来释放flash recovery area空间来解决这个问题：
(1). delete obsolete;
(2). crosscheck backupset;
delete expired backupset;
最后打开数据库；
SQL> alter database open;
-The End-
2011
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
