linux下oracle11G DG搭建（三）：圍繞備庫搭建操作

linux下oracle11G DG搭建（三）：圍繞備庫搭建操作

環境

名稱	主庫	備庫
主機名稱	bjsrv	shsrv
軟體版本	RedHat Enterprise5.5、Oracle 11g 11.2.0.1	RedHat Enterprise5.5、Oracle 11g 11.2.0.1

三、圍繞備庫操作：1、備庫-修改初始化參數檔案

$cd$ORACLE_HOME/dbs

$df -h

$vi initshdb.ora

修改簡要說明：

*.audit_file_dest='/u01/app/oracle/admin/sh/adump'

//審計檔案存放的路徑

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u01/app/oracle/oradata/sh/sh_control01.ctl'

*.db_block_size=8192

*.db_name='TestDB12'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4322230272

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=TestDB12XDB)'//用於共用，刪除

*.log_archive_format='arch_%t_%s_%r.log'

*.memory_target=642006528

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

 

DB_UNIQUE_NAME=shdb

LOG_ARCHIVE_CONFIG='DG_CONFIG=(bjdb,shdb)'

 

LOG_ARCHIVE_DEST_1=

 'LOCATION=/dsk4/arch_sh

 VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

 DB_UNIQUE_NAME=shdb'

 

LOG_ARCHIVE_DEST_2=

 'SERVICE=bjdbASYNC             //應該是對方

 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

 DB_UNIQUE_NAME=bjdb'

 

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

 

LOG_ARCHIVE_MAX_PROCESSES=3

 

FAL_SERVER=bjdb

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/TestDB12','/u01/app/oracle/oradata/sh'                             //先對方，後自己

LOG_FILE_NAME_CONVERT=

 '/dsk1/oradata/bj','/dsk1/oradata/sh','/dsk2/oradata/bj','/dsk2/oradata/sh'

STANDBY_FILE_MANAGEMENT=AUTO          //先對方，後自己

 

參考範例：

*.audit_file_dest='/u01/app/oracle/admin/sh/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u01/app/oracle/oradata/sh/sh_control01.ctl'

*.db_block_size=8192

*.db_name='TestDB12'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4322230272

*.diagnostic_dest='/u01/app/oracle'

*.log_archive_format='arch_%t_%s_%r.log'

*.memory_target=642006528

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

 

DB_UNIQUE_NAME=shdb

LOG_ARCHIVE_CONFIG='DG_CONFIG=(bjdb,shdb)'

 

LOG_ARCHIVE_DEST_1=

 'LOCATION=/dsk4/arch_sh

 VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

 DB_UNIQUE_NAME=shdb'

 

LOG_ARCHIVE_DEST_2=

 'SERVICE=bjdbASYNC            

 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

 DB_UNIQUE_NAME=bjdb'

 

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

 

LOG_ARCHIVE_MAX_PROCESSES=3

 

FAL_SERVER=bjdb

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/TestDB12','/u01/app/oracle/oradata/sh'                               

LOG_FILE_NAME_CONVERT=

 '/dsk1/oradata/bj','/dsk1/oradata/sh','/dsk2/oradata/bj','/dsk2/oradata/sh'

STANDBY_FILE_MANAGEMENT=AUTO         

2、主庫-啟備庫前主庫備份

備庫啟動之前，給主庫做一個備份。

注意：DG下，養成在啟動備庫前為主庫做備份的習慣。以供應對啟動備庫後產生的未知情況。

主庫處於mount狀態下：

SQL>selectstatus from v$instance;

$mkdir/dsk4/backup

$rmantarget /

RMAN> backupdatabase format '/dsk4/backup/%d_%s.bak';

3、主庫、備庫-網路設定

主庫下：

$ lsnrctlstart         //啟動監聽

$cd/u01/app/oracle/product/11.2.0/dbhome_1/network/admin

$ vilistener.ora

# listener.oraNetwork Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated byOracle configuration tools.

 

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.71)(PORT = 1521))

  )

 

ADR_BASE_LISTENER =/u01/app/oracle

$vi tnsnames.ora //手工建立tnsnames檔案

# tnsnames.oraNetwork Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated byOracle configuration tools.

 

bjdb =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.71)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME =bjdb)

    )

  )

 

shdb =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.72)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = shdb)

    )

  )

備庫下：

$ lsnrctlstart        //啟動監聽

$cd/u01/app/oracle/product/11.2.0/dbhome_1/network/admin

$ vilistener.ora      //編輯監聽

# listener.oraNetwork Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated byOracle configuration tools.

 

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.72)(PORT = 1521))

  )

 

ADR_BASE_LISTENER =/u01/app/oracle

 

$vi tnsnames.ora    //手工建立tnsnames檔案

BJDB =

  (DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.71)(PORT = 1521))

    )

(CONNECT_DATA = (SERVER = DEDICATED)

      (SERVICE_NAME = bjdb)

    )

  )

 SHDB =

  (DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.72)(PORT = 1521))

    )

(CONNECT_DATA = (SERVER = DEDICATED)

      (SERVICE_NAME = shdb)

    )

  )

4、備庫-網路測試：

$sqlplussys/oracle@bjdb as sysdba

【補充】：oracle密碼修改

若oracle密碼未知，可以如下修改oracle密碼：

$cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs

$orapwd file=orapwTestDB12 password=oracle entries=3 force=y

$scp orapwTestDB12 shsrv:$ORACLE_HOME/dbs/orapwshdb

//把主庫修改完的密碼檔案拷貝到備庫中

SQL>showparameter name

主庫監聽狀態：

$lsnrctlstatus

備庫監聽狀態：

$lsnrctlstatus

測試主庫能否ping通備庫

$ tnsping shdb

備庫啟動執行個體

$exportORACLE_SID=shdb

//或修改.bash_profile

$sqlplus ‘/assysdba’

SQL>startupnomount;

SQL>showparameter pfile;             //備庫使用pfile啟動

SQL>showparameter name；            //看一下資料庫參數是否正確

SQL>showparameter archive；            //查詢一下歸檔設定是否正確

********************未完待續**************************

聲明：
         原創作品，出自 “深藍的blog” 部落格，允許轉載，轉載時請務必註明出處（http://blog.csdn.net/huangyanlong）。

         關於涉及著作權事宜，作者有權追究法律責任。