Posts

Interview Questions - Oracle Data Guard - 2

1) What is a Redo Transport Service in Oracle Data Guard? The Redo Transport Service is responsible for transmitting redo data from the primary database to the standby database. It ensures that changes made to the primary database are replicated to the standby database, keeping them synchronized. The two modes of redo transport are synchronous and asynchronous. 2) How is log transport initiated from the Primary to Standby database?    Log transport from the Primary to Standby database in Oracle Data Guard is initiated through a series of steps and mechanisms that ensure the redo data (changes made to the database) is reliably transmitted and applied to the standby database. Here’s how the process works: A) Redo Generation:    As transactions are committed on the primary database, redo entries are generated and written to the online redo log files. B) Log Writer Process (LGWR):    The Log Writer process is responsible for writing redo entries from the redo log  buffer in memory to the o

Interview Questions - Oracle Data Guard - 1

Image
 1. What is Oracle Data Guard? Oracle Data Guard is a high-availability and disaster recovery solution provided by Oracle Corporation for Oracle databases. It is designed to ensure data availability, integrity, and reliability by maintaining a synchronized copy of a primary database at one or more remote standby databases. 2. Explain the purpose of Oracle Data Guard. Oracle Data Guard is a high-availability, disaster recovery, and data  protection solution for Oracle databases. Its primary purposes are: 1. Data Protection: Data Guard ensures that data is consistently  and accurately replicated from a primary database to one or  more standby databases. This replication helps protect against  data loss due to hardware failures, human errors, or other  unexpected disruptions. 2. High Availability: By maintaining standby databases that can  take over in the event of a primary database failure, Data Guard  helps ensure that database services are continuously available.  This minimizes downt

user_privs.sql

Copy Code -- ************************************************************************************************************ -- * Filename : user_privs.sql -- * Author : Saravanakumar K -- * Description : This script with show all system,table privs and granted role infor for a user -- * Usage : @user_privs.sql -- * Version : v1 -- ********************************************************************************************************** set echo off set define '&' define username = &1 set tab off verify off col USERNAME for a25 col ACCOUNT_STATUS for a15 col PROFILE for a30 col CREATED heading User|created_dt for a18 col PTIME heading Password|last|changed_dt for a18 col LTIME heading Password|last|locked_dt for a18 col EXPIRY_DATE heading Password|expire|date for a18 col default_tablespace heading Tablespace for a25 col "User account status" for a80 col &

Oracle GoldenGate Initial Load Methods : Direct Load and Direct Bulk Load

Oracle GoldenGate Initial Load Methods Oracle GoldenGate Initial Load Methods Initial Load Direct Load Overview: Initial Load Direct Load is a method that streams the initial data from the source to the target in real-time. This approach utilizes the Extract and Replicat processes to capture and apply data changes continuously. Continuous Capture and Apply: The Extract process reads the data from the source and sends it directly to the target Replicat process, which applies the data immediately. Real-Time Data Streaming: It ensures that the data is streamed in real-time, which is beneficial for scenarios where minimizing latency is crucial. No Intermediate Files: Unlike some other methods, there are no intermediate files or staging areas; the data moves directly from source to target. Transaction Consistency: Ensures transactional consistency, making it suitable for environments where maintaining

db_size_details.sql

Copy Code -- ************************************************************************************************************ -- * Filename : db_size_details.sql -- * Author : Saravanakumar K -- * Description : This script with show all database physical size and average growth in Day and Week -- * Usage : @db_size_details.sql -- * Version : v1 -- ************************************************************************************************************* COL "Database Size" FORMAT a13 COL "Used Space" FORMAT a11 COL "Used in %" FORMAT a11 COL "Free in %" FORMAT a11 COL "Database Name" FORMAT a13 COL "Free Space" FORMAT a12 COL "Growth DAY" FORMAT a15 COL "Growth WEEK" FORMAT a15 COL "Growth DAY in %" FORMAT a18 COL "Growth WEEK in %" FORMAT a20 SELECT ( SELECT MIN(creation_tim

db_size.sql

Copy Code -- ************************************************************************************************************ -- * Filename : db_size.sql -- * Author : Saravanakumar K -- * Description : This script with show all database physical file info -- * Usage : @db_size.sql -- * Version : v1 -- ************************************************************************************************************* set lines 200 pages 999 COL "Database Total Size" FORMAT a20 COL "Free space" FORMAT a20 COL "Used space" FORMAT a20 SELECT name.name,round(SUM(used.bytes) / 1024 / 1024 / 1024) || ' GB' "Database Total Size", round(SUM(used.bytes) / 1024 / 1024 / 1024) - round(free.p / 1024 / 1024 / 1024) || ' GB' "Used space", round(free.p / 1024 / 1024 / 1024) || ' GB' "Free space" FROM (

db_files.sql

Copy Code -- ************************************************************************************************************ -- * Filename : db_files.sql -- * Author : Saravanakumar K -- * Description : This script with show all database physical file info -- * Usage : @db_files.sql -- * Version : v1 -- ************************************************************************************************************* SET TERMOUT OFF; CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES SET TERMOUT ON; SET ECHO OFF SET FEEDBACK 6 SET HEADING ON SET LINESIZE 250 SET PAGESIZE 50000 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON SET VERIFY OFF SET TAB OFF COLUMN ft_sort NOPRINT COLUMN tablespace FORMAT a30 HEADING 'Tablespace Name / File Class' COLUMN filename FORMAT a100 HEADING 'Filename' COLUMN filesize FORMAT 9999999999999 HEADING 'File Size GB' COLUMN autoextensible FORMAT a4