ITPub博客

http://forums.oracle.com/forums/thread.jspa?threadID=540807注意:1.在10g的ASM中要删除没有mount的dg好像是不行的，我们可以通过dd if=/dev/zero f=/dev/xxx bs=1024 count=100来清除ASM磁盘头的信息，dg就自...

报错如下：Sat May 15 01:07:11 2010Errors in file /oracle/admin/scdcdata/udump/scdcdata_ora_581844.trc:ORA-19883: Message 19883 not found;  product=RDBMS; facility=ORA; arguments: [/oradata/sc...

ORA-01843: not a valid month Cause: A date specified an valid month. Valid month are: January-December, for format code MONTH, and Jan-Dec, for format code MON. Action: Enter a valid month value i...

当我在把从RAC做的RMAN全库备份文件还原到单机，在最后open resetlogs报了此错。ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled处理方法：加上thread 2的日志文件：SQL> ALTER...

今天同事提了一个问题，同样的SQL语句在有些地方执行是成功的，有些地方是失败的。SQL如下：SELECT (SELECT MIN(POST.post_name)          FROM org_post POST,&n...