Databases Reference
In-Depth Information
input datafile file number=00009
name=+DATA/cdb1/c4bd35d102b92f07e04380a8840a6a44/datafile/sysaux.275.788546943
input datafile file number=00007
name=+DATA/cdb1/c4bd2d3ad8c42bf9e04380a8840a451e/datafile/sysaux.270.788546799
input datafile file number=00005
name=+DATA/cdb1/c4bd2d3ad8c42bf9e04380a8840a451e/datafile/system.271.788546799
input datafile file number=00008
name=+DATA/cdb1/c4bd35d102b92f07e04380a8840a6a44/datafile/system.274.788546943
input datafile file number=00004 name=+DATA/cdb1/datafile/undotbs1.260.788546719
input datafile file number=00006 name=+DATA/cdb1/datafile/users.259.788546719
input datafile file number=00010
name=+DATA/cdb1/c4bd35d102b92f07e04380a8840a6a44/datafile/users.277.788546967
channel ORA_DISK_1: starting piece 1 at 21-JUL-12
channel ORA_DISK_1: finished piece 1 at 21-JUL-12
piece handle=+FRA/cdb1/backupset/2012_07_21/nnndf0_tag20120721t173019_0.256.789240621
tag=TAG20120721T173019 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 21-JUL-12
channel ORA_DISK_1: finished piece 1 at 21-JUL-12
piece handle=+FRA/cdb1/backupset/2012_07_21/ncsnf0_tag20120721t173019_0.257.789240677
tag=TAG20120721T173019 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-JUL-12
RMAN>
Note the command in step 3 carefully; you issued just the
backup database
command. You specified nothing
else—no channel creation, no format, nothing. Since you have defined a fast recovery area, the backups go in there by
default. Of course, you can issue a format command and use channels to redirect the backup to a different location,
but as you will see later in this chapter, the fast recovery area provides greater control if you choose to place the
backups there.
How It Works
The solution in this recipe creates backup sets under the directory specified as the fast recovery area. Note the output
carefully and, more specifically, the following line:
piece
handle=+FRA/cdb1/backupset/2012_07_21/nnndf0_tag20120721t173019_0.256.789240621
tag=TAG20120721T173019 comment=NONE
This line of output shows the file created by the RMAN backup process. The file is named
nnndf0_tag20120721t173019_0.256.789240621, which is a pretty strange name in any language. This is what is known
as an Oracle managed file. Ordinarily you don't need to worry about the name since Oracle manages the file on your
behalf—it creates the file with a unique name, deletes the file when not needed, and so on. Since you don't deal with
it, the daunting name does not sound so daunting after all.
Also note the directory in which the backup file was stored. Remember, you set the fast recovery area in Recipe 3-1
to +FRA. The RMAN backup process created a subdirectory called CDB1, the same name as the database you are
