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.
