Monthly Archives: 四月 2013

RAC恢复到单节点报ORA-00392 ORA-00312

0

Posted on by

把rac的备份恢复到单节点后,在open resetlogs时碰到错误

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/27/2013 12:25:24
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1: '+datadg'

[……]

查看全文

11g自动统计信息修改调用时间

2

Posted on by

在11g中,自动收集统计信息的时间为晚上10点(周一到周五),早上6点(周六,周日)

由于有些系统在晚上10点还是高分期。会影响系统的性能,所以简单的方法就是把时间调整为晚上3点;

当然也可以把自动统计信息关闭,自己写个存储过程自定义的去收集统计信息。

把时间调整为晚上3点的方法:

 sql:
select a.window_name, a.repeat_interval,a.duration
   from dba_scheduler_windows a, dba_scheduler_wingroup_members b
  where a.window_name = b.window_name
    and b.window_group_name = 'MAINTENANCE_WINDOW_GROUP';

 

MONDAY_WINDOW	freq=daily;byday=MON;byhour=22;byminute=0; bysecond=0	+000[......]

查看全文

How to start up the ASM instance when the spfile is misconstrued or lost

1

Posted on by

在11g中,asm的spfile都存放在asm磁盘组中,所以当ASM的spfile被消失了或删除了,需要自己手动写个pfile 临时把磁盘组mount,然后create spfile到原来的磁盘组上。

错误:

- Start the ASM instance fail with error

SQL> startup;
ORA-00099: warning: no parameter file specified for ASM instance
ORA-00304: requested INSTANCE_NUMBER is busy

- Start up the CRS services fail with error

# crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors

- Checked t[......]

查看全文

11.2.0.3 asm报ORA-04031

0

Posted on by

数据库11.2.0.3 在ASM instances后台会报 ORA-04031这样的错

ERROR at line 1:
ORA-04031: unable to allocate 256 bytes of shared memory ("shared
pool","unknown object","PCursor","kglob")
 
原因是:
1) ASM instance was running out of shared pool free memory.
2) The shared pool free memory was close to 0 MB on the affected ASM instances:
 

+ASM1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~[......]

查看全文

Configure Direct NFS Client (DNFS) on Linux (11g)

1

Posted on by

在Oracle 11g中有了Direct NFS Client (DNFS)新功能 ,配置好后数据库将可以直接访问NFS服务器上的文件,避免由OS内核NFS造成的额外开销。

DIRECT NFS CLIENT OVERVIEW

      Standard NFS client software, provided by the operating system, is not optimized for Oracle Database file I/O access patterns.  With Oracle Database 11g, you can configure Oracle Database to access NFS V3 NAS devices directly using Oracle Direct NFS Client, rather than using the operating system kernel NFS client.  Oracle Database wi[……]

查看全文

第 1 页,共 2 页12