最近关注了下Oracle 19C相关信息,发现19C通过官方认证的版本里面尽然没有了redhat 6系列,在以往的版本发布中,一般都支持两类的linux,至此就只支持Linux 7,而且要求7.4及其以上版本




参考:https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/database-installation-guide-linux.pdf
dg备库mount报ORA-07217
在一次搭建dg过程中,备库无法mount,报ORA-07217: sltln: environment variable cannot be evaluated.错误
[oracle@localhost orcl]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 13 22:27:31 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter database mount; alter database mount * ERROR at line 1: ORA-07217: sltln: environment variable cannot be evaluated.
alert日志报错
Set as converted control file due to db_unique_name mismatch Changing di2dbun from ORCL to ORCLDG ORA-7217 signalled during: alter database mount... Wed Feb 13 20:33:41 2019 alter database mount ORA-7217 signalled during: alter database mount... Wed Feb 13 20:36:11 2019 alter database mount ORA-7217 signalled during: alter database mount...
根据mos排查
根据mos ORA-07217: sltln: environment variable cannot be evaluated (Doc ID 2487898.1)描述排查,确认不是该问题
SQL> show parameter diag; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ diagnostic_dest string /u01/app/oracle [oracle@dg:/opt/app/oracle/arch]$env|grep ORA ORACLE_SID=orcl ORACLE_BASE=/opt/app/oracle ORACLE_TERM=xterm ORACLE_HOME=/opt/app/oracle/product/11.2.0/db_1
检查发现数据文件异常
SQL> select name from v$datafile where name like '%$%'; NAME ------------------------------------------------------ +DATA/orcl/datafile/ts_his$emr01 +DATA/orcl/datafile/ts_his$emr02
通过分析,注释掉db_file_name_convert=’+DATA/orcl/datafile/’,’/u01/app/oradata/orcl/’即可正常mount成功,数据文件命令一定要规范(不要有特殊符号),不然给后人和自己留下巨坑
数据库open成功,但是有undo文件异常报ORA-00376
Mon Feb 04 07:43:18 中国标准时间 2019 Completed: alter database open Mon Feb 04 07:43:18 中国标准时间 2019 ALTER SYSTEM disable restricted session; Mon Feb 04 07:43:19 中国标准时间 2019 ORA-376 encountered when generating server alert SMG-4120 Mon Feb 04 07:43:19 中国标准时间 2019 Errors in file d:\oracle\xff\xff\background\xff_cjq0_5428.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: 'K:\ORACLE\SAP\SAPDATA1\UNDO_1\UNDO.DATA1'
Wed Feb 06 12:51:01 中国标准时间 2019
ALTER DATABASE RECOVER datafile 2
Wed Feb 06 12:51:01 中国标准时间 2019
Media Recovery Start
Read of rdba: 0x00800001 (file 2, block 1) failed with ORA-01205.
Trying reread from disk.
Reread of rdba: 0x00800001 (file 2, block 1) failed with ORA-01205
Wed Feb 06 12:51:01 中国标准时间 2019
Errors in file d:\oracle\xff\xff\usertrace\xff_ora_6988.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_intel_fast_memset.A+44]
[PC:0x356EA7C] [ADDR:0x7F20000] [UNABLE_TO_WRITE] []
ORA-01205: not a data file - type number in header is 0
Wed Feb 06 12:52:14 中国标准时间 2019
alter database open
Wed Feb 06 12:52:15 中国标准时间 2019
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=17, OS id=6124
Wed Feb 06 12:52:15 中国标准时间 2019
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=18, OS id=7044
Wed Feb 06 12:52:15 中国标准时间 2019
Thread 1 opened at log sequence 1370107
Current log# 2 seq# 1370107 mem# 0: D:\ORACLE\xff\ORIGLOGB\LOG_G12M1.DBF
Current log# 2 seq# 1370107 mem# 1: E:\ORACLE\xff\MIRRLOGB\LOG_G12M2.DBF
Successful open of redo thread 1
Wed Feb 06 12:52:15 中国标准时间 2019
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Feb 06 12:52:15 中国标准时间 2019
ARC0: STARTING ARCH PROCESSES
Wed Feb 06 12:52:15 中国标准时间 2019
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Wed Feb 06 12:52:15 中国标准时间 2019
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=19, OS id=3772
Wed Feb 06 12:52:15 中国标准时间 2019
SMON: enabling cache recovery
Wed Feb 06 12:52:15 中国标准时间 2019
Read of rdba: 0x00800001 (file 2, block 1) failed with ORA-01205.
Trying reread from disk.
Reread of rdba: 0x00800001 (file 2, block 1) failed with ORA-01205
Wed Feb 06 12:52:15 中国标准时间 2019
Errors in file d:\oracle\xff\xff\usertrace\xff_ora_5036.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_intel_fast_memset.A+44]
[PC:0x356EA7C] [ADDR:0xD5F0000] [UNABLE_TO_WRITE] []
ORA-01205: not a data file - type number in header is 0
Sat Feb 09 10:09:40 中国标准时间 2019 Successfully onlined Undo Tablespace 1. Sat Feb 09 10:09:40 中国标准时间 2019 SMON: enabling tx recovery Sat Feb 09 10:09:40 中国标准时间 2019 Database Characterset is UTF8 Opening with internal Resource Manager plan Starting background process QMNC QMNC started with pid=36, OS id=3888 Sat Feb 09 10:09:42 中国标准时间 2019 Completed: alter database open
17813235971 |
QQ 咨询 |