1. Listing archivelog using from time and until time
RMAN> list archivelog from time "to_date('14-MAY-2014 10:14:41','dd-mon-yyyy hh24:mi:ss')" until time "to_date('15-MAY-2014 01:33:53','dd-mon-yyyy hh24:mi:ss')";
2. Output of the statement
List of Archived Log Copies for database with db_unique_name CVRMAN
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - --------------------
38 1 3 A 14-MAY-2014 10:14:41
Name: +DATA/cvrman/archivelog/2014_05_15/thread_1_seq_3.298.847589635
39 1 4 A 15-MAY-2014 01:33:53
Name: +DATA/cvrman/archivelog/2014_05_15/thread_1_seq_4.271.847589869
