Forum Stats

  • 3,768,013 Users
  • 2,252,740 Discussions
  • 7,874,409 Comments

Discussions

regarding archive log backup

User_URPA8
User_URPA8 Member Posts: 485 Blue Ribbon
edited Jul 20, 2020 6:33AM in Recovery Manager (RMAN)

Hi Experts,

Our db version 12.1.0.2 RAC(2node)

We have scheduled rman L0 backup runs every day morning 01:00 AM that completes in 40minutes.

Every 1 hour,we have scheduled archivelog backup.We would like to know if it is possible to take archivelog backup to 2 locations in the same script?

Right now,the archive backup is happening to {BACKUPDIR} folder as below script does.We would like to to backup to different location as well(external hard disk)

our archivelog backup script

exec >> ${LOGFILE} 2>&1

${ORACLE_HOME}/bin/rman target / nocatalog <<EOF!

configure retention policy to recovery window of 5 DAYS; # default 1

CONFIGURE BACKUP OPTIMIZATION OFF; # default OFF

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON; # default OFF

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${BACKUPDIR}/ora_cf%F'; # default '%F'

CONFIGURE DEVICE TYPE DISK PARALLELISM 2; # default 1

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '${BACKUPDIR}/ora_df%t_s%s_s%p';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/PROD/db/apps_st/data/archive/SSSEBSPR/rman/snapcfarchive%t_PRODDB.f';

SHOW ALL;

sql "alter system archive log current";

BACKUP ARCHIVELOG ALL NOT BACKED UP 1 TIMES;

EOF!

sqlplus -s "/as sysdba"<<EOF

alter database backup controlfile to trace as '${BACKUPDIR}/ctrlfile_${ORACLE_SID}_${RUNTIME}';

EXIT;

EOF

[[email protected] ~]$

Thank You

Answers