Essential PostgreSQL Shortcut Commands for Efficient Database Management 📌 Master psql with these quick and powerful shortcut commands! Category: Database, PostgreSQL Tags: PostgreSQL, psql, database management, SQL commands Slug: postgresql-shortcut-commands…
Read MoreCreate a new RSA Key Oracle$ java -jar oci_install.jar -newrsakeypair -walletDir $ORACLE_HOME/dbs/opc_wallet Oracle Database Cloud Backup Module Install Tool, build 19.3.0.0.0DBBKPCSBP_2019-10-16 OCI API signing keys are created: PRIVATE KEY –>…
Read MoreThis document describes the process of creating a DBLink from an MSSQL database to an Oracle database schema A database link (DBLink) allows seamless integration and access between two databases,…
Read MoreManaging large datasets efficiently is a key challenge for database administrators (DBAs). One solution to this problem is table partitioning, a feature in Oracle databases that allows large tables to…
Read MoreIn Oracle E-Business Suite (EBS) environments, it’s a good practice to occasionally analyze the largest database objects to identify potential inefficiencies. Recently, I discovered that the FND_LOG_MESSAGES table in my…
Read MoreIntroduction: DbFetchX is a robust application designed to streamline data extraction, transformation, and retrieval from Oracle Databases. Its installation involves integrating the application’s schema, objects, and configurations into an Oracle…
Read MoreDescription to standby: A standby database is a transactionally consistent replica of the primary database, designed to ensure continuity and data integrity in the event of disasters or data corruption. It allows the primary Oracle database to remain operational even during planned or unplanned outages. If the primary database becomes unavailable, Data Guard can seamlessly promote the standby database to the primary role, minimizing downtime. Additionally, the performance of the primary database can be optimized by redirecting resource-intensive tasks such as backups and reporting to the standby system. Therefore, keeping the standby database synchronized with the primary database is always advantageous. A standby database might lag behind the primary for various reasons like: Unavailability of or insufficient network bandwidth between primary and standby database Unavailability of Standby database Corruption / Accidental deletion of Archive Redo Data on primary CHECK THE SEQUENCE IN BOTH NODES: PRIMARY: SQL> select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1; THREAD# Last Primary Seq Generated ———- ————————– 1 556 STANDBY:…
Read MoreDescription: After configuring Data Guard, databases operate in either the primary or standby role, which can be switched dynamically without data loss or resetting redo logs. This process, known as a Switchover, can be executed using specific commands. Configuration Details: Environment detail Primary Standby SID SOURCE SOURCE DB Role Primary Physical standby Host prime.localdomain.com stand.localdomain.com DB Version 19.3.0.0 19.3.0.0 OS RHEL 7.9 RHEL 7.9 Step 1:- Check database role and database name Primary database:- SQL> select name,open_mode,database_role from v$database; NAME OPEN_MODE DATABASE_ROLE ——— ——————– —————- SOURCE READ WRITE PRIMARY Standby database:- SQL> select name,open_mode,database_role from v$database;…
Read MoreIntroduction: Upgrading from Linux 7 to Linux 8 in the Oracle Cloud Infrastructure (OCI) environment is a crucial step to ensure the operating system is up-to-date, secure, and capable…
Read MoreIntroduction Exporting data using a SELECT query in MySQL is a common practice to extract specific data from a database and save it in a usable format. This allows users…
Read More