MRP0: Background Media Recovery terminated with error 328,ORA-00328
Tue Oct 28 12:17:07 2014
Primary database is in MAXIMUM PERFORMANCE mode
Tue Oct 28 12:17:07 2014
RFS[1]: Assigned to RFS process 49545378
RFS[1]: Selected log 21 for thread 1 sequence 261 dbid -512063538 branch 856885056
RFS[2]: Assigned to RFS process 58654738
RFS[2]: Selected log 22 for thread 1 sequence 262 dbid -512063538 branch 856885056
Archived Log entry 9 added for thread 1 sequence 261 ID 0xffffffffe179e6f6 dest 1:
Tue Oct 28 12:19:52 2014
Archived Log entry 10 added for thread 1 sequence 262 ID 0xffffffffe179e6f6 dest 1:
Tue Oct 28 12:19:52 2014
RFS[2]: Selected log 21 for thread 1 sequence 263 dbid -512063538 branch 856885056
Tue Oct 28 12:21:11 2014
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (DEMO3)
Tue Oct 28 12:21:11 2014
MRP0 started with pid=26, OS id=44957722
MRP0: Background Managed Standby Recovery process started (DEMO3)
started logmerger process
Tue Oct 28 12:21:16 2014
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 16 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /oracle/oradata/demo3/arch/1_253_856885056.dbf
Errors with log /oracle/oradata/demo3/arch/1_253_856885056.dbf
MRP0: Background Media Recovery terminated with error 328
Errors in file /oracle/orademo3/diag/rdbms/demo3dg/DEMO3/trace/DEMO3_pr00_60621052.trc:
ORA-00328: archived log ends at change 12478008353750, need later change 12478008373749
ORA-00334: archived log: '/oracle/oradata/demo3/arch/1_253_856885056.dbf'
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Completed: alter database recover managed standby database using current logfile disconnect
MRP0: Background Media Recovery process shutdown (DEMO3)
使用如下方式發現不行 。
Solution
-To resolve this GAP Please follow these steps:
1- Run the following query to determine the needed logfile
SQL> select name, thread#, sequence#, archived, applied, status from
v$archived_log where 12478008373749 between FIRST_CHANGE# and NEXT_CHANGE#;
2- Recopy the logfile from the primary to the standby server
3- Register the logfile
SQL> alter database register logfile '';
4- start media recovery
SQL> alter database recover automatic managed standby database disconnect from session;
參考 ,發現現象非常相似, 使用其中提到的 Using RMAN Incremental Backups to Roll Forward a Physical Standby Database
進行修復,無奈RMAN Incremental Backups 時間太長, 最終放棄,所以具體這種方式是否可以roll forward a physical standby database 還不清楚。
最後只有重新實施physical standby 。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-1316182/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MRP0- Background Media Recovery terminated with error 1111Error
- Terminated With Error ORA-474: SMON Process Terminated With Error-1361872.1Error
- Crash recovery和Media recovery的區別
- ORA-16139: media recovery requiredUI
- 【Redis】slaveof 報錯 Background transfer errorRedisError
- Recovery failing with ORA-00328, ORA-00334 [ID 1327154.1]AI
- oracle media recovery介質恢復實驗-Oracle
- oracle media recovery介質恢復小記Oracle
- NBU (98) error requesting media (tpreq)Error
- ServeRAID disk drive error recoveryServerAIError
- ORACLE 9i歸檔之ARCn: Media recovery disabledOracle
- idea 報錯maven [ERROR] Maven execution terminated abnormally (exit code 1)IdeaMavenErrorORM
- FIELDS TERMINATED BY WHITESPACE & FIELDS TERMINATED BY x'09'
- Oracle OCP 1Z0 053 Q399(block media recovery)OracleBloC
- Oracle OCP 1Z0 053 Q401(Block Media Recovery)OracleBloC
- FIELDS TERMINATED BY WHITESPACE & FIELDS TERMINATED BY x'09' 區別
- Disk Drill Media Recovery for Mac(支援多種格式的資料恢復工具)Mac資料恢復
- RMAN-06054: media recovery requesting unknown archived log for thread...Hivethread
- ABC 328F Good Set QueryGo
- ASM管理環境----資料檔案丟失介質恢復(MEDIA RECOVERY)ASM
- The SQL Server (MSSQLSERVER) service terminated with service-specific error 1814 (0x716).SQLServerError
- Gradient_patch_recovery, Z_Z posteriori error estimatorError
- 【問題處理】ORA-01113 file xxx need media recovery
- sublime text編譯時提示錯誤[Decode error - output not utf-8] compilation terminated編譯Error
- Common Causes and Solutions on ORA-376 Error Found in Backup & RecoveryError
- OGG-01028 Recovery record is missing ERRORError
- 多種格式的資料恢復軟體Disk Drill Media Recovery 4.5.972中文資料恢復
- background-clip 和 background-origin
- OGG-01028 Recovery record is missing ERROR[續]Error
- [LeetCode] 328. Odd Even Linked ListLeetCode
- The OracleService$$$ service terminated unexpectedly.Oracle
- JVM terminated. Exit code=1JVM
- background-origin和background-clip區別
- background 屬性
- CSS background背景CSS
- CSS background 背景CSS
- background屬性
- background總結