Article Figure 1 Listing 1 Listing 2 Listing 3 may2006.tar

Listing 3 Determining the Until sequence line

$rman rcvcat rman/xxx@rman target sys/xxx@mydata;

RMAN> LIST BACKUP OF ARCHIVELOG all;


BS Key  Size       Device Type Elapsed Time Completion Time    
------- ---------- ----------- ------------ -------------------
6972640 111M       SBT_TAPE    00:00:27     12-20-2005 22:52:15
        BP Key: 6972644   Status: AVAILABLE   Tag: TAG20051220T225147
        Piece Name: mydata_arch_24521_1_577579908

  List of Archived Logs in backup set 6972640
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    10057   3201693195 12-20-2005 14:57:57 3201696364 12-20-2005 14:58:11
  1    10058   3201696364 12-20-2005 14:58:11 3201720844 12-20-2005 22:51:44
  1    10059   3201720844 12-20-2005 22:51:44 3201720848 12-20-2005 22:51:47


  List of Archived Logs in backup set 6972642
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    10054   3201685067 12-20-2005 14:57:13 3201687988 12-20-2005 14:57:27
  1    10055   3201687988 12-20-2005 14:57:27 3201690593 12-20-2005 14:57:42
  1    10056   3201690593 12-20-2005 14:57:42 3201693195 12-20-2005 14:57:57