Skip to main content

Welcome to DBA Master – Database Tips, Tricks, and Tutorials

Welcome to DBA Master ! This blog is dedicated to all things related to database administration , SQL optimization , and performance tuning . Whether you're a beginner or a seasoned DBA, you'll find practical guides, troubleshooting tips, and real-world tutorials to help you work smarter with data. What to Expect: SQL performance tuning tips Indexing strategies Backup and recovery best practices High availability and replication techniques Database creation, configuration, and setup Monitoring queries and scripts for proactive performance management Migration guides across different database platforms Security essentials and best practices Recommended tools for DBAs Real-world error fixes and how to solve them Stay tuned — exciting content is coming soon. Feel free to bookmark and share: www.dbamaster.com ! Thanks for visiting!
Post a Comment

Fast-Start Failover Enable the Broker (DGMGRL) in Oracle 19C

  • Fast-Start Failover enables the broker to perform these tasks automatically failover to standby database.
  • The key to this feature is a monitoring process appropriately named the Observer. 
  • The Observer is a component of the DGMGRL interface that is configured on a system outside the systems actually running the Oracle Data Guard configuration, which monitors the availability of the primary database. 
  • It will issue a failover after waiting the number of seconds specified by the FastStartFailoverThreshold property

Fast-start failover can be enabled for either maximum availability mode or maximum performance mode

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Enable the Fast-start Failover:

DGMGRL> enable fast_start failover;

The observe-only mode for fast-start failover enables you to test how fast-start failover will
work in your environment with no impact on your current configuration or on applications:

DGMGRL> enable fast_start failover observe only;

Set FSFO targets and start the Observer:

DGMGRL> show database pearl FastStartFailoverTarget;
  FastStartFailoverTarget = ''
 
DGMGRL> edit database pearl set property FastStartFailoverTarget='muthu';
Property "faststartfailovertarget" updated
 
DGMGRL> show database pearl FastStartFailoverTarget;
  FastStartFailoverTarget = 'muthu'

# then, the other way arround in case of a role switch

DGMGRL> edit database muthu set property FastStartFailoverTarget='pearl';
Property "faststartfailovertarget" updated

Start the DGMGRL Observer:

DGMGRL> start observer;

(OR)

DGMGRL> start observer observ file is /home/opc/fsfo.dat logfile is /home/opc/observ.log;

[W000 2019-10-26T23:38:06.076+05:30] FSFO target standby is muthu
Observer 'observ' started
[W000 2019-10-26T23:38:06.983+05:30] Observer trace level is set to USER
[W000 2019-10-26T23:38:06.983+05:30] Try to connect to the primary.
[W000 2019-10-26T23:38:06.983+05:30] Try to connect to the primary pearl.
[W000 2019-10-26T23:38:07.030+05:30] The standby muthu is ready to be a FSFO target
[W000 2019-10-26T23:38:08.030+05:30] Connection to the primary restored!
[W000 2019-10-26T23:38:10.046+05:30] Disconnecting from database pearl.

The session will seem to hang. You can do a control C. Or create and run the script as nohup. (other way to start the observer)

Other way to start in background

nohup dgmgrl sys/admin123@orcl "start observer file='/home/oracle/fsfo.dat'" -logfile $HOME/observer.log &

dgmgrl SYS/admin123@pearl "start observer observ file is /home/opc/fsfo.dat logfile is home/opc/observ.log;" &

Check the observer:

DGMGRL> show observer

check the fast start failover status

DGMGRL> show fast_start failover

DGMGRL> show configuration FastStartFailoverAutoReinstate
  FastStartFailoverAutoReinstate = 'TRUE'
 
DGMGRL> show configuration FastStartFailoverThreshold
  FastStartFailoverThreshold = '30'
 
DGMGRL> edit configuration set property FastStartFailoverThreshold=15;
Property "faststartfailoverthreshold" updated

Disable the Fast-Start Failover (FSFO);

DGMGRL> DISABLE FAST_START FAILOVER;

Labels:

Comments

Post a Comment

Popular posts from this blog

Oracle Database 19C Performance Tunning - PART 1

Advantages: 1. Improved Query Performance •    Optimized SQL execution plans lead to faster query response times. •    Reduces unnecessary full table scans and improves indexing strategies. •    Parallel execution tuning speeds up large data processing tasks. 2. Better Resource Utilization •    Efficient use of CPU, memory, disk I/O, and network resources. •    Reduces contention on Redo Logs, Undo Tablespaces, and Buffer Cache. •    Helps in load balancing across multiple instances in RAC (Real Application Clusters). 3. Increased System Scalability •    Ensures that the database can handle a growing number of users and transactions. •    Proper tuning allows scaling without degrading performance. •    Optimized parallel processing ensures better performance on multi-core servers. 4. Lower Infrastructure Costs •    Reduces the need for add...
Post a Comment
Read more

Oracle RMAN Backup And Restore

RMAN: (Oracle 8) RMAN (Recovery Manager) is a utility provided by Oracle Database to perform backup, restore, and recovery operations. It is a command line tool. Features of RMAN in Oracle 19c Comprehensive Backup Capabilities: Full and incremental backups. Block-level backups for efficient data storage. Archived redo log backups. Fast Recovery Area (FRA) integration for centralized backup storage. Efficient Recovery Options: Point-in-time recovery (PITR). Complete and incomplete recovery. Flashback database capabilities for quick undo of changes. Multitenant Database Support: RMAN fully supports container databases (CDBs) and pluggable databases (PDBs). Provides flexibility to back up and recover individual PDBs or entire CDBs. Automatic Space Management: Manages disk space in the FRA. Automatically deletes obsolete backups and archived logs. Data Deduplication and Compression: Backup optimization through block-level deduplication. Built-in compression algorithms to reduce storage req...
Post a Comment
Read more

Oracle 19c Database Software Installation in OEL8

 Pre-requisites for OS level:            Set the static IP Address     Disable the Firewall (systemctl stop firewalld & systemctl disable firewalld)     set SELINUX=permissive on /etc/selinux/config  ##Need to restart the server use init 6 Oracle Installation Pre-requisites Methods     Automatic Setup     Manual Setup      Automatic requisites Setup: (avoid step 1 to step 5): dnf install -y oracle-database-preinstall-19c Install the dependencies: curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm Manual Setup: step 1: Add the karenl parameters and values vi /etc/sysctl.conf     fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel....
Post a Comment
Read more