Database Administration (MOSC)

MOSC Banner

RMAN backup script

edited Nov 26, 2015 10:06AM in Database Administration (MOSC) 3 commentsAnswered

Hi Experts,

The below script does not run when we schedule it in cron job but when we run it manually it completes successfully.

cron job:

00 16 * * * /u2/oracle/dailybkp.ksh

dailybkp.ksh script

#!/bin/bash

export DATE=$(date +"%d-%m-%Y")

export ORACLE_SID=UAT

rman target / catalog rman_rc/rman_rc@orcl log=/u2/oracle/rman_bkp/rman_bkp_logs/fullbkp_${DATE}.log << EOF

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u2/oracle/rman_bkp/uat/Autobkp_Cntrl_File_%F_%T';

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u2/oracle/rman_bkp/uat/snapcf_UAT.ctl';

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