Wednesday, May 14, 2014

Listing archivelog using From and until time clause in RMAN



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

No comments: