本文共 6540 字，大约阅读时间需要 21 分钟。

今天在做oracle异机备份恢复测试的时候，数据文件以及应用归档日志都正常恢复，但是在打开数据库的时候报了如下错误

RMAN> run{2>      sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"';3>      recover database until time '2019-07-11 09:16:00';4>  }sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"Starting recover at 11-JUL-19using channel ORA_DISK_1starting media recoveryarchived log for thread 1 with sequence 52935 is already on disk as file /backup2/backup189.82_prod/rman/2019_07_11/log1_52935_899300012.arcchannel ORA_DISK_1: starting archived log restore to default destinationchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52926channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52927channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52928channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52929channel ORA_DISK_1: reading from backup piece /backup2/backup189.82_prod/rman/2019_07_11/prod_lev"0"_mpu6bp4l_1_1_20190711channel ORA_DISK_1: piece handle=/backup2/backup189.82_prod/rman/2019_07_11/prod_lev"0"_mpu6bp4l_1_1_20190711 tag=PROD_LEV"0"channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:02:45archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52926_899300012.arc thread=1 sequence=52926archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52927_899300012.arc thread=1 sequence=52927archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52928_899300012.arc thread=1 sequence=52928archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52929_899300012.arc thread=1 sequence=52929channel ORA_DISK_1: starting archived log restore to default destinationchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52930channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52931channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52932channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52933channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=52934channel ORA_DISK_1: reading from backup piece /backup2/backup189.82_prod/rman/2019_07_11/prod_lev"0"_mqu6bp4l_1_1_20190711channel ORA_DISK_1: piece handle=/backup2/backup189.82_prod/rman/2019_07_11/prod_lev"0"_mqu6bp4l_1_1_20190711 tag=PROD_LEV"0"channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:02:15archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52930_899300012.arc thread=1 sequence=52930archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52931_899300012.arc thread=1 sequence=52931archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52932_899300012.arc thread=1 sequence=52932archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52933_899300012.arc thread=1 sequence=52933archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52934_899300012.arc thread=1 sequence=52934archived log file name=/backup2/backup189.82_prod/rman/2019_07_11/log1_52935_899300012.arc thread=1 sequence=52935archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52936_899300012.arc thread=1 sequence=52936archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52937_899300012.arc thread=1 sequence=52937archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52938_899300012.arc thread=1 sequence=52938archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52939_899300012.arc thread=1 sequence=52939archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52940_899300012.arc thread=1 sequence=52940archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52941_899300012.arc thread=1 sequence=52941archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52942_899300012.arc thread=1 sequence=52942archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52943_899300012.arc thread=1 sequence=52943archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52944_899300012.arc thread=1 sequence=52944archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52945_899300012.arc thread=1 sequence=52945archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52946_899300012.arc thread=1 sequence=52946archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52947_899300012.arc thread=1 sequence=52947archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52948_899300012.arc thread=1 sequence=52948archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52949_899300012.arc thread=1 sequence=52949archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52950_899300012.arc thread=1 sequence=52950archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52951_899300012.arc thread=1 sequence=52951archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52952_899300012.arc thread=1 sequence=52952archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52953_899300012.arc thread=1 sequence=52953archived log file name=/opt/oracle/oradata/PROD/archivelog/log1_52954_899300012.arc thread=1 sequence=52954media recovery complete, elapsed time: 01:14:54Finished recover at 11-JUL-19

 尝试打开数据库

SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-00600: internal error code, arguments: [opiodr: call 2], [], [], [], [],[], [], [], [], [], [], []ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [],[], [], [], [], [], [], [], [], []

虽然上面报错，但是数据库却是打开的状态，之前做恢复之前插了一笔测试数据也都还在，说明恢复没啥大问题

SQL> select open_mode from v$database;ERROR:ORA-03114: not connected to ORACLESQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@db_hx_55_36 archivelog]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 11 15:50:55 2019Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select open_mode from v$database;OPEN_MODE----------------------------------------READ WRITESQL> select * from test;        ID TIMES---------- --------------------------------------         1 2018-12-19 09:52:57         2 2019-07-11 09:15:30

那为什么会报这种ora-600错误呢，mos上给出了答案

按照文档上，查看异机数据库

这样，就必须有时区信息文件 

检查安装目录之后，果然没有这两个文件。

然后重启数据库

数据库已经正常打开

转载地址：http://vjhji.baihongyu.com/