Question on database restore preview
Dear Experts,
We are on 19c. We are validating our backups.
Can you please let us know how the below values are calculated.
recovery will be done up to SCN 5995749465067 Media recovery start SCN is 5995749279319 Recovery must be done beyond SCN 5995749402336 to clear datafile fuzziness
Log:
RMAN> spool log to 'aaaaa.txt';
RMAN> run {
ALLOCATE CHANNEL CH1 DEVICE TYPE sbt_tape parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,
ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=prodcdb2,OB2BARLIST=ERP_PROD_19C)';
set until time "to_date('2023-14-02:20:35:29','yyyy-dd-mm:hh24:mi:ss')";
2> 3> 4> 5> restore database preview;
}
6>
RMAN> RMAN> spool off;
RMAN> exit
[orauat@erpuatdb2 19chome]$ vi aaaaa.txt
[orauat@erpuatdb2 19chome]$ cat aaaaa.txt
Spooling started in log file: aaaaa.txt
Recovery Manager19.17.0.0.0
RMAN> 2> 3> 4> 5> 6>
allocated channel: CH1
channel CH1: SID=249 instance=uatcdb2 device type=SBT_TAPE
channel CH1: Omniback/278
executing command: SET until clause
Starting restore at 2023-02-16:13:22:19
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
384 Incr 0 957.00M SBT_TAPE 00:02:38 2023-02-14:16:05:24
BP Key: 384 Status: AVAILABLE Compressed: 0