Abbreviations and Definitions in MySQL DMR ==> Development Milestone Release RC ==> Release Candidate GA ==> General Availability (Release) DMG Packages ==> (Native Packages) A file that is used
Oracle commands Vs PostgreSQL commands Feature/command Oracle Commands PostgreSQL Commands Switch connection to a new database SQL>alter session set container=pdb1; postgres=# \c test1 List available databases SQL> show pdbs
Oracle RAC DBA Interview Questions. Question Which daemon is used to ensure the time synchronization between RAC nodes? Answer ctssd — Oracle Cluster Time Synchronization daemon Question On a rac
Oracle Data Guard Frequently Asked Questions (FAQ). Question What is meant by real time apply in DataGuard environment? If the transactions from Primary to secondary are applied by using the
Converting a Snapshot Standby database into a Physical Standby Database. Step 1 verify open mode of database (it should be in read write) SQL>select open_mode from v$database; SQL> conn sys/oracle@standby
Managing Snapshot standby database in Oracle. In this article we will see step by step procedure to convert physical standby database to snapshot standby database. At Standby database Step 1.
Cascading replication by using Oracle GoldenGate. 1. Scenario: 1.1. Creating a Cascading Reporting Configuration Oracle GoldenGate supports cascading synchronization, where Oracle GoldenGate propagates data changes from the source database to
Errors and Solutions in Oracle GoldenGate Setup. Errors and solution 1.ERROR: GGSCI (ol6-GG-sys1.localdomain) 3> start extract DPUMP_NR Sending START request to MANAGER … ERROR: opening port for MGR MGR
Oracle GoldenGate Bidirectional Replication Setup. 1. Scenario 2: Bidirectional replication Summary of the software / configuration items would be as given in below table. SNo Software/Configuration Item Value @ Site
