加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 （https://www.lidatong.com.cn/）- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置： 首页 > 百科 > 正文

ORA-00257: archiver error --11GR2 RAC 设置归档路径和开启flas

发布时间：2020-12-15 20:06:37 所属栏目：百科 来源：网络整理
导读：ORA-00257: archiver error --11GR2 RAC 设置归档路径和开启flashback [sql] ? view plain copy print ? ?wbr?开启归档和flashback，现在对于11g来说开启RAC和单实例没有什么差别，测试了这么的一个例子，?? 需求：把归档日志存放到ASM上，orcl1的归档存放在

ORA-00257: archiver error --11GR2 RAC 设置归档路径和开启flashback


[sql]? view plain copy print ?
  1. ?<wbr>?开启归档和flashback，现在对于11g来说开启RAC和单实例没有什么差别，测试了这么的一个例子，??
  2. 需求：把归档日志存放到ASM上，orcl1的归档存放在+DATA/ARC1下，orcl2的归档放到+DATA/ARC2下。??
  3. Flashbask?area是需要单独的一个diskgroup，所以特地给他创建了个新的DG?--?SHFLASH??
?
  1. 一、under?asm?environment??
  2. ??
  3. ??
  4. [grid@node1?~]$?sqlplus?/?as?sysasm??
  5. SQL*Plus:?Release?11.2.0.1.0?Production?on?Tue?Apr?9?15:06:35?2013??
  6. Copyright?(c)?1982,?2009,?Oracle.??All?rights?reserved.??
  7. Connected?to:??
  8. Oracle?Database?11g?Enterprise?Edition?Release?11.2.0.1.0?-?64bit?Production??
  9. With?the?Real?Application?Clusters?and?Automatic?Storage?Management?options??
  10. SQL>?CREATE?DISKGROUP?SHFLASH?EXTERNAL?REDUNDANCY?DISK?'/dev/raw/raw2';----此处也可用asmca图形化界面去创建??
  11. SQL>?desc?v$asm_diskgroup??????????????
  12. ?Name??????????????????????????????????????Null?????Type??
  13. ?-----------------------------------------?--------?----------------------------??
  14. ?GROUP_NUMBER???????????????????????????????????????NUMBER??
  15. ?NAME???????????????????????????????????????????????VARCHAR2(30)??
  16. ?SECTOR_SIZE????????????????????????????????????????NUMBER??
  17. ?BLOCK_SIZE?????????????????????????????????????????NUMBER??
  18. ?ALLOCATION_UNIT_SIZE???????????????????????????????NUMBER??
  19. ?STATE??????????????????????????????????????????????VARCHAR2(11)??
  20. ?TYPE???????????????????????????????????????????????VARCHAR2(6)??
  21. ?TOTAL_MB???????????????????????????????????????????NUMBER??
  22. ?FREE_MB????????????????????????????????????????????NUMBER??
  23. ?HOT_USED_MB????????????????????????????????????????NUMBER??
  24. ?COLD_USED_MB???????????????????????????????????????NUMBER??
  25. ?REQUIRED_MIRROR_FREE_MB????????????????????????????NUMBER??
  26. ?USABLE_FILE_MB?????????????????????????????????????NUMBER??
  27. ?OFFLINE_DISKS??????????????????????????????????????NUMBER??
  28. ?COMPATIBILITY??????????????????????????????????????VARCHAR2(60)??
  29. ?DATABASE_COMPATIBILITY?????????????????????????????VARCHAR2(60)??
  30. ?VOTING_FILES???????????????????????????????????????VARCHAR2(1)??
  31. SQL>?select??group_number,name?from?v$asm_diskgroup;??
  32. GROUP_NUMBER?NAME??
  33. ------------?------------------------------??
  34. ???????????1?DATA??
  35. ???????????2?SHFLASH??
  36. SQL>?alter?diskgroup?data?add?directory?'+DATA/ARC1';??
  37. Diskgroup?altered.??
  38. SQL>??alter?diskgroup?data?add?directory?'+DATA/ARC2';??
  39. SQL>?EXIT??
  40. Disconnected?from?Oracle?Database?11g?Enterprise?Edition?Release?11.2.0.1.0?-?64bit?Production??
  41. With?the?Real?Application?Clusters?and?Automatic?Storage?Management?options??
  42. 二、under?oracle?environment??
  43. [grid@node1?~]$?su?-?oracle??
  44. Password:??
  45. [oracle@node1?~]$?sqlplus?/?as?sysdba??
  46. SQL*Plus:?Release?11.2.0.1.0?Production?on?Tue?Apr?9?15:15:38?2013??
  47. Copyright?(c)?1982,128); background-color:inherit">All?rights?reserved.??
  48. Connected?to:??
  49. Oracle?Database?11g?Enterprise?Edition?Release?11.2.0.1.0?-?64bit?Production??
  50. With?the?Partitioning,?Real?Application?Clusters,?Automatic?Storage?Management,?OLAP,??
  51. Data?Mining?and?Real?Application?Testing?options??
  52. SQL>?alter?system?set?log_archive_dest_1?='location=+DATA/ARC1'?scope=spfile?sid='orcl1';??
  53. System?altered.??
  54. SQL>?alter?system?set?log_archive_dest_1?='location=+DATA/ARC2'?scope=spfile?sid='orcl2';??
  55. SQL>?show?parameter?db_recovery??
  56. NAME?????????????????????????????????TYPE????????VALUE??
  57. ------------------------------------?-----------?------------------------------??
  58. db_recovery_file_dest????????????????string??????+DATA??
  59. db_recovery_file_dest_size???????????big?integer?3882M??
  60. SQL>?alter?system?set??db_recovery_file_dest_size=2G?scope=both?sid='*';??
  61. SQL>?alter?system?set?db_recovery_file_dest?='+SHFLASH'?scope=both?sid='*';??
  62. SQL>?show?parameter?db_flashback??
  63. db_flashback_retention_target????????integer?????1440??
  64. 三、shutdown?immediate?instance?in?all?nodes??
  65. on?node1:??
  66. SQL>?show?user??
  67. USER?is?"SYS"??
  68. SQL>?shutdown?immediate??
  69. Database?closed.??
  70. Database?dismounted.??
  71. ORACLE?instance?shut?down.??
  72. SQL>?!???????
  73. [oracle@node1?~]$?srvctl?status?database?-d?orcl??
  74. Instance?orcl1?is?not?running?on?node?node1??
  75. Instance?orcl2?is?running?on?node?node2??
  76. on?node2:??
  77. [oracle@node1?~]$?export?ORACLE_SID=orcl1??
  78. [oracle@node1?~]$?srvctl?status?database?-d?orcl??
  79. Instance?orcl1?is?not?running?on?node?node1??
  80. Instance?orcl2?is?not?running?on?node?node2??
  81. 四、startup?mount?one?instance?and?enable?ARCHIVELOG?and?FLASHBACK??
  82. SQL*Plus:?Release?11.2.0.1.0?Production?on?Tue?Apr?9?15:52:06?2013??
  83. Connected?to?an?idle?instance.??
  84. SQL>?startup?mount??
  85. ORACLE?instance?started.??
  86. Total?System?Global?Area?1269366784?bytes??
  87. Fixed?Size??????????????????2212976?bytes??
  88. Variable?Size?????????????889195408?bytes??
  89. Database?Buffers??????????369098752?bytes??
  90. Redo?Buffers????????????????8859648?bytes??
  91. Database?mounted.??
  92. SQL>?alter?database?archivelog;??
  93. Database?altered.??
  94. SQL>?alter?database?flashback?on;??
  95. SQL>?desc?v$database??
  96. ?Name??????????????????????????????????????Null?????Type??
  97. ?-----------------------------------------?--------?----------------------------??
  98. ?DBID???????????????????????????????????????????????NUMBER??
  99. ?NAME???????????????????????????????????????????????VARCHAR2(9)??
  100. ?CREATED????????????????????????????????????????????DATE??
  101. ?RESETLOGS_CHANGE#??????????????????????????????????NUMBER??
  102. ?RESETLOGS_TIME?????????????????????????????????????DATE??
  103. ?PRIOR_RESETLOGS_CHANGE#????????????????????????????NUMBER??
  104. ?PRIOR_RESETLOGS_TIME???????????????????????????????DATE??
  105. ?LOG_MODE???????????????????????????????????????????VARCHAR2(12)??
  106. ?CHECKPOINT_CHANGE#?????????????????????????????????NUMBER??
  107. ?ARCHIVE_CHANGE#????????????????????????????????????NUMBER??
  108. ?CONTROLFILE_TYPE???????????????????????????????????VARCHAR2(7)??
  109. ?CONTROLFILE_CREATED????????????????????????????????DATE??
  110. ?CONTROLFILE_SEQUENCE#??????????????????????????????NUMBER??
  111. ?CONTROLFILE_CHANGE#????????????????????????????????NUMBER??
  112. ?CONTROLFILE_TIME???????????????????????????????????DATE??
  113. ?OPEN_RESETLOGS?????????????????????????????????????VARCHAR2(11)??
  114. ?VERSION_TIME???????????????????????????????????????DATE??
  115. ?OPEN_MODE??????????????????????????????????????????VARCHAR2(20)??
  116. ?PROTECTION_MODE????????????????????????????????????VARCHAR2(20)??
  117. ?PROTECTION_LEVEL???????????????????????????????????VARCHAR2(20)??
  118. ?REMOTE_ARCHIVE?????????????????????????????????????VARCHAR2(8)??
  119. ?ACTIVATION#????????????????????????????????????????NUMBER??
  120. ?SWITCHOVER#????????????????????????????????????????NUMBER??
  121. ?DATABASE_ROLE??????????????????????????????????????VARCHAR2(16)??
  122. ?ARCHIVELOG_CHANGE#?????????????????????????????????NUMBER??
  123. ?ARCHIVELOG_COMPRESSION?????????????????????????????VARCHAR2(8)??
  124. ?SWITCHOVER_STATUS??????????????????????????????????VARCHAR2(20)??
  125. ?DATAGUARD_BROKER???????????????????????????????????VARCHAR2(8)??
  126. ?GUARD_STATUS???????????????????????????????????????VARCHAR2(7)??
  127. ?SUPPLEMENTAL_LOG_DATA_MIN??????????????????????????VARCHAR2(8)??
  128. ?SUPPLEMENTAL_LOG_DATA_PK???????????????????????????VARCHAR2(3)??
  129. ?SUPPLEMENTAL_LOG_DATA_UI???????????????????????????VARCHAR2(3)??
  130. ?FORCE_LOGGING??????????????????????????????????????VARCHAR2(3)??
  131. ?PLATFORM_ID????????????????????????????????????????NUMBER??
  132. ?PLATFORM_NAME??????????????????????????????????????VARCHAR2(101)??
  133. ?RECOVERY_TARGET_INCARNATION#???????????????????????NUMBER??
  134. ?LAST_OPEN_INCARNATION#?????????????????????????????NUMBER??
  135. ?CURRENT_SCN????????????????????????????????????????NUMBER??
  136. ?FLASHBACK_ON???????????????????????????????????????VARCHAR2(18)??
  137. ?SUPPLEMENTAL_LOG_DATA_FK???????????????????????????VARCHAR2(3)??
  138. ?SUPPLEMENTAL_LOG_DATA_ALL??????????????????????????VARCHAR2(3)??
  139. ?DB_UNIQUE_NAME?????????????????????????????????????VARCHAR2(30)??
  140. ?STANDBY_BECAME_PRIMARY_SCN?????????????????????????NUMBER??
  141. ?FS_FAILOVER_STATUS?????????????????????????????????VARCHAR2(22)??
  142. ?FS_FAILOVER_CURRENT_TARGET?????????????????????????VARCHAR2(30)??
  143. ?FS_FAILOVER_THRESHOLD??????????????????????????????NUMBER??
  144. ?FS_FAILOVER_OBSERVER_PRESENT???????????????????????VARCHAR2(7)??
  145. ?FS_FAILOVER_OBSERVER_HOST??????????????????????????VARCHAR2(512)??
  146. ?CONTROLFILE_CONVERTED??????????????????????????????VARCHAR2(3)??
  147. ?PRIMARY_DB_UNIQUE_NAME?????????????????????????????VARCHAR2(30)??
  148. ?SUPPLEMENTAL_LOG_DATA_PL???????????????????????????VARCHAR2(3)??
  149. ?MIN_REQUIRED_CAPTURE_CHANGE#???????????????????????NUMBER??
  150. SQL>?select??LOG_MODE?,?FLASHBACK_ON??from?v$database;??
  151. LOG_MODE?????FLASHBACK_ON??
  152. ------------?------------------??
  153. ARCHIVELOG???YES??
  154. SQL>?alter?database?open??
  155. ??2??;??
  156. Database?altered.??
  157. 五、startup?node2??
  158. [oracle@node2?~]$?sqlplus?/?as?sysdba??
  159. SQL>?startup??
  160. 六、test?and?verify??
  161. [oracle@node1?~]$?sqlplus?/?as?sysdba??
  162. SQL*Plus:?Release?11.2.0.1.0?Production?on?Tue?Apr?9?15:55:23?2013??
  163. With?the?Partitioning,??
  164. Data?Mining?and?Real?Application?Testing?options??
  165. SQL>?archive?log?list;??
  166. Database?log?mode??????????????Archive?Mode??
  167. Automatic?archival?????????????Enabled??
  168. Archive?destination????????????+DATA/arc1??
  169. Oldest?online?log?sequence?????15??
  170. Next?log?sequence?to?archive???16??
  171. Current?log?sequence???????????16??
  172. SQL>?select?status?from?gv$instance;??
  173. STATUS??
  174. ------------??
  175. OPEN??
  176. OPEN??
  177. SQL>?desc?v$asm_diskgroup??
  178. SQL>?select?GROUP_NUMBER?,NAME??from?v$asm_diskgroup;??
  179. SQL>?select?name?from?v$datafile??
  180. ??2??union?all??
  181. ??3??select?name?from?v$controlfile??
  182. ??4??union? ??5??select?member?from?v$logfile;??
  183. NAME??
  184. --------------------------------------------------------------------------------??
  185. +DATA/orcl/datafile/system.256.811903481??
  186. +DATA/orcl/datafile/sysaux.257.811903483??
  187. +DATA/orcl/datafile/undotbs1.258.811903483??
  188. +DATA/orcl/datafile/users.259. +DATA/orcl/datafile/undotbs2.267.811903583??
  189. +DATA/orcl/controlfile/current.261.811903555??
  190. +DATA/orcl/controlfile/current.260.811903555??
  191. +DATA/orcl/onlinelog/group_2.264.811903559??
  192. +DATA/orcl/onlinelog/group_2.265.811903559??
  193. +DATA/orcl/onlinelog/group_1.262. +DATA/orcl/onlinelog/group_1.263. +DATA/orcl/onlinelog/group_3.268.811903615??
  194. +DATA/orcl/onlinelog/group_3.269.811903617??
  195. +DATA/orcl/onlinelog/group_4.270.811903617??
  196. +DATA/orcl/onlinelog/group_4.271. 15?rows?selected.??
  197. SQL*Plus:?Release?11.2.0.1.0?Production?on?Tue?Apr?9?15:55:23?2013??
  198. SQL>?archive?log?list;??
  199. Database?log?mode??????????????Archive?Mode??
  200. Automatic?archival?????????????Enabled??
  201. Archive?destination????????????+DATA/arc2??
  202. Oldest?online?log?sequence?????15??
  203. Next?log?sequence?to?archive???16??
  204. Current?log?sequence???????????16??
  205. SQL>?desc?v$archived_log??
  206. ?RECID??????????????????????????????????????????????NUMBER??
  207. ?STAMP??????????????????????????????????????????????NUMBER??
  208. ?NAME???????????????????????????????????????????????VARCHAR2(513)??
  209. ?DEST_ID????????????????????????????????????????????NUMBER??
  210. ?THREAD#????????????????????????????????????????????NUMBER??
  211. ?SEQUENCE#??????????????????????????????????????????NUMBER??
  212. ?RESETLOGS_CHANGE#??????????????????????????????????NUMBER??
  213. ?RESETLOGS_TIME?????????????????????????????????????DATE??
  214. ?RESETLOGS_ID???????????????????????????????????????NUMBER??
  215. ?FIRST_CHANGE#??????????????????????????????????????NUMBER??
  216. ?FIRST_TIME?????????????????????????????????????????DATE??
  217. ?NEXT_CHANGE#???????????????????????????????????????NUMBER??
  218. ?NEXT_TIME??????????????????????????????????????????DATE??
  219. ?BLOCKS?????????????????????????????????????????????NUMBER??
  220. ?CREATOR????????????????????????????????????????????VARCHAR2(7)??
  221. ?REGISTRAR??????????????????????????????????????????VARCHAR2(7)??
  222. ?STANDBY_DEST???????????????????????????????????????VARCHAR2(3)??
  223. ?ARCHIVED???????????????????????????????????????????VARCHAR2(3)??
  224. ?APPLIED????????????????????????????????????????????VARCHAR2(9)??
  225. ?DELETED????????????????????????????????????????????VARCHAR2(3)??
  226. ?STATUS?????????????????????????????????????????????VARCHAR2(1)??
  227. ?COMPLETION_TIME????????????????????????????????????DATE??
  228. ?DICTIONARY_BEGIN???????????????????????????????????VARCHAR2(3)??
  229. ?DICTIONARY_END?????????????????????????????????????VARCHAR2(3)??
  230. ?END_OF_REDO????????????????????????????????????????VARCHAR2(3)??
  231. ?BACKUP_COUNT???????????????????????????????????????NUMBER??
  232. ?ARCHIVAL_THREAD#???????????????????????????????????NUMBER??
  233. ?ACTIVATION#????????????????????????????????????????NUMBER??
  234. ?IS_RECOVERY_DEST_FILE??????????????????????????????VARCHAR2(3)??
  235. ?COMPRESSED?????????????????????????????????????????VARCHAR2(3)??
  236. ?FAL????????????????????????????????????????????????VARCHAR2(3)??
  237. ?END_OF_REDO_TYPE???????????????????????????????????VARCHAR2(10)??
  238. ?BACKED_BY_VSS??????????????????????????????????????VARCHAR2(3)??
  239. SQL>?alter?system?switch?logfile;??
  240. SQL>?select?THREAD#?SEQUENCE#?,?ARCHIVED?from?v$archived_log;??
  241. ?SEQUENCE#?ARC??
  242. ----------?---??
  243. ?????????2?YES??
  244. ?????????1?YES??
  245. ?????????1?YES??
  246. ?????????2?YES??
  247. 25?rows?selected.??
  248. 27?rows?selected.??
  249. ARCHIVELOG???YES??

开启归档和flashback，现在对于11g来说开启RAC和单实例没有什么差别，测试了这么的一个例子，
需求：把归档日志存放到ASM上，orcl1的归档存放在+DATA/ARC1下，orcl2的归档放到+DATA/ARC2下。
Flashbask area是需要单独的一个diskgroup，所以特地给他创建了个新的DG -- SHFLASH

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
    相关内容
      推荐文章
        站长推荐
        热点阅读

          【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。

          建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果

          Copygight © 2008-2022 https://www.lidatong.com.cn/ All Rights Reserved. 李大同