1.1yasboot查状态
yasboot cluster status -c yashandb -d
1.2创建ycp用户
# su - yashan
# yasql / as sysdba
> create user ycp identified by yasdb_123;
> grant dba to ycp;
1.3 ycp登入
# yasql ycp/yasdb_123
1.4创建ycp表空间
> create tablespace ycp datafile 'ycp_data' size 100M autoextend on next 5M maxsize 1000M;
数据库备份：level 0 增备；Level 1累积增备
mkdir -p /data/yasdb_data/backup
Level 0 增备
>backup database incremental level 0 format '/data/yasdb_data/backup/incr_0_20251119';
Level 1 累积增备
> backup database incremental level 1 cumulative format '/data/yasdb_data/incr_1_2_20251119';
可以查询到备份记录
> select * from dba_backup_set;
调整redo
> alter database add logfile('redo5' size 200M, 'redo6' size 200M, 'redo7' size 200M, 'redo8' size 200M, 'redo9' size 200M);
> alter system switch logfile;
> alter system checkpoint;
>alter database drop logfile 'redo1';
>alter database drop logfile 'redo2';
>alter database drop logfile 'redo3';
>alter database drop logfile 'redo4';
> select * from v$logfile;
实例参数优化
> EXEC DBMS_PARAM.OPTIMIZE(NULL,NULL,7,10);
> SELECT DBMS_PARAM.SHOW_RECOMMEND() FROM DUAL;
> EXEC DBMS_PARAM.APPLY_RECOMMEND();
重启生效
# yasboot cluster restart -c yashandb
记录一次脚本优化
set timing on；
SELECT day_num,
prod2,
AVG(prod2) OVER (
ORDER BY day_num
ROWS BETWEEN 4 PRECEDING AND CURRENT ROW
) AS avg_prod2_last5
FROM sales_amount_by_days
ORDER BY day_num;
崖山数据库启动
yasboot process yasom start -c yashandb
yasboot process yasagent start -c yashandb
yasboot cluster restart -c yashandb
YMP安装
YCP第五-18
上传: instantclient-basic-linux.x64-19.19.0.0.0dbru.el9.zip、yashandb-personal-23.2.1.100-linux-x86_64.tar.gz、yashan-migrate-platform-v23.2.1.3-linux-x86-64.zip
# useradd ymp
# su - ymp
# cd /home/ymp/
解压OCI
# unzip instantclient-basic-linux.x64-19.19.0.0.0dbru.el9.zip
安装ymp
# unzip yashan-migrate-platform-v23.2.1.3-linux-x86-64.zip
# cd /home/ ymp/ yashan-migrate-platform/
# sh bin/ ymp. sh ins tal l - -db /home/ ymp/ yashandb-per sonal -23.2.3.100- l inux - x86_64.tar.gz - -path
/home/ ymp/ ins tantc l ient _19_19
改ymp配置
# /home/ymp/yashan-migrate-platform/conf
# vim application.properties
重启
# sh bin/ymp.sh restartnodb
查ymp状态
