Author's posts
Oct 27 2021
Clone a Database User by Query
Script to pull/show a database user’s privileges or clone a user by query.
Oracle GolgeGate
Oracle GoldenGate is a comprehensive software solution provided by Oracle for real-time data integration and replication in heterogeneous IT environments. It enables the exchange and manipulation of data at the transaction level among multiple, diverse platforms across the enterprise
Feb 18 2021
Create a Trace file for Control file
Sometimes DBA needs to create database creation script from existing database. Oracle provides the “alter database backup controlfile to trace” command to copy the create database syntax into a trace file.
Jan 16 2021
Create a filesystem on Linux
In this article, I will show how to create a filesystem and mount it on Linux.
Nov 13 2020
Oracle Database Performance Issue Troubleshooting and Tuning Part – I
“Database or query is performing very slow”. This is a very common complain for DBA. Database performance is an art as there is always have an option to tune. There is no limit to tuning the database performance but DBA need to meet the company’s threshold or SLA. There are lots of factors involved to …
Nov 07 2020
Restoring Corrupted Datafile Using RMAN in Oracle
Datafile corrupt is a partial disaster in database. it will impact for all objects belonging the tablespace. In this case, DBA can either restore the problematic/corrupted datafile from backup.
Nov 07 2020
Performing Block Media Recovery in Oracle
In most cases, the database marks a block as media corrupt and then writes it to disk when the corruption is first encountered. No subsequent read of the block will be successful until the block is recovered. You can only perform block recovery on blocks that are marked corrupt or fail a corruption check.
Oct 27 2020
Configure and Manage RMAN Recovery Catalog
Recovery Catalog: A set of Oracle tables and views used by RMAN to store RMAN repository information about one or more Oracle databases. RMAN uses this metadata to manage the backup, restore, and recovery of Oracle databases. Target Database: In an RMAN environment, the database to which you are connected as TARGET. The target database is …
Oct 16 2020
Oracle Database 12c R2 (12.2) RAC On Oracle Linux 7
Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. In this article, I will show how to install Oracle RAC (12.2.0.1) on Oracle Enterprise Linux 7.1. Below high level steps will perform to install/configure Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC. Install …
Oct 16 2020
How to Show All Privileges for a User in Oracle Database
Sometimes DBA needs to generate the report to provide audit team or management about the users access information on database. In this article, I will show how to get list of access for oracle user. Query to find all privileges for all users in Database: