Database Backup and Recovery (MOSC)

MOSC Banner

Issue on RMAN backup by a batch file

edited Jul 1, 2010 1:34AM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓
Why my batch file did not run the second line below?

--start_backup.bat--

rman target sys/sys_pwd@mySid
@D:\dbbackup\sys_admin\rman_scripts\rman_blk_L1.BAT

--------------------------

On the file, \dbbackup\sys_admin\rman_scripts\rman_blk_L1.BAT

run {
SQL "ALTER DATABASE BACKUP CONTROLFILE TO TRACE";
allocate channel EAG1 type disk;
BACKUP INCREMENTAL LEVEL 1
tag='MPSA2 LVL 1 Incremental DB BKUP'
format 'D:\dbbackup\RMAN\Level_1\MPSA2L1_t%t_s%s_p%p_c%c.bak'
filesperset 5
DATABASE
INCLUDE CURRENT CONTROLFILE;
BACKUP CURRENT CONTROLFILE TAG='curcfbkp';

BACKUP archivelog all format
'D:\dbbackup\RMAN\Level_1\MPSA2%d_AL_%T_%u_s%s_p%p.arc'; #delete input;

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