Skip to Main Content


Question and Answer

Connor McDonald

Thanks for the question, Abdul Wahid.

Asked: October 05, 2021 - 12:20 pm UTC

Last updated: October 08, 2021 - 3:04 am UTC

Version: 19c

Viewed 100+ times

You Asked


I have a multi tenant 19c database

below is the directory where my archives are generated


in this I have a folder with today's date


and below are archives generated in it

o1_mf_1_783_joqsfg35_.arc o1_mf_1_785_joqy8dk1_.arc o1_mf_1_787_jor31mh6_.arc o1_mf_1_789_jor7wz6n_.arc o1_mf_1_791_jorf9hoc_.arc
o1_mf_1_784_joqw4oq3_.arc o1_mf_1_786_jor0d91w_.arc o1_mf_1_788_jor5681t_.arc o1_mf_1_790_jorbn5gh_.arc o1_mf_1_792_jorhyqhs_.arc

is there a way to only backup (using rman) the archives generated in today's folder

I need this because I will then create a backup script which will take rman backup of

archives generated today
control file

then using this backup I will refresh my database on test server

please assist

Abdul Wahid Solanki

and Connor said...

Here's the hint from RMAN :-)

RMAN> backup archivelog;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "all, from, high, like, low, scn, sequence, time, until"   <<<<==========
RMAN-01007: at line 1 column 18 file: standard input

You can pick and choose whatever archive log range you like

More to Explore


Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.