rman验证备份有效性

环境:

DB:11.2.0.4

run{
set until sequence 8;
restore validate database;
restore database preview;
}

RMAN> run{
2> set until sequence 8;
3> restore validate database;
4> restore database preview;
5> }

executing command: SET until clause

Starting restore at 10-NOV-21
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/daily_db_fullbk_SLNNGK_72_280dpqv9_20211110.bak
channel ORA_DISK_1: piece handle=/u01/rmanbak/daily_db_fullbk_SLNNGK_72_280dpqv9_20211110.bak tag=TAG20211110T032217
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/daily_db_fullbk_SLNNGK_71_270dpqv9_20211110.bak
channel ORA_DISK_1: piece handle=/u01/rmanbak/daily_db_fullbk_SLNNGK_71_270dpqv9_20211110.bak tag=TAG20211110T032217
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/daily_db_fullbk_SLNNGK_70_260dpqv9_20211110.bak
channel ORA_DISK_1: piece handle=/u01/rmanbak/daily_db_fullbk_SLNNGK_70_260dpqv9_20211110.bak tag=TAG20211110T032217
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:45
Finished restore at 10-NOV-21

Starting restore at 10-NOV-21
using channel ORA_DISK_1


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68      Full    196.48M    DISK        00:00:45     10-NOV-21      
        BP Key: 68   Status: AVAILABLE  Compressed: YES  Tag: TAG20211110T032217
        Piece Name: /u01/rmanbak/daily_db_fullbk_SLNNGK_70_260dpqv9_20211110.bak
  List of Datafiles in backup set 68
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1664224    10-NOV-21 /u01/app/oracle/oradata/slnngk/system01.dbf
  4       Full 1664224    10-NOV-21 /u01/app/oracle/oradata/slnngk/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67      Full    88.63M     DISK        00:00:34     10-NOV-21      
        BP Key: 67   Status: AVAILABLE  Compressed: YES  Tag: TAG20211110T032217
        Piece Name: /u01/rmanbak/daily_db_fullbk_SLNNGK_71_270dpqv9_20211110.bak
  List of Datafiles in backup set 67
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1664225    10-NOV-21 /u01/app/oracle/oradata/slnngk/sysaux01.dbf
  6       Full 1664225    10-NOV-21 /u01/app/oracle/oradata/slnngk/hxl02.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64      Full    6.70M      DISK        00:00:04     10-NOV-21      
        BP Key: 64   Status: AVAILABLE  Compressed: YES  Tag: TAG20211110T032217
        Piece Name: /u01/rmanbak/daily_db_fullbk_SLNNGK_72_280dpqv9_20211110.bak
  List of Datafiles in backup set 64
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1664226    10-NOV-21 /u01/app/oracle/oradata/slnngk/undotbs01.dbf
  5       Full 1664226    10-NOV-21 /u01/app/oracle/oradata/slnngk/hxl01.dbf

no backup of archived log for thread 1 with sequence 6 and starting SCN of 1664596 found to restore

List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
76      1.73M      DISK        00:00:00     10-NOV-21      
        BP Key: 76   Status: AVAILABLE  Compressed: YES  Tag: TAG20211110T032312
        Piece Name: /u01/rmanbak/daily_arch_SLNNGK_82_2i0dpr15_20211110.bak

  List of Archived Logs in backup set 76
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       1658896    10-NOV-21 1664307    10-NOV-21
  1    4       1664307    10-NOV-21 1664315    10-NOV-21
List of Archived Log Copies for database with db_unique_name SLNNGK
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
218     1    5       A 10-NOV-21
        Name: /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_5_jrq0gsb9_.arc

222     1    7       A 10-NOV-21
        Name: /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_7_jrq0hg8g_.arc

Media recovery start SCN is 1664224
Recovery must be done beyond SCN 1664226 to clear datafile fuzziness
Finished restore at 10-NOV-21