ITPub博客

BANNER                                                &nb...

ORA-65086: cannot open/close the pluggable database一旦pdb执行了unplug，然后想在该cdb中重新使用该pdb，不能直接操作，需要先drop，然后重新plug到该cdb中：SQL>  show pdbs    CON_ID CON_NAME             &nb...

Iscsi Target config lv lvcreate -L 20G -n lv_arch vg_orastorage [root@orastorage rc0.d]# service tgtd statustgtd (pid 3159 3157) is running...[root@orastorage rc0.d]# iscsiadm -m discovery --type sendtargets --portal 10.10.22.16[  OK  ] iscsid: [  OK  ][root@orastorage...

Oracle 12c Rac Set Archive Modenode1:SQL>  show parameter  db_recovery_file_destNAME                                 TYPE&...

[oracle@oratest1 bin]$ ./emctl start omsOracle Enterprise Manager Cloud Control 12c Release 3  Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.Starting Oracle Management Server...Starting WebTier...WebTier Successfully StartedOracle Management Server Could Not Be ...

How to Create Oracle Database QoS Management Administrator Accounts[oracle@oratest1 bin]$ srvctl status oc4jOC4J is enabledOC4J is running on node oratest1[oracle@oratest1 bin]$ qosctl qosadmin -setpasswd qosadmin-bash: qosctl: command not found[oracle@oratest1 bin]$ iduid=1101(oracle) g...

[oracle@oratest1 bin]$ ./crsctl status serverpoolNAME=FreeACTIVE_SERVERS=NAME=GenericACTIVE_SERVERS=oratest1 oratest2NAME=ora.crmACTIVE_SERVERS=NAME=ora.crm_nocACTIVE_SERVERS=oratest2NAME=ora.crmnocACTIVE_SERVERS=oratest2NAME=ora.emrepACTIVE_SERVERS=oratest1NAME=ora....

Oracle 11g RAC环境下Private IP修改方法及异常处理 一、  修改方法 1.  确认所有节点CRS服务以启动 # olsnodes -s -n –i host1      1              host1-vip       &nbs...

表被truncate/drop 的恢复方法有: 1 闪回数据库(需要开启flashback)2 异机数据库不完全恢复(可基于部分表空间),exp导出,再导入源库3 TSPITR (把表空间的所有表恢复的一个时间点,影响较大)在没有开启flashback 的情况优先选择第二种方式 第二种方法过程如下: 1 安装与源数据库相同的数据库版本...

Install / Upgrade / Migrate Document  1520299.1 Master  Note  For  Oracle  Database  12c  Release  1 (12.1)  Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC)    Document 1483380.1 Changes For Oracle Database 12...

ltedb2$[/oracle]nohup ./restore.sh 1>restore.log 2>&1 &[1]     13172738ltedb2$[/oracle]ltedb2$[/oracle]jobs[1] +  Running                 nohup ./restore.sh 1>restore.log 2>&1

3环境准备数据库恢复的前环境准备工作包括：3.1测试机安装主机操作系统：      测试机为IBM小机，安装aix 6.1版本操作系统，创建vg，lv等。      特别注意需要按照生产库创建同样的redo lv：mklv -y 'lv_vg01_1_rd11' -...

适用于:Oracle Database - Enterprise Edition - 版本 8.1.7.0 和更高版本本文档所含信息适用于所有平台用途本文章将重点概述重建索引的各种影响。我们通常会定期重建索引，但事实上，判断索引重建是否有用一般并不以统计数字为基础，而且很少保留索引的重建历史记录。适用范围本文章的目标受众是...

Open Database failed - DATAFILE NEEDS MORE RECOVERY TO BE CONSISTENT ORA-1194 ORA-1547 ORA-1110 Applies to:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document applies to any platform.PurposeThe goal of this article is to assist DBAs who enc...

RMAN> run 2> {3> ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';4> SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_SERV=sfmbak';5> RESTORE CONTROLFILE FROM '/c-825733388-20131205-02';6> RELEASE CHANNEL CH00;7> };allocated channel: CH00channel CH00: sid=6583 devtype=SBT_TAPEchannel CH00: Veritas NetBackup for...

Subject:  List of X$ Tables and how the names are derived Type:  REFERENCE                     Status:  PUBLISHED Content Type:  TEXT/PLAIN Creation Date:  14-MAR-1995 La...

vi enterprise.rsp修改相应的home等参数。./runInstaller -silent -ignoreSysPrereqs -responseFile /oracle/oradisk/database/response/enterprise.rsp$ ./runInstaller -silent -ignoreSysPrereqs -responseFile /oracle/oradisk/database/response/enterprise.rsp*****************************************...

ps -ef |grep ora* lwc -lora-08104select min(object_id) from dba_objects where object_name ='ECS_ORDER_TRACE' select index_name from dba_indexes where table_name ='ECS_ORDER_TRACE';429471declare ret boolean; begin ret:=sys.dbms_repair.ONLINE_INDEX_CLEAN(OBJECT_...

ORA-00064: object is too large to allocate on this O/S相关的bug：Bug 7659217  ORA-64 attempting to startup with a large SGA / buffer cache size；但经常不一定是bug：solution：按照metlink提示根源有：1 隐含参数设置(比如刚才提出的： _ksmg_granule_size)；2 库内参数：sga相关的，和进程等相关...

mmdb1:/home/grid>./deinstall -home /ora11g/11.2/gridLocation of logs /orabackup/install/deinstall/./logs/############ ORACLE DEINSTALL & DECONFIG TOOL START ##################################### CHECK...