RMAN不停機搭建DG

前面pfile引數等配置 參考如下：
http://blog.itpub.net/29990276/viewspace-1683772/

點選( 此處 )摺疊或開啟

1. run{
   

2. allocate channel c1 type disk ;
   

3. allocate channel c2 type disk ;
   

4. sql 'alter system archive log current' ;
   

5. backup format '/backup/db_%U_%T' skip inaccessible filesperset 5 database ;
   

6. sql 'alter system archive log current' ;
   

7. backup format '/backuparch/arch_%U_%T' skip inaccessible filesperset 5 archivelog all delete input ;
   

8. backup current controlfile for standby format = '/backup/control_%U' ;
   

9. release channel c1 ;
   

10. release channel c2 ;
    

11. }

scp備份集到備庫相應的目錄

點選( 此處 )摺疊或開啟

1. [ oracle@primary backuparch ] $ scp * 192 . 168 . 6 . 31 : / backuparch/

2. oracle@192 . 168 . 6 . 31 's password:
   

3. arch_05q8hd9e_1_1_20150603                                                                                                                                   100%   61MB  15.2MB/s   00:04
   

4. arch_06q8hd9e_1_1_20150603                                                                                                                                   100% 9477KB   9.3MB/s   00:00
   

5. arch_07q8hd9f_1_1_20150603                                                                                                                                   100%   66MB  16.5MB/s   00:04
   

6. arch_08q8hd9g_1_1_20150603                                                                                                                                   100%   12MB  12.3MB/s   00:00
   

7. [oracle@primary backuparch]$ cd /backup

8. [ oracle@primary backup ] $ ll
   

9. total 1154188
   

10. - rw - r - - - - - 1 oracle oinstall   9797632 Jun  3 02 : 15 control_09q8hd9i_1_1
    

11. - rw - r - - - - - 1 oracle oinstall 711983104 Jun  3 02 : 15 db_01q8hd8h_1_1_20150603
    

12. - rw - r - - - - - 1 oracle oinstall 449028096 Jun  3 02 : 15 db_02q8hd8h_1_1_20150603
    

13. - rw - r - - - - - 1 oracle oinstall   9797632 Jun  3 02 : 15 db_03q8hd9a_1_1_20150603
    

14. - rw - r - - - - - 1 oracle oinstall     98304 Jun  3 02 : 15 db_04q8hd9a_1_1_20150603
    

15. [ oracle@primary backup ] $ scp * 192 . 168 . 6 . 31 : / backup
    

16. oracle@192 . 168 . 6 . 31's password:

17. ... 

18. ...

備庫duplicate登陸

點選( 此處 )摺疊或開啟

1. [ oracle@standby ~ ] $ rman target sys/oracle@bj auxiliary sys/oracle@sh
   

2. 
   

3. Recovery Manager : Release 11 . 2 . . 3 . 0 - Production on Tue Jun 2 11 : 18 : 17 2015
   

4. 
   

5. Copyright ( c ) 1982 , 2011 , Oracle and / or its affiliates . All rights reserved .
   

6. 
   

7. connected to target database : BEIJING ( DBID = 845781194 )
   

8. connected to auxiliary database : BEIJING ( not mounted )

點選( 此處 )摺疊或開啟

1. RMAN > duplicate target database for standby nofilenamecheck dorecover ;
   

2. 
   

3. Starting Duplicate Db at 02 - JUN - 15
   

4. using target database control file instead of recovery catalog
   

5. allocated channel : ORA_AUX_DISK_1
   

6. channel ORA_AUX_DISK_1 : SID = 19 device type = DISK
   

7. 
   

8. contents of Memory Script :
   

9. {
   

10.    set until scn  1134882 ;
    

11.    restore clone standby controlfile ;
    

12. }
    

13. executing Memory Script
    

14. 
    

15. executing command : SET until clause
    

16. 
    

17. Starting restore at 02 - JUN - 15
    

18. using channel ORA_AUX_DISK_1
    

19. 
    

20. channel ORA_AUX_DISK_1 : starting datafile backup set restore
    

21. channel ORA_AUX_DISK_1 : restoring control file
    

22. channel ORA_AUX_DISK_1 : reading from backup piece /backup/db_03q8hd9a_1_1_20150603
    

23. channel ORA_AUX_DISK_1 : piece handle = / backup/db_03q8hd9a_1_1_20150603 tag = TAG20150603T021440
    

24. channel ORA_AUX_DISK_1 : restored backup piece 1
    

25. channel ORA_AUX_DISK_1 : restore complete , elapsed time : 00 : 00 : 02
    

26. output file name = / u01/app/oracle/oradata/shanghai/control01 . ctl
    

27. output file name = / u01/app/oracle/fast_recovery_area/shanghai/control02 . ctl
    

28. Finished restore at 02 - JUN - 15
    

29. 
    

30. contents of Memory Script :
    

31. {
    

32.    sql clone 'alter database mount standby database' ;
    

33. }
    

34. executing Memory Script
    

35. 
    

36. sql statement : alter database mount standby database
    

37. 
    

38. contents of Memory Script :
    

39. {
    

40.    set until scn  1134882 ;
    

41.    set newname for tempfile  1 to
    

42.   "/u01/app/oracle/oradata/shanghai/temp01.dbf" ;
    

43.    switch clone tempfile all ;
    

44.    set newname for datafile  1 to
    

45.   "/u01/app/oracle/oradata/shanghai/system01.dbf" ;
    

46.    set newname for datafile  2 to
    

47.   "/u01/app/oracle/oradata/shanghai/sysaux01.dbf" ;
    

48.    set newname for datafile  3 to
    

49.   "/u01/app/oracle/oradata/shanghai/undotbs01.dbf" ;
    

50.    set newname for datafile  4 to
    

51.   "/u01/app/oracle/oradata/shanghai/users01.dbf" ;
    

52.    set newname for datafile  5 to
    

53.   "/u01/app/oracle/oradata/shanghai/example01.dbf" ;
    

54.    restore
    

55.    clone database
    

56.     ;
    

57. }
    

58. executing Memory Script
    

59. 
    

60. executing command : SET until clause
    

61. 
    

62. executing command : SET NEWNAME
    

63. 
    

64. renamed tempfile 1 to /u01/app/oracle/oradata/shanghai/temp01 . dbf in control file
    

65. 
    

66. executing command : SET NEWNAME
    

67. 
    

68. executing command : SET NEWNAME
    

69. 
    

70. executing command : SET NEWNAME
    

71. 
    

72. executing command : SET NEWNAME
    

73. 
    

74. executing command : SET NEWNAME
    

75. 
    

76. Starting restore at 02 - JUN - 15
    

77. using channel ORA_AUX_DISK_1
    

78. 
    

79. channel ORA_AUX_DISK_1 : starting datafile backup set restore
    

80. channel ORA_AUX_DISK_1 : specifying datafile ( s ) to restore from backup set
    

81. channel ORA_AUX_DISK_1 : restoring datafile 00001 to /u01/app/oracle/oradata/shanghai/system01 . dbf
    

82. channel ORA_AUX_DISK_1 : restoring datafile 00005 to /u01/app/oracle/oradata/shanghai/example01 . dbf
    

83. channel ORA_AUX_DISK_1 : reading from backup piece /backup/db_01q8hd8h_1_1_20150603
    

84. channel ORA_AUX_DISK_1 : piece handle = / backup/db_01q8hd8h_1_1_20150603 tag = TAG20150603T021440
    

85. channel ORA_AUX_DISK_1 : restored backup piece 1
    

86. channel ORA_AUX_DISK_1 : restore complete , elapsed time : 00 : 00 : 15
    

87. channel ORA_AUX_DISK_1 : starting datafile backup set restore
    

88. channel ORA_AUX_DISK_1 : specifying datafile ( s ) to restore from backup set
    

89. channel ORA_AUX_DISK_1 : restoring datafile 00002 to /u01/app/oracle/oradata/shanghai/sysaux01 . dbf
    

90. channel ORA_AUX_DISK_1 : restoring datafile 00003 to /u01/app/oracle/oradata/shanghai/undotbs01 . dbf
    

91. channel ORA_AUX_DISK_1 : restoring datafile 00004 to /u01/app/oracle/oradata/shanghai/users01 . dbf
    

92. channel ORA_AUX_DISK_1 : reading from backup piece /backup/db_02q8hd8h_1_1_20150603
    

93. channel ORA_AUX_DISK_1 : piece handle = / backup/db_02q8hd8h_1_1_20150603 tag = TAG20150603T021440
    

94. channel ORA_AUX_DISK_1 : restored backup piece 1
    

95. channel ORA_AUX_DISK_1 : restore complete , elapsed time : 00 : 00 : 15
    

96. Finished restore at 02 - JUN - 15
    

97. 
    

98. contents of Memory Script :
    

99. {
    

100.    switch clone datafile all ;
     

101. }
     

102. executing Memory Script
     

103. 
     

104. datafile 1 switched to datafile copy
     

105. input datafile copy RECID = 4 STAMP = 881320957 file name = / u01/app/oracle/oradata/shanghai/system01 . dbf
     

106. datafile 2 switched to datafile copy
     

107. input datafile copy RECID = 5 STAMP = 881320957 file name = / u01/app/oracle/oradata/shanghai/sysaux01 . dbf
     

108. datafile 3 switched to datafile copy
     

109. input datafile copy RECID = 6 STAMP = 881320957 file name = / u01/app/oracle/oradata/shanghai/undotbs01 . dbf
     

110. datafile 4 switched to datafile copy
     

111. input datafile copy RECID = 7 STAMP = 881320957 file name = / u01/app/oracle/oradata/shanghai/users01 . dbf
     

112. datafile 5 switched to datafile copy
     

113. input datafile copy RECID = 8 STAMP = 881320957 file name = / u01/app/oracle/oradata/shanghai/example01 . dbf
     

114. 
     

115. contents of Memory Script :
     

116. {
     

117.    set until scn  1134882 ;
     

118.    recover
     

119.    standby
     

120.    clone database
     

121.     delete archivelog
     

122.     ;
     

123. }
     

124. executing Memory Script
     

125. 
     

126. executing command : SET until clause
     

127. 
     

128. Starting recover at 02 - JUN - 15
     

129. using channel ORA_AUX_DISK_1
     

130. 
     

131. starting media recovery
     

132. 
     

133. channel ORA_AUX_DISK_1 : starting archived log restore to default destination
     

134. channel ORA_AUX_DISK_1 : restoring archived log
     

135. archived log thread = 1 sequence = 14
     

136. channel ORA_AUX_DISK_1 : restoring archived log
     

137. archived log thread = 1 sequence = 15
     

138. channel ORA_AUX_DISK_1 : reading from backup piece /backuparch/arch_08q8hd9g_1_1_20150603
     

139. channel ORA_AUX_DISK_1 : piece handle = / backuparch/arch_08q8hd9g_1_1_20150603 tag = TAG20150603T021509
     

140. channel ORA_AUX_DISK_1 : restored backup piece 1
     

141. channel ORA_AUX_DISK_1 : restore complete , elapsed time : 00 : 00 : 01
     

142. archived log file name = / arch/1_14_881314188 . dbf thread = 1 sequence = 14
     

143. channel clone_default : deleting archived log ( s )
     

144. archived log file name = / arch/1_14_881314188 . dbf RECID = 1 STAMP = 881320959
     

145. archived log file name = / arch/1_15_881314188 . dbf thread = 1 sequence = 15
     

146. channel clone_default : deleting archived log ( s )
     

147. archived log file name = / arch/1_15_881314188 . dbf RECID = 2 STAMP = 881320959
     

148. media recovery complete , elapsed time : 00 : 00 : 00
     

149. Finished recover at 02 - JUN - 15
     

150. Finished Duplicate Db at 02 - JUN - 15

中間有  alter database mount standby database;過程，一條命令搞定所有，但是不會做路徑的轉換，這時我們在pfile新增covert。

執行之後，資料庫是mount狀態，這時候我們就可以開啟備庫了。

點選( 此處 )摺疊或開啟

1. SQL > alter database open ;
   

2. 
   

3. Database altered .
   

4. 
   

5. SQL > select open_mode from v$database ;
   

6. 
   

7. OPEN_MODE
   

8. - - - - - - - - - - - - - - - - - - - -
   

9. READ ONLY

新增standby redo log和online redo log

應用

點選( 此處 )摺疊或開啟

1. SQL > alter database recover managed standby database disconnect from session ;
   

2. 
   

3. Database altered .