Database Backup and Recovery (MOSC)

MOSC Banner

duplicate database upto the last log file recovery

edited Apr 2, 2020 5:04AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

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 .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center