Hi experts
I have a database 11g (11.1.0.7) that uses by EBS 12.1.1.
I use this script for creating RMAN backup from this database.
{
sql 'alter system archive log current';
RECOVER COPY OF DATABASE
WITH TAG 'TRNG_BKP'
UNTIL TIME 'SYSDATE-3';
BACKUP
INCREMENTAL LEVEL 1
FOR RECOVER OF COPY WITH TAG 'TRNG_BKP'
DATABASE;
DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK;
}
we used this backup script for about 1 year and we didn't had any problem by this script and many times we restore our database from this backup outputs.
now i have 2 question:
1) recently I think in RECOVER COPY OF DATABASE WITH TAG 'TRNG_BKP' UNTIL TIME 'SYSDATE-3'; the UNTIL TIME 'SYSDATE-3' is not useful.
because after 3 days we have recovering process in primary backup files (datafile directory) everyday but instead of last night changes we have 3 days ago changes only. so 3 days gap for recovering i think is not useful.
i mean if i don't use UNTIL TIME 'SYSDATE-3' or use 7 instead of 3 after some days the daily process is same.
am i right?
or this strategy has some other benefits for me that maybe I don't know?
2) with this script we can restore database from rman backup file until last archivedlog. can I use any script to recover until last redologs transaction with rman as disaster backup?
or even other backup tools?
Thanks
M.kh