SQL> select status from v$instance;
STATUS
------------------------
MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 3 sequence# 107 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO3_B.LOG'
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 107
Next log sequence to archive 107
Current log sequence 110
SQL> show parameter recovery
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_recovery_file_dest string
D:\oracle/flash_recovery_area
db_recovery_file_dest_size big integer
2G
recovery_parallelism integer
0
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 3 sequence# 107 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO3_B.LOG'
SQL> show parameter dump
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
background_core_dump string
partial
background_dump_dest string
D:\ORACLE\ADMIN\ORA10GDB\BDUMP
core_dump_dest string
D:\ORACLE\ADMIN\ORA10GDB\CDUMP
max_dump_file_size string
UNLIMITED
shadow_core_dump string
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
partial
user_dump_dest string
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
查看LOG文件：
*** SERVICE NAME:() 2010-03-01 15:47:25.058
*** SESSION ID:(155.3) 2010-03-01 15:47:25.058
kcrrwkx: work to do 0x1 (start)
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
*** 2010-03-01 15:47:26.136
************************************************************************
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 47840256 bytes disk space from 2147483648 limit
*** 2010-03-01 15:47:26.183 60680 kcrr.c
ARC0: Error 19809 Creating archive log file to 'D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_03_01\O1_MF_1_108_%U_.ARC'
*** 2010-03-01 15:47:26.183 58942 kcrr.c
kcrrfail: dest:10 err:19809 force:0 blast:1
*** 2010-03-01 15:47:26.214 20146 kcrr.c
ORA-16038: log 1 sequence# 108 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO01.LOG'
ORA-00312: online log 1 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO01_B'
*** 2010-03-01 15:48:24.872
*** 2010-03-01 15:48:24.872 20146 kcrr.c
ORA-16014: log 3 sequence# 107 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:\ORACLE\ORADATA\ORA10GDB\REDO3_B.LOG'
*** 2010-03-01 15:50:24.984
*** 2010-03-01 15:50:24.984 20146 kcrr.c
之前手动删除归档日志后没有crosscheck archivelog all
C:\>rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Mar 1 15:56:03 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10GDB (DBID=1730206972, not open)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=151 devtype=DISK
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_63_5OCORYOW_.ARC recid=29 stamp=708739233
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_64_5ODHL1G2_.ARC recid=30 stamp=708765636
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_65_5OFB0DRC_.ARC recid=31 stamp=708792717
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_66_5OG4L9YQ_.ARC recid=32 stamp=708819916
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
1\O1_MF_1_67_5OGY3B1F_.ARC recid=33 stamp=708846060
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
1\O1_MF_1_68_5OHRFONX_.ARC recid=34 stamp=708873014
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
1\O1_MF_1_69_5OJLT4YP_.ARC recid=35 stamp=708900038
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
2\O1_MF_1_70_5OKF6NLZ_.ARC recid=36 stamp=708927061
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
2\O1_MF_1_71_5OL7L00W_.ARC recid=37 stamp=708954050
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
2\O1_MF_1_72_5OM1BJ0X_.ARC recid=38 stamp=708980432
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_73_5OMOT4QV_.ARC recid=39 stamp=709001414
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_74_5ONJM7Y3_.ARC recid=40 stamp=709028840
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_75_5OOBNMQ5_.ARC recid=41 stamp=709055508
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_76_5OP5JWY6_.ARC recid=42 stamp=709083037
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
4\O1_MF_1_77_5OPZYS88_.ARC recid=43 stamp=709110106
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
4\O1_MF_1_78_5OQN5JQC_.ARC recid=44 stamp=709130801
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
4\O1_MF_1_79_5ORGTQ0F_.ARC recid=45 stamp=709158103
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
5\O1_MF_1_80_5OS9P5FM_.ARC recid=46 stamp=709185607
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
5\O1_MF_1_81_5OSZZDF4_.ARC recid=47 stamp=709208429
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
5\O1_MF_1_82_5OTQSKPO_.ARC recid=48 stamp=709232818
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_83_5OVLF76R_.ARC recid=49 stamp=709260072
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_84_5OWDYR4C_.ARC recid=50 stamp=709287258
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_85_5OX3LHWR_.ARC recid=51 stamp=709310417
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_86_5OXY100W_.ARC recid=52 stamp=709337504
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_87_5P53XKGL_.ARC recid=53 stamp=709572917
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_88_5P53XMB6_.ARC recid=54 stamp=709572920
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_89_5P53XPT9_.ARC recid=55 stamp=709572925
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_90_5P53XSKJ_.ARC recid=56 stamp=709572927
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_91_5P53Z5O7_.ARC recid=57 stamp=709572967
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_92_5P55Z6J2_.ARC recid=58 stamp=709575016
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_93_5P5ZVH69_.ARC recid=59 stamp=709601521
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_94_5P62T70G_.ARC recid=60 stamp=709604554
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_95_5P6OGN8P_.ARC recid=61 stamp=709623636
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_96_5P76QW2V_.ARC recid=62 stamp=709641342
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_97_5P7TYHB6_.ARC recid=63 stamp=709662032
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_98_5P8OC5OD_.ARC recid=64 stamp=709689062
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
1\O1_MF_1_99_5P9HON1D_.ARC recid=65 stamp=709716020
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
1\O1_MF_1_100_5P9V48OX_.ARC recid=66 stamp=709727755
validation failed for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
1\O1_MF_1_101_5PBJHS5B_.ARC recid=67 stamp=709749626
validation succeeded for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_02_0
1\O1_MF_1_102_5PCBVNPD_.ARC recid=68 stamp=709776633
validation succeeded for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_02_0
1\O1_MF_1_103_5PD588GZ_.ARC recid=69 stamp=709803657
validation succeeded for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_02_0
1\O1_MF_1_104_5PDHJNCN_.ARC recid=70 stamp=709814165
validation succeeded for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_02_0
1\O1_MF_1_105_5PF8CWWR_.ARC recid=71 stamp=709839614
validation succeeded for archived log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_02_0
2\O1_MF_1_106_5PG4GTPR_.ARC recid=72 stamp=709868380
Crosschecked 44 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=151 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - ------------------- ----
29 1 63 X 2010-01-19 17:05:16 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_20\O1_MF_1_63_5OCORYOW_.ARC
30 1 64 X 2010-01-20 00:00:29 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_20\O1_MF_1_64_5ODHL1G2_.ARC
31 1 65 X 2010-01-20 07:20:33 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_20\O1_MF_1_65_5OFB0DRC_.ARC
32 1 66 X 2010-01-20 14:51:56 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_20\O1_MF_1_66_5OG4L9YQ_.ARC
33 1 67 X 2010-01-20 22:25:13 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_21\O1_MF_1_67_5OGY3B1F_.ARC
34 1 68 X 2010-01-21 05:40:57 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_21\O1_MF_1_68_5OHRFONX_.ARC
35 1 69 X 2010-01-21 13:10:13 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_21\O1_MF_1_69_5OJLT4YP_.ARC
36 1 70 X 2010-01-21 20:40:36 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_22\O1_MF_1_70_5OKF6NLZ_.ARC
37 1 71 X 2010-01-22 04:11:00 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_22\O1_MF_1_71_5OL7L00W_.ARC
38 1 72 X 2010-01-22 11:40:47 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_22\O1_MF_1_72_5OM1BJ0X_.ARC
39 1 73 X 2010-01-22 19:00:31 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_23\O1_MF_1_73_5OMOT4QV_.ARC
40 1 74 X 2010-01-23 00:50:12 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_23\O1_MF_1_74_5ONJM7Y3_.ARC
41 1 75 X 2010-01-23 08:27:19 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_23\O1_MF_1_75_5OOBNMQ5_.ARC
42 1 76 X 2010-01-23 15:51:47 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_23\O1_MF_1_76_5OP5JWY6_.ARC
43 1 77 X 2010-01-23 23:30:36 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_24\O1_MF_1_77_5OPZYS88_.ARC
44 1 78 X 2010-01-24 07:01:45 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_24\O1_MF_1_78_5OQN5JQC_.ARC
45 1 79 X 2010-01-24 12:46:40 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_24\O1_MF_1_79_5ORGTQ0F_.ARC
46 1 80 X 2010-01-24 20:21:42 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_25\O1_MF_1_80_5OS9P5FM_.ARC
47 1 81 X 2010-01-25 04:00:05 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_25\O1_MF_1_81_5OSZZDF4_.ARC
48 1 82 X 2010-01-25 10:20:28 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_25\O1_MF_1_82_5OTQSKPO_.ARC
49 1 83 X 2010-01-25 17:06:57 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_26\O1_MF_1_83_5OVLF76R_.ARC
50 1 84 X 2010-01-26 00:41:11 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_26\O1_MF_1_84_5OWDYR4C_.ARC
51 1 85 X 2010-01-26 08:14:16 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_26\O1_MF_1_85_5OX3LHWR_.ARC
52 1 86 X 2010-01-26 14:40:15 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_26\O1_MF_1_86_5OXY100W_.ARC
53 1 87 X 2010-01-26 22:11:43 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_29\O1_MF_1_87_5P53XKGL_.ARC
54 1 88 X 2010-01-27 05:40:40 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_29\O1_MF_1_88_5P53XMB6_.ARC
55 1 89 X 2010-01-27 10:21:01 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_29\O1_MF_1_89_5P53XPT9_.ARC
56 1 90 X 2010-01-27 16:00:35 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_29\O1_MF_1_90_5P53XSKJ_.ARC
57 1 91 X 2010-01-29 15:35:18 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_29\O1_MF_1_91_5P53Z5O7_.ARC
58 1 92 X 2010-01-29 15:36:05 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_29\O1_MF_1_92_5P55Z6J2_.ARC
59 1 93 X 2010-01-29 16:10:14 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_29\O1_MF_1_93_5P5ZVH69_.ARC
60 1 94 X 2010-01-29 23:31:59 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_30\O1_MF_1_94_5P62T70G_.ARC
61 1 95 X 2010-01-30 00:22:30 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_30\O1_MF_1_95_5P6OGN8P_.ARC
62 1 96 X 2010-01-30 05:40:36 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_30\O1_MF_1_96_5P76QW2V_.ARC
63 1 97 X 2010-01-30 10:35:39 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_30\O1_MF_1_97_5P7TYHB6_.ARC
64 1 98 X 2010-01-30 16:20:31 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_30\O1_MF_1_98_5P8OC5OD_.ARC
65 1 99 X 2010-01-30 23:51:01 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_31\O1_MF_1_99_5P9HON1D_.ARC
66 1 100 X 2010-01-31 07:20:19 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_31\O1_MF_1_100_5P9V48OX_.ARC
67 1 101 X 2010-01-31 10:35:52 D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GD
B\ARCHIVELOG\2010_01_31\O1_MF_1_101_5PBJHS5B_.ARC
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_63_5OCORYOW_.ARC recid=29 stamp=708739233
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_64_5ODHL1G2_.ARC recid=30 stamp=708765636
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_65_5OFB0DRC_.ARC recid=31 stamp=708792717
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
0\O1_MF_1_66_5OG4L9YQ_.ARC recid=32 stamp=708819916
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
1\O1_MF_1_67_5OGY3B1F_.ARC recid=33 stamp=708846060
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
1\O1_MF_1_68_5OHRFONX_.ARC recid=34 stamp=708873014
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
1\O1_MF_1_69_5OJLT4YP_.ARC recid=35 stamp=708900038
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
2\O1_MF_1_70_5OKF6NLZ_.ARC recid=36 stamp=708927061
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
2\O1_MF_1_71_5OL7L00W_.ARC recid=37 stamp=708954050
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
2\O1_MF_1_72_5OM1BJ0X_.ARC recid=38 stamp=708980432
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_73_5OMOT4QV_.ARC recid=39 stamp=709001414
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_74_5ONJM7Y3_.ARC recid=40 stamp=709028840
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_75_5OOBNMQ5_.ARC recid=41 stamp=709055508
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
3\O1_MF_1_76_5OP5JWY6_.ARC recid=42 stamp=709083037
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
4\O1_MF_1_77_5OPZYS88_.ARC recid=43 stamp=709110106
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
4\O1_MF_1_78_5OQN5JQC_.ARC recid=44 stamp=709130801
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
4\O1_MF_1_79_5ORGTQ0F_.ARC recid=45 stamp=709158103
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
5\O1_MF_1_80_5OS9P5FM_.ARC recid=46 stamp=709185607
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
5\O1_MF_1_81_5OSZZDF4_.ARC recid=47 stamp=709208429
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
5\O1_MF_1_82_5OTQSKPO_.ARC recid=48 stamp=709232818
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_83_5OVLF76R_.ARC recid=49 stamp=709260072
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_84_5OWDYR4C_.ARC recid=50 stamp=709287258
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_85_5OX3LHWR_.ARC recid=51 stamp=709310417
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
6\O1_MF_1_86_5OXY100W_.ARC recid=52 stamp=709337504
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_87_5P53XKGL_.ARC recid=53 stamp=709572917
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_88_5P53XMB6_.ARC recid=54 stamp=709572920
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_89_5P53XPT9_.ARC recid=55 stamp=709572925
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_90_5P53XSKJ_.ARC recid=56 stamp=709572927
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_91_5P53Z5O7_.ARC recid=57 stamp=709572967
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_92_5P55Z6J2_.ARC recid=58 stamp=709575016
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_2
9\O1_MF_1_93_5P5ZVH69_.ARC recid=59 stamp=709601521
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_94_5P62T70G_.ARC recid=60 stamp=709604554
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_95_5P6OGN8P_.ARC recid=61 stamp=709623636
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_96_5P76QW2V_.ARC recid=62 stamp=709641342
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_97_5P7TYHB6_.ARC recid=63 stamp=709662032
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
0\O1_MF_1_98_5P8OC5OD_.ARC recid=64 stamp=709689062
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
1\O1_MF_1_99_5P9HON1D_.ARC recid=65 stamp=709716020
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
1\O1_MF_1_100_5P9V48OX_.ARC recid=66 stamp=709727755
deleted archive log
archive log filename=D:\ORACLE\FLASH_RECOVERY_AREA\ORA10GDB\ARCHIVELOG\2010_01_3
1\O1_MF_1_101_5PBJHS5B_.ARC recid=67 stamp=709749626
Deleted 39 EXPIRED objects
RMAN> alter database open;
database opened
RMAN> exit
Recovery Manager complete.
C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 1 16:01:26 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select status from v$instance;
STATUS
------------------------
OPEN
SQL>