Differences

This shows you the differences between two versions of the page.

--- rman_duplicate [2022/11/10 12:06] – created mduersch
+++ rman_duplicate [2022/11/14 11:57] (current) – mduersch
@@ Line 41: / Line 41: @@
    RMAN> CONNECT CATALOG rman_owner@ONETST;    # recovery catalog database
    connected to recovery catalog database
+Method one (filnames in script):
    run {
-    ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE disk;
+        ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE disk;
-    ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE disk;
+        ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE disk;
-	SET NEWNAME FOR DATAFILE 1 /oracle/data4/TWOTST/datafile/system_001.dbf
+        SET NEWNAME FOR DATAFILE 1 /oracle/data4/TWOTST/datafile/system_001.dbf
-	SET NEWNAME FOR DATAFILE 2 /oracle/data4/TWOTST/datafile/sysaux_001.dbf
+        SET NEWNAME FOR DATAFILE 2 /oracle/data4/TWOTST/datafile/sysaux_001.dbf
-	SET NEWNAME FOR DATAFILE 3 /oracle/data4/TWOTST/datafile/databyhora.dbf
+        SET NEWNAME FOR DATAFILE 3 /oracle/data4/TWOTST/datafile/databyhora.dbf
-	SET NEWNAME FOR DATAFILE 4 /oracle/data4/TWOTST/datafile/tools_001.dbf
+        SET NEWNAME FOR DATAFILE 4 /oracle/data4/TWOTST/datafile/tools_001.dbf
-	SET NEWNAME FOR DATAFILE 5 /oracle/data4/TWOTST/datafile/data_001.dbf
+        SET NEWNAME FOR DATAFILE 5 /oracle/data4/TWOTST/datafile/data_001.dbf
-	SET NEWNAME FOR DATAFILE 6 /oracle/data4/TWOTST/datafile/undotwo_001.dbf
+        SET NEWNAME FOR DATAFILE 6 /oracle/data4/TWOTST/datafile/undotwo_001.dbf
-	SET NEWNAME FOR DATAFILE 7 /oracle/data4/TWOTST/datafile/data_002.dbf
+        SET NEWNAME FOR DATAFILE 7 /oracle/data4/TWOTST/datafile/data_002.dbf
-    DUPLICATE TARGET DATABASE TO 'DUPDB'
+        DUPLICATE TARGET DATABASE TO 'DUPDB'
-    SKIP TABLESPACE tools
+        #SKIP TABLESPACE tools
-    LOGFILE
+        LOGFILE
-      GROUP 1 ('/oracle/data1/TWOTST/onlinelog/redo1_1.rdo',
+                  GROUP 1 ('/oracle/data1/TWOTST/onlinelog/redo1_1.rdo',
 			   '/oracle/data1/TWOTST/onlinelog/redo2_1.rdo',
 			   '/oracle/data1/TWOTST/onlinelog/redo3_1.rdo',
-               '/oracle/data1/TWOTST/onlinelog/redo4_1.rdo') SIZE 200M REUSE,
+                           '/oracle/data1/TWOTST/onlinelog/redo4_1.rdo') SIZE 200M REUSE,
-      GROUP 2 ('/oracle/data1/TWOTST/onlinelog/redo2_1.rdo',
+                  GROUP 2 ('/oracle/data2/TWOTST/onlinelog/redo2_1.rdo',
-			   '/oracle/data1/TWOTST/onlinelog/redo2_2.rdo',
+			   '/oracle/data2/TWOTST/onlinelog/redo2_2.rdo',
-			   '/oracle/data1/TWOTST/onlinelog/redo3_2.rdo',
+			   '/oracle/data2/TWOTST/onlinelog/redo3_2.rdo',
-               '/oracle/data1/TWOTST/onlinelog/redo4_2.rdo') SIZE 200M REUSE,
+                           '/oracle/data2/TWOTST/onlinelog/redo4_2.rdo') SIZE 200M REUSE,
     }
+Method two (filenames in initSID.ora via db_file_name_convert, log_file_name_convert: