ORACLE_FAQ
Perry705
OCM
展开
-
How to Recreate OCR / Voting Disk Accidentally Deleted [ID 399482.1]
How to Recreate OCR / Voting Disk Accidentally Deleted [ID 399482.1] How to Recreate OCR/Voting Disk Accidentally Deleted [ID 399482.1] Modified 2翻译 2014-09-30 22:38:13 · 393 阅读 · 0 评论 -
11gR2 RAC停机修改redolog路径
1.查看redolog路径2.停止所有节点的数据库服务srvctl stop database -d orcl3.连接ASM实例,查看确认磁盘组(本实验中将+DATA和+ARCH中的redolog修改到+DC中)4.进入asmcmd,在+DC中创建对应的路径5.将+DATA和+ARCH中的redolog全部cp到+DC中原创 2016-01-07 13:42:17 · 1272 阅读 · 0 评论 -
RMAN For 11gR2 RAC脚本备份
1.创建脚本,备份集,备份日志存放路径mkdir /data/scripts -p //备份脚本路径mkdir /data/rman_bak/data -p //备份集存放路径mkdir /data/rman_bak/logs -p //备份日志存放路径chown oracle:oinstall /data -R //设置路径原创 2016-01-07 14:48:12 · 1500 阅读 · 0 评论 -
11gR2 RAC手动添加VIP
RAC安装完grid,只有一个节点有VIP,另一个节点没有VIP手动添加VIP手动启动VIP原创 2015-12-25 09:50:44 · 611 阅读 · 0 评论 -
Physical and Logical Block Corruptions. All you wanted to know about it. (Doc ID 840978.1)
Physical and Logical Block Corruptions. All you wanted to know about it. (Doc ID 840978.1)Physical Block CorruptionsThis kind of block corruptions are normally reported by Oracle with erro原创 2016-03-24 13:05:30 · 416 阅读 · 0 评论 -
standby报错:PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.
standby报错:Mon Apr 25 12:18:26 2016PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.Mon Apr 25 12:19:26 2016PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. E原创 2016-04-25 13:30:40 · 7096 阅读 · 0 评论 -
Resolving ORA-752 or ORA-600 [3020] During Standby Recovery (Doc ID 1265884.1)
Resolving ORA-752 or ORA-600 [3020] During Standby Recovery (Doc ID 1265884.1)To BottomIn this DocumentSymptoms Cause原创 2016-04-25 20:49:34 · 940 阅读 · 0 评论 -
创建Control Files/Redo Log Files的目录顺序
Specifying Control Files at Database CreationAt database creation, the control file is created in the files specified by the CONTROL_FILES initialization parameter. If the CONTROL_FILES paramete原创 2016-04-26 15:27:29 · 424 阅读 · 0 评论 -
Installer安装过程中报错:安装包有问题
Installer安装过程中报错:安装包有问题(大小一致,可正常解压)Installer安装过程中报错:安装包有问题(大小一致,可正常解压)原创 2016-04-19 21:45:10 · 1001 阅读 · 0 评论 -
启动数据库报错:
SD2-100-RAC1:/home/oracle>srvctl start database -d anyangPRCR-1079 : Failed to start resource ora.anyang.dbCRS-5017: The resource action "ora.anyang.db start" encountered the following error: OR原创 2016-09-05 13:34:19 · 571 阅读 · 0 评论 -
duplicate报错:ORA-12154
$ rman target sys/oracle@anyang auxiliary sys/oracle@dupRecovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 29 12:03:42 2016Copyright (c) 1982, 2014, Oracle and/or its affiliates.原创 2016-09-05 13:42:56 · 827 阅读 · 0 评论 -
数据库名与实例名不同情况下的静态监听配置
listener.ora配置tnsnames.ora配置原创 2015-12-30 13:14:08 · 368 阅读 · 0 评论 -
RAC For Windows识别不到ASM磁盘
由于磁盘设置为动态磁盘导致,修改为基本磁盘解决。原创 2015-12-29 14:41:49 · 453 阅读 · 0 评论 -
UNDO损坏修复
UNDO损坏修复 undo损坏后的修复分为以下三种情况:一、数据库正常关闭immediate或normal ①、创建pfile并使用pfile启动数据库 startup nomount create pfile= from spfile; shutdown abort startup转载 2014-09-30 22:39:45 · 502 阅读 · 0 评论 -
诡异的TNS-12154
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';CONFIGURE CHANNEL 1 DEVICE TYPE DISK clear;CONFIGURE CHANNEL 2 DEVICE TYPE DISK clear;原创 2014-09-30 22:33:47 · 355 阅读 · 0 评论 -
ORA-01200: actual file size of 1199 is smaller than correct size of 1280 blocks
[oracle@lucky ~]$ cd /u01/app/oracle/oradata/orcl/[oracle@lucky orcl]$ lscontrol01.ctl redo2.log redo4.log system.dbf test.dbf undotbs2.dbfredo1.log redo3.log sysaux.dbf temp.db原创 2014-11-24 14:11:07 · 1130 阅读 · 0 评论 -
尝试进行recover datafile时报告下列错误:ORA-00283 ORA-01115 ORA-01110 ORA-27069 OSD-04026
操作系统环境:WIndows 2003 Server (32Bit)数据库版本:9.2.0.1 ARCHIVED mode错误现象:写入数据文件11时报告I/O错误,尝试进行recover时报告下列错误: ORA-00283:恢复会话因错误而取消 ORA-01115:从文件11读取块时出现IO错误(块#1046535) ORA-0111原创 2015-02-26 13:16:49 · 7711 阅读 · 0 评论 -
ORACLE启动报错:ORA-00600: 内部错误代码,参数: [kcratr1_lostwrt], [], [], [], [], [], [], []
SQL> startupORACLE 例程已经启动。 Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytes原创 2015-04-10 11:46:18 · 1537 阅读 · 0 评论 -
删除ORACLE的临时表空间报错:ORA-12906: cannot drop default temporary tablespace
删除临时表空间temp,报错:SQL> drop tablespace temp including contents;drop tablespace temp including contents*ERROR at line 1:ORA-12906: cannot drop default temporary tablespace设置临时表空间temp1为默认原创 2015-04-16 15:52:21 · 3898 阅读 · 0 评论 -
Troubleshooting Guide ORA-3136: WARNING Inbound Connection Timed Out (文档 ID 465043.1)
In this Document Purpose Troubleshooting Steps ReferencesAPPLIES TO:Oracle Net Services - Version 10.2.0.5 to 11.2.0.4 [Release 10.2 to 11.2原创 2015-05-29 08:56:28 · 563 阅读 · 0 评论 -
ORACLE启动报错:ORA-16068:redo log file activation identifier mismatch
ORACLE9i启动报错:由于数据库属于正常关闭可以参照以下两种方式进行处理:1.备份redoSQL> recover database until cancelSQL> alter database open resetlogs;SQL> alter database open;2.备份redoSQL> select原创 2015-08-07 09:24:10 · 608 阅读 · 0 评论 -
Oracle 11gR2 ASM 单实例安装 DBCA 建库报错: ORA-12547: TNS:lost contact
1、首先查看$ORACLE_HOME/bin/oracle权限oracle和grid用户下$ORACLE_HOME/bin/oracle的权限是否为"-rwsr-s--x"且属于oinstall组:[oracle@dbserver ~]$ ls -al $ORACLE_HOME/bin/oracle-r-sr-s--x 1oracle asmadmin 210824714 08-1原创 2015-11-04 10:29:03 · 1768 阅读 · 0 评论 -
ORA-38856: Cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
Example:In the example below the error Occurred while performing an open resetlogs on a 10.2.0.3 Oracle Single Instance DatabaseServer prior to restoring an RMAN backup of and Oracle Database. T原创 2015-11-02 10:50:02 · 604 阅读 · 0 评论 -
Grid Infrastructure 启动的五大问题 (Doc ID 1526147.1)
文档内容用途适用范围详细信息 问题 1:CRS-4639:无法连接 Oracle 高可用性服务,ohasd.bin 未运行或 ohasd.bin 虽在运行但无 init.ohasd 或其他进程 问题 2:CRS-4530:联系集群同步服务守护进程时出现通信故障,ocssd.bin 未运行 问题 3:CRS-4535:无法与集群就绪服务通信,crsd.bin 未运...转载 2018-12-20 10:35:20 · 803 阅读 · 0 评论