Running oracle 12.1 on linux x64.
I have a database on one system (ODA RAC), one full backup from March 2019.
I have another full backup from June2019, and incremental backups after June backup.
On another hardware (asm but no rac) I restored backup from March, recovered at some time, opened the db read only then shutdown the database.
Now I want to replace it using the full backuo from June. Most archivelogs between March and June are not available.
No new datafile was created between March and June..
On new system:
[code]rman target /
crosscheck backup;
catalog start with '/backup/newbackup/';
restore database;
recover database;
[/code]
restore worked (used one of the files from March, but I don't know why), and telling some files were skipped (no change?)
[code]
skipping datafile 2; already restored to file +DATASLOW/ESQA/DATAFILE/sysaux.269.1001171071
skipping datafile 3; already restored to file +DATASLOW/ESQA/DATAFILE/undotbs1.277.1001171073
skipping datafile 5; already restored to file +DATASLOW/ESQA/DATAFILE/users.279.1001171073
skipping datafile 6; already restored to file +DATASLOW/ESQA/DATAFILE/esqa_data.276.1001171073
skipping datafile 9; already restored to file +DATASLOW/ESQA/DATAFILE/sysaux.265.1001171071
skipping datafile 11; already restored to file +DATASLOW/ESQA/DATAFILE/esbqa_dbfs.281.1001171073
[/code]
but recover tells an error:
[code]
RMAN-06025: no backup of archived log for thread 2 with sequence 2040 and starting SCN of 1930990782 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 2039 and starting SCN of 1930814755 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 2038 and starting SCN of 1930658372 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 2037 and starting SCN of 1930393723 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 2036 and starting SCN of 1930238338 found to restore
...
SQL> select file#, CHECKPOINT_CHANGE#, LAST_CHANGE# from v$datafile;
FILE# CHECKPOINT_CHANGE# LAST_CHANGE#
---------- ------------------ ------------
1 1966819708
2 1966819708
3 1966819708
4 1966819708
5 1966819708
6 1966819708
7 1966819708
8 1966819708
9 1966819708
10 1966819708
11 1966819708
[/code]
Question: if scn is 1966819708, why does he need archivelogs from scn 1930238338 (or before)?
So according to him some datafiles don't have to be restored... but I guess He tries to recover these files that are too old.
Any hint?