Add filesystem mountpoint in linux
After storage team provision the physical disk layer,check the logical units of the disks using fdisk Create a mount point with type(-t) ext4 on /dev/sde Create a directory to mount the logical mount point Check if the mount point is added to the OS.Note that so far we have temporarily mounted the filesystem.Post reboot of … Continue reading Add filesystem mountpoint in linux
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
Format the output of numeric scientific notation(12E+10) in sqlplus
In sqlplus commandline, we dont get proper output on the screen for large number because of width and column number format rather we get scientific notation which is absurd in case of dbid or scn number of a database. There are two ways to get proper output with full digits One variable is numwidth Another … Continue reading Format the output of numeric scientific notation(12E+10) in sqlplus
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
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
Cause: Workaround: Incremental backup needs archivelogs to be enabled Check if your database is in archivelog mode Else enable archivelog in your database Verify the change Check this post for more info! https://wordpress.com/post/alphaoragroup.com/2276
Does rman take incremental lvl 0 backup in noarchivelog mode?
In this article, i am going to test rman level 0 incremental backup in noarchivelog mode. For long time, i had this thing in my mind to test this scenario.Why because, i know that incremental backup happens when the database is online and it is more of a ground level hot backup or online backup … Continue reading Does rman take incremental lvl 0 backup in noarchivelog mode?
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
