0

Is it possible to do a full database backup with until specific SCN using RMAN?

For example, I know there are SCNs numbered 10002, 10003, 10004, 10005, and so forth. Can I take a database backup until SCN 10004 using RMAN?

YasirA
  • 9,531
  • 2
  • 40
  • 61
mao
  • 11
  • 2

1 Answers1

0

Use UNTIL SCN parameter, for example:

RMAN> BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG UNTIL SCN 10002

Relevant Oracle Docs page

yamny
  • 660
  • 4
  • 13
  • Hello I face error, RMAN> BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG SCN 1487655; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "scn": expecting one of: "auxiliary, channel, delete, diskratio, filesperset, force, format, – mao Aug 28 '14 at 09:08
  • Wellp, you forgot `UNTIL` between `ARCHIVELOG` and `SCN` – yamny Aug 28 '14 at 09:09
  • Still face issue : RMAN> BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG UNTIL SCN 10002; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "until": expecting one of: "auxiliary, channel, delete, diskratio, filesperset, force, format, from, include, keep, maxsetsize, noexclude, nokeep, not, pool, reu – mao Aug 30 '14 at 03:28