-
编辑 删除
oracle 12c新特性：Rman表恢复之直接导入系统
Rman表恢复之直接导入系统：RMAN> recover table pdb.pdb of pluggable database pdba until time '2014-12-15 09:39:31' auxiliary destination '/soft/auxi' datapump destination '/soft/pdump';------缺少了notableimport参数。 Starting recover at 2014/12/15 10:13:54using channel ORA...
-
编辑 删除
Oracle 12C 新特性：Rman的单个表恢复测试--未导入系统
确认在pdb下操作：SQL> show con_name CON_NAME------------------------------PDBA创建一个表：SQL> create table pdb (id number,tdatedate);插入部分数据：SQL> select * from pdb; IDTDATE---------- ------------------- ...
-
编辑 删除
Oracle 12C 新特性：关于归档日志的备份
关于归档日志的备份： RMAN>backup archivelog all; Starting backup at 2014/12/10 10:38:50current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived logbackup setchannel ORA_DISK_1: specifying archivedlog(s) in backup setinput ar...
-
编辑 删除
关于归档日志的切换测试
[oracle@node02 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production onWed Dec 10 10:34:02 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise EditionRelease 12.1.0.1.0 - 64bit ProductionWith...
-
编辑 删除
Oracle 12C 单实例安装文档（ 官方文档）
Oracle? DatabaseQuick Installation Guide12c Release 1 (12.1) for Linux x86-64E54543-04October 2014This guide describes how to quickly install Oracle Database 12c Release 1 (12.1) on Linux x86-64 systems. It includes information about the following:Rev...
-
编辑 删除
oracle ovm配置使用
1 环境概要环境概要说明：因此次资源不足，仅有两台服务器进行Oracle OVM测试安装，故部分功能无法实现，如在线迁移、异常OVS异常模拟等。1.1 硬件信息物理服务器 2 台， HP DL 360 G7,颗 4核 CPU（型...
-
编辑 删除
多租户系统的建立目标
Amultitenant environment enables the central management of multiple PDBs in asingle installation. By using a multitenant environment, you can accomplish thefollowing goals:· Costreduction------降低成本By consolidating合并、巩固 hardware ...
-
编辑 删除
PDB数据文件的在线位置以及文件名更改
SQL> alter database move datafile'/oracle/app/oracle/oradata/ITAM/0949345E60F736A4E0530101007F2940/datafile/o1_mf_system_b7x420m8_.dbf'to '/oracle/app/oracle/oradata/ITAMpdb/o1_mf_system_b7x420m8_.dbf';alter database move datafile'/oracle/app/oracle/oradata/ITAM/0949345E60F736A4E0530101007F...
-
编辑 删除
oracle 12C rman下表的恢复
确认在pdb下操作：SQL> show con_name CON_NAME------------------------------PDBA创建一个表：SQL> create table pdb (id number,tdatedate);插入部分数据：SQL> select * from pdb; IDTDATE---------- ------------------- ...
-
编辑 删除
关于Oracle12C rac DDL日志的测试验证
关于Oracle DDL日志的记录：[oracle@DBA12C02 ddl]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production onMon Dec 15 10:19:03 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to:Oracle Database 12c Enterprise...
-
编辑 删除
oracle 12C RAC 启动报错 ORA-00845
oracle 12C RAC在安装完后，启动实例的时候一直报错如下：[grid@node01 ~]$ srvctl start database -d cloud -verbosePRCR-1079 : Failed to start resource ora.cloud.dbCRS-5017: The resource action "ora.cloud.db start" encountered the following error: ORA-00845: MEMORY_TARGET not supported on this s...
-
编辑 删除
oracle ovm deploycluster工具简介
The deploycluster tool is astandalone program that can run from any Linux server. It connects to Oracle VM3 Manager to automatically configure any number of nodes (VMs) to create afully functional Single Instance, Single Instance/HA (Oracle Restart) or RealApplication Cluster environment. The ...
-
编辑 删除
PRVF-0002的解决方法
安装oracle11g单实例时报错：PRVF-0002 : Could not retrieve local nodename该错误主要是由于hosts文件配置问题：在hosts文件中加入服务器ip以及hostname即可
-
编辑 删除
Linux udev 动态管理Oracle ASM磁盘-实验
1 概述在Red Hat Enterprise Linux (RHEL) 6以前，Oracle都是采用ASMLib包来管理ASM磁盘。但是2011年5月甲骨文发表了一份声明，声明中称Oracle将不再提供Red Hat Enterprise L...
-
编辑 删除
Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out
问题描述：*********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNSfor IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production &nbs...
-
编辑 删除
ORA-12545 or ORA-12537 While Connecting to RAC through SCAN name
最近集团部分oracle 11.2.0.1的RAC数据库在使用scanip作为tnsnames.ora配置后，总是会报出ORA-12545 or ORA-12537 的错误查metalink发现原来是oracle11.2.0.1的一个bug，该问题在11.2.0.2上已解决，再次小记作为备忘：错误描述：Error ORA-12545 or ORA-12537 reported while trying to connect to 11gR2 Real Applicatio...
-
编辑 删除
Oracle Grid Infrastructure Patch Set Update 11.2.0.4.3
Oracle Grid Infrastructure Patch Set Update 11.2.0.4.3 (Includes Database PSU 11.2.0.4.3) - 18706472 Released: July 15, 2014In this document Oracle Database Home refers to Enterprise Edition or Standard Edition Database software. GI refers to Grid Infrastructure and PSU refers to ...
-
编辑 删除
关于orachk的使用方法介绍
本文主要简单介绍下使用orachk检测系统健康状况的方法：整个步骤如下：d4jtfmcvurd02-> mkdir orachkd4jtfmcvurd02-> cd orachkd4jtfmcvurd02-> mv ../orachk.zip ./d4jtfmcvurd02-> lsorachk.zipd4jtfmcvurd02-> pwd /home/oracle/orachkd4jtfmcvurd02-> unzip orachk.zip Archive: orac...
-
编辑 删除
oracle STREAM 单向用户配置流程步骤总结
alter system set aq_tm_processes=2 scope=both; alter system set global_names=true scope=both; alter system set job_queue_processes=10 scope=both; alter system set parallel_max_servers=20 scope=both;alter system set undo_retention=3600 scope=both; alter system set nls_date_format='YYYY-MM-DD H...
-
编辑 删除
ORACLE初始化参数：AUDIT_TRAIL
ORACLE初始化参数：AUDIT_TRAIL AUDIT_TRAIL：初始化参数AUDIT_TRAIL用于控制数据库审计，默认值为none。 参数类型：String默认值：none允许动态修改：否基本参数：否语法： AUDIT_TRAIL = { none | os | db | db,extended | xml | xml,extended }...
搜博主文章
他的分类
- Python 学习(3)
- DataGuard(1)
- Mysql 参考学习(3)
- WebSphere 学习笔记(1)
- Oracle EBS(1)
- GreenPlum 学习总结(1)
- Oracle常用脚本(2)
- Oracle 12C 新特性(19)
- Oracle RAC12C(8)
- oracle 虚拟化(2)
- oracle安装(7)
- oracle性能相关(5)
- rman 备份恢复(3)
- oracle默认信息(1)
- oracle随记(4)
- oracle 参数学习笔记(2)
- oracle STREAM(2)
- oracle错误代码分析解决(21)
- oracle RAC(9)
- oracle11g新特性学习(2)
- 精彩生活(1)
- Linux常用命令(1)
- oracle日常学习纪实(51)
