RAM&KRISHNA BLOG

  WHAT IS SCAN CLUSTERWARE AND BENEFITS OF SCAN? SCAN stands for Single Client Access Name . It's simplifies client connectivity.   Single Entry Point: SCAN provides a single, consistent name for clients to access any database instance within the RAC cluster. Now clients only need to know the SCAN name, eliminating the need to manage multiple connection strings.   srvctl set scan -scanname myrac-scan.example.com   to list the contents of the scan.properties file, you can use the following command: crsctl list scan How SCAN Listener Knows the Least-Loaded Node Local Listener Communication: Each node in the RAC cluster has its own local listener that keeps track of the load on its node, including session count, CPU usage, memory usage, and other factors. The local listeners regularly communicate with the Global Resource Directory (GRD) in the Oracle Clusterware to update load-related information. Each local listener adve...

  DIFFERENT WAYS TO STOP A PLUGGABLE DATABASE:   OPTION:1:   SQL> show pdbs;       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 ORCLPDB                        READ WRITE NO   SQL> alter pluggable database ORCLPDB close immediate;   Pluggable database altered.   SQL> show pdbs;       CON_ID CON_NAME   ...

    Real-Time Redo Transport Incremental Forever Backups Scalable Architecture Fast Database Recovery : Integration with RMAN (Recovery Manager) : Point-in-Time Recovery for Multiple Databases : Automated Backup Validation and Repair : Recovery Points : The Oracle Zero Data Loss Recovery Appliance (ZDLRA) is a highly specialized data protection and recovery solution designed specifically for Oracle databases. It was created to eliminate data loss and ensure near-instant recovery from failures, making it an essential part of Oracle’s data protection strategy, especially for mission-critical databases. Here’s a breakdown of what the Oracle Zero Data Loss Recovery Appliance (ZDLRA) does and how it works: Key Features of Zero Data Loss Recovery Appliance: Eliminates Data Loss : Real-Time Redo Transport : One of the main features of ZDLRA is its ability to capture database changes in real time by streaming redo logs directly from the Or...