Category - 数据库

2016-05-10 00:35:16    196    0    0
--操作会导致`全局索引失效`(要考虑including indexes 或者重建索引) --分区表的truncate 创建环境: ``` SQL> l 1 create table part_tab_trunc (id int,col2 int,col3 int,contents varchar2(4000)) 2 partition by range (id) 3
2016-05-10 00:30:28    207    0    0
创建表: ``` SQL> create table hash_part_tab (id number,deal_date date,area_code number,nbr number,contents varchar2(4000)) 2 partition by hash (deal_date) 3 PARTITIONS
2016-05-10 00:28:29    221    0    0
首先创建实验环境: ``` SQL> l 1 create table list_part_tab (id number,deal_date date,area_code number,nbr number,contents varchar2(4000)) 2 partition by list (area_code) 3 ( 4 partition p_591 valu
2016-05-10 00:24:38    206    0    0
建立表以搭建实验环境: ``` SQL> l 1 create table range_part_mult_col_tab (id number,deal_date date,area_code number,nbr number,contents varchar2(4000)) 2 partition by range (area_code,deal_date) 3 (
2016-05-10 00:21:09    195    0    0
实验环境在Oracle 12c的插拔库中 ``` [oracle@mlab1 ~]$ sqlplus sys/oracle@TESTPDB as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 5 10:18:06 2015 Copyright (c) 1982, 2014, Oracle. All rights reserv
2016-05-10 00:06:53    243    0    0
[oracle@anderson admin]$ oerr ora 16693 16693, 0000, "requirements not met for enabling fast-start failover" // *Cause: The attempt to enable fast-start failover could not be completed
2016-05-10 00:06:03    219    0    0
![](https://leanote.com/api/file/getImage?fileId=5730b574ab64413fd7009d85) 在主库,Data Guard 使用Log Write(LGWR)进程或多个Archive(ARCH)进程来收集事务redo数据。 为了确保与网络中断相隔离,Log Writer线程使用专门的后台进程Log Writer Network S
2016-05-10 00:04:17    187    0    0
Archived Log entry 159 added for thread 1 sequence 189 ID 0x89102948 dest 1: RFS[3]: Selected log 7 for thread 1 sequence 190 dbid 2299059812 branch 887945090 Wed Aug 19 12:14:59 2015
2016-05-10 00:03:48    226    0    0
本来计划着,在Far sync中不添加ASM 但是使用Broker 添加Far sync 后报错: 在DGMGRL中执行 enable far_sync后: Mon Aug 10 11:39:00 2015 Starting background process NSV1 Mon Aug 10 11:39:00 2015 NSV1 started with p
2016-05-10 00:03:48    161    0    0
查看数据库在DG中的角色、保护模式等: SQL> l 1 SELECT FS_FAILOVER_STATUS "FSFO STATUS", 2 FS_FAILOVER_CURRENT_TARGET TARGET, 3 FS_FAILOVER_THRESHOLD THRESHOLD, 4 FS_FAILOVER_OBSERVER
2/2