ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > rac 32bit 备份 还原到 windows 64bit

rac 32bit 备份 还原到 windows 64bit

原创 Oracle 作者：desert_xu 时间：2015-08-22 15:57:06 0 删除 编辑
昨天一个网友问我，rac 恢复到异机 报错误 执行rman脚本如下
run  {                                                                   
set newname for datafile 1 to   '/u02/oracle/oradata/system01.dbf';
set newname for datafile 2 to  '/u02/oracle/oradata/sysaux01.dbf';  
set newname for datafile 3 to   '/u02/oracle/oradata/undotbs01.dbf';
set newname for datafile 4 to  '/u02/oracle/oradata/users01.dbf';   
set newname for datafile 5 to   '/u02/oracle/oradata/example01.dbf';
set newname for datafile 6 to   '/u02/oracle/oradata/system01.dbf';
set newname for datafile 7 to     '/u02/oracle/oradata/tbs01.dbf;   
set newname for datafile 8 to   '/u02/oracle/oradata/tbs02.dbf';    
set newname for datafile 9 to    '/u02/oracle/oradata/tbs03.dbf';   
restore database;                                                   
switch datafile all;                                                
}  

后来我告诉他设置参数 db_file_name_convert 解决还不行。
于是我在rac测试环境 做个了一个备份
rman>backup database format '/u01/app/oracle/%UDB';
把生成的备份文件和2 thread# seq#　7815　日志下载到本地电脑移动硬盘上。为什么只需要这么一个归档日志呢，因为这个日志的ｓｃｎ　first_change# <  生成备份的scn  and  next_change# > 生成备份的scn,这个归档日志符合条件。

在Windows开始恢复，Windows比较特殊需要创建一个service
oradim -new -sid udevtest -startmode manual -pfile %oracle_home%/database/initudevtest.ora
set oracle_sid=udevtest
%oracle_home%/bin/rman target /
startup nomount
启动实例到 nomount状态
恢复控制文件
restore controflile to 'd:\oracle\oradata\udevtest\CONTROL01.CTL' ,restore controflile to 'd:\oracle\oradata\udevtest\CONTROL02.CTL'  from 'I:\temp\ctl_sp_auto.bak';
执行如下类似脚本
run  {                                                                   
set newname for datafile 1 to   '/u02/oracle/oradata/system01.dbf';
set newname for datafile 2 to  '/u02/oracle/oradata/sysaux01.dbf';  
set newname for datafile 3 to   '/u02/oracle/oradata/undotbs01.dbf';
set newname for datafile 4 to  '/u02/oracle/oradata/users01.dbf';   
set newname for datafile 5 to   '/u02/oracle/oradata/example01.dbf';
set newname for datafile 6 to   '/u02/oracle/oradata/system01.dbf';
set newname for datafile 7 to     '/u02/oracle/oradata/tbs01.dbf;   
set newname for datafile 8 to   '/u02/oracle/oradata/tbs02.dbf';    
set newname for datafile 9 to    '/u02/oracle/oradata/tbs03.dbf';   
restore database;                                                   
switch datafile all;                                                
}
报如下错误
RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP
根据网上搜索结果，把脚本改动如下
run { allocate channel c1 type disk;
restore controlfile to 'd:\oracle\oradata\udevtest\CONTROL01.CTL' from 'i:\temp\ctl_sp_auto.bak';
restore controlfile to 'd:\oracle\oradata\udevtest\CONTROL02.CTL' from 'i:\temp\ctl_sp_auto.bak';
sql 'alter database mount';catalog backuppiece 'I:\temp\58qf6jr5_1_1_UDEVTEST_888360805FULL_DB';
 set newname for datafile 1 to 'i:\oradata\udevtest\system.dbf';
set newname for datafile 2 to 'i:\oradata\udevtest\sysaux.dbf';
set newname for datafile 3 to 'i:\oradata\udevtest\undotbs1.dbf';
set newname for datafile 4 to 'i:\oradata\udevtest\undotbs2.dbf';
set newname for datafile 5 to'i:\oradata\udevtest\users.dbf';
set newname for datafile 6 to 'i:\oradata\udevtest\trans.dbf';
restore database;
switch datafile all; }
执行却报错误，找不到备份文件 reading error  文件 bak_full.bak这个 文件的scn 明显小于我昨天生成的备份文件，一直在找这个文件，我心想 它ramn为什么不找最新的bak文件啊，想想应该控制文件里的记录的备份信息太多了，rman只能按照最旧的snc号来恢复，所以怎么把控制文件里的备份信息清除掉，然后通过 catalog backuppiece  把最新的备份文件 注册进去，按照这个思路，后来我在百度搜索 找到 macclean Liu的文章
http://www.askmaclean.com/archives/cleanup-controlfile-sectio-record-deleted-archivelog.html

1* select rownum-1, type from v$controlfile_record_section
SQL> /

ROWNUM-1 TYPE
———- —————————-
0 DATABASE
1 CKPT PROGRESS
2 REDO THREAD
3 REDO LOG
4 DATAFILE
5 FILENAME
6 TABLESPACE
7 TEMPORARY FILENAME
8 RMAN CONFIGURATION
9 LOG HISTORY
10 OFFLINE RANGE
11 ARCHIVED LOG
12 BACKUP SET
13 BACKUP PIECE
14 BACKUP DATAFILE
15 BACKUP REDOLOG
16 DATAFILE COPY
17 BACKUP CORRUPTION
18 COPY CORRUPTION
19 DELETED OBJECT
20 PROXY COPY
21 BACKUP SPFILE
22 DATABASE INCARNATION
23 FLASHBACK LOG
24 RECOVERY DESTINATION
25 INSTANCE SPACE RESERVATION
26 REMOVABLE RECOVERY FILES
27 RMAN STATUS
28 THREAD INSTANCE NAME MAPPING
29 MTTR
30 DATAFILE HISTORY
31 STANDBY DATABASE MATRIX
32 GUARANTEED RESTORE POINT
33 RESTORE POINT

execute sys.dbms_backup_restore.resetCfileSection( 11);
execute sys.dbms_backup_restore.resetCfileSection( 12);
execute sys.dbms_backup_restore.resetCfileSection( 13);
execute sys.dbms_backup_restore.resetCfileSection( 14);
execute sys.dbms_backup_restore.resetCfileSection( 15);

然后
catalog backuppiece 'I:\temp\58qf6jr5_1_1_UDEVTEST_888360805FULL_DB';


RMAN> run { allocate channel c1 type disk;
2>   set newname for datafile 1 to 'i:\oradata\udevtest\system.dbf';
3>   set newname for datafile 2 to 'i:\oradata\udevtest\sysaux.dbf';
4>   set newname for datafile 3 to 'i:\oradata\udevtest\undotbs1.dbf';
5>   set newname for datafile 4 to 'i:\oradata\udevtest\undotbs2.dbf';
6>   set newname for datafile 5 to'i:\oradata\udevtest\users.dbf';
7>   set newname for datafile 6 to 'i:\oradata\udevtest\trans.dbf';
8>   restore database;
9> switch datafile all;}

allocated channel: c1
channel c1: SID=133 device type=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 22-AUG-15

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to i:\oradata\udevtest\system.dbf
channel c1: restoring datafile 00002 to i:\oradata\udevtest\sysaux.dbf
channel c1: restoring datafile 00003 to i:\oradata\udevtest\undotbs1.dbf
channel c1: restoring datafile 00004 to i:\oradata\udevtest\undotbs2.dbf
channel c1: restoring datafile 00005 to i:\oradata\udevtest\users.dbf
channel c1: restoring datafile 00006 to i:\oradata\udevtest\trans.dbf
channel c1: reading from backup piece I:\TEMP\58QF6JR5_1_1_UDEVTEST_888360805FULL_DB
channel c1: piece handle=I:\TEMP\58QF6JR5_1_1_UDEVTEST_888360805FULL_DB tag=TAG20150821T225325
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:03:15
Finished restore at 22-AUG-15

完成切换
查看
    select  checkpoint_change# from v$database; @1
    select checkpoint_change# from v$datafile;  @2
    select checkpoint_change# from v$datafile_header; @3

2和3 的 检查点scn是一致的，单与1都大，我尝试open 
alter  database open resetlogs;
提示我错误 说1号文件system 是从 old 备份文件恢复出来，需要恢复

sqlplus> recover database ;
提示用 using backup controlfile 恢复

sqlplus> recover database using backup controlfile until cancel;
手动输入日志文件
I:\temp\2_7815_862871577.dbf
就卡这里。
后台alert日志报很多错误

Successful mount of redo thread 1, with mount id 3411202352
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Sat Aug 22 13:52:34 2015
Full restore complete of datafile 6 to datafile copy I:\ORADATA\UDEVTEST\TRANS.DBF.  Elapsed time: 0:00:06
  checkpoint is 53904322
Sat Aug 22 13:53:01 2015
Full restore complete of datafile 3 to datafile copy I:\ORADATA\UDEVTEST\UNDOTBS1.DBF.  Elapsed time: 0:00:33
  checkpoint is 53904322
  last deallocation scn is 53690445
  Undo Optimization current scn is 53872571
Sat Aug 22 13:53:36 2015
Full restore complete of datafile 4 to datafile copy I:\ORADATA\UDEVTEST\UNDOTBS2.DBF.  Elapsed time: 0:01:08
  checkpoint is 53904322
  last deallocation scn is 53846145
  Undo Optimization current scn is 53872571
Full restore complete of datafile 5 to datafile copy I:\ORADATA\UDEVTEST\USERS.DBF.  Elapsed time: 0:01:17
  checkpoint is 53904322
  last deallocation scn is 6924694
Sat Aug 22 13:54:36 2015
Full restore complete of datafile 1 to datafile copy I:\ORADATA\UDEVTEST\SYSTEM.DBF.  Elapsed time: 0:02:08
  checkpoint is 53904322
  last deallocation scn is 306032
  Undo Optimization current scn is 53872571
Sat Aug 22 13:55:39 2015
Full restore complete of datafile 2 to datafile copy I:\ORADATA\UDEVTEST\SYSAUX.DBF.  Elapsed time: 0:03:11
  checkpoint is 53904322
  last deallocation scn is 53901358
Sat Aug 22 13:55:58 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_5828.trc:
ORA-19625: error identifying file +UDEV_TEST/udevtest/datafile/system.260.862871591
ORA-17503: ksfdopn:2 Failed to open file +UDEV_TEST/udevtest/datafile/system.260.862871591
ORA-15001: diskgroup "UDEV_TEST" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Switch of datafile 1 complete to datafile copy
  checkpoint is 53904322
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_5828.trc:
ORA-19625: error identifying file +UDEV_TEST/udevtest/datafile/sysaux.261.862871631
ORA-17503: ksfdopn:2 Failed to open file +UDEV_TEST/udevtest/datafile/sysaux.261.862871631
ORA-15001: diskgroup "UDEV_TEST" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Switch of datafile 2 complete to datafile copy
  checkpoint is 53904322
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_5828.trc:
ORA-19625: error identifying file +UDEV_TEST/udevtest/datafile/undotbs1.262.862871651
ORA-17503: ksfdopn:2 Failed to open file +UDEV_TEST/udevtest/datafile/undotbs1.262.862871651
ORA-15001: diskgroup "UDEV_TEST" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Switch of datafile 3 complete to datafile copy
  checkpoint is 53904322
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_5828.trc:
ORA-19625: error identifying file +UDEV_TEST/udevtest/datafile/undotbs2.264.862871695
ORA-17503: ksfdopn:2 Failed to open file +UDEV_TEST/udevtest/datafile/undotbs2.264.862871695
ORA-15001: diskgroup "UDEV_TEST" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Switch of datafile 4 complete to datafile copy
  checkpoint is 53904322
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_5828.trc:
ORA-19625: error identifying file +UDEV_TEST/udevtest/datafile/users.265.862871705
ORA-17503: ksfdopn:2 Failed to open file +UDEV_TEST/udevtest/datafile/users.265.862871705
ORA-15001: diskgroup "UDEV_TEST" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Switch of datafile 5 complete to datafile copy
  checkpoint is 53904322
Sat Aug 22 13:56:08 2015
Signalling error 1152 for datafile 5!
Sat Aug 22 13:56:09 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_5828.trc:
ORA-19625: error identifying file +UDEV_TEST/udevtest/datafile/trans.dbf
ORA-17503: ksfdopn:2 Failed to open file +UDEV_TEST/udevtest/datafile/trans.dbf
ORA-15001: diskgroup "UDEV_TEST" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Switch of datafile 6 complete to datafile copy
  checkpoint is 53904322
Checker run found 1 new persistent data failures
Sat Aug 22 14:00:34 2015
alter database open
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_5904.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Sat Aug 22 14:00:36 2015
Signalling error 1152 for datafile 1!
Signalling error 1152 for datafile 2!
Signalling error 1152 for datafile 3!
Signalling error 1152 for datafile 4!
Signalling error 1152 for datafile 5!
Signalling error 1152 for datafile 6!
Checker run found 5 new persistent data failures
Sat Aug 22 14:02:39 2015
alter database rename file '+UDEV_TEST/udevtest/redo01.log' to 'i:\oradata\udevtest\redo01.log'
Completed: alter database rename file '+UDEV_TEST/udevtest/redo01.log' to 'i:\oradata\udevtest\redo01.log'
alter database rename file '+UDEV_TEST/udevtest/redo02.log' to 'i:\oradata\udevtest\redo02.log'
Completed: alter database rename file '+UDEV_TEST/udevtest/redo02.log' to 'i:\oradata\udevtest\redo02.log'
alter database rename file '+UDEV_TEST/udevtest/redo03.log' to 'i:\oradata\udevtest\redo03.log'
Completed: alter database rename file '+UDEV_TEST/udevtest/redo03.log' to 'i:\oradata\udevtest\redo03.log'
alter database rename file '+UDEV_TEST/udevtest/redo04.log' to 'i:\oradata\udevtest\redo04.log'
Completed: alter database rename file '+UDEV_TEST/udevtest/redo04.log' to 'i:\oradata\udevtest\redo04.log'
Sat Aug 22 14:03:05 2015
alter database drop logfile group 5
Completed: alter database drop logfile group 5
alter database drop logfile group 6
Completed: alter database drop logfile group 6
alter database drop logfile group 7
Completed: alter database drop logfile group 7
Sat Aug 22 14:03:17 2015
alter database drop logfile group 8
Completed: alter database drop logfile group 8
alter database drop logfile group 9
Completed: alter database drop logfile group 9
alter database drop logfile group 10
Completed: alter database drop logfile group 10
Sat Aug 22 14:03:44 2015
alter database open resetlogs
Signalling error 1152 for datafile 1!
ORA-1152 signalled during: alter database open resetlogs...
Sat Aug 22 14:03:45 2015
Signalling error 1152 for datafile 1!
Signalling error 1152 for datafile 2!
Signalling error 1152 for datafile 3!
Signalling error 1152 for datafile 4!
Signalling error 1152 for datafile 5!
Signalling error 1152 for datafile 6!
Sat Aug 22 14:05:32 2015
ALTER DATABASE RECOVER  database  
Media Recovery Start
 started logmerger process
Sat Aug 22 14:05:33 2015
Media Recovery failed with error 1610
Slave exiting with ORA-283 exception
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr00_2332.trc:
ORA-00283: 恢复会话因错误而取消
ORA-01610: 使用 BACKUP CONTROLFILE 选项的恢复必须已完成
Recovery Slave PR00 previously exited with exception 283
ORA-283 signalled during: ALTER DATABASE RECOVER  database  ...
Sat Aug 22 14:05:34 2015
Signalling error 1152 for datafile 1!
Signalling error 1152 for datafile 2!
Signalling error 1152 for datafile 3!
Signalling error 1152 for datafile 4!
Signalling error 1152 for datafile 5!
Signalling error 1152 for datafile 6!
Sat Aug 22 14:06:00 2015
ALTER DATABASE RECOVER  database using backup controlfile until cancel  
Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER  database using backup controlfile until cancel  ...
Sat Aug 22 14:07:24 2015
ALTER DATABASE RECOVER    LOGFILE 'i:\temp\2_7815_862871577.dbf'  
Media Recovery Log i:\temp\2_7815_862871577.dbf
Sat Aug 22 14:07:25 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr01_4284.trc  (incident=19393):
ORA-00600: 内部错误代码, 参数: [ktbair2_0], [0], [68], [], [], [], [], [], [], [], [], []
Sat Aug 22 14:07:25 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr02_3612.trc  (incident=19401):
ORA-00600: 内部错误代码, 参数: [6122], [0], [63681], [0], [], [], [], [], [], [], [], []
Incident details in: d:\oracle\diag\rdbms\udevtest\udevtest\incident\incdir_19401\udevtest_pr02_3612_i19401.trc
Incident details in: d:\oracle\diag\rdbms\udevtest\udevtest\incident\incdir_19393\udevtest_pr01_4284_i19393.trc
Sat Aug 22 14:07:27 2015
Trace dumping is performing id=[cdmp_20150822140727]
Sat Aug 22 14:07:29 2015
Sweep [inc][19401]: completed
Sweep [inc][19393]: completed
Sweep [inc2][19401]: completed
Sweep [inc2][19393]: completed
Sat Aug 22 14:13:01 2015
alter database register logfile 'i:\temp\2_7815_862871577.dbf'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [LOGICAL] LOGFILE
ORA-604 signalled during: alter database register logfile 'i:\temp\2_7815_862871577.dbf'...
Sat Aug 22 14:15:29 2015
alter database register logfile 'i:\temp\2_7815_862871577.dbf'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [LOGICAL] LOGFILE
ORA-604 signalled during: alter database register logfile 'i:\temp\2_7815_862871577.dbf'...
Sat Aug 22 14:15:30 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr01_4284.trc:
ORA-00308: 无法打开归档日志 '+DATA/archivelog/1_8143_862871577.dbf'
ORA-17503: ksfdopn: 2 未能打开文件 +DATA/archivelog/1_8143_862871577.dbf
ORA-15001: 磁盘组 "DATA" 不存在或尚未装载
ORA-15077: 找不到提供所需磁盘组的 ASM 实例
ORA-29701: 无法连接到集群同步服务
ORA-00600: 内部错误代码, 参数: [ktbair2_0], [0], [68], [], [], [], [], [], [], [], [], []
Slave exiting with ORA-10562 exception
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr01_4284.trc:
ORA-10562: Error occurred while applying redo to data block (file# 2, block# 17134)
ORA-10564: tablespace SYSAUX
ORA-01110: 数据文件 2: 'I:\ORADATA\UDEVTEST\SYSAUX.DBF'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 39884
ORA-00600: 内部错误代码, 参数: [ktbair2_0], [0], [68], [], [], [], [], [], [], [], [], []
Sat Aug 22 14:15:34 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr02_3612.trc:
ORA-00308: 无法打开归档日志 '+DATA/archivelog/1_8143_862871577.dbf'
ORA-17503: ksfdopn: 2 未能打开文件 +DATA/archivelog/1_8143_862871577.dbf
ORA-15001: 磁盘组 "DATA" 不存在或尚未装载
ORA-15077: 找不到提供所需磁盘组的 ASM 实例
ORA-29701: 无法连接到集群同步服务
ORA-00600: 内部错误代码, 参数: [6122], [0], [63681], [0], [], [], [], [], [], [], [], []
Slave exiting with ORA-10562 exception
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr02_3612.trc:
ORA-10562: Error occurred while applying redo to data block (file# 2, block# 56178)
ORA-10564: tablespace SYSAUX
ORA-01110: 数据文件 2: 'I:\ORADATA\UDEVTEST\SYSAUX.DBF'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 15449
ORA-00600: 内部错误代码, 参数: [6122], [0], [63681], [0], [], [], [], [], [], [], [], []
Sat Aug 22 14:15:34 2015
Recovery interrupted!
Recovered data files to a consistent state at change 53904672
Media Recovery failed with error 448
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr00_5480.trc:
ORA-00283: 恢复会话因错误而取消
ORA-00448: 后台进程正常结束
Slave exiting with ORA-283 exception
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr00_5480.trc:
ORA-00283: 恢复会话因错误而取消
ORA-00448: 后台进程正常结束
Sat Aug 22 14:15:35 2015
ORA-3113 signalled during: ALTER DATABASE RECOVER    LOGFILE 'i:\temp\2_7815_862871577.dbf'  ...
Sat Aug 22 14:15:45 2015
alter database register logical logfile 'i:\temp\2_7815_862871577.dbf'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [LOGICAL] LOGFILE
ORA-604 signalled during: alter database register logical logfile 'i:\temp\2_7815_862871577.dbf'...
Sat Aug 22 14:17:08 2015
ALTER DATABASE RECOVER  database using backup controlfile until cancel  
Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER  database using backup controlfile until cancel  ...
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000007815_0862871577.0002
Sat Aug 22 14:17:13 2015
Errors with log D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000007815_0862871577.0002
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr00_4308.trc:
ORA-00308: 无法打开归档日志 'D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000007815_0862871577.0002'
ORA-27041: 无法打开文件
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER    CONTINUE DEFAULT  
Media Recovery Log D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000007815_0862871577.0002
Errors with log D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000007815_0862871577.0002
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr00_4308.trc:
ORA-00308: 无法打开归档日志 'D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000007815_0862871577.0002'
ORA-27041: 无法打开文件
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
ALTER DATABASE RECOVER  database using backup controlfile until cancel  
Media Recovery Start
 started logmerger process
Sat Aug 22 14:17:19 2015
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER  database using backup controlfile until cancel  ...
Sat Aug 22 14:17:57 2015
ALTER DATABASE RECOVER    LOGFILE 'i:\temp\2_7815_862871577.dbf'  
Media Recovery Log i:\temp\2_7815_862871577.dbf
Sat Aug 22 14:17:59 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr01_2148.trc  (incident=19377):
ORA-00600: 内部错误代码, 参数: [ktbair2_0], [0], [68], [], [], [], [], [], [], [], [], []
Incident details in: d:\oracle\diag\rdbms\udevtest\udevtest\incident\incdir_19377\udevtest_pr01_2148_i19377.trc
Sat Aug 22 14:18:00 2015
Trace dumping is performing id=[cdmp_20150822141800]
Sat Aug 22 14:18:03 2015
Sweep [inc][19377]: completed
Sweep [inc2][19377]: completed
Sat Aug 22 14:25:34 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr02_3808.trc:
ORA-00308: 无法打开归档日志 '+DATA/archivelog/1_8143_862871577.dbf'
ORA-17503: ksfdopn: 2 未能打开文件 +DATA/archivelog/1_8143_862871577.dbf
ORA-15001: 磁盘组 "DATA" 不存在或尚未装载
ORA-15077: 找不到提供所需磁盘组的 ASM 实例
ORA-29701: 无法连接到集群同步服务
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr02_3808.trc  (incident=19385):
ORA-00600: 内部错误代码, 参数: [kdBlkCheckError], [1], [2009], [6110], [], [], [], [], [], [], [], []
Incident details in: d:\oracle\diag\rdbms\udevtest\udevtest\incident\incdir_19385\udevtest_pr02_3808_i19385.trc
Sat Aug 22 14:25:35 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr01_2148.trc:
ORA-00308: 无法打开归档日志 '+DATA/archivelog/1_8143_862871577.dbf'
ORA-17503: ksfdopn: 2 未能打开文件 +DATA/archivelog/1_8143_862871577.dbf
ORA-15001: 磁盘组 "DATA" 不存在或尚未装载
ORA-15077: 找不到提供所需磁盘组的 ASM 实例
ORA-29701: 无法连接到集群同步服务
ORA-00600: 内部错误代码, 参数: [ktbair2_0], [0], [68], [], [], [], [], [], [], [], [], []
Slave exiting with ORA-10562 exception
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr01_2148.trc:
ORA-10562: Error occurred while applying redo to data block (file# 2, block# 17134)
ORA-10564: tablespace SYSAUX
ORA-01110: 数据文件 2: 'I:\ORADATA\UDEVTEST\SYSAUX.DBF'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 39884
ORA-00600: 内部错误代码, 参数: [ktbair2_0], [0], [68], [], [], [], [], [], [], [], [], []
Slave exiting with ORA-10562 exception
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr02_3808.trc:
ORA-10562: Error occurred while applying redo to data block (file# 1, block# 2009)
ORA-10564: tablespace SYSTEM
ORA-01110: 数据文件 1: 'I:\ORADATA\UDEVTEST\SYSTEM.DBF'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 287
ORA-00600: 内部错误代码, 参数: [kdBlkCheckError], [1], [2009], [6110], [], [], [], [], [], [], [], []
Sat Aug 22 14:25:35 2015
Trace dumping is performing id=[cdmp_20150822142535]
Sat Aug 22 14:25:36 2015
Recovery Slave PR01 previously exited with exception 10562
Sat Aug 22 14:25:36 2015
Recovery interrupted!
Recovered data files to a consistent state at change 53904672
Media Recovery failed with error 448
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr00_1632.trc:
ORA-00283: 恢复会话因错误而取消
ORA-00448: 后台进程正常结束
Slave exiting with ORA-283 exception
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_pr00_1632.trc:
ORA-00283: 恢复会话因错误而取消
ORA-00448: 后台进程正常结束
ORA-10562 signalled during: ALTER DATABASE RECOVER    LOGFILE 'i:\temp\2_7815_862871577.dbf'  ...
ALTER DATABASE RECOVER CANCEL
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...
Sat Aug 22 14:25:37 2015
Sweep [inc][19385]: completed
Sweep [inc2][19385]: completed
Sat Aug 22 14:30:25 2015
alter database open resetlogs
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'I:\ORADATA\UDEVTEST\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'I:\ORADATA\UDEVTEST\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'I:\ORADATA\UDEVTEST\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'I:\ORADATA\UDEVTEST\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: 'I:\ORADATA\UDEVTEST\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: 'I:\ORADATA\UDEVTEST\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: 'I:\ORADATA\UDEVTEST\REDO04.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: 'I:\ORADATA\UDEVTEST\REDO04.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
RESETLOGS after incomplete recovery UNTIL CHANGE 53904672
Resetting resetlogs activation ID 3388075295 (0xc9f1ed1f)
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'I:\ORADATA\UDEVTEST\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'I:\ORADATA\UDEVTEST\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'I:\ORADATA\UDEVTEST\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'I:\ORADATA\UDEVTEST\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: 'I:\ORADATA\UDEVTEST\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: 'I:\ORADATA\UDEVTEST\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: 'I:\ORADATA\UDEVTEST\REDO04.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: 'I:\ORADATA\UDEVTEST\REDO04.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Sat Aug 22 14:30:36 2015
Setting recovery target incarnation to 2
Sat Aug 22 14:30:38 2015
ARCH: STARTING ARCH PROCESSES
Sat Aug 22 14:30:38 2015
ARC0 started with pid=21, OS id=6136
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Aug 22 14:30:38 2015
ARC1 started with pid=22, OS id=4964
Sat Aug 22 14:30:39 2015
ARC2 started with pid=23, OS id=4912
ARC1: Archival started
Sat Aug 22 14:30:39 2015
ARC3 started with pid=24, OS id=3748
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 2 advanced to log sequence 2 (before internal thread enable)
Archived Log entry 30802 added for thread 2 sequence 1 ID 0x0 dest 1:
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Thread 2 advanced to log sequence 3 (after internal thread enable)
Sat Aug 22 14:30:40 2015
Assigning activation ID 3411202352 (0xcb52d130)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Aug 22 14:30:40 2015
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Dictionary check beginning
Sat Aug 22 14:30:42 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_dbw0_4008.trc:
ORA-01157: ????/?????? 201 - ??? DBWR ????
ORA-01110: ???? 201: '+UDEV_TEST/udevtest/tempfile/temp.263.862871657'
ORA-17503: ksfdopn: 2 ?????? +UDEV_TEST/udevtest/tempfile/temp.263.862871657
ORA-15001: ??? "UDEV_TEST" ????????
ORA-15077: ??????????? ASM ??
ORA-29701: ???????????
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_dbw0_4008.trc:
ORA-01186: ?? 201 ??????
ORA-01157: ????/?????? 201 - ??? DBWR ????
ORA-01110: ???? 201: '+UDEV_TEST/udevtest/tempfile/temp.263.862871657'
File 201 not verified due to error ORA-01157
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Redo thread 2 internally disabled at seq 3 (CKPT)
Archived Log entry 30803 added for thread 2 sequence 2 ID 0x0 dest 1:
ARC3: Archiving disabled thread 2 sequence 3
Thread 1 advanced to log sequence 2 (LGWR switch)
  Current log# 2 seq# 2 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Archived Log entry 30804 added for thread 2 sequence 3 ID 0x0 dest 1:
Cannot re-create tempfile +UDEV_TEST/udevtest/tempfile/temp.263.862871657, the same name file exists
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_dbw0_4008.trc:
ORA-01157: ????/?????? 201 - ??? DBWR ????
ORA-01110: ???? 201: '+UDEV_TEST/udevtest/tempfile/temp.263.862871657'
ORA-17503: ksfdopn: 2 ?????? +UDEV_TEST/udevtest/tempfile/temp.263.862871657
ORA-15001: ??? "UDEV_TEST" ????????
ORA-15077: ??????????? ASM ??
ORA-29701: ???????????
Archived Log entry 30805 added for thread 1 sequence 1 ID 0xcb52d130 dest 1:
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat Aug 22 14:30:47 2015
QMNC started with pid=25, OS id=860
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Error 604 in kwqmnpartition(), aborting txn
Sat Aug 22 14:30:48 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56327]
Sat Aug 22 14:30:49 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:30:53 2015
Starting background process CJQ0
Sat Aug 22 14:30:53 2015
CJQ0 started with pid=27, OS id=4556
Completed: alter database open resetlogs
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Setting Resource Manager plan SCHEDULER[0x3008]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Aug 22 14:30:57 2015
Starting background process VKRM
Sat Aug 22 14:30:57 2015
VKRM started with pid=26, OS id=5316
Sat Aug 22 14:30:57 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_q000_5628.trc:
ORA-06553: PLS-801: 内部错误 [56327]
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:31:00 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_j000_3744.trc:
ORA-12012: error on auto execute of job 12860
ORA-06553: PLS-801: internal error [56327]
Sat Aug 22 14:31:00 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_j002_5272.trc:
ORA-12012: error on auto execute of job 12861
ORA-06553: PLS-801: internal error [56327]
Sat Aug 22 14:31:00 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_j001_5804.trc:
ORA-12012: error on auto execute of job 12192
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
Sat Aug 22 14:31:00 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_j004_4168.trc:
ORA-12012: error on auto execute of job 12690
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
Sat Aug 22 14:31:00 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_j005_4816.trc:
ORA-12012: error on auto execute of job 12319
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
Sat Aug 22 14:31:00 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_j003_5104.trc:
ORA-12012: error on auto execute of job 12314
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:31:07 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:31:17 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:31:27 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:31:37 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:31:47 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:31:57 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:32:07 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:32:17 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:32:27 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:32:37 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:32:43 2015
alter database rename file '+UDEV_TEST/udevtest/tempfile/temp.263.862871657' to 'I:\oradata\udevtest\temp01.dbf'
ORA-1511 signalled during: alter database rename file '+UDEV_TEST/udevtest/tempfile/temp.263.862871657' to 'I:\oradata\udevtest\temp01.dbf'...
Sat Aug 22 14:32:47 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:32:57 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:33:07 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:33:17 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:33:20 2015
alter tablespace temp add tempfile 'I:\oradata\udevtest\temp01.dbf' size 100M
Completed: alter tablespace temp add tempfile 'I:\oradata\udevtest\temp01.dbf' size 100M
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
alter database rename file '+UDEV_TEST/udevtest/tempfile/temp.263.862871657' to 'I:\oradata\udevtest\temp01.dbf'
ORA-1511 signalled during: alter database rename file '+UDEV_TEST/udevtest/tempfile/temp.263.862871657' to 'I:\oradata\udevtest\temp01.dbf'...
Sat Aug 22 14:33:27 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:33:37 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:33:47 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:33:57 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:34:07 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:34:15 2015
alter tablespace temp drop tempfile '+UDEV_TEST/udevtest/tempfile/temp.263.862871657'
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-01122: database file 201 failed verification check
ORA-01110: data file 201: '+UDEV_TEST/udevtest/tempfile/temp.263.862871657'
ORA-01565: error in identifying file '+UDEV_TEST/udevtest/tempfile/temp.263.862871657'
ORA-17503: ksfdopn:2 Failed to open file +UDEV_TEST/udevtest/tempfile/temp.263.862871657
ORA-15001: diskgroup "UDEV_TEST" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_ora_4744.trc:
ORA-01258: unable to delete temporary file +UDEV_TEST/udevtest/tempfile/temp.263.862871657
Completed: alter tablespace temp drop tempfile '+UDEV_TEST/udevtest/tempfile/temp.263.862871657'
Sat Aug 22 14:34:17 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:34:27 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:34:37 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:34:47 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:34:57 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:35:07 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:35:17 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:35:27 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:35:37 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:35:47 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:35:56 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_mmon_5372.trc:
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:35:57 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:36:07 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:36:17 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:36:27 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:36:37 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:36:47 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:36:57 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:37:07 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:37:17 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:37:27 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:37:37 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:37:48 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:37:58 2015
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Errors in file d:\oracle\diag\rdbms\udevtest\udevtest\trace\udevtest_cjq0_4556.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-06544: PL/SQL: 内部错误, 参数: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: 内部错误 [56327]
Sat Aug 22 14:38:06 2015
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 9
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Sat Aug 22 14:38:16 2015
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Aug 22 14:38:16 2015
Shutting down archive processes
Archiving is disabled
Sat Aug 22 14:38:16 2015
ARCH shutting down
Sat Aug 22 14:38:16 2015
ARCH shutting down
ARC2: Archival stopped
Sat Aug 22 14:38:16 2015
ARCH shutting down
ARC0: Archival stopped
ARC1: Archival stopped
Sat Aug 22 14:38:16 2015
ARCH shutting down
ARC3: Archival stopped
Thread 1 closed at log sequence 2
Successful close of redo thread 1
Sat Aug 22 14:38:18 2015
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Aug 22 14:38:19 2015
Stopping background process VKTM:
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Aug 22 14:38:21 2015
Instance shutdown complete
Sat Aug 22 14:38:31 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\product\11.2.0\dbhome_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in server-side spfile D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEUDEVTEST.ORA
System parameters with non-default values:
  processes                = 150
  nls_language             = "SIMPLIFIED CHINESE"
  nls_territory            = "CHINA"
  memory_target            = 384M
  control_files            = "D:\ORACLE\ORADATA\UDEVTEST\CONTROL01.CTL"
  control_files            = "D:\ORACLE\ORADATA\UDEVTEST\CONTROL02.CTL"
  db_file_name_convert     = "+UDEVTEST"
  db_file_name_convert     = "i:\oradata\udevtest"
  log_file_name_convert    = "+UDEVTEST"
  log_file_name_convert    = "i:\oradata\udevtest"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(protocol=TCP)"
  shared_servers           = 1
  audit_file_dest          = "D:\ORACLE\ADMIN\UDEVTEST\ADUMP"
  audit_trail              = "DB"
  db_name                  = "UDEVTEST"
  open_cursors             = 300
  diagnostic_dest          = "D:\ORACLE"
Sat Aug 22 14:38:31 2015
PMON started with pid=2, OS id=6008
Sat Aug 22 14:38:32 2015
VKTM started with pid=3, OS id=5224 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sat Aug 22 14:38:32 2015
GEN0 started with pid=4, OS id=1920
Sat Aug 22 14:38:32 2015
DIAG started with pid=5, OS id=3700
Sat Aug 22 14:38:32 2015
DBRM started with pid=6, OS id=4572
Sat Aug 22 14:38:32 2015
PSP0 started with pid=7, OS id=4584
Sat Aug 22 14:38:32 2015
DIA0 started with pid=8, OS id=5044
Sat Aug 22 14:38:32 2015
MMAN started with pid=9, OS id=4192
Sat Aug 22 14:38:32 2015
DBW0 started with pid=10, OS id=3708
Sat Aug 22 14:38:32 2015
LGWR started with pid=11, OS id=1196
Sat Aug 22 14:38:32 2015
CKPT started with pid=12, OS id=2188
Sat Aug 22 14:38:32 2015
SMON started with pid=13, OS id=5556
Sat Aug 22 14:38:32 2015
RECO started with pid=14, OS id=4092
Sat Aug 22 14:38:32 2015
MMON started with pid=15, OS id=640
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Aug 22 14:38:32 2015
MMNL started with pid=16, OS id=5824
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\ORACLE
Sat Aug 22 14:38:32 2015
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 3411198568
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Sat Aug 22 14:38:36 2015
ALTER DATABASE OPEN MIGRATE
LGWR: STARTING ARCH PROCESSES
Sat Aug 22 14:38:37 2015
ARC0 started with pid=19, OS id=4108
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Aug 22 14:38:38 2015
ARC1 started with pid=21, OS id=4180
Sat Aug 22 14:38:38 2015
ARC2 started with pid=22, OS id=4684
Sat Aug 22 14:38:38 2015
ARC3 started with pid=23, OS id=5428
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 2
  Current log# 2 seq# 2 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Stopping background process MMNL
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
Sat Aug 22 14:38:42 2015
MMON started with pid=15, OS id=5360
Sat Aug 22 14:38:42 2015
MMNL started with pid=16, OS id=1764
ALTER SYSTEM enable restricted session;
ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY;
Autotune of undo retention is turned off.
ALTER SYSTEM SET _undo_autotune=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY;
ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;
ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=MEMORY;
Resource Manager disabled during database migration: plan '' not set
ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY;
ALTER SYSTEM SET recyclebin='OFF' DEFERRED SCOPE=BOTH;
Resource Manager disabled during database migration
Completed: ALTER DATABASE OPEN MIGRATE
Sat Aug 22 14:39:44 2015
Thread 1 advanced to log sequence 3 (LGWR switch)
  Current log# 1 seq# 3 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Sat Aug 22 14:39:47 2015
Archived Log entry 30806 added for thread 1 sequence 2 ID 0xcb52d130 dest 1:
Sat Aug 22 14:40:00 2015
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Sat Aug 22 14:40:08 2015
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Aug 22 14:40:08 2015
Shutting down archive processes
Archiving is disabled
Sat Aug 22 14:40:09 2015
ARCH shutting down
Sat Aug 22 14:40:09 2015
ARC3: Becoming the 'no FAL' ARCH
Sat Aug 22 14:40:09 2015
ARCH shutting down
ARC3: Becoming the 'no SRL' ARCH
ARC0: Archival stopped
ARC3: Archiving disabled
ARCH shutting down
ARC3: Archival stopped
Sat Aug 22 14:40:09 2015
ARCH shutting down
ARC1: Archival stopped
ARC2: Archival stopped
Thread 1 closed at log sequence 3
Successful close of redo thread 1
Sat Aug 22 14:40:12 2015
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Aug 22 14:40:13 2015
Stopping background process VKTM:
Sat Aug 22 14:40:15 2015
Instance shutdown complete
Sat Aug 22 14:40:48 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\oracle\product\11.2.0\dbhome_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in server-side spfile D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEUDEVTEST.ORA
System parameters with non-default values:
  processes                = 150
  nls_language             = "SIMPLIFIED CHINESE"
  nls_territory            = "CHINA"
  memory_target            = 384M
  control_files            = "D:\ORACLE\ORADATA\UDEVTEST\CONTROL01.CTL"
  control_files            = "D:\ORACLE\ORADATA\UDEVTEST\CONTROL02.CTL"
  db_file_name_convert     = "+UDEVTEST"
  db_file_name_convert     = "i:\oradata\udevtest"
  log_file_name_convert    = "+UDEVTEST"
  log_file_name_convert    = "i:\oradata\udevtest"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  undo_tablespace          = "UNDOTBS1"
  recyclebin               = "OFF"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(protocol=TCP)"
  shared_servers           = 1
  audit_file_dest          = "D:\ORACLE\ADMIN\UDEVTEST\ADUMP"
  audit_trail              = "DB"
  db_name                  = "UDEVTEST"
  open_cursors             = 300
  diagnostic_dest          = "D:\ORACLE"
Sat Aug 22 14:40:48 2015
PMON started with pid=2, OS id=2116
Sat Aug 22 14:40:48 2015
VKTM started with pid=3, OS id=4972 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sat Aug 22 14:40:48 2015
GEN0 started with pid=4, OS id=3724
Sat Aug 22 14:40:48 2015
DIAG started with pid=5, OS id=3416
Sat Aug 22 14:40:48 2015
DBRM started with pid=6, OS id=6104
Sat Aug 22 14:40:48 2015
PSP0 started with pid=7, OS id=1480
Sat Aug 22 14:40:48 2015
DIA0 started with pid=8, OS id=2324
Sat Aug 22 14:40:48 2015
MMAN started with pid=9, OS id=4904
Sat Aug 22 14:40:48 2015
DBW0 started with pid=10, OS id=5024
Sat Aug 22 14:40:48 2015
LGWR started with pid=11, OS id=5648
Sat Aug 22 14:40:48 2015
CKPT started with pid=12, OS id=3712
Sat Aug 22 14:40:48 2015
SMON started with pid=13, OS id=4792
Sat Aug 22 14:40:48 2015
RECO started with pid=14, OS id=3196
Sat Aug 22 14:40:48 2015
MMON started with pid=15, OS id=3536
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Aug 22 14:40:48 2015
MMNL started with pid=16, OS id=3264
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\ORACLE
Sat Aug 22 14:40:48 2015
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 3411239152
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Sat Aug 22 14:40:53 2015
ALTER DATABASE OPEN
LGWR: STARTING ARCH PROCESSES
Sat Aug 22 14:40:53 2015
ARC0 started with pid=19, OS id=4308
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Aug 22 14:40:54 2015
ARC1 started with pid=21, OS id=3336
Sat Aug 22 14:40:54 2015
ARC2 started with pid=22, OS id=5320
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 3
  Current log# 1 seq# 3 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Sat Aug 22 14:40:54 2015
ARC3 started with pid=23, OS id=5932
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
Starting background process QMNC
Sat Aug 22 14:41:01 2015
QMNC started with pid=24, OS id=5840
Sat Aug 22 14:41:20 2015
Completed: ALTER DATABASE OPEN
Sat Aug 22 14:41:20 2015
Starting background process CJQ0
Sat Aug 22 14:41:20 2015
CJQ0 started with pid=30, OS id=2972
Sat Aug 22 14:41:22 2015
Thread 1 advanced to log sequence 4 (LGWR switch)
  Current log# 2 seq# 4 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Sat Aug 22 14:41:26 2015
Archived Log entry 30807 added for thread 1 sequence 3 ID 0xcb52d130 dest 1:
Setting Resource Manager plan SCHEDULER[0x3008]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Sat Aug 22 14:41:27 2015
Starting background process VKRM
Sat Aug 22 14:41:27 2015
VKRM started with pid=28, OS id=2888
Sat Aug 22 14:41:35 2015
SERVER COMPONENT id=UTLRP_BGN: timestamp=2015-08-22 14:41:35
Sat Aug 22 14:41:46 2015
Thread 1 cannot allocate new log, sequence 5
Checkpoint not complete
  Current log# 2 seq# 4 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Thread 1 advanced to log sequence 5 (LGWR switch)
  Current log# 1 seq# 5 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Sat Aug 22 14:41:53 2015
Archived Log entry 30808 added for thread 1 sequence 4 ID 0xcb52d130 dest 1:
Sat Aug 22 14:42:26 2015
Thread 1 cannot allocate new log, sequence 6
Checkpoint not complete
  Current log# 1 seq# 5 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Thread 1 advanced to log sequence 6 (LGWR switch)
  Current log# 2 seq# 6 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Sat Aug 22 14:42:33 2015
Archived Log entry 30809 added for thread 1 sequence 5 ID 0xcb52d130 dest 1:
Sat Aug 22 14:43:00 2015
Thread 1 cannot allocate new log, sequence 7
Checkpoint not complete
  Current log# 2 seq# 6 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Thread 1 advanced to log sequence 7 (LGWR switch)
  Current log# 1 seq# 7 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Sat Aug 22 14:43:07 2015
Archived Log entry 30810 added for thread 1 sequence 6 ID 0xcb52d130 dest 1:
Sat Aug 22 14:43:32 2015
Thread 1 cannot allocate new log, sequence 8
Checkpoint not complete
  Current log# 1 seq# 7 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Thread 1 advanced to log sequence 8 (LGWR switch)
  Current log# 2 seq# 8 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Sat Aug 22 14:43:39 2015
Archived Log entry 30811 added for thread 1 sequence 7 ID 0xcb52d130 dest 1:
Sat Aug 22 14:44:03 2015
Thread 1 cannot allocate new log, sequence 9
Checkpoint not complete
  Current log# 2 seq# 8 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Thread 1 advanced to log sequence 9 (LGWR switch)
  Current log# 1 seq# 9 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Sat Aug 22 14:44:11 2015
Archived Log entry 30812 added for thread 1 sequence 8 ID 0xcb52d130 dest 1:
Sat Aug 22 14:44:28 2015
Thread 1 cannot allocate new log, sequence 10
Checkpoint not complete
  Current log# 1 seq# 9 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Thread 1 advanced to log sequence 10 (LGWR switch)
  Current log# 2 seq# 10 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Sat Aug 22 14:44:35 2015
Archived Log entry 30813 added for thread 1 sequence 9 ID 0xcb52d130 dest 1:
Sat Aug 22 14:45:00 2015
Thread 1 cannot allocate new log, sequence 11
Checkpoint not complete
  Current log# 2 seq# 10 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Thread 1 advanced to log sequence 11 (LGWR switch)
  Current log# 1 seq# 11 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Sat Aug 22 14:45:06 2015
Archived Log entry 30814 added for thread 1 sequence 10 ID 0xcb52d130 dest 1:
Sat Aug 22 14:45:36 2015
Thread 1 cannot allocate new log, sequence 12
Checkpoint not complete
  Current log# 1 seq# 11 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Thread 1 advanced to log sequence 12 (LGWR switch)
  Current log# 2 seq# 12 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Sat Aug 22 14:45:43 2015
Archived Log entry 30815 added for thread 1 sequence 11 ID 0xcb52d130 dest 1:
Sat Aug 22 14:46:02 2015
Starting background process SMCO
Sat Aug 22 14:46:02 2015
SMCO started with pid=42, OS id=3972
Sat Aug 22 14:46:12 2015
Thread 1 cannot allocate new log, sequence 13
Checkpoint not complete
  Current log# 2 seq# 12 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Thread 1 advanced to log sequence 13 (LGWR switch)
  Current log# 1 seq# 13 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Sat Aug 22 14:46:19 2015
Archived Log entry 30816 added for thread 1 sequence 12 ID 0xcb52d130 dest 1:
Sat Aug 22 14:47:01 2015
Thread 1 cannot allocate new log, sequence 14
Checkpoint not complete
  Current log# 1 seq# 13 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Thread 1 advanced to log sequence 14 (LGWR switch)
  Current log# 2 seq# 14 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Sat Aug 22 14:47:06 2015
Archived Log entry 30817 added for thread 1 sequence 13 ID 0xcb52d130 dest 1:
Sat Aug 22 14:47:43 2015
Thread 1 cannot allocate new log, sequence 15
Checkpoint not complete
  Current log# 2 seq# 14 mem# 0: I:\ORADATA\UDEVTEST\REDO02.LOG
Thread 1 advanced to log sequence 15 (LGWR switch)
  Current log# 1 seq# 15 mem# 0: I:\ORADATA\UDEVTEST\REDO01.LOG
Sat Aug 22 14:47:50 2015
Archived Log entry 30818 added for thread 1 sequence 14 ID 0xcb52d130 dest 1:
Sat Aug 22 14:49:15 2015
SERVER COMPONENT id=UTLRP_END: timestamp=2015-08-22 14:49:15

alter database open resetlogs;
终于打开，不过由于 备份集原来是32位库，恢复到64Windows库下，所以要重启实例 编译过程
执行如下代码，时间可能比较久
                                                                                           
SQL> startup upgrade;                                                                                                                                                                
SQL> @?/rdbms/admin/utlirp                                                                                                                                                     
SQL> shutdown immediate                                                                                                                                                            
SQL> startup                                                                                                                                                                     
SQL> @?/rdbms/admin/utlrp   

调价temp临时文件、重命令redo文件，删除  standby redo 文件。
总结，学习oracle 就是要多动脑筋，多实践，多思考，为什么这样等等。。

--end--
2015/8/22

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

0
0
上一篇： Oracle 11gR2 Database UNDO表空间使用率居高不下
下一篇： asm 下datafile数据文件au分布剖析
请登录后发表评论 登录
全部评论
desert_xu

注册时间：2013-10-23

  • 博文量
    79
  • 访问量
    281029

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593