RMAN Restore Preview

$ rman target /

RMAN> list backup;

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

15526   Full    6.77M      DISK        00:00:01     15-SEP-21

        BP Key: 15615   Status: AVAILABLE  Compressed: YES  Tag: TAG20210915T234616

        Piece Name: +RECO/SSLCDB/BACKUP_FILES/c-4188050246-20210915-05

  SPFILE Included: Modification time: 15-SEP-21

  SPFILE db_unique_name: SSLCDB

  Control File Included: Ckp SCN: 67374431842   Ckp time: 15-SEP-21

RMAN>  

run{

set until scn 67374431842;

restore database preview;

}

List of Archived Log Copies for database with db_unique_name SSLCDB

=====================================================================

Key     Thrd Seq     S Low Time

------- ---- ------- - ---------

92560   1    47166   A 15-SEP-21

        Name: +RECO/SSLCDB/ARCHIVELOG/2021_09_15/thread_1_seq_47166.3007.1083368767

92562   1    47167   A 15-SEP-21

        Name: +RECO/SSLCDB/ARCHIVELOG/2021_09_16/thread_1_seq_47167.3005.1083369733

recovery will be done up to SCN 67374431842

Media recovery start SCN is 67374208371

Recovery must be done beyond SCN 67374426191 to clear datafile fuzziness

Finished restore at 16-SEP-21

RMAN>

Restore Preview Reports RMAN-05119 and Recover Database Reports RMAN-06054 ( Multi-tenant ) (Doc ID 2233445.1)

Error seems to be a wrong notification which misleads the recovery process.  Ignore the error (or apply the patch 20315311) and proceed with the 'alter database open' after the recover database.   

Sample output of the errors 

Assuming you have valid backup of database and archivelogs, Oracle recommends validating the integrity of the backup by running 'restore database preview'.

Due to a code defect, 'restore database preview' command returns the error RMAN-05119 although valid backups exist.