Re: until scn

Posted by satish on Jun 05, 2018; 10:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/until-scn-tp6153p6158.html

Thanks for the update erman.

Dear Erman,

Thanks for the update.i have issues list backup command and taken the backup details that ran on 27th full backup

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ------------------
73266   1.24M      DISK        00:00:00     27-may-18 01:17:14
        BP Key: 73266   Status: AVAILABLE  Compressed: YES  Tag: TAG20180527T011714
        Piece Name: /u03/PRODRMAN/PRODDB2/rman/ora_df977188634_s74649_s1

  List of Archived Logs in backup set 73266
  Thrd Seq     Low SCN    Low Time           Next SCN   Next Time
  ---- ------- ---------- ------------------ ---------- ---------
  1    26405   5967693033115 27-may-18 01:00:17 5967693042468 27-may-18 01:17:14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ------------------
73267   1.45M      DISK        00:00:00     27-may-18 01:17:14
        BP Key: 73267   Status: AVAILABLE  Compressed: YES  Tag: TAG20180527T011714
        Piece Name: /u03/PRODRMAN/PRODDB2/rman/ora_df977188634_s74648_s1

  List of Archived Logs in backup set 73267
  Thrd Seq     Low SCN    Low Time           Next SCN   Next Time
  ---- ------- ---------- ------------------ ---------- ---------
  2    25602   5967693033119 27-may-18 01:00:16 5967693042463 27-may-18 01:17:12


we are using RAC.From above next time is 27-may-18 01:17:12,if we issue this,then will it recover till 27-may-18 01:17:12?

one of my friend updated me to add 1 minute for the above time,need your expertise