[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
文章
阅读量
获赞