ORACLE技术论坛–请到ask.orasos.com提问

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
ORA-16225: Missing LogMiner session name for Streams
2015 年 10 月 15 日
00:23
惜分飞
Admin
Forum Posts: 345
Member Since:
2010 年 07 月 31 日
Offline

[oracle@app101-2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Oct 14 22:50:03 2015

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 and Data Mining options

SQL>  ALTER DATABASE REGISTER LOGFILE '/Data/oracle/fast_recovery_area/TXLHDB/archivelog/2015_10_14/o1_mf_1_2943_c1wns5z2_.arc';
 ALTER DATABASE REGISTER LOGFILE '/Data/oracle/fast_recovery_area/TXLHDB/archivelog/2015_10_14/o1_mf_1_2943_c1wns5z2_.arc'
*
ERROR at line 1:
ORA-16225: Missing LogMiner session name for Streams

解决方案
SQL> ALTER DATABASE REGISTER physical  LOGFILE '/Data/oracle/fast_recovery_area/TXLHDB/archivelog/2015_10_14/o1_mf_1_2943_c1wns5z2_.arc';

Database altered.

 

 

参考bug:Internal bug 5766114 – REGISTER LOGFILE GENERATES ORA-16225

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

2015 年 10 月 15 日
00:27
惜分飞
Admin
Forum Posts: 345
Member Since:
2010 年 07 月 31 日
Offline

Applies to:

Oracle Database – Enterprise Edition – Version 10.2.0.2 and later
Information in this document applies to any platform.

Symptoms

When using 'ALTER DATABASE REGISTER LOGFILE' command, the following errors occur:

ORA-00604: error occurred at recursive SQL level" error on "ALTER DATABASE REGISTER LOGFILE '/<path>/1_234_636797930.dbf'"

You are using user managed backup/recovery, without RMAN.

You are trying to rebuild the control file and generated a backup controlfile to trace.

You are trying to modify the control file incarnation table section to point to existing logfiles.

Cause

Internal bug 5766114 – REGISTER LOGFILE GENERATES ORA-16225

Solution

This is a known issue and is currently being worked in an internal bug.

Use the workaround :

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/<path>/1_234_636797930.dbf';

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

评论功能已关闭。