环境:RHEL5.8 RAC 11.2.0.3.01:查看ORC和voting disk信息:In 11g Release 2 your voting disk data is automatically backed up in the OCR whenever there is a configuration change.所以恢复时恢复备份OCR即可,这里和10g是不同的,不需要备份voting disk,备份OCR即可2:使用cluvfy 工具检查OCR完整...【阅读全文】
ALTER TABLE SUPMAN."Base_StaffInfo" CACHE;ALTER TABLE SUPMAN."Base_StaffInfo" STORAGE (BUFFER_POOL KEEP);oracle 回滚段查看:select s.username, u.name from v$transaction t,v$rollstat r,v$rollname u,v$session s where s.taddr=t.addr andt.xidusn=r.usn and r.usn=u.usn order by s.us...【阅读全文】