ITPub博客

 环境：两个双节点RAC  主库：Hostname=rui1,rui2db_name=proddb_unique_name=primaryinstance_name=prod1,prod2service_names=primary 备库：hostname=zhang1,zhang2db_name=PRODdb_unique_name=standbyinstance_name=std1,std2se...

The Data Recovery Advisor workflow begins when you either suspect or discover afailure. You can discover failures in many ways, including error messages, alerts, tracefiles, and failed data integrity checks. the database can automatically diagnose failures when errors occur.The basic proc...

[root@node2 ~]# cat /home/grid/.bash_profile # .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then        . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport EDITOR=viexport ORACLE_SID=+ASM2...

场景：11.0.3.0-->11.0.4.0基于rman备份的恢复错误代码：ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADECause: The database was mounted for SHARED cluster access.解决方法：Set the CLUSTER_DATABASE initialization parameter to FALSE and restart the server w...

Enabling or Disabling the Standard Audit TrailYou enable the standard audit trail by setting the AUDIT_TRAIL initialization parameter. This setting determines whether to create the audit trail in the database audit trail, write the audit activities to an operating system file, or to di...

错误：通过emctl status dbconsole启动数据库em时起不来，有如下提示：Unable to determine consoleport. /u01/app/product/11.2.0/db_1/oc4j/j2ee/oc4j_dbconsole_orcle11g_orcl/config/*web_site.xml not found. No such file or directory解决方案：使用telnet 验证端口号 OEM端口号默认为1158，验证1158端口号...

kill掉此进程的父进程ppid的占用即可

In some situations, a business cannot afford to lose data regardless of the circumstances. In other situations, the availability of the database may be more important than any potential data loss in the unlikely event of a multiple failure. Finally, some applications require maximu...

1、  开闪回idle>alter database flashback on; Database altered. idle>select flashback_on fromv$database; FLASHBACK_ON------------------YES开闪回归档idle>create flashback archive fba1tablespace example quota 500m retention 1 year;...

第一步：查看RAC的server pool是基于admin-managed还是基于policy-managed[grid@node2 ~]$ srvctl config database -d prodDatabase unique name: prodDatabase name: prodOracle home: /u01/app/oracle/product/11.2.0/db_1Oracle user: oracleSpfile: +ORADATA/prod/spfileprod.oraDomain: Start options: ...

dbca -silent -createDatabase -templateName /tmp/Data_Warehouse.dbc -gdbname ora11g -sid ora11g -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 40 -emConfiguration LOCAL-templateName  模板路径+文件名-gdbname         全局数据库名-sid       &...

  mysql安装   1.1 Linux之下MySQL安装的三种方案的比较 具体内容参考这篇blog： http://blog.itpub.net/8183550/viewspace-680749/   一.1  windows 下安装(mysql-5.6.21-win32) 一.1.1  mysql server 安装   1登录   http://dev.mysql.com/downloads/   2进...

 隐隐约约感觉到学数据库多多少少以后会涉及到mysql，好吧，那就趁着现在工作不是很忙的时间抽空来学学mysql吧，把这几天视频中学习到的知识和笔记整理了一下发出来大家共同学习。。。 MySQL 5.6.21最新版下载    MySQL Enterprise Edition (commercial) 商业版第一步：登录mysql的官方网站htt...

Task 1: Determine if Platforms are Supported and Determine EndiannessThis task is only necessary if you are transporting the tablespace set to a platform different from the source platform.这步骤只是跨平台的时候才是必须If you are transporting the tablespace set to a platform different from t...

The FAILOVER_MODE parameter must be included in the CONNECT_DATA section of a connect descriptor. FAILOVER_MODE can contain the parameters described in Table 13–4.Table 13–4 Additional Parameters of the FAILOVER_MODE Parameter

All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch. This is called a conflict situation. OPatch detects such situations and raises an error when it detects a conflict.$ OPatch/opatch apply ...

An Oracle Real Application Clusters environment enables active instances to concurrently execute transactions on a shared database. Patching in an Oracle Real Application Clusters environment is slightly different compared to patching a single node.Interim Patching using OPatch follows a similar a...

错误：官档提示：ORA-15063: ASM discovered an insufficient number of disks for diskgroup "string"Cause: ASM was unable to find a sufficient number of disks belonging to the diskgroup to continue the operation.Action: Check that the disks in the diskgroup are present ...

影响Oracle数据库字符集最重要的参数是NLS_LANG参数它的格式如下: NLS_LANG = language_territory.charset它有三个组成部分(语言、地域和字符集)，每个成分控制了NLS子集的特性。其中:Language： 指定服务器消息的语言， 影响提示信息是中文还是英文Territory： 指定服务器的日期和数字格式，Charset：&nb...

You can use the VALIDATE command to manually check for physical and logical corruptions in database files. This command performs the same types of checks as BACKUP VALIDATE, but VALIDATE can check a larger selection of objects. For example, you can validate individual blocks with t...