RMAN Backup Archive logs until SCN:

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    2161903

RMAN>  backup archivelog until scn  2161903  delete input;

Starting backup at 12-AUG-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=60 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=5 STAMP=1080341951
input archived log thread=1 sequence=10 RECID=6 STAMP=1080425353
channel ORA_DISK_1: starting piece 1 at 12-AUG-21
channel ORA_DISK_1: finished piece 1 at 12-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/0q06buvj_1_1 
tag=TAG20210812T221059 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file 
name=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch1_9_1080337722.dbf RECID=5 
STAMP=1080341951
archived log file 
name=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch1_10_1080337722.dbf RECID=6 
STAMP=1080425353
Finished backup at 12-AUG-21

Starting Control File and SPFILE Autobackup at 12-AUG-21
piece handle=/u01/app/oracle/product/19.0.0/dbhome_1/dbs/c-1608118455-20210812-00 
comment=NONE
Finished Control File and SPFILE Autobackup at 12-AUG-21

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8