dataguard ORA-17628 處理

shawnloong發表於2018-07-01
dataguard ORA-17628 處理

點選(此處)摺疊或開啟

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

  3. Starting Duplicate Db at 02-JUL-18
  4. using target database control file instead of recovery catalog
  5. allocated channel: ORA_AUX_DISK_1
  6. channel ORA_AUX_DISK_1: SID=396 device type=DISK


  9. contents of Memory Script:
  10. {
  11.    backup as copy reuse
  12.    targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' auxiliary format
  13.  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' ;
  14. }
  15. executing Memory Script


  18. Starting backup at 02-JUL-18
  19. allocated channel: ORA_DISK_1
  20. channel ORA_DISK_1: SID=408 device type=DISK
  21. Finished backup at 02-JUL-18


  24. contents of Memory Script:
  25. {
  26.    backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/netdata/control01.ctl';
  27.    restore clone controlfile to '/u01/app/oracle/fast_recovery_area/netdata/control02.ctl' from
  28.  '/u01/app/oracle/oradata/netdata/control01.ctl';
  29. }
  30. executing Memory Script


  33. Starting backup at 02-JUL-18
  34. using channel ORA_DISK_1
  35. channel ORA_DISK_1: starting datafile copy
  36. copying standby control file
  37. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_netdata.f tag=TAG20180702T183426 RECID=1 STAMP=980447667
  38. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  39. Finished backup at 02-JUL-18


  42. Starting restore at 02-JUL-18
  43. using channel ORA_AUX_DISK_1


  46. channel ORA_AUX_DISK_1: copied control file copy
  47. Finished restore at 02-JUL-18


  50. contents of Memory Script:
  51. {
  52.    sql clone 'alter database mount standby database';
  53. }
  54. executing Memory Script


  57. sql statement: alter database mount standby database


  60. contents of Memory Script:
  61. {
  62.    set newname for tempfile 1 to
  63.  "/u01/app/oracle/oradata/netdata/temp01.dbf";
  64.    switch clone tempfile all;
  65.    set newname for datafile 1 to
  66.  "/u01/app/oracle/oradata/netdata/system01.dbf";
  67.    set newname for datafile 2 to
  68.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf";
  69.    set newname for datafile 3 to
  70.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf";
  71.    set newname for datafile 4 to
  72.  "/u01/app/oracle/oradata/netdata/users01.dbf";
  73.    backup as copy reuse
  74.    datafile 1 auxiliary format
  75.  "/u01/app/oracle/oradata/netdata/system01.dbf" datafile
  76.  2 auxiliary format
  77.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf" datafile
  78.  3 auxiliary format
  79.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf" datafile
  80.  4 auxiliary format
  81.  "/u01/app/oracle/oradata/netdata/users01.dbf" ;
  82.    sql 'alter system archive log current';
  83. }
  84. executing Memory Script


  87. executing command: SET NEWNAME


  90. renamed tempfile 1 to /u01/app/oracle/oradata/netdata/temp01.dbf in control file


  93. executing command: SET NEWNAME


  96. executing command: SET NEWNAME


  99. executing command: SET NEWNAME


  102. executing command: SET NEWNAME


  105. Starting backup at 02-JUL-18
  106. using channel ORA_DISK_1
  107. channel ORA_DISK_1: starting datafile copy
  108. input datafile file number=00001 name=/u01/app/oracle/oradata/netdata/system01.dbf
  109. output file name=/u01/app/oracle/oradata/netdata/system01.dbf tag=TAG20180702T183437
  110. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
  111. channel ORA_DISK_1: starting datafile copy
  112. input datafile file number=00002 name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
  113. output file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf tag=TAG20180702T183437
  114. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
  115. channel ORA_DISK_1: starting datafile copy
  116. input datafile file number=00003 name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
  117. output file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf tag=TAG20180702T183437
  118. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  119. channel ORA_DISK_1: starting datafile copy
  120. input datafile file number=00004 name=/u01/app/oracle/oradata/netdata/users01.dbf
  121. output file name=/u01/app/oracle/oradata/netdata/users01.dbf tag=TAG20180702T183437
  122. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  123. Finished backup at 02-JUL-18


  126. sql statement: alter system archive log current


  129. contents of Memory Script:
  130. {
  131.    backup as copy reuse
  132.    archivelog like "/u01/archive/1_8_980442214.dbf" auxiliary format
  133.  "/u01/archive/1_8_980442214.dbf" ;
  134.    catalog clone archivelog "/u01/archive/1_8_980442214.dbf";
  135.    switch clone datafile all;
  136. }
  137. executing Memory Script


  140. Starting backup at 02-JUL-18
  141. using channel ORA_DISK_1
  142. channel ORA_DISK_1: starting archived log copy
  143. input archived log thread=1 sequence=8 RECID=4 STAMP=980447742
  144. RMAN-00571: ===========================================================
  145. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  146. RMAN-00571: ===========================================================
  147. RMAN-03002: failure of Duplicate Db command at 07/02/2018 18:35:43
  148. RMAN-05501: aborting duplication of target database
  149. RMAN-03015: error occurred in stored script Memory Script
  150. RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/02/2018 18:35:43
  151. ORA-17628: Oracle error 19505 returned by remote Oracle server
檢查備庫alert日誌

點選(此處)摺疊或開啟

  1. Additional information: 3
  2. Mon Jul 02 18:35:43 2018
  3. Errors in file /u01/app/oracle/diag/rdbms/netdata_st1/netdata/trace/netdata_ora_4020.trc:
  4. ORA-19505: failed to identify file "/u01/archive/1_8_980442214.dbf"
  5. ORA-27040: file create error, unable to create file
  6. Linux-x86_64 Error: 13: Permission denied
  7. Additional information: 1

很明顯的錯誤，由於之前是用root建的的目錄未修改許可權

點選(此處)摺疊或開啟

  1. chown -R oracle:oinstall /u01/archive

修改後刪除備庫之前複製檔案

點選(此處)摺疊或開啟

  1. rm -rf /u01/app/oracle/oradata/netdata

重新duplicate

點選(此處)摺疊或開啟

  1. RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
  2. Starting Duplicate Db at 02-JUL-18
  3. using target database control file instead of recovery catalog
  4. allocated channel: ORA_AUX_DISK_1
  5. channel ORA_AUX_DISK_1: SID=10 device type=DISK


  8. contents of Memory Script:
  9. {
  10.    backup as copy reuse
  11.    targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' auxiliary format
  12.  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' ;
  13. }
  14. executing Memory Script


  17. Starting backup at 02-JUL-18
  18. allocated channel: ORA_DISK_1
  19. channel ORA_DISK_1: SID=404 device type=DISK
  20. Finished backup at 02-JUL-18


  23. contents of Memory Script:
  24. {
  25.    backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/netdata/control01.ctl';
  26.    restore clone controlfile to '/u01/app/oracle/fast_recovery_area/netdata/control02.ctl' from
  27.  '/u01/app/oracle/oradata/netdata/control01.ctl';
  28. }
  29. executing Memory Script


  32. Starting backup at 02-JUL-18
  33. using channel ORA_DISK_1
  34. channel ORA_DISK_1: starting datafile copy
  35. copying standby control file
  36. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_netdata.f tag=TAG20180702T185303 RECID=2 STAMP=980448784
  37. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  38. Finished backup at 02-JUL-18


  41. Starting restore at 02-JUL-18
  42. using channel ORA_AUX_DISK_1


  45. channel ORA_AUX_DISK_1: copied control file copy
  46. Finished restore at 02-JUL-18


  49. contents of Memory Script:
  50. {
  51.    sql clone 'alter database mount standby database';
  52. }
  53. executing Memory Script


  56. sql statement: alter database mount standby database


  59. contents of Memory Script:
  60. {
  61.    set newname for tempfile 1 to
  62.  "/u01/app/oracle/oradata/netdata/temp01.dbf";
  63.    switch clone tempfile all;
  64.    set newname for datafile 1 to
  65.  "/u01/app/oracle/oradata/netdata/system01.dbf";
  66.    set newname for datafile 2 to
  67.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf";
  68.    set newname for datafile 3 to
  69.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf";
  70.    set newname for datafile 4 to
  71.  "/u01/app/oracle/oradata/netdata/users01.dbf";
  72.    backup as copy reuse
  73.    datafile 1 auxiliary format
  74.  "/u01/app/oracle/oradata/netdata/system01.dbf" datafile
  75.  2 auxiliary format
  76.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf" datafile
  77.  3 auxiliary format
  78.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf" datafile
  79.  4 auxiliary format
  80.  "/u01/app/oracle/oradata/netdata/users01.dbf" ;
  81.    sql 'alter system archive log current';
  82. }
  83. executing Memory Script


  86. executing command: SET NEWNAME


  89. renamed tempfile 1 to /u01/app/oracle/oradata/netdata/temp01.dbf in control file


  92. executing command: SET NEWNAME


  95. executing command: SET NEWNAME


  98. executing command: SET NEWNAME


  101. executing command: SET NEWNAME


  104. Starting backup at 02-JUL-18
  105. using channel ORA_DISK_1
  106. channel ORA_DISK_1: starting datafile copy
  107. input datafile file number=00001 name=/u01/app/oracle/oradata/netdata/system01.dbf
  108. output file name=/u01/app/oracle/oradata/netdata/system01.dbf tag=TAG20180702T185311
  109. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
  110. channel ORA_DISK_1: starting datafile copy
  111. input datafile file number=00002 name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
  112. output file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf tag=TAG20180702T185311
  113. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
  114. channel ORA_DISK_1: starting datafile copy
  115. input datafile file number=00003 name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
  116. output file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf tag=TAG20180702T185311
  117. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
  118. channel ORA_DISK_1: starting datafile copy
  119. input datafile file number=00004 name=/u01/app/oracle/oradata/netdata/users01.dbf
  120. output file name=/u01/app/oracle/oradata/netdata/users01.dbf tag=TAG20180702T185311
  121. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  122. Finished backup at 02-JUL-18


  125. sql statement: alter system archive log current


  128. contents of Memory Script:
  129. {
  130.    backup as copy reuse
  131.    archivelog like "/u01/archive/1_9_980442214.dbf" auxiliary format
  132.  "/u01/archive/1_9_980442214.dbf" ;
  133.    catalog clone archivelog "/u01/archive/1_9_980442214.dbf";
  134.    switch clone datafile all;
  135. }
  136. executing Memory Script


  139. Starting backup at 02-JUL-18
  140. using channel ORA_DISK_1
  141. channel ORA_DISK_1: starting archived log copy
  142. input archived log thread=1 sequence=9 RECID=5 STAMP=980448836
  143. output file name=/u01/archive/1_9_980442214.dbf RECID=0 STAMP=0
  144. channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
  145. Finished backup at 02-JUL-18


  148. cataloged archived log
  149. archived log file name=/u01/archive/1_9_980442214.dbf RECID=1 STAMP=980448838


  152. datafile 1 switched to datafile copy
  153. input datafile copy RECID=2 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/system01.dbf
  154. datafile 2 switched to datafile copy
  155. input datafile copy RECID=3 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/sysaux01.dbf
  156. datafile 3 switched to datafile copy
  157. input datafile copy RECID=4 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/undotbs01.dbf
  158. datafile 4 switched to datafile copy
  159. input datafile copy RECID=5 STAMP=980448838 file name=/u01/app/oracle/oradata/netdata/users01.dbf


  162. contents of Memory Script:
  163. {
  164.    set until scn 973806;
  165.    recover
  166.    standby
  167.    clone database
  168.     delete archivelog
  169.    ;
  170. }
  171. executing Memory Script


  174. executing command: SET until clause


  177. Starting recover at 02-JUL-18
  178. using channel ORA_AUX_DISK_1


  181. starting media recovery


  184. archived log for thread 1 with sequence 9 is already on disk as file /u01/archive/1_9_980442214.dbf
  185. archived log file name=/u01/archive/1_9_980442214.dbf thread=1 sequence=9
  186. media recovery complete, elapsed time: 00:00:01
  187. Finished recover at 02-JUL-18
  188. Finished Duplicate Db at 02-JUL-18

  190. RMAN> quit
  191. Recovery Manager complete.



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24486203/viewspace-2157175/，如需轉載，請註明出處，否則將追究法律責任。

相關文章