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

 

# Specific settings #

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

 

export LOGFILE=${LOGDIR}/DB_${ORACLE_SID}_${RUNTIME}.log

export BACKUPDIR=${BACKUP_BASE}/${ORACLE_SID}/rman

#### Rman backup ##

######CONFIGURE SNAPSHOT CONTROLFILE NAME TO '${BACKUPDIR}/snapcf_${ORACLE_SID}.f';####

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

 

 

exec >> ${LOGFILE} 2>&1

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

configure retention policy to recovery window of 20 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 4; # 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 '+DATADG/DB/CONTROLFILE/snapcf_DB.f';

SHOW ALL;

 

sql "alter system archive log current";

 

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL=0 spfile format '${BACKUPDIR}/spfile_%d_%s_%T.bak' DATABASE INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG;

 

crosscheck backup;

crosscheck archivelog all;

REPORT OBSOLETE;

DELETE FORCE NOPROMPT OBSOLETE;

DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 3 TIMES to disk;

 

LIST BACKUP OF DATABASE;

LIST BACKUP OF ARCHIVELOG ALL;

LIST BACKUP;

 

EOF!

sqlplus -s "/as sysdba"<<EOF

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

EXIT;

EOF

 

 

L1 script

======

[oraprod@node2 ~]$ cat /home/scripts/rman_incr_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

 

# Specific settings #

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

 

export LOGFILE=${LOGDIR}/DB_${ORACLE_SID}_${RUNTIME}.log

export BACKUPDIR=${BACKUP_BASE}/${ORACLE_SID}/rman

 

#### Rman backup ##

######CONFIGURE SNAPSHOT CONTROLFILE NAME TO '${BACKUPDIR}/snapcf_${ORACLE_SID}.f';####

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

 

exec >> ${LOGFILE} 2>&1

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

configure retention policy to recovery window of 20 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 4; # 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 '+DATADG/DB/CONTROLFILE/snapcf_DB.f';

SHOW ALL;

 

sql "alter system archive log current";

 

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL=1 spfile format '${BACKUPDIR}/spfile_%d_%s_%T.bak' DATABASE INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG;

 

 

crosscheck backup;

crosscheck archivelog all;

REPORT OBSOLETE;

DELETE FORCE NOPROMPT OBSOLETE;

DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 3 TIMES to disk;

 

LIST BACKUP OF DATABASE;

LIST BACKUP OF ARCHIVELOG ALL;

LIST BACKUP;

 

EOF!

 

sqlplus -s "/as sysdba"<<EOF

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

EXIT;

EOF

 

 

sample archivelogs on server:

 

 

[oraprod@node2 rman]$ ls -lrt|head -50

total 1262361700

-rw-r----- 1 oraprod asmadmin    57869824 Jul  5 11:40 ora_df980682015_s83931_s1

-rw-r----- 1 oraprod asmadmin   166964224 Jul  5 11:40 ora_df980682015_s83930_s1

-rw-r----- 1 oraprod asmadmin    55591936 Jul  5 12:00 ora_df980683214_s83933_s1

-rw-r----- 1 oraprod asmadmin    43500544 Jul  5 12:00 ora_df980683214_s83934_s1

-rw-r----- 1 oraprod asmadmin    41402880 Jul  5 12:20 ora_df980684414_s83937_s1

-rw-r----- 1 oraprod asmadmin    42059264 Jul  5 12:20 ora_df980684414_s83936_s1

-rw-r----- 1 oraprod asmadmin    51293184 Jul  5 12:40 ora_df980685615_s83940_s1

-rw-r----- 1 oraprod asmadmin   301405696 Jul  5 12:40 ora_df980685615_s83939_s1

-rw-r----- 1 oraprod asmadmin    22060032 Jul  5 13:00 ora_df980686815_s83943_s1

-rw-r----- 1 oraprod asmadmin    24556544 Jul  5 13:00 ora_df980686815_s83942_s1

-rw-r----- 1 oraprod asmadmin    12795392 Jul  5 13:20 ora_df980688014_s83946_s1

-rw-r----- 1 oraprod asmadmin    51200512 Jul  5 13:20 ora_df980688014_s83945_s1

-rw-r----- 1 oraprod asmadmin    12767744 Jul  5 13:40 ora_df980689214_s83949_s1

-rw-r----- 1 oraprod asmadmin    35804160 Jul  5 13:40 ora_df980689214_s83948_s1

-rw-r----- 1 oraprod asmadmin     9438208 Jul  5 14:00 ora_df980690414_s83952_s1

-rw-r----- 1 oraprod asmadmin    13514752 Jul  5 14:00 ora_df980690414_s83951_s1

-rw-r----- 1 oraprod asmadmin    26064384 Jul  5 14:20 ora_df980691615_s83955_s1

-rw-r----- 1 oraprod asmadmin    26067456 Jul  5 14:20 ora_df980691615_s83954_s1

-rw-r----- 1 oraprod asmadmin    31678464 Jul  5 14:40 ora_df980692815_s83958_s1

-rw-r----- 1 oraprod asmadmin    34029568 Jul  5 14:40 ora_df980692815_s83957_s1

-rw-r----- 1 oraprod asmadmin    59704320 Jul  5 15:00 ora_df980694014_s83961_s1

-rw-r----- 1 oraprod asmadmin    81807360 Jul  5 15:00 ora_df980694014_s83960_s1

-rw-r----- 1 oraprod asmadmin    99200512 Jul  5 15:20 ora_df980695215_s83964_s1

-rw-r----- 1 oraprod asmadmin   119849472 Jul  5 15:20 ora_df980695215_s83963_s1

-rw-r----- 1 oraprod asmadmin    45508096 Jul  5 15:40 ora_df980696415_s83967_s1

-rw-r----- 1 oraprod asmadmin    64638976 Jul  5 15:40 ora_df980696415_s83966_s1

-rw-r----- 1 oraprod asmadmin    33192448 Jul  5 16:00 ora_df980697614_s83970_s1

-rw-r----- 1 oraprod asmadmin    40496128 Jul  5 16:00 ora_df980697614_s83969_s1

-rw-r----- 1 oraprod asmadmin   176486400 Jul  5 16:20 ora_df980698815_s83973_s1

-rw-r----- 1 oraprod asmadmin   317603328 Jul  5 16:20 ora_df980698815_s83972_s1

-rw-r----- 1 oraprod asmadmin    47336960 Jul  5 16:40 ora_df980700014_s83976_s1

-rw-r----- 1 oraprod asmadmin   131053056 Jul  5 16:40 ora_df980700014_s83975_s1

-rw-r----- 1 oraprod asmadmin    21742592 Jul  5 17:00 ora_df980701215_s83979_s1

-rw-r----- 1 oraprod asmadmin    36524032 Jul  5 17:00 ora_df980701215_s83978_s1

-rw-r----- 1 oraprod asmadmin    19049472 Jul  5 17:20 ora_df980702415_s83982_s1

-rw-r----- 1 oraprod asmadmin    39199744 Jul  5 17:20 ora_df980702415_s83981_s1

-rw-r----- 1 oraprod asmadmin    15950336 Jul  5 17:40 ora_df980703615_s83985_s1

-rw-r----- 1 oraprod asmadmin    49357824 Jul  5 17:40 ora_df980703615_s83984_s1

-rw-r----- 1 oraprod asmadmin    10236928 Jul  5 18:00 ora_df980704814_s83989_s1

-rw-r----- 1 oraprod asmadmin    24525824 Jul  5 18:00 ora_df980704814_s83988_s1

-rw-r----- 1 oraprod asmadmin   369730560 Jul  5 18:00 ora_df980704814_s83987_s1

-rw-r----- 1 oraprod asmadmin     6118400 Jul  5 18:20 ora_df980706015_s83992_s1

-rw-r----- 1 oraprod asmadmin     6767104 Jul  5 18:20 ora_df980706015_s83991_s1

-rw-r----- 1 oraprod asmadmin    12044800 Jul  5 18:40 ora_df980707214_s83994_s1

-rw-r----- 1 oraprod asmadmin    10872832 Jul  5 18:40 ora_df980707214_s83995_s1

-rw-r----- 1 oraprod asmadmin     5065216 Jul  5 19:00 ora_df980708414_s83998_s1

-rw-r----- 1 oraprod asmadmin    10508800 Jul  5 19:00 ora_df980708414_s83997_s1

-rw-r----- 1 oraprod asmadmin     1699840 Jul  5 19:20 ora_df980709615_s84001_s1

-rw-r----- 1 oraprod asmadmin     3467264 Jul  5 19:20 ora_df980709615_s84000_s1

[oraprod@node2 rman]$