duplicate database upto the last log file recovery
Hi , I am cloning every night DBs to production to non production environment every night using unix script and duplicate command
Production is CRMPRD.
This is 11.2 enterprise .
run
{
DUPLICATE TARGET DATABASE TO CRMTRN
logfile
'+REDO' size 128m,
'+REDO' size 128m,
'+REDO' size 128m;
}
But it does not restore up to the last archive log. ex: if start 6.00am. then restore DB using last night backup pieces, then apply logs upto 6:00am. when I checked the are few archives available and didnt apply.
since its is doing it though script. what is the best option to do to recover until last log sequence automatically .