2013年09月_lemontree1123

11月 10月 09月

原创 11g新功能:自动坏块修复

官档:Automatic Block RepairThe enhancements to corrupt block detection make block repair more efficient and increase availability. The automatic block repair enhancement complements the Oracle

2013-09-18 11:05:23 1262

原创 Rman如何记录日志？

rman记录日志:1.rman target / log=/home/oracle/rman.log----->>>这种日志只记录在文件，无法在操作界面显示2.在rman里面spoolspool log to '/home/oracle/rman.log';spool log off;----->>>这种日志只记录在文件，无法在操作界面显示3.rman ta

2013-09-16 04:00:10 4767

原创 Rman还原种子数据库练习

种子数据库的控制文件位置:$ORACLE_HOME/assistants/dbca/templates/Seed_Database.ctl种子数据库的备份片位置:$ORACLE_HOME/assistants/dbca/templates/Seed_Database.dfb大体步骤如下:编辑一个pfile启动到nomount，然后通过控制文件启动到mount状态，恢复数据库

2013-09-15 11:56:53 1986

原创常用隐含参数查询

col parameter for a35col "session value" for a15col "instance value" for a15SELECT a.ksppinm "parameter", b.ksppstvl "session value", c.ksppstvl "instance value" FROM x$ksppi a, x$kspp

2013-09-15 11:48:05 763

转载 OCM考纲

Server ConfigurationCreate the databaseDetermine and set sizing parameters for database structuresCreate and manage temporary, permanent, and undo tablespacesStripe data files across multiple phys

2013-09-15 10:59:24 1283

原创 Failed to retrieve procctx from ht. constr

给一个客户巡检时发生这样的少见的集群报错:[ OCRSRV][1220598112]th_select_handler: Failed to retrieve procctx from ht. constr = [-1734303600] retval lht [-27] Signal CV.遇到这种报错我想到的就是:1.检查系统防火墙和selinux有没有关闭2.检

2013-09-15 10:49:16 1559