您好

我把主從做了DG之后，然后主庫(kù)生成一個(gè)日志，可以傳送到備機(jī)

但是備機(jī)可能在做DG過(guò)程失敗的時(shí)候，有一個(gè)日志有問(wèn)題，請(qǐng)問(wèn)如何解決這個(gè)日志？

一直被卡在這里。

主庫(kù)

SQL> select process,status,sequence# from v$managed_standby;

PROCESS? ?? ?? ?? ?STATUS? ?? ?? ?? ?? ?? ???SEQUENCE#

------------------ ------------------------ ----------

ARCH? ?? ?? ?? ?? ?CLOSING? ?? ?? ?? ?? ?? ?? ?? ???45

ARCH? ?? ?? ?? ?? ?CLOSING? ?? ?? ?? ?? ?? ?? ?? ???45

LNS? ?? ?? ?? ?? ? WRITING? ?? ?? ?? ?? ?? ?? ?? ???46

備庫(kù)查詢(xún)

SQL> select process,status,sequence# from v$managed_standby;

PROCESS? ?? ?? ?? ?STATUS? ?? ?? ?? ?? ?? ???SEQUENCE#

------------------ ------------------------ ----------

ARCH? ?? ?? ?? ?? ?CONNECTED? ?? ?? ?? ?? ?? ?? ?? ? 0

ARCH? ?? ?? ?? ?? ?CONNECTED? ?? ?? ?? ?? ?? ?? ?? ? 0

RFS? ?? ?? ?? ?? ? IDLE? ?? ?? ?? ?? ?? ?? ?? ?? ???46

RFS? ?? ?? ?? ?? ? IDLE? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?0

MRP0? ?? ?? ?? ?? ?WAIT_FOR_LOG? ?? ?? ?? ?? ?? ?? ?46

備庫(kù)日志內(nèi)容

MESSAGE

--------------------------------------------------------------------------

ARC0: Archival started

ARC1: Archival started

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

ARC1: Becoming the heartbeat ARCH

Redo Shipping Client Connected as PUBLIC

-- Connected User is Valid

RFS[1]: Assigned to RFS process 3312

RFS[1]: Identified database type as 'physical standby'

Primary database is in MAXIMUM PERFORMANCE mode

Primary database is in MAXIMUM PERFORMANCE mode

MESSAGE

--------------------------------------------------------------------------

RFS[1]: No standby redo logfiles created

Redo Shipping Client Connected as PUBLIC

-- Connected User is Valid

RFS[2]: Assigned to RFS process 2788

RFS[2]: Identified database type as 'physical standby'

RFS[2]: No standby redo logfiles created

Attempt to start background Managed Standby Recovery process

MRP0: Background Managed Standby Recovery process started

Managed Standby Recovery not using Real Time Apply

Media Recovery Log E:\ORACLE\FLASH_RECOVERY_AREA\ARC00045_0834519882.001

Media Recovery Waiting for thread 1 sequence 46 (in transit)

備庫(kù)查詢(xún)

SQL> select PROCESS,sequence#,status,thread#,block# from v$managed_standby where

process='MRP0';

PROCESS? ?? ?? ?? ? SEQUENCE# STATUS? ?? ?? ?? ?? ?? ?? ? THREAD#? ???BLOCK#

------------------ ---------- ------------------------ ---------- ----------

MRP0? ?? ?? ?? ?? ?? ?? ???46 WAIT_FOR_LOG? ?? ?? ?? ?? ?? ?? ? 1? ?? ?? ? 0

不知如何解決了，麻煩各位幫忙看看，謝謝

總結(jié)

以上是生活随笔為你收集整理的oracle dg 日志手动应用,做了DG之后，日志没有被应用的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。