Database Backup and Recovery (MOSC)

MOSC Banner

archive logs deletion

edited Aug 9, 2018 3:24AM in Database Backup and Recovery (MOSC) 7 commentsAnswered

Dear Support,

Need your help.In our environment,archivelogs are not getting deleted automatically.we are on 12.1.0 and we dont use flash recovery area

L0 script

======

[oraprod@node2~]$ cat /home/scripts/rman_backup_DB.sh

#!/usr/bin/ksh

#set -x

######## Variables #######

##########################

RUNTIME=`date '+%H%M%S_%d%m%Y'`

RUNDATE=`date '+%d%m%Y'`

###### Input Values #######

###########################

ORACLE_HOME=/u02/DB/12.1.0

ORACLE_SID=DB2

ORACLE_DB=DB

LOGDIR=/home/oraprod/rman/logs

BACKUP_BASE=/u03/PRODRMAN

PATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin

NLS_DATE_FORMAT='DD-MM-YY HH24:MI:SS'

export ORACLE_HOME PATH NLS_DATE_FORMAT NODE_NAME BACKUP_BASE ORACLE_SID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center