Skip to main content

Oracle database dataguard configuration

 The database connected by the application user is called the primary database when data get this implemented there is another database running at a different site data guard Synchronizes any changes that happen in the primary database to the standby database located 

 If you are disaster occurs at the site hosting the primary database the service will fail over to the standby  database.

 In in this case application users connect to the standby database instead of the primary database

 When data guard is implemented by default the standby database cannot be accessed until your disaster occurs.

 However there is an option in Oracle database called active data guard with this option application users can connect to the stand by database for read only operations.

 This is useful for allowing users who generate reports to access the standby database rather than connecting to the primary database, which would put more load on it.



Comments

Post a Comment

Popular posts from this blog

Oracle database single instance architecture

Oracle database single instance architecture  Maine database runs on a single machine we referred to this architecture as the Oracle database single instance architecture this setup involves having one Oracle database instance running on the mission serving its clients   The term Oracle database instance simply refers to the combination of memory structure and database process that collectively represent the database service.  However this Architectire has a significant availability risk.  If anything goes wrong with the mission that database becomes UN available.
Post a Comment
Read more

Table spaces

 Tablespace consists of one or more data files.  A data file belongs to only one tablespace. Segments, Extents, and Blocks • Segments exist within a tablespace • Segments are made up of a collection of extents • An extents is a collection of logically contiguous data blocks - Cannot span multiple data files • Data blocks are mapped to disk blocks SYSTEM and SYSAUX Tablespaces • The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. • They are created at the time of database creation. • They must be online. • The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). • The auxiliary SYSAUX tablespace is used for additional database components.
Post a Comment
Read more