Databases Reference
In-Depth Information
It's important to understand that the backup
...
backupset
command produces additional copies of the backup
pieces in the backup set but doesn't create a new backup set itself with a different backup set key.
Making Copies of Image Copy Backups
Problem
You want to make copies of image copy backups you've already made using RMAN.
Solution
Use the
backup as copy
or
backup as backupset
command to make copies of image copies made by RMAN.
Here are some examples:
RMAN> backup as copy copy of database;
RMAN> backup as backupset copy of tablespace users;
RMAN> backup as backupset copy of datafile 4;
The first
backup as copy
command makes an image copy of an image copy of the database. Make sure you make
an image copy of the database first! The second command,
backup as backupset
, creates a backup set from an image
copy of a tablespace. The third command,
backup as backupset
, creates a backup set from an image copy of a data file.
The following example shows how to copy two data files using the tag
weekly_copy
. The example creates the data
file copies in a new location and names them using substitution variables:
RMAN> backup as copy
copy of datafile 2,3
from tag 'weekly_copy'
format '/backup/datafile%f_Database%d';
In the previous example, the
format
parameter uses the percent sign (%) as a wildcard that means zero or more
characters. Use an underscore (_) instead of the percent sign to refer to exactly one character. The syntax element
f
refers to the absolute file number, and the syntax element
d
specifies the name of the database.
The following example shows how to make an image copy of a database copy to the default destination:
RMAN> backup as copy
copy of database
from tag "test";
The previous command will create new copies of the original image copy of the database with the tag
test
.
How It Works
You can use either the
copy of database
,
copy of tablespace
, or
copy of datafile
clause to make a backup of an
image copy of a database, tablespace, or data file, respectively. Note that the output of any of these commands can be
either an image copy or a backup set.
