Showing posts with label List archivelog. Show all posts
Showing posts with label List archivelog. Show all posts

Friday, May 16, 2014

Listing archivelog that are backed up 2 times by RMAN



1.Listing archivelog that are backed twice to device type disk

RMAN> list archivelog all backed up 2 times to device type disk;

List of Archived Log Copies for database with db_unique_name CVRMAN
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - --------------------
47      1    12      A 15-MAY-2014 07:42:19
        Name: +DATA/cvrman/archivelog/2014_05_15/thread_1_seq_12.319.847663387




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