-
编辑 删除
理解透明应用程序故障转移 (TAF) 和快速连接故障转移 (FCF)
适用于:JDBC - 版本 10.1.0.2 到 11.2.0.3.0 [发行版 10.1 到 11.2]本文档所含信息适用于所有平台***Checked for relevance on 24-Apr-2013***文档 ID 1602113.1用途本文档旨在解释两个 RAC 概念，即透明应用程序故障转移 (TAF) 和快速连接故障转移 (FCF)。 适用范围需要了解 JDBC。详...
-
编辑 删除
Metlink:hugepages_settings.sh
#!/bin/bash## hugepages_settings.sh## Linux bash script to compute values for the# recommended HugePages/HugeTLB configuration## Note: This script does calculation for all shared memory# segments available when the script is run, no matter it# is an Oracle RDBMS shared memory segment or n...
-
编辑 删除
How to check oracleasm config
uname -a cat /etc/*release rpm -qa |grep oracleasm /etc/init.d/oracleasm status lsmod |grep -i asm cat /proc/filesystems |grep -i asm ls -l /usr/sbin/oracleasm-discover /etc/init.d/oracleasm listdisks /etc/init.d/oracleasm listdisks ...
-
编辑 删除
资源管理才是关键焦点问题
集群内的资源调度和互补:1 业务空闲的和业务繁忙的互补互动调度资源（忙的种类不同，网络/IOcpu）；2 白天忙的和晚上忙的业务时间错峰来资源互补互动调度(各自业务忙的时间不同)。oracle12cr2 待续hadoop yarn待续...
-
编辑 删除
Truncate and data_object_id
默认的，一个表当进行truncate 表时DATA_OBJECT_ID将增加1；但是当此表有一个索引时，进行truncate 表时DATA_OBJECT_ID将增加2：SQL> SQL> create table x ( x number );Table created.SQL> select object_id, data_object_id, last_ddl_time, created from user_objects where object_name = 'X';&nbs...
-
编辑 删除
DNS and DHCP Setup Example for Grid Infrastructure GNS
In this DocumentPurposeScopeDetails DNS Setup Example To verify delega...
-
编辑 删除
How to Configure the DNS Server for 11gR2 SCAN On Linux
In this DocumentGoalSolutionReferencesApplies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Generic Li...
-
编辑 删除
Rac One Node在计划内切换和非计划内CRASH时实例名的变化区别
我这里说的rac one node是11203版本，如果我们为了主动进行维护进行计划内切换，比如进行：srvctl relocate database -d lteidba -n osslteidb2 这里是为了主动维护的计划内手工动作，这里是SWITCHOVER，比如如上...
-
编辑 删除
11gR2_After Modify Passwd Normal User Conn Hang Solution
晚上陪着应用室同事弄数据库应用账号的口令加固工作，心想应该没什么大问题，一边等他们一边看电视，突然电话过来问题就出现了。 应用帐号批量修改密码后，若干应用帐号用新密码连接数据库无反应hang住不动，随即查看等待事件： selec...
-
编辑 删除
11g_Hidden_parameters
NAMEVALUEDESCRIPTION_4031_dump_bitvec67194879bitvec to specify dumps prior to 4031 error_4031_dump_interval300Dump 4031 error once for e...
-
编辑 删除
How to move ASM database files from one diskgroup to another
原来数据文件：ASMCMD> pwd+sysdg/UIMDB/datafileASMCMD> lsSYSAUX.257.840633371SYSTEM.256.840633371TEST.263.843647081UIMDB_DATA.264.843647213UIMDB_DATA.265.843647325UIMDB_DATA.266.843664683UIMDB_DATA.267.843665385UIMDB_DATA01UIMDB_DATA02UIMDB_DATA03UIMDB_DATA04UNDOTBS1.258.84...
-
编辑 删除
12c-How To Recover Root Container
接下来分享一下对root容器的备份与恢复：root容器的备份其实就是cdb的备份，完全没有pdb的备份：[oracle@orat3 ~]$ export ORACLE_SID=prd12cdb1[oracle@orat3 ~]$ [oracle@orat3 ~]$ [oracle@orat3 ~]$ rman target /Recovery Manager: Release 12.1.0.1.0 - Production on Sat Jun 7 14:38:42 2014Copyright (c)...
-
编辑 删除
12c-RECOVER PLUGGABLE DATABASE
[oracle@orat3 ~]$ export ORACLE_SID=prd12cdb1[oracle@orat3 ~]$ rman target /Recovery Manager: Release 12.1.0.1.0 - Production on Fri Jun 6 23:59:18 2014Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.connected to target database: PRD12CDB (DBID...
-
编辑 删除
12c-Say goodbye to your backup when dropping your PDB
删除pdb：SQL> drop PLUGGABLE database ZSKMSDB; Pluggable database dropped.SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED--------...
-
编辑 删除
How To Restore 12cR1DB to New Host File System using RMAN(二)
容器数据库(CDB$ROOT)包含system，sysaux，undo和temp表空间，控制文件和redofile；而种子数据库(PDB$SEED)包含system，sysaux，temp，example表空间，用来作为一个临时模板来创建新的插件库；临时表空间对于所有的容器库都是必需的，但是每个插件数据库都拥有自己local用户（In a multitenant container database (CDB...
-
编辑 删除
How To Restore 12cR1DB to New Host File System using RMAN(一)
oracle 12cr1 异机恢复；oracle 12cr1备份目前nbu不支持，所以主机写sh包含rman，然后放到crontab里变定期跑备份到本地文件目录；nbu只需把文件目录拉到带库。恢复测试环境只需要用把备份文件目录拉到测试机存储里后实施恢复。1 恢复参数文件并适当修改参数：#RUN#{# allocate channel c1 type dis...
-
编辑 删除
Kill Oracle Local=NO
linux:所有含有关键字“LOCAL=NO”的进程，这是Oracle数据库中远程连接进程的共同特点，因此通过以下命令可以kill掉所有的进程ps -ef |grep LOCAL=NO|grep -v grep|cut -c 9-15|xargs kill -9管道符“|”用来隔开两个命令，管道符左边命令的输出会作为管道符右边命令的输入。下面说说用管道符联接起来的几个命令...
-
编辑 删除
RECOVERING FROM A LOST DATAFILE IN A UNDO TABLESPACE (文档 ID 1013221.6)
the range of your online logs. Otherwise, the last full backup must be restored. If a backup of the datafile is not available, please contact Oracle Support Services.These are the steps: 1. Restore the lost file from a backup. 2. Mount the database: SQL...
-
编辑 删除
Monitor ASM DG IO
In this DocumentPurposeRequirementsConfiguringInstructionsScript...
-
编辑 删除
NEEDS MORE RECOVERY TO BE CONSISTENT ORA-1194 ORA-1547 ORA-1110
Assuming All Datafiles was either successfully restored, and/or recovery was done with existing database datafiles.Then open the database failed with errors like:ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01194: file 1 needs more recovery to be consist...
