Oracle 11.2.0.4.0 dataguard部署和日常維護(2)

標籤：share   automatic   資料   environ   設定   syn   查看   net   mem   

1. primary庫設定dataguard相關參數

  1.1. 強制primay庫在任何狀態下必須記錄日誌

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

 

  1.2. 設定primay庫在歸檔模式

SYS@userdata>shutdown immediate;SYS@userdata>startup mount;SYS@userdata>alter database archivelog;SYS@userdata>alter database open;SYS@userdata>archive log list;Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     2Next log sequence to archive   4Current log sequence           4

 

 

  1.3. 設定primary和standby庫的tnsnames

$ cat $ORACLE_HOME/network/admin/tnsnames.ora# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.userdata1 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = ec2t-userdata-01)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = userdata)    )  )userdata2 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = ec2t-userdata-02)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = userdata)    )  )

 

  1.4. 根據spfile建立可更新的pfile檔案

SYS@userdata>create pfile=‘/home/oracle/pfile.ora‘ from spfile;File created.

 

  1.5. 更新pfile檔案,添加dataguard相關參數

$ mkdir /u01/app/oracle/arch$ cat /home/oracle/pfile.orauserdata.__db_cache_size=620756992userdata.__java_pool_size=16777216userdata.__large_pool_size=33554432userdata.__oracle_base=‘/u01/app/oracle‘#ORACLE_BASE set from environmentuserdata.__pga_aggregate_target=620756992userdata.__sga_target=905969664userdata.__shared_io_pool_size=0userdata.__shared_pool_size=218103808userdata.__streams_pool_size=0*.audit_file_dest=‘/u01/app/oracle/admin/userdata/adump‘*.audit_trail=‘db‘*.compatible=‘11.2.0.4.0‘*.control_files=‘/u01/app/oracle/oradata/userdata/control01.ctl‘,‘/u01/app/oracle/fast_recovery_area/userdata/control02.ctl‘*.db_block_size=8192*.db_domain=‘‘*.db_name=‘userdata‘*.db_recovery_file_dest=‘/u01/app/oracle/fast_recovery_area‘*.db_recovery_file_dest_size=4294967296*.diagnostic_dest=‘/u01/app/oracle‘*.dispatchers=‘(PROTOCOL=TCP) (SERVICE=userdataXDB)‘*.java_jit_enabled=FALSE*.memory_target=1526726656*.open_cursors=600*.processes=600*.remote_login_passwordfile=‘EXCLUSIVE‘*.undo_tablespace=‘UNDOTBS1‘*.db_unique_name=‘userdata1‘*.log_archive_config=‘DG_CONFIG=(userdata1,userdata2)‘*.log_archive_dest_1=‘location=/u01/app/oracle/arch‘*.log_archive_dest_2=‘SERVICE=userdata2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=userdata2‘*.log_archive_dest_state_1=‘ENABLE‘*.log_archive_dest_state_2=‘ENABLE‘*.standby_file_management=‘AUTO‘*.fal_client=‘userdata1‘*.fal_server=‘userdata2‘

 

 

  1.5. 匯入新的參數檔案,使dataguard配置生效

SYS@userdata>shutdown immediate;SYS@userdata>create spfile from pfile=‘/home/oracle/pfile.ora‘;SYS@userdata>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)