DM7配置遠端歸檔
配置遠端歸檔
與本地歸檔一樣,遠端歸檔也是配置在dmarch.ini檔案中,遠端歸檔相關的主要幾個配置項包括:
1. ARCH_TYPE設定為REMOTE,表示是遠端歸檔
2. ARCH_DEST設定為遠端資料庫例項名,表示REDO日誌傳送到這個節點
3. ARCH_INCOMING_PATH設定為本地儲存路徑,用於儲存ARCH_DEST例項傳送的REDO日誌
一般建議DMRAC叢集中的節點,在配置本地歸檔之外,再交叉配置叢集中所有其他節點的遠端歸檔。查詢V$DM_ARCH_INI、V$ARCH_STATUS等動態檢視可以獲取歸檔配置以及歸檔狀態等相關資訊。下面以兩節點DMRAC叢集為例,說明如何配置遠端歸檔,RAC0和RAC1是DMRAC叢集中的兩個例項,交叉進行REMOTE歸檔配置:
1)修改資料庫為MOUNT狀態。
rac0例項:
SQL> alter database mount; executed successfully used time: 00:00:01.852. Execute id is 0.
rac1例項:
SQL> alter database mount; executed successfully used time: 00:00:01.853. Execute id is 0.
2)配置本地歸檔。
rac0例項:
SQL> alter database add archivelog 'dest=/dm7/data/rac0_arch,type=local,file_size=256,space_limit=0'; executed successfully used time: 3.459(ms). Execute id is 0.
rac1例項:
SQL> alter database add archivelog 'dest=/dm7/data/rac1_arch,type=local,file_size=256,space_limit=0'; executed successfully used time: 3.000(ms). Execute id is 0.
3)配置遠端歸檔。
rac0例項:
SQL> alter database add archivelog 'dest=RAC1,type=remote,file_size=256,space_limit=0,incoming_path=/dm7/data/rac1_arch'; executed successfully used time: 2.836(ms). Execute id is 0.
rac1例項:
SQL> alter database add archivelog 'dest=RAC0,type=remote,file_size=256,space_limit=0,incoming_path=/dm7/data/rac0_arch'; executed successfully used time: 2.865(ms). Execute id is 0.
4)開啟歸檔模式。
rac0例項:
SQL> alter database archivelog; executed successfully used time: 11.553(ms). Execute id is 0.
rac1例項:
SQL> alter database archivelog; executed successfully used time: 10.644(ms). Execute id is 0.
5)修改資料庫為OPEN狀態。
rac0例項:
SQL> alter database open; executed successfully used time: 00:00:01.362. Execute id is 0.
rac1例項:
SQL> alter database open; executed successfully used time: 00:00:02.341. Execute id is 0.
6)檢視歸檔配置檔案dmarch.ini
rac0例項:
[dmdba@dmrac1 rac0_config]$ pwd /dm7/data/rac0_config [dmdba@dmrac1 rac0_config]$ cat dmarch.ini #DaMeng Database Archive Configuration file #this is comments ARCH_WAIT_APPLY = 1 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = /dm7/data/rac0_arch ARCH_FILE_SIZE = 256 ARCH_SPACE_LIMIT = 0 [ARCH_REMOTE1] ARCH_TYPE = REMOTE ARCH_DEST = RAC1 ARCH_INCOMING_PATH = /dm7/data/rac1_arch ARCH_FILE_SIZE = 256 ARCH_SPACE_LIMIT = 0
rac1例項:
[dmdba@dmrac2 rac1_config]$ pwd /dm7/data/rac1_config [dmdba@dmrac2 rac1_config]$ cat dmarch.ini #DaMeng Database Archive Configuration file #this is comments ARCH_WAIT_APPLY = 1 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL ARCH_DEST = /dm7/data/rac1_arch ARCH_FILE_SIZE = 256 ARCH_SPACE_LIMIT = 0 [ARCH_REMOTE1] ARCH_TYPE = REMOTE ARCH_DEST = RAC0 ARCH_INCOMING_PATH = /dm7/data/rac0_arch ARCH_FILE_SIZE = 256 ARCH_SPACE_LIMIT = 0
7)檢查ARCH_INI引數是否為1
rac0例項:
SQL> select * from v$dm_ini where para_name='ARCH_INI'; LINEID PARA_NAME PARA_VALUE MIN_VALUE MAX_VALUE MPP_CHK SESS_VALUE FILE_VALUE DESCRIPTION PARA_TYPE ---------- --------- ---------- --------- --------- ------- ---------- ---------- ----------- --------- 1 ARCH_INI 1 0 1 N 1 1 dmarch.ini SYS used time: 10.267(ms). Execute id is 9.
rac1例項:
SQL> select * from v$dm_ini where para_name='ARCH_INI'; LINEID PARA_NAME PARA_VALUE MIN_VALUE MAX_VALUE MPP_CHK SESS_VALUE FILE_VALUE DESCRIPTION PARA_TYPE ---------- --------- ---------- --------- --------- ------- ---------- ---------- ----------- --------- 1 ARCH_INI 1 0 1 N 1 1 dmarch.ini SYS used time: 30.225(ms). Execute id is 19.
8)檢查是否生成了歸檔日誌檔案(在開啟資料庫時就會生成)
本地歸檔日誌檔案
rac0例項:
[dmdba@dmrac1 rac0_arch]$ pwd /dm7/data/rac0_arch [dmdba@dmrac1 rac0_arch]$ ls -lrt total 136 -rw-r--r-- 1 dmdba dinstall 268435456 May 28 20:21 ARCHIVE_LOCAL1_20200528202150715_0.log
rac1例項:
[dmdba@dmrac2 rac1_arch]$ pwd /dm7/data/rac1_arch [dmdba@dmrac2 rac1_arch]$ ls -lrt total 136 -rw-r--r-- 1 dmdba dinstall 268435456 May 28 20:21 ARCHIVE_LOCAL1_20200528202151877_1.log
遠端歸檔日誌檔案
rac0例項:
[dmdba@dmrac1 rac1_arch]$ pwd /dm7/data/rac1_arch [dmdba@dmrac1 rac1_arch]$ ls -lrt total 136 -rw-r--r-- 1 dmdba dinstall 268435456 May 28 20:21 ARCH_REMOTE1_20200528202146001_1.log
rac1例項:
[dmdba@dmrac2 rac0_arch]$ pwd /dm7/data/rac0_arch [dmdba@dmrac2 rac0_arch]$ ls -lrt total 136 -rw-r--r-- 1 dmdba dinstall 268435456 May 28 20:21 ARCH_REMOTE1_20200528202156601_0.log
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26015009/viewspace-2702572/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DM7配置本地歸檔
- DM7使用DMRMAN執行歸檔還原
- DM7使用DMRMAN執行歸檔修復
- DM7使用DMRAMN執行歸檔恢復
- DM7使用DMRMAN執行歸檔備份
- DM7使用dmrestore工具利用歸檔日誌還原REST
- MYSQL遠端連線配置MySql
- 配置 MySQL 遠端連線MySql
- MYSQL配置遠端連線MySql
- pycharm 遠端除錯配置PyCharm除錯
- [20141210]使用logminer看遠端歸檔檔案補充
- [20141208]使用logminer看遠端歸檔檔案.txt
- DM7聯機執行SQL語句進行歸檔備份SQL
- 配置歸檔位置和檔案格式
- PostgreSQL歸檔日誌配置SQL
- 通過nfs共享目錄實現oracle 歸檔日誌遠端備份NFSOracle
- 在CentOS6.0上配置Oracle資料庫可以遠端使用的遠端配置。CentOSOracle資料庫
- 遠端檔案包含shell
- rdp(遠端桌面協議)配置協議
- Maven遠端倉庫的配置Maven
- PostgreSQL 9.6 配置遠端訪問SQL
- 配置linux遠端管理 VNCLinuxVNC
- Hive遠端模式安裝配置Hive模式
- RAC歸檔配置方案:使用NFS共享儲存儲存歸檔檔案NFS
- VScode 遠端開發配置VSCode
- Web | 快速整合華為AGC遠端配置WebGC
- CentOS使用配置VNC遠端連線CentOSVNC
- FRP配置外網遠端桌面FRP
- Ubuntu下遠端配置靜態IPUbuntu
- gdb配置預設連線遠端
- linux遠端工具xmanager--遠端圖形介面配置(redhat6.0)LinuxRedhat
- 後端配置檔案後端
- oracle817歸檔配置相關---Oracle
- 遠端桌面不能貼上檔案
- NSXMLDocument讀取遠端XML檔案XML
- 遠端登錄檔訪問 (轉)
- CentOS 配置Mysql允許遠端登入CentOSMySql
- 升級 Android 認證: 遠端配置Android