Wednesday, May 14, 2014

Listing Archivelog between two times using RMAN



1.List the archivelog between two times

RMAN> list archivelog time between "to_date('14-MAY-2014 10:14:41','dd-mon-yyyy hh24:mi:ss')" and "to_date('15-MAY-2014 01:33:53','dd-mon-yyyy hh24:mi:ss')";


2.Output of the archivelog.

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: