Skip to Main Content

Breadcrumb

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

Hi

I have a multi tenant 19c database

below is the directory where my archives are generated

/erpprd64/oradata/prd64cdb/fast_recovery_area/PRD64CDB/archivelog/

in this I have a folder with today's date

2021_10_05

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

database
archives generated today
control file

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

please assist

Thanks,
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

https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50


More to Explore

Backup/Recovery

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