su - dmdba
cd /dm8/bin
$ ./dmrman
dmrman V8
主机备份
RMAN> backup database'/dm8/data/DM01/dm.ini' backupset '/dm8/backup/FULLBAK';
主机拷贝到备机
scp -r FULLBAK root@ip:/dm8/backup/

备机
cd /dm8/backup
chown -R dmdba:dinstall FULLBAK/
su - dmdba
cd /dm8/bin
$ ./dmrman

restore database to '/dm8/data/DM01' from backupset '/dm8/backup/FULLBAK';

recover database '/dm8/data/DM01/dm.ini' from backupset '/dm8/backup/FULLBAK';

recover database '/dm8/data/DM01/dm.ini' update db_magic;

主库
$ cd /dm8/samples/ini_script/UTF-8

$ cp dmmal_example.ini /dm8/data/DM01/dmmal.ini
$ cp dmarch_example.ini /dm8/data/DM01/dmarch.ini
$ cp dmwatcher_example.ini /dm8/data/DM01/dmwatcher.ini

$ /dm8/data/DM01

1、$ vi dm.ini

INSTANCE_NAME = DMSVR01

MAL_INI = 1

ARCH_INI = 1

ALTER_MODE_STATUS = 0

ENABLE_OFFLINE_TS = 2

2、$ vi dmarch.ini

#DaMeng Database Archive Configuration file
#this is comments

    ARCH_WAIT_APPLY      = 0        

[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 10240
ARCH_FLUSH_BUF_SIZE = 0
ARCH_HANG_FLAG = 1
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME #实时归档
ARCH_DEST = DMSVR02（备机） #实时归档目标实例名

3、$ vi dmmal.ini

MAL_CHECK_INTERVAL = 30

MAL_CONN_FAIL_INTERVAL = 10

MAL_LOGIN_TIMEOUT = 15

MAL_BUF_SIZE = 100

MAL_SYS_BUF_SIZE = 0

[MAL_INST1]

MAL_INST_NAME = DMSVR01

MAL_HOST = 172.10.220.58

MAL_PORT = 61141

MAL_INST_HOST = 172.10.220.58

MAL_INST_PORT = 5236

MAL_DW_PORT = 52141
MAL_INST_DW_PORT = 33141

[MAL_INST2]

MAL_INST_NAME = DMSVR02

MAL_HOST = 172.10.220.59

MAL_PORT = 61141

MAL_INST_HOST = 172.10.220.59(备库）

MAL_INST_PORT = 5236

MAL_INST_DW_PORT = 33141

MAL_DW_PORT = 52141

4、vim dmwatcher.ini

DW_TYPE =GLOBAL

DW_ERROR_TIME = 15

INST_ERROR_TIME = 15

INST_OGUID=88888888

INST_INI = /dm8/data/DM01/dm.ini

INST_AUTO_RESTART = 1

INST_STARTUP_CMD = /dm8/bin/dmserver

INST_RECOVER_TIME = 60

在主库
$ cd /dm8/bin
$ ./dmserver /dm8/data/DM01/dm.ini mount

su - dmdba

$ cd /dm8/bin
]$ ./disql SYSDBA/DM01SYSDBA:5237
SQL>SP_SET_OGUID(88888888);
SQL>alter database primary;

su - dmdba

$ cd /dm8/data/DM01/
$ scp dmmal.ini dmdba@备库ip:/dm8/data/DM01/

$ scp dmarch.ini dmdba@备库:/dm8/data/DM01/

$ scp dmwatcher.ini dmdba@备库:/dm8/data/DM01/

备库
su - dmdba
$ cd /dm8/data/DM01

1、vim dm.ini

MAL_INI = 1
ARCH_INI = 1

INSTANCE_NAME = DMSVR02

ALTER_MODE_STATUS = 0

ENABLE_OFFLINE_TS = 2

2、vim dmarch.ini

ARCH_DEST = DMSVR01

备库
$ cd /dm8/bin
$ ./dmserver /dm8/data/DM01/dm.ini mount

su - dmdba

$ cd /dm8/bin
$ ./disql sysdba/DM01SYSDBA:5237
SQL>SP_SET_OGUID(88888888);
SQL>alter database standby;
**
主库，备库分别启动dmwatcher**

su - dmdba

$ cd /dm8/bin
$ ./dmwatcher /dm8/data/DM01/dmwatcher.ini

连接主库

su - dmdba

$ cd /dm8/bin
$ ./disql sysdba/DM01SYSDBA:5237
处于主库打开状态
启动正常

连接备库

su - dmdba

$ cd /dm8/bin
$ ./disql sysdba/DM01SYSDBA:5237
**处于备库打开状态
启动正常
**

连接主库

su - dmdba

$ cd /dm8/bin
$ ./disql sysdba/DM01SYSDBA:5237
SQL> select * from v$arch_status;
VALID
查看主机的归档状态，VALID 说明主备同步正常
SQL>select count(*) from t_test;

SQL> insert into dmtest.t_test select * from dmtest.t_test;

SQL> commit;

连接备库

su - dmdba

$ cd /dm8/bin
$ ./disql sysdba/DM01SYSDBA:5237
SQL> select * from v$arch_status;
VALID
查看主机的归档状态，VALID 说明主备同步正常
SQL>select count(*) from t_test;

搭建dmmoni
$ cd /dm8/data
$ cp /dm8/samples/ini_script/UTF-8/dmmonitor_example.ini dmmonitor.ini
$ vim 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
[GROUP_A] (守护进程组名，与dmwatcher.ini中的守护进程组名保持一致，
例子：dmwatcher.ini [GROUP_A]）
DW_TYPE
MON_INST_OGUID = 888888
MON_DW_IP = 主机:52141
MON_DW_IP = 备机:52141（端口netstat -ntlp|grep dmwatcher 或者是dmmal.ini中的MAL_DW_PROT端口）

启动监视器
$ cd /dm8/bin
$ ./dmmonitor /dm8/data/dmmonitor.ini

验证：
login
用户名：sysdba
密码：
主备切换
switchover

SQL>select mode$ from v$instance;