• 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

How to quiesce an Oracle 12c RAC database

by admin

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 executes and the database is considered to be quiesced. In RAC, this statement affects all instances.

SQL> ALTER SYSTEM QUIESCE RESTRICTED;

To issue the ALTER SYSTEM QUIESCE RESTRICTED statement in a RAC environment, you must have the Database Resource Manager feature activated, and it must have been activated since instance startup for all instances in the cluster database. It is through the Database Resource Manager that non-DBA sessions are prevented from becoming active. The following conditions apply to RAC:

  • If you had issued the ALTER SYSTEM QUIESCE RESTRICTED statement, but the Oracle server has not finished processing it, then you cannot open the database.
  • You cannot open the database if it is already in a quiesced state.
  • The ALTER SYSTEM QUIESCE RESTRICTED and ALTER SYSTEM UNQUIESCE statements affect all instances in a RAC environment, not just the instance that issues the command.

Cold backups cannot be taken when the database is in a quiesced state because the Oracle background processes may still perform updates for internal purposes even when the database is in a quiesced state. Also, the file headers of online data files continue to appear as if they are being accessed. They do not look the same as they do when a clean shutdown is done.

Filed Under: oracle, oracle 12c, RAC

Some more articles you might also be interested in …

  1. How to Find OCR Master Node
  2. Manage ASM Audit Files with syslog – configure lograte and auditing
  3. Oracle Database : script to create a “CREATE SYNONYM Script”
  4. How To Catalog Backups / Archivelogs / Datafile Copies / Controlfile Copies in Oracle Database
  5. How to Recover A Dropped Tablespace Using TSPITR
  6. How to Clone a Pluggable Database from an RMAN Container Database Backup
  7. How to Optimize a Data Guard Configuration
  8. How to Change SYS and SYSTEM Passwords in Oracle Database
  9. Log file locations for Enterprise Manager Cloud Control 13c (OMS)
  10. Oracle RMAN 11g New Feature – MultiSection Backups

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright