5.再启用mrp进程查看
SQL> alter database recover managed standby database using current logfile disconnect from session;
6.验证
SQL> select message from v$dataguard_status;
MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC1: Becoming the heartbeat ARCH
ARC1: Becoming the active heartbeat ARCH
ARC3: Archival started
RFS[1]: Assigned to RFS process 51650
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Assigned to RFS process 51652
ARC2: Beginning to archive thread 1 sequence 31950 (14519360191421-1451936022552
ARC2: Completed archiving thread 1 sequence 31950 (0-0)
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery starting Real Time Apply
Media Recovery Log /oradata/archive/1_31949_1050099923.dbf
Media Recovery Log /oradata/archive/1_31950_1050099923.dbf
Media Recovery Waiting for thread 1 sequence 31951 (in transit)
ARC2: Beginning to archive thread 1 sequence 31951 (14519360225522-1451936025820
6)