oracle ora 16014,ORA-16014 ORA-00312错误解决

Oracle错误：SQL> conn已连接。SQL> select count(*) from customer;ORA-16014: 日志 3 的序列号 43 未归档, 没有可用的目的地ORA-00312: 联机日志 3 线程 1:'D:\ORACLE\PRODUCT\10.2.0\ORADATA\BOL\ONLINELOG\O1_MF_3_48BZNZBQ_.LOG'ORA-00312: 联机日志 3 线程 1:'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\BOL\ONLINELOG\O1_MF_3_48BZNZJ3_.LOG'

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 9月 24 17:33:46

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connas sysdba已连接。SQL> select status from v$instance;

STATUS------------MOUNTED

SQL> alter database open;alter database open*第 1 行出现错误:ORA-16014: 日志 3 的序列号 43 未归档, 没有可用的目的地ORA-00312: 联机日志 3 线程 1:'D:\ORACLE\PRODUCT\10.2.0\ORADATA\BOL\ONLINELOG\O1_MF_3_48BZNZBQ_.LOG'ORA-00312: 联机日志 3 线程 1:'D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\BOL\ONLINELOG\O1_MF_3_48BZNZJ3_.LOG'

SQL> shutdown immediate;ORA-01109: 未打开

已经卸载数据库。ORACLE 例程已经关闭。SQL>SQL> startup nomountORA-24324: 未初始化服务句柄ORA-01041: 内部错误, hostdef 扩展名不存在SQL>SQL>SQL> show parameter spfile

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string      D:\ORACLE\PRODUCT\10.2.0\DB_1\                                                 DBS\SPFILEBOL.ORASQL> show parameter log_archive

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------log_archive_config                   stringlog_archive_dest                     stringlog_archive_dest_1                   stringlog_archive_dest_10                  stringlog_archive_dest_2                   stringlog_archive_dest_3                   stringlog_archive_dest_4                   stringlog_archive_dest_5                   stringlog_archive_dest_6                   stringlog_archive_dest_7                   stringlog_archive_dest_8                   string

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------log_archive_dest_9                   stringlog_archive_dest_state_1             string      enablelog_archive_dest_state_10            string      enablelog_archive_dest_state_2             string      enablelog_archive_dest_state_3             string      enablelog_archive_dest_state_4             string      enablelog_archive_dest_state_5             string      enablelog_archive_dest_state_6             string      enablelog_archive_dest_state_7             string      enablelog_archive_dest_state_8             string      enablelog_archive_dest_state_9             string      enable

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------log_archive_duplex_dest              stringlog_archive_format                   string      ARC%S_%R.%Tlog_archive_local_first              boolean     TRUElog_archive_max_processes            integer     2log_archive_min_succeed_dest         integer     1log_archive_start                    boolean     FALSElog_archive_trace                    integer     0

SQL> alter system set log_archive_dest='LOCATION=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BOL';alter system set log_archive_dest='LOCATION=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BOL'*第 1 行出现错误:ORA-02097: 无法修改参数, 因为指定的值无效ORA-16018: 无法将 LOG_ARCHIVE_DEST 与 LOG_ARCHIVE_DEST_n 或DB_RECOVERY_FILE_DEST 一起使用

SQL> alter system set log_archive_dest_1='LOCATION=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BOL';

系统已更改。

SQL> alter database open;

数据库已更改。