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?
Use UNTIL SCN parameter, for example:
UNTIL SCN
RMAN> BACKUP AS BACKUPSET DATABASE PLUS ARCHIVELOG UNTIL SCN 10002
Relevant Oracle Docs page