Home > Developer > Database Administrator

Use the Duplicate function of RMAN to create a physical partition uard

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

If the directory on the master and backup is different, add the files in the pfile file on both ends. If the directory is the same, add the following files:

*. Log_file_name_convert = '/u01/oradata/orcl/', '/u02/oradata/orcl /'

*. Db_file_name_convert = '/u01/oradata/orcl/', '/u02/oradata/orcl /'

  1. -- Generate a full backup on the master end, including archiving logs and standby Control Files
  2. [Oracle @ source bak] rman target/
  4. Recovery Manager: Release 10.2.0.1.0-Production on Thursday April 26 23:22:58 2012
  6. Copyright (c) 1982,200 5, Oracle. All rights reserved.
  8. Connected to target database: ORCL (DBID = 1309351439)
  10. RMAN> run {
  11. Backup FORMAT '/home/oracle/bak/orcl _ % U _ % t'
  12. Database
  13. Include current controlfile for standby
  14. Plus archivelog
  15. ;
  16. } 2> 3> 4> 5> 6> 7>
  18. -- Copy the full backup to the backup
  19. [Oracle @ source bak] $ scp * 192.168.1.103: // home/oracle/bak
  21. -- Start pfile to nomount on the slave end and create a spfile;
  22. [Oracle @ target dbs] $ sqlplus/as sysdba
  24. SQL * Plus: Release 10.2.0.1.0-Production on Friday April 27 23:07:28 2012
  26. Copyright (c) 1982,200 5, Oracle. All rights reserved.
  28. Connected to an idle instance.
  30. SQL> startup pfile = initorcl. ora nomount;
  31. ORACLE instance started.
  33. Total System Global Area 276824064 bytes
  34. Fixed Size 2020160 bytes
  35. Variable Size 96472256 bytes
  36. Database Buffers 176160768 bytes
  37. Redo Buffers 2170880 bytes
  38. SQL> create spfile from pfile = 'initorcl. ora ';
  40. File created.
  42. -- Create dg using RMAN Duplicate on the master end. If the directory of the data file is the same as that of the redo log file, add nofilenamecheck. Otherwise, no need to add
  43. [Oracle @ source bak] $ rmant an target/
  45. Recovery Manager: Release 10.2.0.1.0-Production on 4 27 23:08:23 2012
  47. Copyright (c) 1982,200 5, Oracle. All rights reserved.
  49. Connected to target database: ORCL (DBID = 1309351439)
  51. RMAN> connect auxiliary sys/oracle @ orcl_st
  53. Connected to auxiliary database: ORCL (not mounted)
  55. RMAN> run {
  56. Duplicate target database
  57. For standby nofilenamecheck dorecover;
  58. } 2> 3> 4>
  60. Starting Duplicate Db at 2012-04-27 23:08:45
  61. Using target database control file instead of recovery catalog
  62. Allocated channel: ORA_AUX_DISK_1
  63. Channel ORA_AUX_DISK_1: sid = 155 devtype = DISK
  65. Contents of Memory Script:
  66. {
  67. Set until scn 611334;
  68. Restore clone standby controlfile;
  69. SQL clone 'alter database mount standby database ';
  70. }
  71. Executing Memory Script
  73. Executing command: SET until clause
  75. Starting restore at 2012-04-27 23:08:45
  76. Using channel ORA_AUX_DISK_1
  78. Channel ORA_AUX_DISK_1: starting datafile backupset restore
  79. Channel ORA_AUX_DISK_1: restoring control file
  80. Channel ORA_AUX_DISK_1: reading from backup piece/home/oracle/bak/orcl_0cn9gs8i_1_1_20120427
  81. Channel ORA_AUX_DISK_1: restored backup piece 1
  82. Piece handle =/home/oracle/bak/orcl_0cn9gs8i_1_1_20427 tag = TAG20120427T223632
  83. Channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
  84. Output filename =/home/oracle/oradata/orcl/control01.ctl
  85. Output filename =/home/oracle/oradata/orcl/control02.ctl
  86. Output filename =/home/oracle/oradata/orcl/control03.ctl
  87. Finished restore at 23:08:47
  89. SQL statement: alter database mount standby database
  90. Released channel: ORA_AUX_DISK_1
  92. Contents of Memory Script:
  93. {
  94. Set until scn 611334;
  95. Set newname for tempfile 1
  96. "/Home/oracle/oradata/orcl/temp01.dbf ";
  97. Switch clone tempfile all;
  98. Set newname for datafile 1
  99. "/Home/oracle/oradata/orcl/system01.dbf ";
  100. Set newname for datafile 2
  101. "/Home/oracle/oradata/orcl/undotbs01.dbf ";
  102. Set newname for datafile 3
  103. "/Home/oracle/oradata/orcl/sysaux01.dbf ";
  104. Set newname for datafile 4
  105. "/Home/oracle/oradata/orcl/users01.dbf ";
  106. Restore
  107. Check readonly
  108. Clone database
  109. ;
  110. }
  111. Executing Memory Script
  113. Executing command: SET until clause
  115. Executing command: SET NEWNAME
  117. Renamed temporary file 1 to/home/oracle/oradata/orcl/temp01.dbf in control file
  119. Executing command: SET NEWNAME
  121. Executing command: SET NEWNAME
  123. Executing command: SET NEWNAME
  125. Executing command: SET NEWNAME
  127. Starting restore at 2012-04-27 23:08:53
  128. Allocated channel: ORA_AUX_DISK_1
  129. Channel ORA_AUX_DISK_1: sid = 155 devtype = DISK
  131. Channel ORA_AUX_DISK_1: starting datafile backupset restore
  132. Channel ORA_AUX_DISK_1: specifying datafile (s) to restore from backup set
  133. Restoring datafile 00001 to/home/oracle/oradata/orcl/system01.dbf
  134. Restoring datafile 00002 to/home/oracle/oradata/orcl/undotbs01.dbf
  135. Restoring datafile 00003 to/home/oracle/oradata/orcl/sysaux01.dbf
  136. Restoring datafile 00004 to/home/oracle/oradata/orcl/users01.dbf
  137. Channel ORA_AUX_DISK_1: reading from backup piece/home/oracle/bak/orcl_0bn9gs3g_1_1_20120427
  138. Channel ORA_AUX_DISK_1: restored backup piece 1
  139. Piece handle =/home/oracle/bak/orcl_0bn9gs3g_0000000020120427 tag = TAG20120427T223632
  140. Channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:15
  141. Finished restore at 23:10:10
  143. Contents of Memory Script:
  144. {
  145. Switch clone datafile all;
  146. }
  147. Executing Memory Script
  149. Datafile 1 switched to datafile copy
  150. Input datafile copy recid = 5 stamp = 781744210 filename =/home/oracle/oradata/orcl/system01.dbf
  151. Datafile 2 switched to datafile copy
  152. Input datafile copy recid = 6 stamp = 781744210 filename =/home/oracle/oradata/orcl/undotbs01.dbf
  153. Datafile 3 switched to datafile copy
  154. Input datafile copy recid = 7 stamp = 781744210 filename =/home/oracle/oradata/orcl/sysaux01.dbf
  155. Datafile 4 switched to datafile copy
  156. Input datafile copy recid = 8 stamp = 781744210 filename =/home/oracle/oradata/orcl/users01.dbf
  158. Contents of Memory Script:
  159. {
  160. Set until scn 611334;
  161. Recover
  162. Standby
  163. Clone database
  164. Delete archivelog
  165. ;
  166. }
  167. Executing Memory Script
  169. Executing command: SET until clause
  171. Starting recover at 23:10:10
  172. Using channel ORA_AUX_DISK_1
  174. Starting media recovery
  176. Archive log thread 1 sequence 13 is already on disk as file/home/oracle/archive/1_13_781570707.dbf
  177. Archive log filename =/home/oracle/archive/1_13_781570707.dbf thread = 1 sequence = 13
  178. Media recovery complete, elapsed time: 00:00:02
  179. Finished recover at 23:10:14
  180. Finished Duplicate Db at 23:10:14

After completion, the slave database starts to the mount state, and then verifies the DG.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More