场景 adg 备库是aix 12.1.0.2单实例asm,调整ip地址，重启机器集群没起来提示一下错误信息： [grid@leo:/home/grid]$cd /oracle/app/12.1.0/grid/bin [grid@leo:/oracle/app/12.1.0/grid/bin]$./crsctl stat res -t exec(): 0509-036 Cannot load program adrci because of the following errors: rtld: 0712-001 Symbol CreateIoCompletionPo...
2019-01-25 10:25 5570 0
在安装grid之前对环境监察遇到如下错误： [grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose Performing pre-checks for cluster services setup Checking node reachability... Check: Node reachability from node "rac1" Destination Node Reachable? ----------
2018-08-26 16:28 4978 0
Oracle 12c 可以为不同的PDB做IO、内存、CPU限制。 1IO 资源管理 1.1 参数介绍 MAX_IOPS设置每个可插拔数据库（PDB）每秒可发出的最大I/O数 MAX_MBPS设置每个可插拔数据库（PDB）的基础上每秒发出的I/O的最大兆字节（MB）数 12cR2中，引入了两个参数MAX_IOPS和MAX_MBPS来限制PDB的物理IO。这两个参数只作用于PDB，不对CDB和非多租户环境生效。...
2018-06-10 22:56 4211 0
Oracle 12c 新特性 —- RMAN Duplicate CDBs http://www.cndba.cn/leo1990/article/2214 Oracle 12c 新特性 —- RMAN Duplicate PLUGGABLE DATABASE http://www.cndba.cn/leo1990/article/2213 Oracle 12c 新特性 —- RMAN DUPLICATE Enhancements http://www.cndba.cn/leo1990/article/2158 Oracle 12c 新特性 —- RMAN实现表级恢复时可以将表r...
2018-04-05 23:50 2079 0
Oracle 12c Data Guard 搭建 http://www.cndba.cn/leo1990/article/1935 Oracle 12c DG 一主多备搭建 http://www.cndba.cn/leo1990/article/2130 Oracle 12c Data Guard 环境修改主备库IP地址 http://www.cndba.cn/leo1990/article/1936 Oracle 12c 新特性 —- 在角色转换过程中保持Physical Standby 会话 http://www.cndba.cn/leo1990/article/...
2018-04-05 23:49 2436 0
1 概念 There is a new ROLLBACK parameter for the FINISH_REDEF_TABLE procedure that tracks DML on a newly redefined table so that changes can be easily synchronized with the original table using the SYNC_INTERIM_TABLE procedure. 在新重新定义的表上跟踪DML的FINISH_REDEF_TABLE过程有一个新的回滚参数，以便可以使用SYNC_INTER...
2017-09-08 22:37 2491 0
概念 Active DUPLICATE uses a network-enabled restore method that is run on the auxiliary database to clone the source database. This is in contrast to the image copy-based approach that was run on the source database in previous releases. Active DUPLICATE supports the SECTION SIZE option to divide dat
2017-09-06 01:28 2795 0
2017-09-06 01:10 3606 0
1 概念 This feature automatically synchronizes password files across Oracle Data Guard configurations. When the passwords of SYS, SYSDG, and so on, are changed, the password file at the primary database is updated and then the changes are propagated to all standby databases in the configuration. 该特性自
2017-09-03 21:28 4632 0
1 概念 This feature enables pluggable databases (PDB) in a consolidated database (CDB) to have different character sets, time zone file versions, and database time zones. 这个特性使可插入数据库(PDB)在一个统一的数据库(CDB)中具有不同的字符集、时区文件版本和数据库时区。 CDB enables multiple departmental databases to ...
2017-09-03 21:03 2980 0
概念 The new SYNC_INTERIM_TABLE procedure for the DBMS_REDEFINITION package enables incremental refresh of dependent materialized views on the interim table. The SYNC_INTERIM_TABLE procedure refreshes the materialized view as part of its execution. DBMS_REDEFINITION包的新SYNC_INTERIM_TABLE程序允许在临时表上增加依赖物
2017-08-31 14:21 2798 0
概念 A new DDL command allows the creation of a table that exactly matches the shape of a partitioned table and is therefore eligible for a partition or subpartition exchange of a partitioned table. Note that indexes are not created as part of this command. 新的DDL命令允许创建与分区表的形状完全匹配的表，因此有资格获得...
2017-08-31 10:17 3266 0
概念 Active Data Guard provides several new PL/SQL packages and DDL commands to automate the previous manual steps of performing a database rolling upgrade to a new Oracle patch set, database release, or to perform other planned maintenance. The process starts with a primary and physical standby datab
2017-08-29 00:48 4073 0
概念 DBMS_ROLLING.START_PLAN程序是滚动升级的正式开始。START_PLAN过程的目标是配置临时的逻辑备用数据库和任何指定保护它的物理备用数据库。在调用时，START_PLAN程序执行升级计划中的所有指令，并使用START_PLAN的PHASE value 。执行的指令的类型包括: *Backing up the control file for each database to a trace file *C...
2017-08-28 23:18 2840 0
概念 Partition maintenance operations can now be combined with data filtering. For example, a partition can be compressed and moved to a different tablespace, but only the data satisfying the specific filter criteria is actually moved. 分区维护操作现在可以与数据过滤相结合。例如，可以将分区压缩并移动到不同的表空间，但...
2017-08-27 15:54 2096 0
坚持你的坚持
CNDBA社区
