Happy Halloween!
“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in October 2020. I hope you find these helpful to learn something new or to remind you of its existence and use.
| #OraTidbit #AutonomousDB The default operation mode of Autonomous Database is Read/Write. If you select Read-Only mode users can only run queries. You can restrict access to only allow users with the RESTRICTED SESSION privilege to connect to the database. The ADMIN user has this privilege. You can use the restricted access mode to perform administrative tasks such as indexing, data loads, or other planned activities. |
| #OraTidbit #AutonomousDB Read-Only mode and restricted mode of operation are not supported with Autonomous JSON Database. Currently, these modes of operations are available only with Autonomous Data Warehouse (#ADW) and Autonomous Transaction Processing (#ATP). |
| #OraTidbit #OracleOnAzure #Azure Using #Blobfuse (virtual file system driver for Azure Blob storage on Linux), you can write Oracle database RMAN backups directly to Azure Blob storage. |
| #OraTidbit #OracleOnAzure #Azure Though Azure Site Recovery is designed for Business Continuity and Disaster Recovery (BCDR), you can use it to migrate Oracle Databases running on OEL 6.x from on-premises to Azure Cloud. |
| #OraTidbit #OracleOnAzure #Azure You may use Active Data Guard and Far Sync Instance to achieve zero data loss protection for Oracle databases on Azure. The Far Sync instance can be deployed in the same availability zone as the database instance to reduce the latency. |
| #OraTidbit #OracleCloud The Exadata Cloud Service compute nodes are each configured with at least one virtual machine (VM). You have root privilege for the Exadata compute node VMs, so you can load and run additional software on the Exadata compute nodes. |
| #OraTidbit #OracleCloud With Exadata Cloud Service, databases that use Oracle Database 12c, or later, are configured to use the CDB architecture. |
| #OraTidbit #AutonomousDB You can use Oracle Cloud Infrastructure Events to subscribe to and be notified of Autonomous Database events. The Oracle Cloud Infrastructure Events allow to create automation and to receive notifications based on state changes for resources. |
| #OraTidbit #AutonomousDB Autonomous Container Databases with Autonomous Data Guard is available on Oracle Autonomous Database on Dedicated Exadata Infrastructure. When the primary database becomes unavailable for any reason, the Autonomous Data Guard automatically converts the standby database to the primary database and, it begins servicing your applications. |
| #OraTidbit #OrclDB #db20c Oracle Automatic Storage Management Cluster File System (Oracle ACFS) automatic shrinking automatically shrinks an Oracle ACFS file system based on a policy providing there is enough free storage in the volume. |
| #OraTidbit #OracleCloud Cloud Guard is a cloud-native detect-and-respond solution that detects misconfigured resources and insecure activities at scale. Cloud Guard acts as a log and events aggregator that directly integrates with all major Oracle Cloud Infrastructure services (Compute, Networking, Storage, etc.), providing actionable results. |
| #OraTidbit #OracleCloud The OCI Designer Toolkit (OKIT) is a standalone/offline, OpenSource browser-based Drag-n-Drop design tool for OCI providing rapid design and prototyping of OCI based infrastructure. Once the design is complete Terraform / Ansible scripts can be generated that can then be executed to build what has been designed. |
| #OraTidbit #OracleCloud Security Zones let you be confident that your resources in Oracle Cloud Infrastructure, including Compute, Networking, Object Storage, and Database resources, comply with Oracle security principles. |
| #OraTidbit #OracleCloud Oracle Autonomous JSON Database is an Oracle Cloud service that is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents. It performs all routine database maintenance tasks while the system is running, without human intervention. |
| #OraTidbit Oracle NoSQL Database provides SQL for Oracle NoSQL Database, which is an easy to use SQL-like language that supports read-only queries and data definition (DDL) statements. |
| #OraTidbit Oracle Audit Vault and Database Firewall monitors Oracle and non-Oracle database traffic to detect and block threats, as well as improves compliance reporting by consolidating audit data from databases, operating systems, directories, and other sources. |
| #OraTidbit Oracle Audit Vault and Database Firewall uses a sophisticated grammar analysis engine to inspect SQL statements before they reach the database and determines with high accuracy whether to allow, log, alert, substitute, or block the incoming SQL. |
| #OraTidbit #AutonomousDB When you perform the clone operation you can select a newer Oracle Database version for the target database. This allows you to use cloning to upgrade Autonomous Database. |