Database Backup and Recovery (MOSC)

MOSC Banner

BACKUP ... FORMAT '%U' Default?

edited Oct 29, 2012 1:16AM in Database Backup and Recovery (MOSC) 13 commentsAnswered
In Oracle documentation I read that when issuing the BACKUP command without FORMAT and by issuing the backup command with FORMAT '%U' the filenames should be the same. That's why '%U' is considered default. See below link (Scroll down to FORMAT clause):

http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta007.htm#RCMRF107

So I test this in my environment.

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

First I issue:

backup as copy datafile 1;

and the filename I get is O1_MF_SYSTEM_881NQOC2_.DBF

Not the '%U' format.

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

Then I issue:

backup as copy datafile 1 format 'C:\app\fast_recovery_area\dhman\DATAFILE\%U';

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