Database Backup and Recovery (MOSC)

MOSC Banner

how to skip errors run within RMAN cmdfile

edited Aug 28, 2011 10:49PM in Database Backup and Recovery (MOSC) 5 commentsAnswered
Hi,

I have a cmdfile created which will remove all the global stored script in recovery catalog e.g:

DELETE GLOBAL SCRIPT  full_backup_scr;

DELETE GLOBAL SCRIPT  archive_backup_scr;

When i try run the cmdfile, if rman couldn't find full_backup_scr, it will report below error message and exit, without proceed to delete the next stored script - archive_backup_scr

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete script command at 08/27/2011 09:33:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20400: stored script not found
RMAN-06710: script full_backup_scr not found in catalog

How do I skip the error without exiting the rman session, and continue with the next command in cmdfile? The reason i want to do this because i have hundred of databases and recovery catalogs that need to run this to remove some of the global script and i do not want to do it manually.

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