- 博客(9)
- 资源 (3)
- 收藏
- 关注
原创 DG 备库 snapshot database
snapshot database状态下允许对备库进行读写,且在切回物理备库时恢复原有状态。同时主库日志仍然会向备库传输,当备库从snapshot状态切回到物理备库后,应用这些日志。1)备库设置闪回区使用snapshot database需要配置以下2个参数,不需要打开flashback。(也可以在前面配置备库参数时进行设置)SQL> alter system set db_r...
2018-12-25 22:42:15 463
原创 Oracle 主备库切换 switchover
1. 检查主库状态: SQL> select switchover_status from v$database; SWITCHOVER_STATUS ---------------------------------------- TO STANDBY2. 检查备库状态(MRP0进程是否存在): select count(*) num from v$pr...
2018-12-25 21:29:06 970
原创 drop diskgroup ORA-15039 ORA-15027
SQL>drop diskgroup DATAGRP1 including contents;[DBT-30012] Dropping disk group DATAGRP1 failed.ORA-15039: diskgroup not droppedORA-15027: active use of diskgroup "DATAGRP1" precludes its dismou...
2018-12-18 18:00:48 737
原创 ORA-01536: space quota exceeded for tablespace '
SQL> create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLICY_ID)) tablespace FQZDATATBS ; 2 create unique index fqzrule.PK_DD_POLICY122T on fqzrule.DD_POLICY (TRIM(POLIC...
2018-12-11 11:07:09 604
原创 ORA-28040: No Matching Authentication Protocol and ORA-01017: invalid username/password (Doc ID 2436
1、问题描述:周末给业务装了套Oracle 12CR2压测数据库,业务反应连接时报错如下ORA-28040: No Matching Authentication Protocol 2、问题解决:于$ORACLE_HOME/network/admin/下添加了sqlnet.ora文件设置SQLNET.ALLOWED_LOGON_VERSION_SERVER=8后又报错 ORA...
2018-12-10 11:14:11 985
原创 enq: US - contention
查询等待事件:SQL> 1 select s.event, count(s.event) 2 from v$session s, v$process p 3 where s.PADDR = p.ADDR 4 group by s.event 5* order by 2 descSQL> EVENT ...
2018-12-07 18:33:47 588
原创 enq: HW - contention
SQL> l 1 select s.event, count(s.event) 2 from v$session s, v$process p 3 where s.PADDR = p.ADDR 4 group by s.event 5* order by 2 descSQL> EVENT ...
2018-12-07 18:32:33 434
原创 sysbench 压测 安装
sysbench是一款开源的多线程性能测试工具,可以执行CPU/内存/线程/IO/数据库等方面的性能测试。更重要的我们是用来做OLTP的测试http://imysql.com/2014/10/17/sysbench-full-user-manual.shtml下载地址:http://imysql.com/wp-content/uploads/2014/09/sysbench-0...
2018-12-01 22:53:58 543
原创 Linux 压测工具 stress 安装下载
下载地址http://people.seas.harvard.edu/~apw/stress/将stress-1.0.4.tar.gz复制到“/etc/local/src/”目录下:执行以下命令安装:Step1 #cd /usr/local/srcStep2 #tar -xzpvf stress-1.0.4.tar.gzStep3 #cd stress-1.0.4Step4...
2018-12-01 18:36:54 8350 1
Oracle 9i_10g编程艺术:深入数据库体系结构
2016-01-05
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人