摘要： Today when trying to open my Oracle EM url, I can not open it. So I thought may be the network is having issue. I use the tenlet to try to identifiy if the network is ok. The command is telnet racnode1 1158 and it shows the network is ok. So I go to the the rac server to check.First I use emctl stat 阅读全文

摘要： backup terminologyUsing the RMAN BACKUP Commandto Create BackupsServer-Managed Consistent Backupsserver-managed open backupsincremental backupsimage copyprotect your backupsparallelism your backupsconfig rman defaultsManaging and Monitoring RMAN BackupsThe LIST, REPORT, and DELETE CommandsArchival B 阅读全文

摘要： v$log has one row for each group.v$logfile has one row for each file.There is a status column for v$log.Current means the group is being used.Inactive means the group is not in use and will not be need for instance recovery if the instance crash now.Active means the group is not in use but will be u 阅读全文

摘要： Release 9i introduced a new parameter, FAST_START_MTTR_TARGET, that makes controlling instance recovery time a trivial exercise. You specify it in seconds, and Oracle will then ensure that DBWn writes out blocks at a rate sufficiently fast that if the instance crashes, the recovery will take no long 阅读全文

摘要： You can use bellow command to make your session resumable. Which means that if your session hit space limited issue, for example, the data file do not have more space and it can not be auto extended, then your session will not exit with error. It will only hung there waiting for you to resolve the i 阅读全文

摘要： First of all, the version of my enviroment is Oracle 11.0.2.3. The fast recovery area used to be called flashback recovery area. When you want to enable flashback database feature, your database must have this area. So I always confused about these two concept.Let`s review how to enable flashback re 阅读全文

摘要： 在尝试删除一个diskgroup的时候遇到这个错误。ORA-15024: discovered duplicately numbered ASM disk 0这说明oracle认为有两个disk 具有相同的ID。 好像是这么个意思。虽然不知道这是为什么，但是却非常容易解决dd if=/dev/zero of=data01 bs=1024 count=100用上面这条命令把该diskgroup中的每一个diskgroup磁盘头信息清空。 这样就可以删掉[oracle@racnode1 nfsdg1]$ dd if=/dev/zero of=data01 bs=1024 count=100100+ 阅读全文

摘要： 本文基于oracle 11.0.2.3. 主要介绍什么叫Qos management。本文包括以下内容：什么是 Oracle Database QoS Management?使用QoS Management的好处Overview of Oracle Database QoS ManagementWhat Does Oracle Database QoS Management Manage?Overview of Metrics什么是 oracle database Qos management现在企业里倾向于把多个不同业务的数据库整合到一起，用一个数据库面向多种应用需求。比如说，人力资源管理业 阅读全文

摘要： 首先，这是oracle 11g 11.0.2.3 版本。这是一个神奇的问题.asm instance启动正常，但是用sqlplus 去连接的时候会显示如下：[oracle@racnode1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 6 12:59:28 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.SQL> quitView Code 这是因为 ORACL 阅读全文

摘要： Hit an strange error just now.[oracle@racnode1 ~]$ srvctl## An unexpected error has been detected by HotSpot Virtual Machine:## SIGBUS (0x7) at pc=0x42604f0a, pid=20424, tid=3077707456## Java VM: Java HotSpot(TM) Client VM (1.5.0_30-b03 mixed mode, sharing)# Problematic frame:# /u01/app/11.2.0/grid. 阅读全文