Oracle 12c
Leo-2016
这个作者很懒,什么都没留下…
展开
-
expdp/impdp remap_table参数使用
expdp/impdp remap_table参数使用原创 2022-01-07 10:12:20 · 2241 阅读 · 1 评论 -
Oracle 12c 新特性 --- 分区表的局部索引
概念Local and global indexes can be created on a subset of the partitions of a table.Partial indexes provide more flexibility in index creation for partitioned tables. For example, index segments ...原创 2019-05-10 08:24:14 · 480 阅读 · 0 评论 -
Oracle 12c 新特性 --- ONLINE Move Partition
概述ALTER TABLE ... MOVE PARTITION becomes non-blocking online DDL while DML operations continue to run uninterrupted on the partition that is being moved. Global indexes are maintained during the mo...原创 2019-05-10 08:23:16 · 302 阅读 · 0 评论 -
Oracle 12c 新特性 --- 间隔分区
概念This feature enables reference-partitioned table to use interval partitioning as a top partitioning strategy, which provides a better partitioning modeling. Interval partitioned tables can be u...原创 2019-05-10 08:22:14 · 512 阅读 · 0 评论 -
Oracle 12c 新特性 --- 级联截断和交换分区
概述 TRUNCATE and EXCHANGE partition operations provide cascading functionality for reference-partitioned tables, enabling the inheritance of the partition maintenance operation from the parent to...原创 2019-05-10 08:20:46 · 264 阅读 · 0 评论 -
Oracle 12c 新特性 ---异步全局索引维护,用于删除和截断分区
概念Global index maintenance is decoupled from the DROP and TRUNCATE partition maintenance operation without rendering a global index unusable. Index maintenance is done asynchronously and can be del...原创 2019-05-10 08:19:50 · 733 阅读 · 0 评论 -
Oracle 12c 新特性 --- PDBs 可以设置不同的time zone
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)在一个统一的数据库(CD...原创 2019-05-07 14:43:04 · 321 阅读 · 0 评论 -
Oracle 12c 新特性 --- Oracle Data Guard 配置自动同步密码文件
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 data...原创 2019-05-07 14:12:20 · 795 阅读 · 0 评论 -
Oracle 12c 新特性 --- RMAN Duplicate PLUGGABLE DATABASE
概念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 t...原创 2019-05-07 14:07:59 · 877 阅读 · 0 评论 -
Oracle 12c 新特性 --- RMAN Duplicate CDBs
概念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...原创 2019-05-07 14:04:13 · 725 阅读 · 0 评论 -
Oracle 12c 新特性 --- Rolling Back Redefinition
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 SY...原创 2019-05-07 13:58:10 · 275 阅读 · 0 评论 -
Oracle 12c --- DG系列汇总
Oracle 12c Data Guard 搭建http://www.cndba.cn/leo1990/article/1935Oracle 12c DG 一主多备搭建http://www.cndba.cn/leo1990/article/2130Oracle 12c Data Guard 环境修改主备库IP地址http://www.cndba.cn/leo1990/article/193...原创 2019-05-07 13:56:40 · 754 阅读 · 0 评论 -
Oracle 12c --- RMAN系列汇总
Oracle 12c 新特性 —- RMAN Duplicate CDBshttp://www.cndba.cn/leo1990/article/2214Oracle 12c 新特性 —- RMAN Duplicate PLUGGABLE DATABASEhttp://www.cndba.cn/leo1990/article/2213Oracle 12c 新特性 —- RMAN DUPLI...原创 2019-05-07 13:55:37 · 644 阅读 · 0 评论 -
Oracle 12c PDB资源管理之IO、内存、CPU
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...原创 2019-05-07 13:53:48 · 3527 阅读 · 0 评论 -
Oracle 12c 新特性 --- 克隆PDB
概念说明CLONEDB provides a way to easily and quickly create copies of databases on network attached storage (NAS), using a thin provisioning approach integrated with Oracle Database.CLONEDB 提供了一种方法,可以...原创 2019-05-07 08:51:51 · 574 阅读 · 0 评论 -
Oracle 12c 新特性 --- Recovery PDBs
概念There are two approaches to recovering a PDB with RMAN:· Connect to the root and then use the RESTORE PLUGGABLE DATABASE and RECOVER PLUGGABLE DATABASE commands. This approach enables you ...原创 2019-05-15 08:36:47 · 212 阅读 · 0 评论 -
搭建Oracle 12.1.0.1RAC遇到ERROR:Reference data is not available for verifying prerequisites on this on
搭建Oracle 12.1.0.1 RAC遇到 ERROR: Reference data is not available for verifying prerequisites on this operating system distribution在安装grid之前对环境监察遇到如下错误:[grid@rac1 grid]$ ./runcluvfy.sh stage -pre cr...原创 2019-05-06 21:25:55 · 1227 阅读 · 0 评论 -
Oracle 12c 新特性 --- Backing Up CDBs and PDBs
2017-08-03 00:324620原创Oracle 12c编辑删除本文链接:https://www.cndba.cn/leo1990/article/2045概念A CDB consists of zero or more PDBs. Recovery Manager (RMAN) can backup the entire CDB and single or multiple ...原创 2019-05-15 08:38:41 · 259 阅读 · 0 评论 -
Oracle 12c 新特性 --- 对多个分区进行维护操作
概述Partition maintenance operations can be performed on multiple partitions as part of a single partition maintenance operation.分区维护操作可以在多个分区上执行,作为单个分区维护操作的一部分。A single partition maintenance opera...原创 2019-05-10 08:25:22 · 215 阅读 · 0 评论 -
RMAN 连接 12c PDB 提示ORA-01017无效的用户名密码
--官方文档 连接PDBConnecting as Target to a PDBTo connect as target to a PDB, you must: Connect with a net service name that resolves to a database service for that PDB. Connect as a local user or...原创 2019-05-15 08:40:04 · 1666 阅读 · 0 评论 -
Oracle Kill Session 方法详细说明
Oracle 数据库中经常会出现session阻塞等导致CPU使用率异常的情况,而一个快速解决这个故障的方法就是kill session,可以直接kill 所有session,也可以使用hanganalyze 工具找到具体的session 在kill。关于hanganalyze的使用可以参考博客:Oracle HANGANALYZE 功能诊断 DB hanginghttps://www...原创 2019-05-16 13:45:59 · 14501 阅读 · 0 评论 -
搭建 12c DG 遇到的错误信息 ORACLE error from auxiliary database: ORA-19527,ORA-00312
1 错误信息:[oracle@dg1 ~]$ rman target sys/oracle@pdbcndba_p auxiliary sys/oracle@pdbcndba_s;Recovery Manager: Release 12.2.0.1.0 - Production on Thu May 25 17:51:56 2017Copyright (c) 1982, 2017, ...原创 2019-05-16 12:56:27 · 1433 阅读 · 0 评论 -
Oracle 12c Data Guard 搭建
Oracle 12c 的DataGuard 是在CDB 级别进行的,所以我们的配置都是从CDB角度出发。测试里主备库的数据库CDB名称相同。1 环境说明OS Version:[root@dg1 yum.repos.d]# cat /etc/redhat-releaseRed Hat Enterprise Linux Server release 7.3 (Maipo)[root...原创 2019-05-16 12:53:51 · 882 阅读 · 0 评论 -
Oracle 12c Data Guard 环境修改主备库IP地址
因为虚拟机IP 地址冲突,需要修改DG IP 地址,顺便测试一下 DG 修改IP的步骤。一. IP 及数据库信息 修改之前: 主库:192.168.1.60 备库:192.168.1.61 修改之后: 主库:192.168.1.10 备库:192.168.1.11 数据库版本:12.2.0.1.0 操作系统版本: Redhat 7.3二. Shut...原创 2019-05-16 12:52:14 · 949 阅读 · 0 评论 -
Oracle 12c 新特性 --- Oracle Data Guard Broker DGMGRL接口 支持块比较
概念The new database comparison tool, introduced in this release, is also supported by Oracle Data Guard broker. The PL/SQL package that compares blocks across primary and standby databases can also ...原创 2019-05-10 14:10:00 · 249 阅读 · 0 评论 -
Oracle 12c 新特性 --- Oracle Data Guard Database Compare
概念This new tool compares data blocks stored in an Oracle Data Guard primary database and its physical standby databases. Use this tool to find disk errors (such as lost write) that cannot be det...原创 2019-05-10 14:08:34 · 368 阅读 · 0 评论 -
Oracle 12c DG 一主多备搭建
环境说明:1)数据库版本 12.2.0.1.02)db_name为cndba,db_unique_name 分别为 pdbcndba_p(主库),pdbcndba_s(备库1),pdbcndba_c(备库2)3)主库地址 192.168.1.74,备库1地址 192.168.1.75,备库2地址 192.168.1.784)一个备库搭建和多个备库搭建方法一样,配置修改可参考下面链...原创 2019-05-10 14:07:00 · 2506 阅读 · 0 评论 -
Oracle 12c 新特性 --- 在角色转换过程中保持Physical Standby 会话
概念Currently, when a role change occurs and an Active Data Guard standby becomes the primary, all read-only user connections are disconnected and must reconnect, losing their state information. This...原创 2019-05-10 14:06:02 · 325 阅读 · 0 评论 -
PL/SQL连接Oracle 12c R2 PDB报错ORA-28040/ORA-01017
今天用plsql 连12c 的数据库首先提示按照网上方法来做在服务器上的/u01/app/oracle/product/12.1.0/db_1/network/admin 目录下sqlnet.ora 文件添加一行SQLNET.ALLOWED_LOGON_VERSION=8备注: Oracle 12c的参数SQLNET.ALLOWED_LOGON_VERSION默认等于11...原创 2019-05-16 11:03:28 · 2221 阅读 · 0 评论 -
12c DG 切换保护模式 报ORA-16086: Redo data cannot be written to the standby redo log
2017-07-11 23:4412330原创Oracle 12c故障处理编辑删除本文链接:https://www.cndba.cn/leo1990/article/201212c 切换保护模式时,切换至最大可用 PROTECTION_LEVEL 为 RESYNCHRONIZATION,切换至最大保护时主库启动报错。SQL> select protection_mode,d...原创 2019-05-15 08:47:08 · 1652 阅读 · 0 评论 -
Oracle 12c CDB 和PDB 数据库的启动与关闭
1 Container Database (CDB)对于CDB,启动和关闭与之前传统的方式一样,具体语法如下:STARTUP[NOMOUNT | MOUNT | RESTRICT | UPGRADE | FORCE | READ ONLY]SHUTDOWN[IMMEDIATE | ABORT]要注意,在12c数据库创建完成后,默认情况下使用sqlplus / as sysdba ...原创 2019-05-15 08:45:59 · 2354 阅读 · 0 评论 -
oracle 启动 报ORA-16014 和 ORA-00312
1 启动数据库报错SQL> alter database open;alter database open*ERROR at line 1:ORA-03113: end-of-file on communication channelProcess ID: 10380Session ID: 32 Serial number: 24360跟踪日志错误提示如下:[or...原创 2019-05-15 08:44:57 · 605 阅读 · 0 评论 -
Oracle 12c 新特性 --- PDB VARCHAR2、NVARCHAR2、RAW类型最大长度扩展到32767字节
概念说明The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes.Increasing the allotted size for these data types allows users to store more infor...原创 2019-05-15 08:44:07 · 600 阅读 · 0 评论 -
Oracle 12c 新特性 --- CBD VARCHAR2、NVARCHAR2、RAW类型最大长度扩展到32767字节
1 概念说明The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes.Increasing the allotted size for these data types allows users to store more i...原创 2019-05-15 08:43:03 · 1175 阅读 · 0 评论 -
Oracle 12c 新特性 --- 标识列
1概念说明Table columns have been enhanced to support the American National Standards Institute (ANSI) SQL keyword IDENTITY.This provides a standards based approach to the declaration of automatically ...原创 2019-05-15 08:42:12 · 344 阅读 · 0 评论 -
Oracle 12c 新特性 --- 克隆PDB
概念说明CLONEDB provides a way to easily and quickly create copies of databases on network attached storage (NAS), using a thin provisioning approach integrated with Oracle Database.CLONEDB 提供了一...原创 2019-05-15 08:41:13 · 173 阅读 · 0 评论 -
AIX 12.1.0.2 rtld: 0712-001 Symbol CreateIoCompletionPort was referenced from module
AIX 12.1.0.2 rtld: 0712-001 Symbol CreateIoCompletionPort was referenced from module /oracle/app/12.1.0/grid/lib/libclntsh.so(), but a runtime definition of the symbol was not found.场景adg 备库是aix 12...原创 2019-05-06 21:18:14 · 2962 阅读 · 0 评论 -
Oracle 12c 新特性 --- Invisible Columns
概念The property of whether a column is visible can be controlled by the user. Invisible columns are not seen unless specified explicitly in the SELECT list. Any generic access of a table (such as ...原创 2019-05-09 14:20:48 · 1175 阅读 · 0 评论 -
Oracle 12c 新特性 --- Move a Data File Online
概念In this release, a data file can now be moved online while it is open and being accessed.在这个版本中,一个数据文件现在可以在打开和被访问的时候在线移动。Being able to move a data file online means that many maintenance opera...原创 2019-05-09 14:18:40 · 369 阅读 · 0 评论 -
Oracle 12c 新特性 --- RMAN通过网络服务恢复DG主备库数据
概念RESTORE operations can copy data files from one database to another (for example, a physical standby database to a primary database) over the network. Network-enabled restore also supports compre...原创 2019-05-13 19:30:12 · 319 阅读 · 0 评论