The location conversion method of the RMAN database clone file

When using Rman to clone a database, there is a problem with location conversions if the secondary database (the new database) uses a different path than the target database (the original database). In Oracle, the control file is used to locate the data file and the online redo log file, if there is no correct conversion, the control file can not find the corresponding data file, log file. This oralce provides us with three ways to convert file locations. This article is a description of the three conversion methods.

1. Using Db_file_name_convert and Log_file_name_convert parameters

2. --We can define these two parameters in the secondary database parameter file Spfile/pfile for Oracle to automatically convert file locations based on this value
4. --This parameter can also be used to configure Dataguard is the primary database and standby database file location conversion
6. --The first string defines the target database file location, and the second string defines the secondary database file location
8. -As the following example
10. *.db_file_name_convert = ('/u01/database/sybo3 ', '/u02/database/sybo5 ')
12. *.log_file_name_convert = ('/u01/database/sybo3 ', '/u02/database/sybo5 ')
16. --If other information about the location of the secondary database file, such as the load point, is the same, you can define the parameters directly using the following method
18. --target db Path:/u01/database/sybo3
20. --auxiliary db Path:/U01/DATABASE/SYBO5
22. --Do the following definition
24. *.db_file_name_convert = (' Sybo3 ', ' Sybo5 ')
26. *.log_file_name_convert = (' Sybo3 ', ' Sybo5 ')
30. --if it's the following scenario
32. --target DB Path:
34. /u01/database/sybo3/oradata/system01.dbf
36. /u01/database/sybo3/oradata/sysaux01.dbf
38. /u02/database/sybo3/oradata/undotbs01.dbf
40. /u02/database/sybo3/oradata/users01.dbf
42. /u02/database/sybo3/oradata/example01.dbf
46. --auxiliary DB Path:
48. /u01/database/sybo5/oradata/system01.dbf
50. /u01/database/sybo5/oradata/sysaux01.dbf
52. /u02/database/sybo5/oradata/undotbs01.dbf
54. /u02/database/sybo5/oradata/users01.dbf
56. /u02/database/sybo5/oradata/example01.dbf
60. -As mentioned earlier, because the load point is the same, it can still be defined as above
62. *.db_file_name_convert = (' Sybo3 ', ' Sybo5 ')
64. *.log_file_name_convert = (' Sybo3 ', ' Sybo5 ')
68. -The following is the case after cloning, it is best to clear this two parameters
70. [[email protected] ~]$ Rman target Sys/[email protected] auxiliary sys/[email protected]
74. Rman> duplicate target database to Sybo5; --When the command is published, Oracle automatically creates the secondary database log files and temporary tablespace data files based on the target database
78. sql> Select name,dbid,open_mode from v$database;
82. NAME DBID Open_mode
84. --------- ---------- --------------------
86. SYBO5 2292457546 READ WRITE
90. sql> Show Parameter Name_conve
94. NAME TYPE VALUE
96. ------------------------------------ ----------- ------------------------------
98. Db_file_name_convert string Sybo3, Sybo5
100. Log_file_name_convert string Sybo3, Sybo5
102. Sql> alter system reset Db_file_name_convert;
106. System altered.
110. Sql> alter system reset Log_file_name_convert;
114. System altered.

2. Using the Rman set newname clause

2. RMAN provides us with a set newname clause to specify the location of the secondary database data file and the temporary tablespace data file.
4. The command can also be used for a specific tablespace or data file to recover a data file to a non-failed load point because of a load point failure.
6. As follows:
8. Set newname for datafile m to ' <new_dir>/file_name '
10. Set newname for tempfile N to ' <new_dir>/file_name '
14. If we can use the following command to clone a database
18. Rman> Run
20. {
22. Set newname for datafile 1 to '/u01/database/sybo5/oradata/system01.dbf ';--Specify a new path for the data file
24. Set newname for datafile 2 to '/u01/database/sybo5/oradata/sysaux01.dbf ';
26. Set newname for datafile 3 to '/u01/database/sybo5/oradata/undotbs01.dbf ';
28. Set newname for datafile 4 to '/u01/database/sybo5/oradata/users01.dbf ';
30. Set newname for datafile 5 to '/u01/database/sybo5/oradata/example01.dbf ';
32. Set newname for Tempfile 1 to '/u01/database/sybo5/oradata/temp01.dbf ';--Specify a new path for the log file
34. Duplicate target database to Sybo5-->duplicate command for cloning databases
36. LogFile
38. Group 1 ('/u01/database/sybo5/redo/redo01a.log ','/u01/database/sybo5/redo/redo01b.log ') size 10m,- , you can specify the log group and the number of members, size
40. Group 2 ('/u01/database/sybo5/redo/redo02a.log ','/u01/database/sybo5/redo/redo02b.log ') size 10m, --If the logfile part is not specified, its group number and
42. Group 3 ('/u01/database/sybo5/redo/redo03a.log ','/u01/database/sybo5/redo/redo03b.log ') size 10m;- Number of members, size equals the target database
44. Switch datafile all; --To update the above new path to the control file, this sentence can be omitted (automatically updated)
46. }

3. Using Configure Auxname command

2. Configure Auxname is a new command that starts at Oracle 11g, which stores its values in the control file of the target database
4. Use the following:
6. Configure Auxname for datafile N to ' <new_dir>/file_name ';
8. Configure Auxname for datafile n Clear;
12. --author:robinson
14. --blog:http://blog.csdn.net/robinson_0612
18. The following is the result after setting:
20. Rman> show Auxname;
24. RMAN configuration parameters for database with db_unique_name SYBO3 is:
26. CONFIGURE auxname for datafile '/u01/database/sybo3/oradata/system01.dbf ' to '/u01/database/sybo5/oradata/ SYSTEM01.DBF ';
28. CONFIGURE auxname for datafile '/u01/database/sybo3/oradata/sysaux01.dbf ' to '/u01/database/sybo5/oradata/ SYSAUX01.DBF ';
30. CONFIGURE auxname for datafile '/u01/database/sybo3/oradata/undotbs01.dbf ' to '/u01/database/sybo5/oradata/ UNDOTBS01.DBF ';
32. CONFIGURE auxname for datafile '/u01/database/sybo3/oradata/users01.dbf ' to '/u01/database/sybo5/oradata/ USERS01.DBF ';
34. CONFIGURE auxname for datafile '/u01/database/sybo3/oradata/example01.dbf ' to '/u01/database/sybo5/oradata/ EXAMPLE01.DBF ';
38. Rman>run
40. {
42. Set until time = "To_date (' 20130725 10:09:53 ', ' yyyymmdd hh24:mi:ss ')" and you can specify Time,scn,sequence
44. Set newname for Tempfile 1 to '/u01/database/sybo5/oradata/temp01.dbf ';-Note that configure Auxname does not support tempfile, which requires the use of Set newname
46. Duplicate target database to clone_db Pfile=/u01/oracle/db_1/dbs/initsybo5.ora
48. LogFile
50. '/u01/database/sybo5/redo/redo01a.log ' SIZE 5M,
52. '/u01/database/sybo5/redo/redo02a.log ' SIZE 5M,
54. '/u01/database/sybo5/redo/redo03a.log ' SIZE 5M;
56. }

The location conversion method of the RMAN database clone file