如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

ORA-01579

oerr ora 1579
01579, 00000, "write error occurred during recovery"
// *Cause: A write error occurred during recovery
// *Action: Consult trace files for the nature of the write error, and
// correct error.
适用于： Oracle Server - Enterprise Edition – 版本 9.2.0.8 及以上 本文信息适用于任何平台。 该问题可能出现在任何平台。 *** 18-JUNE-2012检查相关性*** 症状 -- 问题描述： Media Recovery Log /u08/fobridge/archive1/Log1_0000146994.arch Recovery interrupted. Write error has occurred during recovery Some recovered datafiles maybe left media fuzzy Media recovery may continue but open resetlogs may fail Tue Mar 24 05:39:25 2009 Media Recovery failed with error 1579 ORA-283 signalled during: ALTER DATABASE RECOVER LOGFILE '/u08/fobridge/a... Tue Mar 24 05:39:25 2009 ALTER DATABASE RECOVER CANCEL ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ... Tue Mar 24 05:46:49 2009 RFS: Archive log thread 1 sequence 147006 available in 58 minute(s)   原因 ++ 在primary 重新调整大小导致MRP挂起。 Bug 3945551 - Hdr: 3945551 9.2.0.5.0 RDBMS 9.2.0.5.0 RECOVERY PRODID-5 PORTID-23 ORA-1579 7205263 Abstract: MRP TERMINATED DUE TO ERROR ORA-1579 解决方法： 重启managed recovery。 Bug 6111022 - Hdr: 6111022 9.2.0.8 RDBMS 9.2.0.8 RECOVERY PRODID-5 PORTID-215 ORA-1579 Abstract: ALTER DATABASE DATAFILE RESIZE RESULTS IN ALL STBY DB FILES FUZZY STATE. 解决方案 
-- 要实施解决方法，请执行以下步骤：
 1. 在primary？？时，使表空间处于begin backup模式 Put the tablespace in begin backup mode with you rised on primary.
 2. 将文件复制到standby 服务器。
 3. 将旧的文件移动到不同的位置并放入该新文件。
 4. 启动MRP。