Hello together,
actually I'm working on a process to create a clone database out of rman backup pieces on another server. We want to use that to "update" our test and develop database servers after a sprint change. For that I will create a script or more scripts which are doing these steps (very abstact at the moment):
1. Copy all backups since the latest full backup from productive to test server
2. delete the database on test server
3. start a "clone database" out of the backup pieces on the test server
Actually I'm haning on the first step. We've doing 1 full backup (mostly on sunday) and one incremental backup each other day (=>6 pieces). Between that we're also backing up the spfile/controlfile each day and all archived logfiles.
Now I'm trying to find out a way how I can determine when the latest full backup was ccreated without to know, that we're doing it each sunday.
I've tried to select v$rman_status like this:
select * from v$rman_status where OPERATION='BACKUP' and OBJECT_TYPE!='ARCHIVELOG' order by START_TIME desc;
but unfortunately the column OBJECT_TYPE shows "DB Incr" also for the backups which are a full backup.
Did you know any other good way to find that out?
Thanks a lot and regards,
David