Oracle 使用Duplicating转换路径

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
上一篇:sed的用法练习


下一篇:吴裕雄 python深度学习与实践(6)