Database Backup and Recovery (MOSC)

MOSC Banner

Control characters not working in "SNAPSHOT CONTROLFILE" stanza in backup script

edited Dec 28, 2010 2:55PM in Database Backup and Recovery (MOSC) 3 commentsAnswered
Hi there,
I'm working on a script that's meant to do rman backup to disk, mostly it works fine but for some reason the control characters that should be able to timestamp the snapshot controlfile aren't being interpreted and instead the file gets created with a name containing the control chars.  This is weird since the other instances in the same script where the control characters exist, they are correctly interpreted.

Examples from the script:

Works: (within a RUN block):
ARCHIVELOG ALL FORMAT '/backup/oracle/DBSID/arch_t%t_s%s_p%p'
(creates files named "arch_t738497519_s3026_p1" and the like)

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