Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN incremental backup from scn to scn

AnandKumarJan 23 2014 — edited Jan 24 2014

Hi All

Oracle Version -11.2.0.3 EE

OS - Linux 5L

Recently we faced missing archives in PROD and bcos of this the standby is not sync. Hence decided to do RMAN incremental backup (from SCN (last SCN of DR db) and did it successfully. My question is; is there a command "from SCN  XXX to SCN XXX" while doing incremental backup. I initally searched in google and got hits for "from sequence  XXX to Ssequence  XXX" and not for SCN.

Why this question is we had only 3 days archives missing (say Jan 10 to 13) other archives are present (jan 14 to current). If "from SCN  XXX to SCN XXX" exists; we can reduce the manual transfer of RMAN files from Prod to DR as we can transfer only 3 days archives (inc backup);

Regards

Anand

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2014
Added on Jan 23 2014
7 comments
4,036 views