Data Guard

Oracle Data Guard Manual Failover

نشر بواسطة : Obay Salah , January 5, 2025

1- Minimize data loss (primarydb): If you can mount the primary database, then flush the logs to standbyOn primary: =========== SQL> startup mount... اكمل القراءة

Data Guard

Oracle Data Guard Manual Switchover

نشر بواسطة : Obay Salah , January 5, 2025

1- check Primary and standby database role and status.select name, open_mode, db_unique_name, database_role from v$database; 2- Check primary and stan... اكمل القراءة

Data Guard

Refresh Standby Database using RMAN Incremental SCN Backup

نشر بواسطة : Obay Salah , December 25, 2024

1. Verify GAP2. Stop Redo Transfer (On Primary)3. Find current SCN from Standby4. Take RMAN Incremental from SCN (Primary)5. Create Standby Control fi... اكمل القراءة

Data Guard

Creating Physical Standby Using RMAN DUPLICATE FROM ACTIVE DATABASE

نشر بواسطة : Obay Salah , December 25, 2024

Without shutting down primary, we need to create physical standby database using RMAN DUPLICATE FROM ACTIVE DATABASE command (No need to take backup o... اكمل القراءة

Data Guard

Convert Physical Standby To Snapshot Standby

نشر بواسطة : Obay Salah , December 24, 2024

1- Check both primary and standby roleSQL> select name, open_mode, database_role from v$database; SQL> select status, instance_name, databa... اكمل القراءة

Data Guard

Create Physical Standby Database using RMAN Backup

نشر بواسطة : Obay Salah , December 24, 2024

1. EnvironmentOn Primary (Step 2 to Step 12)2. Enable Forced Logging on Primary3. Check Password File on Primary4. Configure a Standby Redo Log on Pri... اكمل القراءة

Database

check Oracle DB FRA and DISKGROUP Usage

نشر بواسطة : Obay Salah , December 22, 2024

1- Check fast recovery area usageselect name,round(space_limit / 1024 / 1024 /1024) size_gb ,round(space_used / 1024 / 1024/1024) used_gb, decode... اكمل القراءة

Database

Enabling ARCHIVELOG mode

نشر بواسطة : Obay Salah , December 22, 2024

1- Log in as user oracle and enter the following commands:$ export ORACLE_SID=<MYDB> where <MYDB> is the name of the... اكمل القراءة

Database

Oracle 19c Installation on Linux

نشر بواسطة : Obay Salah , December 15, 2024

1. Hardware Requirements— Check Physical RAM.# grep MemTotal /proc/meminfo We need at least 8192 MB of physical RAM— Check Swap Space.# grep SwapTotal... اكمل القراءة

Database Performance

Blocked Sessions in Oracle

نشر بواسطة : Obay Salah , December 10, 2024

1- Get current session id.SELECT SID, SERIAL# FROM V$SESSION WHERE SID = Sys_Context('USERENV', 'SID'); 2- Create Below Table and Insert a Row Without... اكمل القراءة