Blog

RECOVER TABLE USING RMAN

Drop a table as a matter of simulation Starting from oracle 12c,there is a recover table feature which can recover the particular accidentally modified or dropped table to the previous point in time. This feature is an alternative to flashback feature which has its own advantage and disadvantage This feature needs backup to be taken … Continue reading RECOVER TABLE USING RMAN

CELL EFFICIENCY RATIO EXADATA

Often, when invoking cellcli utility in exadata storage server,you see a ratio banner called cell efficiency ratio(CER) after copyright message.Have you ever think of what it is and why has it been displayed everytime? I see this banner everytime and ignore it because the ratio value is always small.But suddenly , i saw a huge … Continue reading CELL EFFICIENCY RATIO EXADATA

OSSIPC:SKGXP:[19a6f4c0.31278]{obj}: SKGXPCNH: 0x19a92400 SKGXPCON_CLOSED (1) sconno 40c549b5 accono 767a0096 admno 555ef0 ospid 6155 ANT

Cause: I create diskgroups for RAC node using ASMCA on 11g but the diskgroup fail to create due to timeouts by VKTM background process and it took almost 3 days for the diskgroup The thing is even after 3 days, ASMCA still spinning the gears and it pretty frustates. I checked each and every corner … Continue reading OSSIPC:SKGXP:[19a6f4c0.31278]{obj}: SKGXPCNH: 0x19a92400 SKGXPCON_CLOSED (1) sconno 40c549b5 accono 767a0096 admno 555ef0 ospid 6155 ANT

RAC clusterware commands

To stop the cluster resources on all nodes in RAC cluster To start cluster resources on local node To start database instances on all nodes To check the status of the cluster resource.Note that this report is very important while troubleshoot of RAC issues To check the status of the database instances on all nodes

STORAGE INDEX EXADATA

Storage inde(SI) itself is not an index but a filter which is a cache area used in cell server to reduce disk IO on the database layer. Note:In this article,i will use the term SI instead of storage index so dont get confused Research say that SI is stored in heap of cellsrv which also … Continue reading STORAGE INDEX EXADATA

RMAN-05589: Materialized objects in skipped tablespaces prevent duplication

Cause: This error occur due to the materialized views in tablespace which prevents duplication process Workaround: I find very rare resource in google for this issue nor i couldnt skip the tablespace which contain materialized views Only workaround suggested by oracle is to include the tablespace having MV and drop it after duplication

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.