My Data Support

摘要： 1) Stop the listener on a regular basis then you can simply rename the file at the OS level, then on next listener startup, a new one will be created. 阅读全文

摘要： 方式一： rman>sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''"; RMAN> restore database; RMAN> recover database until time '2017-07-03 15: 阅读全文

摘要： 10g,修改oracle用户下$ORACLE_HOME/network/admin/listener.ora下的文件，增加类似红色一行 LISTENER_ORCLRAC1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) 阅读全文

摘要： 10.2.0.4默认DB_BLOCK_CHECKSUM是TRUE 11.2.0.4默认DB_BLOCK_CHECKSUM是TYPICAL 10g,11g正常备份的时候可以检查物理一致性,但是不检查逻辑一致性 备份时采用类似 backup check logical database; 可以一并检查逻 阅读全文

摘要： 最近刚为客户升级了一套Oracle Database，一切进展顺利，眼看就要顺利验收时，发现有部分客户端软件连接新版本数据库时会Hang，问题非常诡异。系统环境如下升级前的环境OS:Windows Server 2003DB:Windows Database Enterprise Edition 9... 阅读全文

摘要： 通过合理的设置，对于Primary的绝大数操作，都是可以传递到Physical Standby，datafile的操作是通过STANDBY_FILE_MANAGEMENT参数来控制的，但是即使STANDBY_FILE_MANAGEMENT设置为auto，对于rename操作，standby还是忽略的。If you do not rename the corresponding datafile at the standby system, and then try torefresh the standby database control file, the standby database 阅读全文

摘要： In a multi-processor environment running on an AIX platform, if you are intending to use multi-threaded applications,the OS recommendation is to set the environment variable AIXTHREAD_SCOPE=S before invoking this application.It results in improved performance of the application.The syntax to set thi 阅读全文

摘要： How many nodes can one have in an HP-UX/Solaris/AIX/Windows/Linux cluster?Technically and since Oracle RAC 10g Release 2, 100 nodes are supported in one cluster. This includes running 100 database instances belonging to the same (production) database on this cluster, using the Oracle Database Enterp 阅读全文

摘要： http://docs.oracle.com/cd/B19306_01/install.102/b15667/rev_precon_db.htm#i1027493The Oracle Database 10gsoftware identifies a database by its global database name. A global database name consists of the database name and database domain. Usually, the database domain is the same as the network domain 阅读全文

摘要： Oracle UNIX/Linux Tips by Burleson ConsultingSemaphores and Oracle 11g信号量和数据库Semaphores are data structures within the operating system that function like signals for memory process communications. For Oracle, semaphores tell the Oracle processes when to stop, wait or start operations. In addition, 阅读全文