Hi,
Please consider the following scenario :
Source database : 12102
Traget daatbase : 12102
Rman catalog : 11204
My back startegey is :
Once per week - Backup level 0 INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG
Backup level 0 is happen every tuesday morning.
Every day - Backup level 1 INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG
Every 4 hours - backup archivelogs
On DWH environment, Every night i am running several transportable tablespaces from source database (DB : PROD1) to target database (DB : PROD2)
I tried to duplicate my PROD2 database from backup (the one that import the TTS) to TEST database and it failed.
The duplicate has been run on Thursday while backup level 0 was two days earlier at tuesday morning.
Duplicate script:
run {
allocate AUXILIARY channel ch1 type 'SBT_TAPE' PARMS .....;
set until time "to_date('15-06-2017 09:50:00','dd-mm-yyyy hh24:mi:ss')";
duplicate target database for standby backup location 'SBT_TAPE'
PFILE = ....
NOFILENAMECHECK;
release channel ch1;
}
Errror:
...
RMAN-06023: no backup or copy of datafile 288 found to restore
RMAN-06023: no backup or copy of datafile 281 found to restore
.....
RMAN-06023: no backup or copy of datafile 58 found to restore
Which mean that rman couldnt restore ONLY the datafiles which were part of the TTS.
Questions:
1) Should i run Full backup (level 0) after each TTS on target machine ?! I didnt found notes about such requirement in the rman documentation
2) Does it happen because i am taking a backup of the controlfile every day .. ?
Please advise
Regards