100 仓测试

数据加载

#需要先编辑tpcc_load修改仓数
./tpcc_load.sh

开启归档

SELECT ARCH_MODE FROM V$DATABASE;
ALTER DATABASE MOUNT;
ALTER DATABASE ADD ARCHIVELOG 'dest=/data/dmarch100,type=local,file_size=64,space_limit=2048';
alter database archivelog;
alter database open;
SELECT ARCH_MODE FROM V$DATABASE;

在线备份数据

BACKUP DATABASE FULL TO TEST_FULL_BACKUP BACKUPSET '/data/bak100' COMPRESSED LEVEL 1 PARALLEL 32;

关闭归档

SELECT ARCH_MODE FROM V$DATABASE;
ALTER DATABASE MOUNT;
alter database noarchivelog;
alter database open;
SELECT ARCH_MODE FROM V$DATABASE;

性能测试

./tpcc_test.sh

停数据库

./DmServiceTPCC stop

脱机还原和恢复

restore database '/data/testbench/TPCC/dm.ini' from backupset '/data/bak100'  TASK THREAD 32;
recover database '/data/testbench/TPCC/dm.ini'  WITH ARCHIVEDIR '/data/dmarch100' until time '2023-06-09 11:44:00';
recover database '/data/testbench/TPCC/dm.ini' update db_magic;

200仓测试

数据加载

#需要先编辑tpcc_load修改仓数
./tpcc_load.sh

开启归档

SELECT ARCH_MODE FROM V$DATABASE;
ALTER DATABASE MOUNT;
ALTER DATABASE ADD ARCHIVELOG 'dest=/data/dmarch200,type=local,file_size=64,space_limit=2048';
alter database archivelog;
alter database open;
SELECT ARCH_MODE FROM V$DATABASE;

在线备份数据

BACKUP DATABASE FULL TO TEST_FULL_BACKUP BACKUPSET '/data/bak200' COMPRESSED LEVEL 1 PARALLEL 32;

关闭归档

SELECT ARCH_MODE FROM V$DATABASE;
ALTER DATABASE MOUNT;
alter database noarchivelog;
alter database open;
SELECT ARCH_MODE FROM V$DATABASE;

性能测试

./tpcc_test.sh

停数据库

./DmServiceTPCC stop

脱机还原和恢复

restore database '/data/testbench/TPCC/dm.ini' from backupset '/data/bak200'  TASK THREAD 32;
recover database '/data/testbench/TPCC/dm.ini'  WITH ARCHIVEDIR '/data/dmarch200' until time '2023-06-09 11:44:00';
recover database '/data/testbench/TPCC/dm.ini' update db_magic;

1000 仓测试

数据加载

#需要先编辑tpcc_load修改仓数
./tpcc_load

开启归档

SELECT ARCH_MODE FROM V$DATABASE;
ALTER DATABASE MOUNT;
ALTER DATABASE ADD ARCHIVELOG 'dest=/data/dmarch1000,type=local,file_size=64,space_limit=2048';
alter database archivelog;
alter database open;
SELECT ARCH_MODE FROM V$DATABASE;

在线备份数据

BACKUP DATABASE FULL TO TEST_FULL_BACKUP BACKUPSET '/data/bak1000' COMPRESSED LEVEL 1 PARALLEL 32;

关闭归档

SELECT ARCH_MODE FROM V$DATABASE;
ALTER DATABASE MOUNT;
alter database noarchivelog;
alter database open;
SELECT ARCH_MODE FROM V$DATABASE;

性能测试

./tpcc_test.sh

停数据库

./DmServiceTPCC stop

还原和恢复

注意归档断档

restore database '/data/testbench/TPCC/dm.ini' from backupset '/data/bak1000'  TASK THREAD 32;
recover database '/data/testbench/TPCC/dm.ini'  WITH ARCHIVEDIR '/data/dmarch1000' until time '2023-05-09 19:17:00';
recover database '/data/testbench/TPCC/dm.ini' update db_magic;

监控记录

#3h
./nmon -s 10 -c 10800 -f -m ./log