Oracle 重新调整Primary 中的数据文件后Mrp 失败显示Ora-1579 ORA-01579: 恢复过程中出现写错误

Posted by PDSERVICE on May 27, 2016 In

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

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

ORA-01579: 恢复过程中出现写错误

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。

You are here

Oracle 重新调整Primary 中的数据文件后Mrp 失败显示Ora-1579 ORA-01579: 恢复过程中出现写错误