MEB Backup & Restore in MySQL
MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking…
Read moreasrblogger
ORA-04021: timeout occurred while waiting to lock object while dropping Materialized View.
A materialized view, or snapshot as they were previously known, is a table segment whose…
Read moreUnable to generate Listener Log in Prod RAC DB
Cause: Looks like ADR is having the issue. Solution: Added the below parameter in the…
Read moreMoving datafile from one location to another in Standby
Check the datafile location along with name: Set standby file management parameter to manual before…
Read moreORA-16047: DGID mismatch between destination setting and target database
Issue : ORA-16047: DGID mismatch between destination setting and target database Since LOG_ARCHIVE_DEST_3 is getting…
Read moreApache Cassandra Performance Tuning
What is Apache Cassandra? ▪ NoSQL database ▪ Schema-free ▪ Very fast ‘write’ ▪ Cassandra…
Read moreCassandra import & export
Cassandra.csv file data: Create keyspace and create tables and then importing the data form local…
Read moreProtected: Cassandra Data Modelling
There is no excerpt because this is a protected post.
Read moreLinux Administration.
A Linux distribution is a collection of (usually open source) software on top of a…
Read moreMySQL HA DR Setup
/etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.10 mysql-prim.localdomain mysql-prim 192.168.56.11…
Read moreBasic Performance and Tuning
As a DBA, you are responsible for the performance of your Oracle database. Typically, performance…
Read moreComparison Between Oracle Streams and GoldenGate
Staging Streams: Streams may store or stage changes in a database buffered queue. The benefit…
Read moreTransparent Data Encryption in Oracle
Transparent Data Encryption (TDE) enables you to encrypt sensitive data that you store in tables…
Read more“ORA-00059: Maximum Number Of DB_FILES Exceeded”
CAUSE ALTER TABLESPACE TB1 add datafile '+WHALE_DG1' size 10g autoextend on next 500M * ERROR…
Read moreUndo Tablespace
There are two types of Undo Modes in 12.2 1) Shared Undo - The Undo…
Read moreRenaming and Relocating Datafiles Online
Relocating an Online Data File Copying an Online Data File This example copies the data…
Read moreOracle Managed Files 11g & 12c
11g When OMF is enabled and If a datafile location is incorrect the file gets…
Read moreManaging Tablespace in CDB and PDB
Managing tablespace in container database is similar to non-container database. Provided you are logged in…
Read moreCommon user password change:
Common user password we can change from only cdb level .container class is optional.
Read moreOracle-maintained users password change
From oracle 12c onwards the default user’s account passwords have to change from cdb container.…
Read moreLockdown Profile:
From 12c onwards we have new feature called lockdown profile to control the PDB level…
Read moreCommon Roles Vs Local Roles
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants…
Read moreCommon Grant Vs Local Grant
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants…
Read moreRedolog Buffer Cache : SGA Component of Oracle
The redo log buffer is a circular buffer in the SGA that stores redo entries…
Read moreShared /Large/Java/Result Pool: SGA Component of Oracle
The shared pool caches various types of program data.For example, the shared pool stores parsed…
Read more