Database Backup and Recovery (MOSC)

MOSC Banner

RMAN DUPLICATE/Clone database.

Dear Experts,

Our database version 12.1.0.2
Run {
SET UNTIL SEQUENCE ## THREAD #;
DUPLICATE TARGET DATABASE
TO "APPSTRDE" device type disk;
}
##end script##

here the sequence has to be picked very carefully, in the below backup logfile review the highlighted sequences and time stamps.

Thrd Seq  Low SCN  Low Time      Next SCN Next Time
 ---- ------- ---------- -------------------- ---------- ---------
 1  1362  10162976618798 27-JUN-2012 19:11:00 10162976838904 27-JUN-2012 20:03:08
 1  1363  10162976838904 27-JUN-2012 20:03:08 10162976839270 27-JUN-2012 20:03:17
 1  1364  10162976839270 27-JUN-2012 20:03:17 10162977148308 27-JUN-2012 21:04:04
 1  1365  10162977148308 27-JUN-2012 21:04:04 10162977149494 27-JUN-2012 21:04:31
 1  1366  10162977149494 27-JUN-2012 21:04:31 10162977180003 27-JUN-2012 21:13:13
 1  1367  10162977180003 27-JUN-2012 21:13:13 10162977280169 27-JUN-2012 21:40:29-----
 1  1368  10162977280169 27-JUN-2012 21:40:29 10162977280458 27-JUN-2012 21:40:36-----
 2  1102  10162976618794 27-JUN-2012 19:11:00 10162976838969 27-JUN-2012 20:03:10
 2  1103  10162976838969 27-JUN-2012 20:03:10 10162976839265 27-JUN-2012 20:03:16
 2  1104  10162976839265 27-JUN-2012 20:03:16 10162977148305 27-JUN-2012 21:04:04
 2  1105  10162977148305 27-JUN-2012 21:04:04 10162977149491 27-JUN-2012

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