• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Define redo log files in an Oracle RAC environment

by admin

Redo Log Files and RAC

In an Oracle RAC database, each instance must have at least two groups of redo log files. You must allocate the redo log groups before enabling a new instance with the ALTER DATABASE ENABLE INSTANCE instance_name command. When you use DBCA to create the database, DBCA allocates redo log files to instances, as required, automatically. You can change the number of redo log groups and the size of the redo log files as required either during the initial database creation or as a post-creation step.

Redo Log Files and RAC

When the current group fills, an instance begins writing to the next log file group. If your database is in ARCHIVELOG mode, then each instance must save filled online log groups as archived redo log files that are tracked in the control file. During database recovery, all enabled instances are checked to see if recovery is needed. If you remove an instance from your Oracle RAC database, you should disable the instance’s thread of redo so that Oracle does not have to check the thread during database recovery.

Redo log management must be considered when the number of instances for a particular production Oracle RAC database changes. For example, if you increase the cardinality of a server pool in a policy-managed database and a new server is allocated to the server pool, then Oracle Clusterware starts an instance on the new server if you have Oracle Managed Files (OMF) enabled. If the instance starts and there is no thread or redo log file available, then Oracle Clusterware automatically enables a thread of redo and allocates the associated redo log files and undo if the database uses Oracle ASM or any cluster file system.

For administrator-managed databases, each instance has its own online redo log groups. Create these redo log groups and establish group members. To add a redo log group to a specific instance, specify the INSTANCE clause in the ALTER DATABASE ADD LOGFILE statement. If you do not specify the instance when adding the redo log group, then the redo log group is added to the instance to which you are currently connected.

Each instance must have at least two groups of redo log files. You must allocate the redo log groups before enabling a new instance with the ALTER DATABASE ENABLE INSTANCE instance_name command. When the current group fills, an instance begins writing to the next log file group. If your database is in ARCHIVELOG mode, then each instance must save filled online log groups as archived redo log files that are tracked in the control file. During database recovery, all enabled instances are checked to see if recovery is needed. If you remove an instance from your Oracle RAC database, then you should disable the instance’s thread of redo so that Oracle does not have to check the thread during database recovery. You can query V$THREAD to see the thread currently in use. Query V$LOG to list the redo log files with the threads they belong to.

Filed Under: oracle, oracle 12c, RAC

Some more articles you might also be interested in …

  1. Oracle DGMGRL (Data Guard Manager) Command Line Reference (Cheat Sheet)
  2. How to Change Timezone Settings on Exadata
  3. How to Enable or Disable Automated Statistics Collection in Oracle Database
  4. How do stubs work in a WebLogic Server cluster?
  5. Oracle Database – Measuring Network Capacity using oratcptest
  6. How to change the SCAN IP address (SCAN VIP resources) in 11gR2 Grid (CRS) environment
  7. How to Delete ASM Disk on Multipath Device in CentOS/RHEL
  8. Interview Questions : Oracle 12c Multitenant Database Architecture
  9. Oracle Database 12c New feature: Local Temporary Tablespaces
  10. Real-time SQL Monitoring for Developers – Oracle Database 19c New Feature

You May Also Like

Primary Sidebar

Recent Posts

  • qsub Command Examples in Linux
  • qsub: command not found
  • qrcp Command Examples in Linux
  • qmrestore Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright