ORA-16019: cannot use LOG_ARCHIVE_DEST_1 解决方法

本文涉及的产品
日志服务 SLS,月写入数据量 50GB 1个月
简介: 在设置DATA GUARD 时,修改了系统参数,重启数据库后出错:SQL> shutdown immediate;Database closed.

在设置DATA GUARD 时,修改了系统参数,重启数据库后出错:

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
SQL> alter system set log_archive_dest_1='+RECOVERY/racdb/archivelog/' scope=spfile;
alter system set log_archive_dest_1='+RECOVERY/racdb/archivelog/' scope=spfile
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 19 Serial number: 48797


计划从spfile 生成pfile 文件:

[oracle@rac1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 19 11:42:10 2011

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

SQL> connetc / as sysdba
SP2-0734: unknown command beginning "connetc / ..." - rest of line ignored.
SQL> connect /as sysdba
Connected to an idle instance.

SQL> create pfile='init.ora' from spfile;
create pfile='init.ora' from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


出错,找不到文件和目录,我环境为RAC+ASM.

指定文件


SQL> create pfile='init.ora' from spfile='+data/racdb/spfileracdb.ora';

File created.

SQL> startup pfile='init.ora';
LRM-00109: could not open parameter file 'init.ora'
ORA-01078: failure in processing system parameters
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup pfile='/opt/app/oracle/product/11.2.0/dbs/init.ora';
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORACLE instance started.

Total System Global Area 3.2603E+10 bytes
Fixed Size            2214816 bytes
Variable Size         1.8254E+10 bytes
Database Buffers     1.4227E+10 bytes
Redo Buffers          120008704 bytes
Database mounted.

Database opened.


把pfile 修改回以前文件。

[root@rac1 dbs]# cp initracdb1.ora.org initracdb1.ora
cp:是否覆盖“initracdb1.ora”? y

(修改前有备份此文件)


[root@rac1 dbs]# cat initracdb1.ora
SPFILE='+DATA/racdb/spfileracdb.ora'


再重新建立 SPFILE:


create spfile='+data/racdb/spfileracdb.ora' from pfile='/opt/app/oracle/product/11.2.0/dbs/init.ora';


(

要指定pfile 具体文件。不然生成pfile 无效,

我在这里错了。出现错误:

ORA-01506: missing or illegal database name

)

指定数据库启动时加载参数文件的路径

alter system set spfile='+DATA/ORCL/spfileorcl.ora';


相关实践学习
日志服务之使用Nginx模式采集日志
本文介绍如何通过日志服务控制台创建Nginx模式的Logtail配置快速采集Nginx日志并进行多维度分析。
目录
相关文章
|
12月前
|
jenkins 持续交付
项目采坑日志——cannot create a build with number 9 since that (or higher) is already in use among [12]
项目采坑日志——cannot create a build with number 9 since that (or higher) is already in use among [12]
133 0
|
8月前
|
Apache
系统找不到指定的路径。 : AH02291: Cannot access directory ‘D:/xp.cn/www/wwwroot/admin/PhpTest_10006/log/‘ for e
系统找不到指定的路径。 : AH02291: Cannot access directory ‘D:/xp.cn/www/wwwroot/admin/PhpTest_10006/log/‘ for e
43 0
|
11月前
|
Java
Lombok @Slf4j log对象没有info等方法 不可用解决方法
Lombok @Slf4j log对象没有info等方法 不可用解决方法
316 0
|
Java Maven
Cannot resolve org.apache.logging.log4j:log4j-api:2.16.0
Cannot resolve org.apache.logging.log4j:log4j-api:2.16.0
208 0
|
Java Maven
Class org.apache.commons.logging.impl.Jdk14Logger does not implement Log 解决方法
org.apache.commons.logging.LogConfigurationException: Class org.apache.commons.logging.impl.Jdk14Logger does not implement Log at org.apache.commons.logging.impl.LogFactoryImpl.getLogConstructor(LogFactoryImpl.java:400) at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.jav
197 0
|
负载均衡 应用服务中间件 Linux
只能使用UDP:514端口接收Syslog日志的两种解决方法
只能使用UDP:514端口接收Syslog日志的两种解决方法
2651 0
只能使用UDP:514端口接收Syslog日志的两种解决方法
|
Go 数据库
|
Go iOS开发
The operation couldn’t be completed. Unable to log in with account 'myappleid'. An unexpected failure occurred while logging in (Underlying error code 1100).解决方法
The operation couldn’t be completed. Unable to log in with account 'myappleid'. An unexpected failure occurred while logging in (Underlying error code 1100).解决方法
382 0
|
安全 Java 程序员
突发!Apache Log4j2 报核弹级漏洞。。赶紧修复!!附解决方法
突发!Apache Log4j2 报核弹级漏洞。。赶紧修复!!附解决方法
183 0