SQL> select completion_time, round(blocks*512/1024/1024) Mb, name from v$archived_log
2 where standby_dest='YES' and
3 completion_time > sysdate- 10/24
4 order by 1 desc;
COMPLETION_TIME MB NAME
-------------------- ---------- -------------------------------------------------------
28-MAY-2015 14:31:07 1503 CFTBANK_CFT-STB
28-MAY-2015 14:21:21 1509 CFTBANK_CFT-STB
28-MAY-2015 14:05:11 1511 CFTBANK_CFT-STB
28-MAY-2015 13:59:38 1536 CFTBANK_CFT-STB
28-MAY-2015 13:41:04 1513 CFTBANK_CFT-STB
28-MAY-2015 13:29:03 1503 CFTBANK_CFT-STB
28-MAY-2015 13:13:49 1503 CFTBANK_CFT-STB
28-MAY-2015 13:02:00 1501 CFTBANK_CFT-STB
28-MAY-2015 12:50:24 1506 CFTBANK_CFT-STB
28-MAY-2015 12:44:11 1507 CFTBANK_CFT-STB
28-MAY-2015 12:31:49 1526 CFTBANK_CFT-STB
28-MAY-2015 12:25:01 1504 CFTBANK_CFT-STB
28-MAY-2015 12:14:42 1504 CFTBANK_CFT-STB
28-MAY-2015 12:04:02 1501 CFTBANK_CFT-STB
28-MAY-2015 11:53:02 1507 CFTBANK_CFT-STB
28-MAY-2015 11:41:37 1556 CFTBANK_CFT-STB
28-MAY-2015 11:39:55 1552 CFTBANK_CFT-STB
28-MAY-2015 11:38:10 1604 CFTBANK_CFT-STB
28-MAY-2015 11:36:23 1537 CFTBANK_CFT-STB
28-MAY-2015 11:34:37 1575 CFTBANK_CFT-STB
28-MAY-2015 11:31:04 1504 CFTBANK_CFT-STB
28-MAY-2015 11:21:48 1502 CFTBANK_CFT-STB
28-MAY-2015 11:18:27 1552 CFTBANK_CFT-STB
28-MAY-2015 11:16:48 1586 CFTBANK_CFT-STB
28-MAY-2015 11:15:12 1568 CFTBANK_CFT-STB
28-MAY-2015 11:13:36 1578 CFTBANK_CFT-STB
28-MAY-2015 11:12:00 1570 CFTBANK_CFT-STB
28-MAY-2015 11:10:27 1600 CFTBANK_CFT-STB
28-MAY-2015 11:03:53 1508 CFTBANK_CFT-STB
28-MAY-2015 10:52:41 1512 CFTBANK_CFT-STB
28-MAY-2015 10:42:43 1508 CFTBANK_CFT-STB
28-MAY-2015 10:36:04 1574 CFTBANK_CFT-STB
28-MAY-2015 10:34:28 1552 CFTBANK_CFT-STB
28-MAY-2015 10:32:43 1540 CFTBANK_CFT-STB
28-MAY-2015 10:31:07 1550 CFTBANK_CFT-STB
28-MAY-2015 10:29:31 1558 CFTBANK_CFT-STB
28-MAY-2015 10:28:01 1578 CFTBANK_CFT-STB
28-MAY-2015 10:26:19 1556 CFTBANK_CFT-STB
28-MAY-2015 10:24:40 1552 CFTBANK_CFT-STB
28-MAY-2015 10:23:04 1563 CFTBANK_CFT-STB
28-MAY-2015 10:21:30 1545 CFTBANK_CFT-STB
28-MAY-2015 10:13:21 1515 CFTBANK_CFT-STB
28-MAY-2015 10:04:32 1513 CFTBANK_CFT-STB
28-MAY-2015 09:52:58 1505 CFTBANK_CFT-STB
28-MAY-2015 09:36:30 1502 CFTBANK_CFT-STB
28-MAY-2015 09:19:10 1503 CFTBANK_CFT-STB
28-MAY-2015 08:59:32 1065 CFTBANK_CFT-STB
28-MAY-2015 08:39:34 889 CFTBANK_CFT-STB
28-MAY-2015 08:19:32 882 CFTBANK_CFT-STB
28-MAY-2015 07:59:33 665 CFTBANK_CFT-STB
28-MAY-2015 07:39:32 390 CFTBANK_CFT-STB
28-MAY-2015 07:19:33 349 CFTBANK_CFT-STB
28-MAY-2015 06:59:34 328 CFTBANK_CFT-STB
28-MAY-2015 06:39:28 301 CFTBANK_CFT-STB
28-MAY-2015 06:19:26 283 CFTBANK_CFT-STB
28-MAY-2015 05:59:26 259 CFTBANK_CFT-STB
28-MAY-2015 05:39:27 193 CFTBANK_CFT-STB
28-MAY-2015 05:19:27 187 CFTBANK_CFT-STB
28-MAY-2015 04:59:27 149 CFTBANK_CFT-STB
59 rows selected.