Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-02 |
|
|
View PDF |
When performing tablespace point-in-time recovery (TSPITR) or duplicating a database using RMAN, you may want to set the names of datafiles in the auxiliary instance before startingthe actual TSPITR or database duplication.
The command for doing so is:
CONFIGURE AUXNAME FOR datafileSpec TO 'filename';
where datafileSpec
identifies some datafile by its original name or datafile number, and filename
is the new path for the specified file.
For example, you might configure a new auxiliary name for datafile 2 as follows:
CONFIGURE AUXNAME FOR DATAFILE 2 TO '/newdisk/datafiles/df2.df;'
As with other settings, this CONFIGURE
setting is persistent across RMAN sessions until cleared using CONFIGURE
... CLEAR
, as shown here:
CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;
If you are performing TSPITR or running the DUPLICATE
command, then by using CONFIGURE AUXNAME
you can preconfigure the filenames for use on the auxiliary database without manually specifying the auxiliary filenames during the procedure.
When renaming files with the DUPLICATE
command, CONFIGURE AUXNAME
is an alternative to SET NEWNAME
. The difference is that after you set the AUXNAME
the first time, you do not need to reset the filename when you issue another DUPLICATE
command: the AUXNAME
setting remains in effect until you issue CONFIGURE AUXNAME
... CLEAR
. In contrast, you must reissue the SET NEWNAME
command every time you rename files.
See Chapter 8, "RMAN Tablespace Point-in-Time Recovery (TSPITR)" for more details on using CONFIGURE
AUXNAME
in connection with TSPITR, and Chapter 13, "Creating and Updating Duplicate Databases with RMAN" for more on using CONFIGURE
AUXNAME
in performing database duplication.
To view auxiliary datafile names currently configured for your database, you can use the SHOW AUXNAME command:
RMAN> SHOW AUXNAME;
Sample output follows:
RMAN configuration parameters are: CONFIGURE AUXNAME FOR DATAFILE '/oracle/oradata/trgt/tools01.dbf' TO '/tmp/tools01.dbf';