熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle Data Guard創建物理Standby數據庫

2013-11-13 22:24:23  來源: Oracle 

  Oracle Data Guard創建物理Standby數據庫

  創建物理備庫

  機器名 a a

  IP:

  Net_Name a a

  SID a a

  DB_UNIQUE_NAME a a

  注主節點上創建數據庫a備節點上只安裝oracle軟件不創建任何數據庫;

  配置listenerora

  主節點listenerora

  SID_LIST_LISTENER=

  (SID_LIST=

  (SID_DESC=

  (GLOBAL_DBNAME=a)

  (ORACLE_HOME=/u/app/oracle/product//db_)

  (SID_NAME=a)

  )

  )

  LISTENER =

  (ADDRESS_LIST=

  (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))

  (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))

  )

  備節點listenerora:

  SID_LIST_LISTENER=

  (SID_LIST=

  (SID_DESC=

  (GLOBAL_DBNAME=a)

  (ORACLE_HOME=/u/app/oracle/product//db_)

  (SID_NAME=a)

  )

  )

  LISTENER =

  (ADDRESS_LIST=

  (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))

  (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))

  )

  配置tnsnamesora(主備節點的tnsnameora內容一樣)

  a=

  (DESCRIPTION =

  (ADDRESS_LIST =

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

  )

  (CONNECT_DATA =

  (SERVICE_NAME = a)

  )

  )

  a=

  (DESCRIPTION =

  (ADDRESS_LIST =

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

  )

  (CONNECT_DATA =

  (SERVICE_NAME = a)

  )

  )

  在主庫啟用歸檔並且啟用強制歸檔

  步驟alter database force logging;

  archive log list;

  步驟在mount狀態下

  alter database archivelog;

  步驟alter database open;

  archive log list;

  在主庫上創建密碼文件

  orapwd file=/u/app/oracle/product//db_/dbs/orapwaora password=xyc entries=

  創建standby redo log

  alter database add standby logfile

  group (/u/app/oracle/oradata/a/standby_redoalog/u/app/oracle/oradata/a/standby_redoblog) size m

  group (/u/app/oracle/oradata/a/standby_redoalog/u/app/oracle/oradata/a/standby_redoblog) size m

  group (/u/app/oracle/oradata/a/standby_redoalog/u/app/oracle/oradata/a/standby_redoblog) size m

  group (/u/app/oracle/oradata/a/standby_redoalog/u/app/oracle/oradata/a/standby_redoblog) size m;

  注意Oracle 建議你在創建 standby 時就考慮 standby redolog 配置的問題standby redologs 與 online redologs

  非常類似應該說兩者只是服務對象不同其它參數屬性甚至操作的命令格式幾乎都一樣你在設計 standby

  redologs 的時候完全可以借鑒創建 online redologs 的思路比如多個文件組啦每組多個文件冗余之類的

  除些之外呢oracle 提供了一些標准的建議如下


From:http://tw.wingwit.com/Article/program/Oracle/201311/19009.html

    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.