rman restore recover date is lost
env:rac 19c
problem description:Data in table t is lost after database restoration
1、Prepare test data:
SQL> select * from t;
ID
----------
1
2、rman backup
cat db_fullbak.sh
#!/bin/bash
echo -e '******Start********_'$(date '+%Y-%m-%d %H:%M:%S')
source /home/oracle/.bash_profile
find /backup/rman/ -mtime +15 -name "mesdb_*" -exec rm -f {} \;
rman target / log=/backup/rman/fulldb_`date +%Y%m%d-%H%M%S`.log <<EOF
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
crosscheck backup;
crosscheck archivelog all;
sql"alter system switch logfile";
delete noprompt expired backup;
delete noprompt expired archivelog all;