Author: mac

Oracle Flashback database 闪回数据库引发ORA-01206

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] oerr ora 1206 01206, 00000, “file is not part of this database – wrong database id” // *Cause: The database ID in the file header does not match the database id // in the control file. The file may be from a different database, or // it…

March 23, 2013
Oracle RMAN Duplicate 无法创建临时文件，生成错误ORA-01186/ORA-01122/ORA-01206/ORA-01203

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] 适用于： Oracle Database – Enterprise Edition – 版本10.2.0.2 到11.2.0.4 [Release 10.2 to 11.2] 本文信息适用于任何平台。 ***27-NOV-2015检查相关性*** 症状在RMAN Duplication期间，在创建临时文件时，我们在辅助实例中看到以下错误： ORA-01186: file 1025 failed verification tests ORA-01122: database file 1025 failed verification check ORA-01110: data file 1025: ‘/u01/oradata/temp_01.dbf’ ORA-01206: file is not part of this database – wrong database…

March 23, 2013
Oracle 在使用NID更改DBID时ORA-01122 ORA-01110 ORA-01206

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] 适用于： Oracle Database – Enterprise Edition – 版本9.0.1.4 到 10.1.0.2 [Release 9.0.1 to 10.1] 本文信息适用于任何平台。 19 Jul 2012检查相关性症状当更改DBID (Reference Note: 190876.1)时，在更改进程或revert时，打开resetlogs失败显示以下错误： ORA-01122: database file system01.dbf failed verification check ORA-01110: datafile system01.dbf ORA-01206: file is not part of this database – wrong database id 原因在使用NID更改DBID时，我们要立即从mount阶段关闭DB。…

March 23, 2013
Oracle 在复制数据库时RMAN-11003 ORA-283 ORA-19909

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] 适用于： Oracle Database – Enterprise Edition – 版本11.2.0.3及以上本文信息适用于任何平台。症状在恢复期间复制活跃数据库，生成以下错误： RMAN-03002: failure of Duplicate Db command at 07/14/2014 18:31:30 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL…

March 23, 2013
Oracle RMAN Duplicate from active database，间歇报错ORA-00283 ORA-448 ORA-10878

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] 适用于: Oracle Database – Enterprise Edition – 版本11.2.0.2 及以上本文信息适用于任何平台。症状在归档重做日志应用期间，RMAN Duplicate from active database（备用数据库）失败。有时后续的重新尝试会成功。有时实例的热启动能更正问题。 ++ 问题是频繁但间歇的。触发错误的代码： connect target sys/${sys_pwd}@${_TargetDb} connect auxiliary sys/${sys_pwd}@TNSDXSBL2 run { duplicate target database to DXSBL2 from active database db_file_name_convert=(‘/u08/oradata/SXSBL/’,’/u31/oradata/DXSBL2/’ ,’/u09/oradata/SXSBL/’,’/u32/oradata/DXSBL2/’ ,’/u10/oradata/SXSBL/’,’/u32/oradata/DXSBL2/’) logfile group 1 (‘/u31/oradata/DXSBL2/redo01a.dbf’,’/u32/oradata/DXSBL2/redo01b.dbf’) SIZE 100M,…

March 23, 2013
【Enterprise Manager 12c】如何在EM 12c中配置Exadata Infiniband告警邮件

EM 12c集中了Exadata的大量管理功能，这里我们介绍一下如何在EM 12c中配置Exadata Infiniband告警邮件？首先需要将IB network加入到EM target中，点击Exadata machine => IB network => target setup => monitor setup 之后进入监视—>度量和搜集设置还可以参考文档 How To Configure Notification Rules in 12c Enterprise Manager Cloud Control ? [ID 1368036.1]

March 23, 2013
Oracle 在运行”Adcfgclone.pl dbTier”时快速克隆失败: ORA-01194 和RC-00118

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] [oracle@ocm_rac01 ~]$ oerr ora 1194 01194, 00000, “file %s needs more recovery to be consistent” // *Cause: An incomplete recovery session was started, but an insufficient // number of logs were applied to make the file consistent. The // reported file was not closed cleanly when it…

March 22, 2013
Oracle 在Duplicate … ‘backup location’时的RMAN-06136 ORA-01194 ORA-01110

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] [oracle@ocm_rac01 ~]$ oerr rman 6136 6136, 1, “ORACLE error from auxiliary database: %s” // *Cause: This message should be accompanied by other error message(s) // indicating the cause of the error. // *Action: Check the accompanying errors. 适用于: Oracle Database – Enterprise Edition – 版本 11.2.0.1 及以上…

March 22, 2013
Oracle 如果一个线程被关闭，从活跃数据库复制引发ORA-01194

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] oerr ora 01194 01194, 00000, “file %s needs more recovery to be consistent” // *Cause: An incomplete recovery session was started, but an insufficient // number of logs were applied to make the file consistent. The // reported file was not closed cleanly when it was last…

March 22, 2013
Oracle ORA-1578 尝试设置一个表空间联机

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队服务热线： 13764045638 QQ号:47079569 邮箱：[email protected] [oracle@ocm_rac01 ~]$ oerr ora 01578 01578, 00000, “ORACLE data block corrupted (file # %s, block # %s)” // *Cause: The data block indicated was corrupted, mostly due to software // errors. // *Action: Try to restore the segment containing the block indicated. This // may involve dropping…

March 22, 2013