ORA-16014: log 3 sequence# 107 not archived, no available destinations

最新推荐文章于 2021-04-04 00:08:17 发布
最新推荐文章于 2021-04-04 00:08:17 发布
阅读量182 收藏
点赞数

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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8102208/viewspace-628288/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8102208/viewspace-628288/

congtudi4111
关注
ORA-16014 ,ORA-00312 oracle备库错误解决记录
hellion2的专栏
10-13 1469
日志的错误信息 RFS[2]: No standby redo logfiles available for thread 1 ORA-16014: log 4 sequence# 113 not archived, no available destinations ORA-00312: online log 4 thread 1: '/data/oracle/oradata/orcl/stdredo01.log' 现象： Oracle11g，从主库spfile生产pfile方法创建备库之后，使.
ORA-16014: 日志 3 的序列号 187 未归档, 没有可用的目的地 问题解析与解决方法
lpwebnet的专栏
01-04 901
此问题，其实由于归档日志已满导致的。 解决方法：                  1、删除老旧的归档日志；                  2、增加归档日志大小； 下面详细案例,仅供参考； Microsoft Windows XP [版本 5.1.2600] (C) 版权所有 1985-2001 Microsoft Corp. C:\Documents and Setti
160;oracle&,关于ORA-16014一次惊险经历
weixin_39692254的博客
04-04 68
本帖最后由 mingjie1116 于 2013-5-21 10:28 编辑今天开发有个同事让我调整一个ORACLE参数，需要重启才能生效，然后，我就重启数据库，但非常慢，于是，我查看进程好像数据库后台没有什么操作了，可以顺利关闭，但一直关闭不了，心急了我就直接kill 掉类似ora_arc8_tclscm 的进程(其实这种操作是非常危险的)，然后启动数据库，结果报错：ORA-16014: log...
ORA-16014: not archived, no available destinations
夜未眠风已息
11-30 1700
问题现象： 同步数据失败，查看alert_orcl.log显示如下错误 ORACLE Instance orcl - Archival Error ORA-16014: log 4 sequence# 10 not archived, no available destinations ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/orcl/standby_log04.log' 问题原因： 参数log_archive..
ORA-16014: log 3 sequence# 540 not archived, no available destinations
weixin_30814223的博客
07-16 187
https://blog.csdn.net/zonelan/article/details/7329369 转载于:https://www.cnblogs.com/onlybobby/p/9317355.html
ORA-16014: log string sequence# string not archived, no available destinations Flash Recovery Area 空间不足
David Dai -- Focus on Oracle
04-28 8605
 今天一网友问我一个问题，数据库报错，错误信息如下：   Errors in file e:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_5620.trc:ORA-16014: log 2 sequence# 195 not archived, no available destinationsORA-00312: online
oracle19504,ORA-19504: failed to create file "" 一则案例
weixin_42120563的博客
04-03 1518
今天检查自己测试库的时候，发现日志狂报ORA-19504: failed to create file ""Thread 1 advanced to log sequence 156 (LGWR switch)Current log# 3 seq# 156 mem# 0: +DATA/netdata/onlinelog/group_3.261.882674015Tue Jul 14 14:01:0...
ORA-16038简单的处理过程
Gtlions Tracker
04-09 653
今天同事的笔记本上的一个oracle 10g实例出现了错误，同事无法处理，我就接过来看了下并解决之。 解决过程记录如下。 检查了下alter日志： ------------------------------------------------------------------------------------------------------------- Fri Apr 02 0
Data Guard ORA-16825、ORA-16661解决一例
crc89714的博客
04-05 644
某天凌晨5点左右，被客户方运维人员电话吵醒，客户的交换机因故重启，导致做了RHCS的两台Linux服务器（非oracle服务器）因心跳问题也导致重启 第一时间登上去查看oracle运行情况,发现主库已是mount状态，备库...
ORA-16014: log 1 sequence# 4 not archived, no available destinations
clhljaa02293633的博客
08-22 644
今天重新建了一个库，在执行 alter system switch logfile;时一直夯在那里，于是查看警报日志文件，有如下信息： Thu Aug 21 19:25:30 2014 Errors in file /u0...
ORA-16014: log 2 sequence# 59 not archived, no available destinations
ctz51934的博客
10-18 565
SQL> select status from v$instance;STATUS------------------------MOUNTEDSQL> alter database open;alter datab...
ORA-16014: log 4 sequence# 1 not archived , 今天解决了
shenghuiping2001的专栏
12-31 2450
今天在dataguard 备库起recover 的时候报错： ORA-16014: log 4 sequence# 1 not archived, no available destinations 解决下面第一种方法： 先看 SQL> show parameter db_recovery NAME                                 TYPE
ORA-16014: log string sequence# string not archived, no available destinations F
tangrobin的专栏
12-06 645
Errors in file e:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_5620.trc: ORA-16014: log 2 sequence# 195 not archived, no available destinations ORA-00312: online log 2 thread 1: 'E:/ORACLE/PRODU
ORA-16014: log 4 sequence# 16 not archived, no available destinations
huangliang0703的专栏
11-18 2013
搭建好DG，发现备库上报如下错误： ORA-16014: log 4 sequence# 16 not archived, no available destinations ORA-00312: online log 4 thread 1: '/export/11g/oradata/orcl/redo04.log' Errors in file /export/11g/diag/r...
ORA-16014: log 2 sequence# not archived, no available destinations"
Rebulid Myself
09-29 3273
DB服务器磁盘满了，从log中看到如下错误， ORA-00312: online log 1 thread 1: '/data/ora_data01/SELADEVW/SELADEVW/redo01.log'  ORACLE Instance SELADEVW - Archival Error  ORA-16014: log 2 sequence# 9389 not
ORA-16014: log 4 sequence# 1 not archived, no available destinations
05-24 500
RAC节点启动实例到mount后，session一直卡在那儿，没有报错。查看警告日志发现ORA-16014报错 根据提示为归档日志的问题 查看归档日志情况如下： SQL> archive log list ...
ORA-16014: log string sequence# string not archived, no available destinations
隐0士的博客
07-09 457
Errors in file e:/oracle/product/10.2.0/admin/orcl/bdump/orcl_arc0_5620.trc: ORA-16014: log 2 sequence# 195 not archived, no available destinations ORA-00312: online log 2 thread 1: 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO02.LOG' 先来分析一下为什么会出现这个问题。..
长春人文学院在河北2021-2024各专业最低录取分数及位次表.pdf
最新发布
09-16
全国各大学在河北2021-2024年各专业最低录取分数及录取位次数据，高考志愿必备参考数据
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
09-16
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist是一个错误代码，表示Oracle数据库不可用或共享内存区域不存在。这个错误通常是由于数据库实例未能正确启动或配置问题引起的。要解决这个问题，可以尝试以下步骤： 1. 确保Oracle数据库实例已正确启动。可以使用命令"lsnrctl status"来检查监听器的状态，并使用命令"sqlplus / as sysdba"登录到数据库实例。 2. 如果数据库实例未启动，请尝试使用命令"startup"来启动实例。如果遇到权限问题，可以尝试以管理员身份运行命令提示符或使用适当的权限登录到系统。 3. 如果数据库实例已经启动，但仍然遇到错误，请检查数据库的日志文件，如alert日志、trace文件等，以获取更多详细信息。这些文件通常位于数据库安装目录的相应子目录中。 4. 如果错误仍然存在，可以尝试重新配置数据库实例的参数。可以通过编辑数据库的初始化参数文件（init.ora或spfile）来修改参数值，并重启实例使其生效。 5. 如果以上步骤都无效，可以尝试重新安装或升级Oracle数据库。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值