Oracle DataGuard 簡單配置

Oracle DataGuard  太噁心了，弄了這麼長時間～下面我來介紹一下最簡單的安裝方法～

1，首先裝兩個相同目錄的oracle（可以選擇不同的目錄），因為我用的是虛機，所以預設裝在c:\app下

2，在primary庫上配置client參數，tnsnames.ora 和 listener.ora， standby上面也是同理～

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = C:\app\product\11.2.0\dbhome_1)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.70.254)(PORT = 1521))
    )
  )

ORCL254 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.70.254)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
 
ORCL253 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.70.253)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

3, enable logging:

進入sqlplus，執行alter database force logging;

4,查看日誌是否歸檔

archive log list;

如果沒有的話就執行，

SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;

5，重新定義pfile檔案

create pfile='c:\pfile.ora' from spfile

修改對應的pfile檔案（其他文檔說還要備份，不用累他們～），在後面加上下面這些內容

DB_UNIQUE_NAME=orcl254
LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl254,orcl253)'
LOG_ARCHIVE_DEST_1='LOCATION=c:\app\oradata\orcl\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl254'
LOG_ARCHIVE_DEST_2='SERVICE=orcl253 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl253'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
FAL_SERVER=orcl
FAL_CLIENT=orcl
DB_FILE_NAME_CONVERT='oradata\orcl253','oradata\orcl254'
LOG_FILE_NAME_CONVERT='oradata\orcl253','oradata\orcl254'
STANDBY_FILE_MANAGEMENT=AUTO

執行：

create spfile from pfile='c:\pfile.ora'

1 2 下一頁