Database Administration (MOSC)

MOSC Banner

Create batch file for click run backup rman

edited June 2016 in Database Administration (MOSC) 2 commentsAnswered ✓

Hello guys,

I've got request to create rman by using click on windows server 2012 R2 environment.

I've create a file.bat for daily and weekly backup.

Here's i've create 2 file

backu_daily_prod.bat

cmdfile=D:\u01\PROD\12.1.0\prod_aj-jkt-ebsdb.cmd

cd C:\Users\Administrator\Desktop\how-to\backup\script

rman target / @backup_daily_prod.cmd log=backup_daily_prod_%date:~4,2%_%date:~7,2%_%date:~10%.log

backup_daily_prod.cmd

run{

Allocate channel ch1 type disk format 'G:\BACKUP\%d_data_daily_%U.ach' maxpiecesize 100G;

Allocate channel ch2 type disk format 'G:\BACKUP\%d_data_daily_%U.ach' maxpiecesize 100G;

Backup incremental level=1 as compressed backupset database plus archivelog tag='Incremental_Backup';

Howdy, Stranger!

Log In

To view full details, sign in.

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