Example 25-1 Duplicating with SET NEWNAME FOR DATAFILE
RUN { SET NEWNAME FOR DATAFILE 1 TO '/oradata1/system01.dbf'; SET NEWNAME FOR DATAFILE 2 TO '/oradata2/sysaux01.dbf'; SET NEWNAME FOR DATAFILE 3 TO '/oradata3/undotbs01.dbf'; SET NEWNAME FOR DATAFILE 4 TO '/oradata4/users01.dbf'; SET NEWNAME FOR DATAFILE 5 TO '/oradata5/users02.dbf'; SET NEWNAME FOR TEMPFILE 1 TO '/oradatat/temp01.dbf'; DUPLICATE TARGET DATABASE TO dupdb SKIP TABLESPACE tools LOGFILE GROUP 1 ('/duplogs/redo01a.log', '/duplogs/redo01b.log') SIZE 4M REUSE, GROUP 2 ('/duplogs/redo02a.log', '/duplogs/redo02b.log') SIZE 4M REUSE; }
Example 25-2 is a variation of Example 25-1 and uses one SET NEWNAME
command to name all data files in the tablespace users
. Once the example completes, the file names for tablespace users
are set to: /oradata4/users01.dbf
and /oradata5/users02.dbf
.
Example 25-2 Duplicating with SET NEWNAME FOR DATAFILE and FOR TABLESPACE
RUN { SET NEWNAME FOR TABLESPACE users TO '/oradata%f/%b'; SET NEWNAME FOR DATAFILE 1 TO '/oradata1/system01.dbf'; SET NEWNAME FOR DATAFILE 2 TO '/oradata2/sysaux01.dbf'; SET NEWNAME FOR DATAFILE 3 TO '/oradata3/undotbs01.dbf'; SET NEWNAME FOR TEMPFILE 1 TO '/oradatat/temp01.dbf'; DUPLICATE TARGET DATABASE TO dupdb SKIP TABLESPACE tools LOGFILE GROUP 1 ('/duplogs/redo01a.log', '/duplogs/redo01b.log') SIZE 4M REUSE, GROUP 2 ('/duplogs/redo02a.log', '/duplogs/redo02b.log') SIZE 4M REUSE; }
Example 25-3 is a variation of Example 25-1 and uses a single SET
command to name all data files in the database.
Example 25-3 Duplicating with SET NEWNAME FOR DATABASE
RUN { SET NEWNAME FOR DATABASE TO '/oradata/%U'; DUPLICATE TARGET DATABASE TO dupdb SKIP TABLESPACE tools LOGFILE GROUP 1 ('/duplogs/redo01a.log', '/duplogs/redo01b.log') SIZE 4M REUSE, GROUP 2 ('/duplogs/redo02a.log', '/duplogs/redo02b.log') SIZE 4M REUSE;
参考地址:https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupad.htm#BRADV441