Database Backup and Recovery (MOSC)

MOSC Banner

RMAN Scheduled backup fail

edited Apr 15, 2014 12:00PM in Database Backup and Recovery (MOSC) 2 commentsAnswered

Hi all,

I am using oracle database 12c and scheduling tasks to run RMAN backup scripts on Windows.

I created a batch file with scripts to mount on Windows scheduler. Scripts details are as follows:

Startbackup.bat:

cd \app\Scripts\Backup\Backup_Scripts_DEV

set ORACLE_SID=HRDEV

set YYYY=%DATE:~10%

set MM=%DATE:~4,2%

set DD=%DATE:~7,2%

set HRS=%TIME:~1,1%

set MIN=%TIME:~3,2%

set SEC=%TIME:~6,2%

set backup_date=%YYYY%%MM%%DD%_%HRS%%MIN%%SEC%

set backup_folder=%ORACLE_SID%_%backup_date%

mkdir \app\oracle\oradata\RMAN_BACKUP\HRDEV_BAK\%backup_folder%

mkdir \app\oracle\oradata\RMAN_BACKUP\HRDEV_BAK\HRDEV

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