注册
DM数据库主备部署-重要文件编辑
专栏/培训园地/ 文章详情 /

DM数据库主备部署-重要文件编辑

Jinh 2025/03/27 19 0 0
摘要

[dmdba@primary ~]$ dmrman use_ap=2
dmrman V8
RMAN>
RMAN>
RMAN>
RMAN> backup database '/dm8/data/DM01/dm.ini' backupset '/dm8/backup/full_pri';
backup database '/dm8/data/DM01/dm.ini' backupset '/dm8/backup/full_pri';
Processing backupset /dm8/backup/full_pri
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
backup successfully!
time used: 00:00:01.778
RMAN>

restore database '/dm8/data/DM01/dm.ini' from backupset '/dm8/backup/full_pri';
recover database '/dm8/data/DM01/dm.ini' from backupset '/dm8/backup/full_pri';
recover database '/dm8/data/DM01/dm.ini' update db_magic;

pri
[dmdba@primary DM01]$ cat /opt/template/dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
arch_space_limit = 102400

[dmdba@primary DM01]$
standby
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR01
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
arch_space_limit = 102400

[dmdba@primary DM01]$ more /opt/template/dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.163.212
MAL_PORT = 55101
MAL_INST_HOST = 192.168.163.212
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.163.180
MAL_PORT = 55121
MAL_INST_HOST = 192.168.163.180
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

[dmdba@primary DM01]$ more /opt/template/dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /dm8/data/DM01/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

[dmdba@primary DM01]$ disql SYSDBA/DMsysdba01:5236

??????[LOCALHOST:5236]:????????????????
???????????? : 5.901(ms)
disql V8
SQL>
SQL>
SQL>
SQL> sp_set_oguid(453331);
DMSQL ??????????????
????????: 15.571(????). ??????:1.
SQL>
SQL> alter database primary;
??????????
????????: 19.844(????). ??????:0.
SQL>

[dmdba@primary DM01]$ more /opt/template/dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 453331
MON_DW_IP = 192.168.163.212:65101
MON_DW_IP = 192.168.163.180:65121

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服