unzip ShenTong7.0.8_342.192_arm64.zip
mkdir ShenTong
cd ShenTong7.0.8_342.192_arm64
chmod 755 setup
./setup -console
source /etc/profile
service oscaragentd stop
service oscardb_OSRDBd stop
service oscaragentd start
service oscardb_OSRDBd start
ps -ef|grep os
root 6429 1 0 15:08 pts/2 00:00:00 /data/ShenTong/bin/oscaragent -e /data/ShenTong -c
root 6455 1 36 15:08 pts/2 00:00:02 /data/ShenTong/bin/oscar -o normal -d "OSRDB"
isql
Welcome to isql 2.0.56 interactive terminal, Client Default Encoding is UTF8.
Login time:2024-01-22 15:09:28
Password for default user:
szoscar55
Connect to:
神通数据库7.0.8.191204 for Linux(arm 64bit) (65535 connections) (license invalid after 90 days)
Using New Protocol. Database Encoding is UTF8.
Type: 'copyright' for distribution terms
'help' or '\h' for help with SQL commands
';' for end with commands
'!' to run system commands
'@' to run sql script
'exit' for quit
SQL=>
查看归档
select * from V_SYS_ARCHIVELOG_INFO;
查看数据文件
select * from v_sys_datafile_info;
查看集群信息
select * from v_sys_ha_slave_info;
查询用户
select username from dba_users;
修改用户密码
alter user icasc with password 'password';
创建用户
create user icasc with password 'password';
赋权
grant role rolename to user username;
开启归档
ALTER DATABASE ARCHIVELOG 'arch/OSRDB';
查看版本
select versiondetail;
优化
修改OSRDB.conf
物理备份命令:
brcmd -O backup -d 实例名称 -u 用户名称 -p 密码 -P 端口 -t full -k file -f 备份文件.osrbk -b 8192 -c TRUE(是否压错,true为压缩)
用例
brcmd -O backup -d OSRDB -u SYSDBA -p szoscar55 -P 2003 -t full -k file -f /opt/OSRDB2021-06-28.osrbk -c true
物理恢复命令:
brcmd -O restore -d 实例名称 -u 用户名称 -p 密码 -P 端口 -t backup_point_last -k file -f 备份文件.osrbk -b 8192
用例
brcmd -O restore -d OSRDB -u SYSDBA -p szoscar55 -P 2003 -t backup_point_last -k file -f /opt/OSRDB2021-06-28.osrbk -b 8192