RAC

Introducing Transaction Guard and Application Continuity Oracle Database 12c introduces two fundamental capabilities for ensuring continuity of applications after database outages: A foolproof way for applications to know the outcome of transactions The ability to mask outages by reconnecting to the database and replaying the workload These capabilities are provided by two new features: Transaction […]

Types of Workload Distribution With RAC, multiple listeners on multiple nodes can be configured to handle client connection requests for the same database service. A multiple-listener configuration enables you to leverage the following failover and load-balancing features: Client-side connect-time load balancing Client-side connect-time failover Server-side connect-time load balancing These features can be implemented either one […]

Need for Global Concurrency Control Latches and mutexes may only protect access to memory structures if they are accessed by processes in the same instance. In RAC, latches and mutexes are still used, but for global concurrency control, some additional global enqueues are used to provide protection across instances. Oracle requires concurrency control because it […]

Archived Redo File Conventions in RAC Variable Description Example %t Thread number, not padded log_1 %T Thread number, left-zero-padded log_0001 %s Log sequence number, not padded log_251 %S Log sequence number, left-zero-padded log_0000000251 %r Resetlogs identifier log_23452345 %R Padded resetlogs identifier log_0023452345 %t_%s_%r Using multiple variables log_1_251_23452345 For any archived redo log configuration, uniquely identify […]

Transparent Data Encryption and Keystores in RAC Oracle Database enables RAC nodes to share the keystore (wallet). This eliminates the need to manually copy and synchronize the keystore across all nodes. Oracle recommends that you create the keystore on a shared file system. This allows all instances to access the same shared keystore. Oracle RAC […]

Terminating Sessions on a Specific Instance You can use the ALTER SYSTEM KILL SESSION statement to terminate a session on a specific instance. The example below illustrates this by terminating a session started on a different instance than the one used to terminate the problematic session. SQL> SELECT SID, SERIAL#, INST_ID 2 FROM GV$SESSION WHERE […]

Quiescing RAC Databases To quiesce a RAC database, use the ALTER SYSTEM QUIESCE RESTRICTED statement from one instance. It is not possible to open the database from any instance while the database is in the process of being quiesced from another instance. After all the non-DBA sessions become inactive, the ALTER SYSTEM QUIESCE RESTRICTED statement […]

Starting and Stopping RAC Instances In a RAC environment, multiple instances can have the same RAC database open at the same time. The procedures for starting up and shutting down RAC instances are identical to the procedures used in single-instance Oracle, with the following exception: – The SHUTDOWN TRANSACTIONAL command with the LOCAL option is […]

Local Temporary Tablespaces To improve I/O operations, Oracle introduces a local temporary tablespace in Oracle Database 12c release 2 (12.2), so that spill-overs are written to the local disks on the reader nodes. It is still possible for SQL operations, such as hash aggregation, sort, hash join, creation of cursor-duration temporary tables for the WITH […]