ORA-16014: log 2 sequence# 59 not archived, no available destinations

oo0yuki0oo發表於2010-10-18

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:ORACLEORADATAORA10GDBREDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:ORACLEORADATAORA10GDBREDO3_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:ORACLEORADATAORA10GDBREDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:ORACLEORADATAORA10GDBREDO3_B.LOG'


SQL> show parameter dump

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
background_core_dump string
partial
background_dump_dest string
D:ORACLEADMINORA10GDBBDUMP
core_dump_dest string
D:ORACLEADMINORA10GDBCDUMP
max_dump_file_size string
UNLIMITED
shadow_core_dump string

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
partial
user_dump_dest string

SQL> exit
Disconnected from Database Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and 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 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:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_03_01O1_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:ORACLEORADATAORA10GDBREDO01.LOG'
ORA-00312: online log 1 thread 1: 'D:ORACLEORADATAORA10GDBREDO01_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:ORACLEORADATAORA10GDBREDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:ORACLEORADATAORA10GDBREDO3_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, , 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:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_63_5OCORYOW_.ARC recid=29 stamp=708739233
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_64_5ODHL1G2_.ARC recid=30 stamp=708765636
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_65_5OFB0DRC_.ARC recid=31 stamp=708792717
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_66_5OG4L9YQ_.ARC recid=32 stamp=708819916
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
1O1_MF_1_67_5OGY3B1F_.ARC recid=33 stamp=708846060
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
1O1_MF_1_68_5OHRFONX_.ARC recid=34 stamp=708873014
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
1O1_MF_1_69_5OJLT4YP_.ARC recid=35 stamp=708900038
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
2O1_MF_1_70_5OKF6NLZ_.ARC recid=36 stamp=708927061
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
2O1_MF_1_71_5OL7L00W_.ARC recid=37 stamp=708954050
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
2O1_MF_1_72_5OM1BJ0X_.ARC recid=38 stamp=708980432
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_73_5OMOT4QV_.ARC recid=39 stamp=709001414
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_74_5ONJM7Y3_.ARC recid=40 stamp=709028840
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_75_5OOBNMQ5_.ARC recid=41 stamp=709055508
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_76_5OP5JWY6_.ARC recid=42 stamp=709083037
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
4O1_MF_1_77_5OPZYS88_.ARC recid=43 stamp=709110106
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
4O1_MF_1_78_5OQN5JQC_.ARC recid=44 stamp=709130801
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
4O1_MF_1_79_5ORGTQ0F_.ARC recid=45 stamp=709158103
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
5O1_MF_1_80_5OS9P5FM_.ARC recid=46 stamp=709185607
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
5O1_MF_1_81_5OSZZDF4_.ARC recid=47 stamp=709208429
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
5O1_MF_1_82_5OTQSKPO_.ARC recid=48 stamp=709232818
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_83_5OVLF76R_.ARC recid=49 stamp=709260072
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_84_5OWDYR4C_.ARC recid=50 stamp=709287258
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_85_5OX3LHWR_.ARC recid=51 stamp=709310417
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_86_5OXY100W_.ARC recid=52 stamp=709337504
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_87_5P53XKGL_.ARC recid=53 stamp=709572917
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_88_5P53XMB6_.ARC recid=54 stamp=709572920
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_89_5P53XPT9_.ARC recid=55 stamp=709572925
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_90_5P53XSKJ_.ARC recid=56 stamp=709572927
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_91_5P53Z5O7_.ARC recid=57 stamp=709572967
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_92_5P55Z6J2_.ARC recid=58 stamp=709575016
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_93_5P5ZVH69_.ARC recid=59 stamp=709601521
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_94_5P62T70G_.ARC recid=60 stamp=709604554
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_95_5P6OGN8P_.ARC recid=61 stamp=709623636
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_96_5P76QW2V_.ARC recid=62 stamp=709641342
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_97_5P7TYHB6_.ARC recid=63 stamp=709662032
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_98_5P8OC5OD_.ARC recid=64 stamp=709689062
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
1O1_MF_1_99_5P9HON1D_.ARC recid=65 stamp=709716020
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
1O1_MF_1_100_5P9V48OX_.ARC recid=66 stamp=709727755
validation failed for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
1O1_MF_1_101_5PBJHS5B_.ARC recid=67 stamp=709749626
validation succeeded for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_02_0
1O1_MF_1_102_5PCBVNPD_.ARC recid=68 stamp=709776633
validation succeeded for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_02_0
1O1_MF_1_103_5PD588GZ_.ARC recid=69 stamp=709803657
validation succeeded for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_02_0
1O1_MF_1_104_5PDHJNCN_.ARC recid=70 stamp=709814165
validation succeeded for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_02_0
1O1_MF_1_105_5PF8CWWR_.ARC recid=71 stamp=709839614
validation succeeded for archived log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_02_0
2O1_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:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_20O1_MF_1_63_5OCORYOW_.ARC
30 1 64 X 2010-01-20 00:00:29 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_20O1_MF_1_64_5ODHL1G2_.ARC
31 1 65 X 2010-01-20 07:20:33 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_20O1_MF_1_65_5OFB0DRC_.ARC
32 1 66 X 2010-01-20 14:51:56 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_20O1_MF_1_66_5OG4L9YQ_.ARC
33 1 67 X 2010-01-20 22:25:13 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_21O1_MF_1_67_5OGY3B1F_.ARC
34 1 68 X 2010-01-21 05:40:57 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_21O1_MF_1_68_5OHRFONX_.ARC
35 1 69 X 2010-01-21 13:10:13 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_21O1_MF_1_69_5OJLT4YP_.ARC
36 1 70 X 2010-01-21 20:40:36 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_22O1_MF_1_70_5OKF6NLZ_.ARC
37 1 71 X 2010-01-22 04:11:00 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_22O1_MF_1_71_5OL7L00W_.ARC
38 1 72 X 2010-01-22 11:40:47 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_22O1_MF_1_72_5OM1BJ0X_.ARC
39 1 73 X 2010-01-22 19:00:31 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_23O1_MF_1_73_5OMOT4QV_.ARC
40 1 74 X 2010-01-23 00:50:12 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_23O1_MF_1_74_5ONJM7Y3_.ARC
41 1 75 X 2010-01-23 08:27:19 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_23O1_MF_1_75_5OOBNMQ5_.ARC
42 1 76 X 2010-01-23 15:51:47 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_23O1_MF_1_76_5OP5JWY6_.ARC
43 1 77 X 2010-01-23 23:30:36 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_24O1_MF_1_77_5OPZYS88_.ARC
44 1 78 X 2010-01-24 07:01:45 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_24O1_MF_1_78_5OQN5JQC_.ARC
45 1 79 X 2010-01-24 12:46:40 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_24O1_MF_1_79_5ORGTQ0F_.ARC
46 1 80 X 2010-01-24 20:21:42 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_25O1_MF_1_80_5OS9P5FM_.ARC
47 1 81 X 2010-01-25 04:00:05 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_25O1_MF_1_81_5OSZZDF4_.ARC
48 1 82 X 2010-01-25 10:20:28 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_25O1_MF_1_82_5OTQSKPO_.ARC
49 1 83 X 2010-01-25 17:06:57 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_26O1_MF_1_83_5OVLF76R_.ARC
50 1 84 X 2010-01-26 00:41:11 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_26O1_MF_1_84_5OWDYR4C_.ARC
51 1 85 X 2010-01-26 08:14:16 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_26O1_MF_1_85_5OX3LHWR_.ARC
52 1 86 X 2010-01-26 14:40:15 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_26O1_MF_1_86_5OXY100W_.ARC
53 1 87 X 2010-01-26 22:11:43 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_29O1_MF_1_87_5P53XKGL_.ARC
54 1 88 X 2010-01-27 05:40:40 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_29O1_MF_1_88_5P53XMB6_.ARC
55 1 89 X 2010-01-27 10:21:01 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_29O1_MF_1_89_5P53XPT9_.ARC
56 1 90 X 2010-01-27 16:00:35 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_29O1_MF_1_90_5P53XSKJ_.ARC
57 1 91 X 2010-01-29 15:35:18 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_29O1_MF_1_91_5P53Z5O7_.ARC
58 1 92 X 2010-01-29 15:36:05 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_29O1_MF_1_92_5P55Z6J2_.ARC
59 1 93 X 2010-01-29 16:10:14 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_29O1_MF_1_93_5P5ZVH69_.ARC
60 1 94 X 2010-01-29 23:31:59 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_30O1_MF_1_94_5P62T70G_.ARC
61 1 95 X 2010-01-30 00:22:30 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_30O1_MF_1_95_5P6OGN8P_.ARC
62 1 96 X 2010-01-30 05:40:36 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_30O1_MF_1_96_5P76QW2V_.ARC
63 1 97 X 2010-01-30 10:35:39 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_30O1_MF_1_97_5P7TYHB6_.ARC
64 1 98 X 2010-01-30 16:20:31 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_30O1_MF_1_98_5P8OC5OD_.ARC
65 1 99 X 2010-01-30 23:51:01 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_31O1_MF_1_99_5P9HON1D_.ARC
66 1 100 X 2010-01-31 07:20:19 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_31O1_MF_1_100_5P9V48OX_.ARC
67 1 101 X 2010-01-31 10:35:52 D:ORACLEFLASH_RECOVERY_AREAORA10GD
BARCHIVELOG2010_01_31O1_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:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_63_5OCORYOW_.ARC recid=29 stamp=708739233
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_64_5ODHL1G2_.ARC recid=30 stamp=708765636
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_65_5OFB0DRC_.ARC recid=31 stamp=708792717
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
0O1_MF_1_66_5OG4L9YQ_.ARC recid=32 stamp=708819916
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
1O1_MF_1_67_5OGY3B1F_.ARC recid=33 stamp=708846060
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
1O1_MF_1_68_5OHRFONX_.ARC recid=34 stamp=708873014
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
1O1_MF_1_69_5OJLT4YP_.ARC recid=35 stamp=708900038
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
2O1_MF_1_70_5OKF6NLZ_.ARC recid=36 stamp=708927061
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
2O1_MF_1_71_5OL7L00W_.ARC recid=37 stamp=708954050
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
2O1_MF_1_72_5OM1BJ0X_.ARC recid=38 stamp=708980432
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_73_5OMOT4QV_.ARC recid=39 stamp=709001414
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_74_5ONJM7Y3_.ARC recid=40 stamp=709028840
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_75_5OOBNMQ5_.ARC recid=41 stamp=709055508
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
3O1_MF_1_76_5OP5JWY6_.ARC recid=42 stamp=709083037
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
4O1_MF_1_77_5OPZYS88_.ARC recid=43 stamp=709110106
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
4O1_MF_1_78_5OQN5JQC_.ARC recid=44 stamp=709130801
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
4O1_MF_1_79_5ORGTQ0F_.ARC recid=45 stamp=709158103
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
5O1_MF_1_80_5OS9P5FM_.ARC recid=46 stamp=709185607
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
5O1_MF_1_81_5OSZZDF4_.ARC recid=47 stamp=709208429
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
5O1_MF_1_82_5OTQSKPO_.ARC recid=48 stamp=709232818
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_83_5OVLF76R_.ARC recid=49 stamp=709260072
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_84_5OWDYR4C_.ARC recid=50 stamp=709287258
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_85_5OX3LHWR_.ARC recid=51 stamp=709310417
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
6O1_MF_1_86_5OXY100W_.ARC recid=52 stamp=709337504
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_87_5P53XKGL_.ARC recid=53 stamp=709572917
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_88_5P53XMB6_.ARC recid=54 stamp=709572920
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_89_5P53XPT9_.ARC recid=55 stamp=709572925
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_90_5P53XSKJ_.ARC recid=56 stamp=709572927
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_91_5P53Z5O7_.ARC recid=57 stamp=709572967
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_92_5P55Z6J2_.ARC recid=58 stamp=709575016
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_2
9O1_MF_1_93_5P5ZVH69_.ARC recid=59 stamp=709601521
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_94_5P62T70G_.ARC recid=60 stamp=709604554
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_95_5P6OGN8P_.ARC recid=61 stamp=709623636
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_96_5P76QW2V_.ARC recid=62 stamp=709641342
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_97_5P7TYHB6_.ARC recid=63 stamp=709662032
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
0O1_MF_1_98_5P8OC5OD_.ARC recid=64 stamp=709689062
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
1O1_MF_1_99_5P9HON1D_.ARC recid=65 stamp=709716020
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
1O1_MF_1_100_5P9V48OX_.ARC recid=66 stamp=709727755
deleted archive log
archive log filename=D:ORACLEFLASH_RECOVERY_AREAORA10GDBARCHIVELOG2010_01_3
1O1_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>


[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8337095/viewspace-1039913/,如需轉載,請註明出處,否則將追究法律責任。

相關文章