About of Database Systems and Information Technologies
Redis is an open-source, in-memory data structure store, widely used as a database, cache, and message broker. Known for its lightning-fast performance, Redis operates by keeping data in memory rather than on disk, which allows for incredibly quick read and write operations. It supports a variety of data structures such as strings, hashes, lists, sets,…
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
Oracle Database 23ai is the next long-term support release of Oracle Database. It includes over 300 new features with a focus on artificial intelligence (AI) and developer productivity. Features such as AI Vector Search enable you to leverage a new generation of AI models to generate and store vectors of documents, images, sound, and so…
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
Oracle database is most used rdbms database system. I will mention how install oracle database 19c version on Oracle Linux 8 operating system. Also, I will apply Oracle 19.22 release update patch after 19c installation. I am using VMware virtualization to infrastructure. Operating system is Oracle Linux 8.9. First Step : Configure Operation System For…
You can take export backup of Oracle, PostgreSQL and MySQL databases with one backup script. There are 3 files (config.py, functions.py, dbbackup.py) for backup operation. You can edit config file regarding to your system. You can download python scripts by clicking : dbbackup config.py ####################### # # # Config File # # # ####################### #########################…
With PostgreSQL 15 version, logical replication became applicable by filtering on the tables by column and row. In this way, replication can be made in the desired columns and rows in the tables. Logical Replication wal_level=logical For logical replication, the wal_level parameter must be logical in the postgresql.conf file . By default, the value of wal_level is replica . The replica value provides the necessary wal files for streaming…
PostgreSQL version 15 was released and made available on October 13, 2022. PostgreSQL, the most advanced open source database, brought many new features with its 15th version. PostgreSQL 15 New Features Merge Command With the release of PostgreSQL 15, the Merge command was also made available. MERGE allows you to write a conditional SQL query that…
While runnig duplicate database, oracle can give ORA-17627, ORA-12154, ORA-17629 errors. Error [oracle@oracle19cdg2 admin]$ rman target sys@ORA19C auxiliary sys@DG2 Recovery Manager: Release 19.0.0.0.0 – Production on Sat Jul 6 14:21:44 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: ORA19C (DBID=1219995577) auxiliary database…
Firstly, OPatch directory has to be actual. You can download actual OPatch files from https://updates.oracle.com/download/6880880.html according to you database and operating system version. OPatch directory is in the grid home and oracle home directory. You have to change it with actual OPatch files. You can backup orjinal OPatch files before changing. Check Current Patches My…