当前位置：Gxlcms > 数据库问题 > Oracle 11.2.0.4.0 dataguard部署和日常维护(2)

Oracle 11.2.0.4.0 dataguard部署和日常维护(2)

时间：2021-07-01 10:21:17 帮助过：20人阅读

>select FORCE_LOGGING from v$database; FORCE_LOG --------- NO SYS@userdata>alter database force logging; Database altered. SYS@userdata>select FORCE_LOGGING from v$database; FORCE_LOG --------- YES

 

  1.2. 设置primay库在归档模式

  1. <span style="color: #000000">SYS</span><span style="color: #008000">@userdata</span><span style="color: #808080">></span><span style="color: #0000ff">shutdown</span><span style="color: #000000"> immediate;
  2. SYS</span><span style="color: #008000">@userdata</span><span style="color: #808080">>s</span><span style="color: #000000">tartup mount;
  3. SYS</span><span style="color: #008000">@userdata</span><span style="color: #808080">></span><span style="color: #0000ff">alter</span> <span style="color: #0000ff">database</span><span style="color: #000000"> archivelog;
  4. SYS</span><span style="color: #008000">@userdata</span><span style="color: #808080">></span><span style="color: #0000ff">alter</span> <span style="color: #0000ff">database</span> <span style="color: #0000ff">open</span><span style="color: #000000">;
  5. SYS</span><span style="color: #008000">@userdata</span><span style="color: #808080">></span>archive <span style="color: #ff00ff">log</span><span style="color: #000000"> list;
  6. </span><span style="color: #0000ff">Database</span> <span style="color: #ff00ff">log</span><span style="color: #000000"> mode              Archive Mode
  7. Automatic archival             Enabled
  8. Archive destination            USE_DB_RECOVERY_FILE_DEST</span><span style="color: #000000">
  9. Oldest online </span><span style="color: #ff00ff">log</span> sequence     <span style="color: #800000; font-weight: bold">2</span>
  10. <span style="color: #0000ff">Next</span> <span style="color: #ff00ff">log</span> sequence <span style="color: #0000ff">to</span> archive   <span style="color: #800000; font-weight: bold">4</span>
  11. <span style="color: #0000ff">Current</span> <span style="color: #ff00ff">log</span> sequence           <span style="color: #800000; font-weight: bold">4</span>

 

 

  1.3. 设置primary和standby库的tnsnames

  1. $ <span style="color: #0000ff">cat</span> $ORACLE_HOME/network/admin/<span style="color: #000000">tnsnames.ora
  2. # tnsnames.ora Network Configuration File: </span>/u01/app/oracle/product/<span style="color: #800080">11.2</span>.<span style="color: #800080">0</span>/db_1/network/admin/<span style="color: #000000">tnsnames.ora
  3. # Generated by Oracle configuration tools.
  4. userdata1 </span>=<span style="color: #000000">
  5.   (DESCRIPTION </span>=<span style="color: #000000">
  6.     (ADDRESS </span>= (PROTOCOL = TCP)(HOST = ec2t-userdata-<span style="color: #800080">01</span>)(PORT = <span style="color: #800080">1521</span><span style="color: #000000">))
  7.     (CONNECT_DATA </span>=<span style="color: #000000">
  8.       (SERVER </span>=<span style="color: #000000"> DEDICATED)
  9.       (SERVICE_NAME </span>=<span style="color: #000000"> userdata)
  10.     )
  11.   )
  12. userdata2 </span>=<span style="color: #000000">
  13.   (DESCRIPTION </span>=<span style="color: #000000">
  14.     (ADDRESS </span>= (PROTOCOL = TCP)(HOST = ec2t-userdata-<span style="color: #800080">02</span>)(PORT = <span style="color: #800080">1521</span><span style="color: #000000">))
  15.     (CONNECT_DATA </span>=<span style="color: #000000">
  16.       (SERVER </span>=<span style="color: #000000"> DEDICATED)
  17.       (SERVICE_NAME </span>=<span style="color: #000000"> userdata)
  18.     )
  19.   )</span>

 

  1.4. 根据spfile创建可更新的pfile文件

  1. SYS<span style="color: #008000">@userdata</span><span style="color: #808080">></span><span style="color: #0000ff">create</span> pfile<span style="color: #808080">=</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">/home/oracle/pfile.ora</span><span style="color: #ff0000">‘</span> <span style="color: #0000ff">from</span><span style="color: #000000"> spfile;
  2. </span><span style="color: #0000ff">File</span> created.

 

  1.5. 更新pfile文件,添加dataguard相关参数

  1. $ <span style="color: #0000ff">mkdir</span> /u01/app/oracle/<span style="color: #000000">arch
  2. $ </span><span style="color: #0000ff">cat</span> /home/oracle/<span style="color: #000000">pfile.ora
  3. userdata.__db_cache_size</span>=<span style="color: #800080">620756992</span><span style="color: #000000">
  4. userdata.__java_pool_size</span>=<span style="color: #800080">16777216</span><span style="color: #000000">
  5. userdata.__large_pool_size</span>=<span style="color: #800080">33554432</span><span style="color: #000000">
  6. userdata.__oracle_base</span>=<span style="color: #800000">‘</span><span style="color: #800000">/u01/app/oracle</span><span style="color: #800000">‘</span><span style="color: #000000">#ORACLE_BASE set from environment
  7. userdata.__pga_aggregate_target</span>=<span style="color: #800080">620756992</span><span style="color: #000000">
  8. userdata.__sga_target</span>=<span style="color: #800080">905969664</span><span style="color: #000000">
  9. userdata.__shared_io_pool_size</span>=<span style="color: #800080">0</span><span style="color: #000000">
  10. userdata.__shared_pool_size</span>=<span style="color: #800080">218103808</span><span style="color: #000000">
  11. userdata.__streams_pool_size</span>=<span style="color: #800080">0</span>
  12. *.audit_file_dest=<span style="color: #800000">‘</span><span style="color: #800000">/u01/app/oracle/admin/userdata/adump</span><span style="color: #800000">‘</span>
  13. *.audit_trail=<span style="color: #800000">‘</span><span style="color: #800000">db</span><span style="color: #800000">‘</span>
  14. *.compatible=<span style="color: #800000">‘</span><span style="color: #800000">11.2.0.4.0</span><span style="color: #800000">‘</span>
  15. *.control_files=<span style="color: #800000">‘</span><span style="color: #800000">/u01/app/oracle/oradata/userdata/control01.ctl</span><span style="color: #800000">‘</span>,<span style="color: #800000">‘</span><span style="color: #800000">/u01/app/oracle/fast_recovery_area/userdata/control02.ctl</span><span style="color: #800000">‘</span>
  16. *.db_block_size=<span style="color: #800080">8192</span>
  17. *.db_domain=<span style="color: #800000">‘‘</span>
  18. *.db_name=<span style="color: #800000">‘</span><span style="color: #800000">userdata</span><span style="color: #800000">‘</span>
  19. *.db_recovery_file_dest=<span style="color: #800000">‘</span><span style="color: #800000">/u01/app/oracle/fast_recovery_area</span><span style="color: #800000">‘</span>
  20. *.db_recovery_file_dest_size=<span style="color: #800080">4294967296</span>
  21. *.diagnostic_dest=<span style="color: #800000">‘</span><span style="color: #800000">/u01/app/oracle</span><span style="color: #800000">‘</span>
  22. *.dispatchers=<span style="color: #800000">‘</span><span style="color: #800000">(PROTOCOL=TCP) (SERVICE=userdataXDB)</span><span style="color: #800000">‘</span>
  23. *.java_jit_enabled=<span style="color: #000000">FALSE
  24. </span>*.memory_target=<span style="color: #800080">1526726656</span>
  25. *.open_cursors=<span style="color: #800080">600</span>
  26. *.processes=<span style="color: #800080">600</span>
  27. *.remote_login_passwordfile=<span style="color: #800000">‘</span><span style="color: #800000">EXCLUSIVE</span><span style="color: #800000">‘</span>
  28. *.undo_tablespace=<span style="color: #800000">‘</span><span style="color: #800000">UNDOTBS1</span><span style="color: #800000">‘</span>
  29. <strong>*.db_unique_name=<span style="color: #800000">‘</span><span style="color: #800000">userdata1</span><span style="color: #800000">‘</span>
  30. *.log_archive_config=<span style="color: #800000">‘</span><span style="color: #800000">DG_CONFIG=(userdata1,userdata2)</span><span style="color: #800000">‘</span>
  31. *.log_archive_dest_1=<span style="color: #800000">‘</span><span style="color: #800000">location=/u01/app/oracle/arch</span><span style="color: #800000">‘</span>
  32. *.log_archive_dest_2=<span style="color: #800000">‘</span><span style="color: #800000">SERVICE=userdata2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=userdata2</span><span style="color: #800000">‘</span>
  33. *.log_archive_dest_state_1=<span style="color: #800000">‘</span><span style="color: #800000">ENABLE</span><span style="color: #800000">‘</span>
  34. *.log_archive_dest_state_2=<span style="color: #800000">‘</span><span style="color: #800000">ENABLE</span><span style="color: #800000">‘</span>
  35. *.standby_file_management=<span style="color: #800000">‘</span><span style="color: #800000">AUTO</span><span style="color: #800000">‘</span>
  36. *.fal_client=<span style="color: #800000">‘</span><span style="color: #800000">userdata1</span><span style="color: #800000">‘</span>
  37. *.fal_server=<span style="color: #800000">‘</span><span style="color: #800000">userdata2‘</span></strong>

 

 

  1.5. 导入新的参数文件,使dataguard配置生效

  1. SYS<span style="color: #008000">@userdata</span><span style="color: #808080">></span><span style="color: #0000ff">shutdown</span><span style="color: #000000"> immediate;
  2. SYS</span><span style="color: #008000">@userdata</span><span style="color: #808080">></span><span style="color: #0000ff">create</span> spfile <span style="color: #0000ff">from</span> pfile<span style="color: #808080">=</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">/home/oracle/pfile.ora</span><span style="color: #ff0000">‘</span><span style="color: #000000">;
  3. SYS</span><span style="color: #008000">@userdata</span><span style="color: #808080">></span>startup;

 

2. standby库设置dataguard相关参数

3. 对primary库做备份

4. 传输备份到standby库

5. 还原standby库

6. 创建standby联机日志

7. 开启stanby库恢复进程

8.primary库归档,查看dataguard数据同步是否成功

Oracle 11.2.0.4.0 dataguard部署和日常维护(2)

标签：share   automatic   数据   environ   设置   syn   查看   net   mem   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！