select thread#,sequence#,applied from v$archived_log where sequence#>=1492;
1 1 1492 NO
2 1 1493 NO
3 1 1494 NO
4 1 1495 NO
5 1 1496 NO
6 1 1497 NO
7 1 1498 NO
8 1 1499 NO
9 1 1500 NO
10 1 1501 NO
SELECT * FROM V$DATAGUARD_STATUS;
1 Log Transport Services Informational 0 1 0 NO 2015/3/27 14:09:32 ARC0: Archival started
2 Log Transport Services Informational 0 2 0 NO 2015/3/27 14:09:32 ARC1: Archival started
3 Log Transport Services Informational 0 3 0 NO 2015/3/27 14:09:32 ARC2: Archival started
4 Log Transport Services Informational 0 4 0 NO 2015/3/27 14:09:32 ARC2: Becoming the 'no FAL' ARCH
5 Log Transport Services Informational 0 5 0 NO 2015/3/27 14:09:32 ARC1: Becoming the heartbeat ARCH
6 Log Transport Services Informational 0 6 0 NO 2015/3/27 14:09:33 ARC3: Archival started
7 Remote File Server Informational 0 7 0 NO 2015/3/27 14:09:33 RFS[1]: Assigned to RFS process 3441
8 Remote File Server Informational 0 8 0 NO 2015/3/27 14:09:33 RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 48565
9 Remote File Server Informational 0 9 0 NO 2015/3/27 14:09:34 RFS[2]: Assigned to RFS process 3443
10 Remote File Server Informational 0 10 0 NO 2015/3/27 14:09:34 RFS[2]: Identified database type as 'physical standby': Client is LGWR ASYNC pid 48569
11 Remote File Server Informational 0 11 0 NO 2015/3/27 14:09:34 Primary database is in MAXIMUM PERFORMANCE mode
12 Remote File Server Informational 0 12 0 NO 2015/3/27 14:09:45 RFS[3]: Assigned to RFS process 3445
13 Remote File Server Informational 0 13 0 NO 2015/3/27 14:09:45 RFS[3]: Identified database type as 'physical standby': Client is ARCH pid 21396
14 Log Transport Services Control 0 14 0 YES 2015/3/27 14:10:35 ARC2: Beginning to archive thread 1 sequence 1508 (27333058-27348487)
15 Remote File Server Informational 0 15 0 NO 2015/3/27 14:10:35 RFS[4]: Assigned to RFS process 3461
16 Remote File Server Informational 0 16 0 NO 2015/3/27 14:10:35 RFS[4]: Identified database type as 'physical standby': Client is ARCH pid 48565
17 Log Transport Services Control 0 17 0 YES 2015/3/27 14:10:35 ARC2: Completed archiving thread 1 sequence 1508 (0-0)
18 Log Apply Services Control 0 18 0 YES 2015/3/27 14:11:20 Attempt to start background Managed Standby Recovery process
19 Log Apply Services Control 0 19 0 YES 2015/3/27 14:11:20 MRP0: Background Managed Standby Recovery process started
20 Log Apply Services Informational 0 20 0 NO 2015/3/27 14:11:25 Managed Standby Recovery not using Real Time Apply
21 Log Apply Services Informational 0 21 0 NO 2015/3/27 14:11:26 Media Recovery Log /home/oracle/app/oracle/arch/orclbak/log_1_1460_855514549.arc
22 Log Apply Services Error 0 22 448 YES 2015/3/27 14:11:28 MRP0: Background Media Recovery terminated with error 448
23 Log Apply Services Control 0 23 0 YES 2015/3/27 14:11:39 MRP0: Background Media Recovery process shutdown
24 Log Transport Services Control 0 24 0 YES 2015/3/27 15:56:56 ARC0: Beginning to archive thread 1 sequence 1509 (27348487-27357049)
25 Log Transport Services Control 0 25 0 YES 2015/3/27 15:56:56 ARC0: Completed archiving thread 1 sequence 1509 (0-0)
26 Log Transport Services Control 0 26 0 YES 2015/3/27 16:04:38 ARC2: Beginning to archive thread 1 sequence 1510 (27357049-27357951)
27 Log Transport Services Control 0 27 0 YES 2015/3/27 16:04:38 ARC2: Completed archiving thread 1 sequence 1510 (0-0)
28 Log Transport Services Control 0 28 0 YES 2015/3/27 17:16:58 ARC3: Beginning to archive thread 1 sequence 1511 (27357951-27363780)
29 Log Transport Services Control 0 29 0 YES 2015/3/27 17:16:58 ARC3: Completed archiving thread 1 sequence 1511 (0-0)
30 Log Apply Services Control 0 30 0 YES 2015/3/27 17:20:54 Attempt to start background Managed Standby Recovery process
31 Log Apply Services Control 0 31 0 YES 2015/3/27 17:20:54 MRP0: Background Managed Standby Recovery process started
32 Log Apply Services Informational 0 32 0 NO 2015/3/27 17:20:59 Managed Standby Recovery starting Real Time Apply
33 Log Apply Services Informational 0 33 0 NO 2015/3/27 17:21:00 Media Recovery Log /home/oracle/app/oracle/arch/orclbak/log_1_1460_855514549.arc
34 Log Apply Services Error 0 34 448 YES 2015/3/27 17:21:03 MRP0: Background Media Recovery terminated with error 448
35 Log Apply Services Informational 0 35 0 NO 2015/3/27 17:21:03 Managed Standby Recovery not using Real Time Apply
36 Log Apply Services Control 0 36 0 YES 2015/3/27 17:21:14 MRP0: Background Media Recovery process shutdown