ORA-16014: log 2 sequence# 59 not archived, no available destinations
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-16014: log 1 sequence# 4 not archived, no available destinationsHiveAI
- ORA-16014: log 1 sequence# 857 not archived, no available destinationsHiveAI
- 【oracle】ORA-16038: log 2 sequence# 98 cannot be archivedOracleHive
- Archived redolog is (significant) smaller than the redologfileHiveNifi
- 【REDO】Archived redolog is (significant) smaller than the redologfileHiveNifi
- Archived redolog is (significant) smaller than the redologfile_1356604.1HiveNifi
- RMAN-05541: no archived logs found in target databaseHiveDatabase
- OGG-00446 ERROR: Could not find archived logErrorHive
- RMAN-08137: WARNING: Archived Log Not DeletedHivedelete
- ogg GGS ERROR 500 Could not find archived logErrorHive
- Managing multiple archive log destinations with RMAN (Doc ID 443814.1)Hive
- Log actively being archived by another process問題解決Hive
- oracle 9i physical standby database 上的v$archived_logOracleDatabaseHive
- Archived Redo Logs歸檔重做日誌介紹及其優點Hive
- 清除Oracle控制檔案中的歸檔資訊v$archived_logOracleHive
- RMAN-08137: WARNING: archived log not deleted, needed for standby or upstreamHivedelete
- Alert.log shows No Standby Redo Logfiles Of Size 153600 Blocks AvailableBloCAI
- RMAN-06054: media recovery requesting unknown archived log for thread...Hivethread
- RMAN 中V$ARCHIVED_LOG 中STATUS 為"X" 的檔案處理Hive
- 更新啦!第 59 期《HelloGitHub》開源月刊Github
- weblogic.common.ResourceException: No good connections available.WebExceptionGoAI
- rman 刪除v$archive_log檢視裡的記錄(Removing entries in v$archived_log)HiveREM
- Alert.log shows No stdby Redo Logfiles Of Size 153600 Blocks Available-405836.1BloCAI
- 59
- VL59 根據RTL圖編寫Verilog程式
- Archiving not possible: No primary destinations errorsError
- 【實驗】【Archived Log】歸檔日誌格式和歸檔路徑之change趣談Hive
- 資料庫關不掉,報No primary destinations資料庫
- YaST2 error: (gnomesu): CRITICAL **: There are no services for 'libgnomesu' available.ASTErrorAI
- weblogic 2Web
- InputStream之available()AI
- No free sectors availableAI
- Servlet action is not availableServletAI
- OPPO A59怎麼樣? OPPO A59評測
- ORA-16014錯誤解決辦法
- OPPO A59和一加2區別對比評測
- OPPO A59與樂視樂2區別對比評測
- 【Archived Log】通過日誌切換頻率推算出存放歸檔日誌所需的空間Hive