• On-premises RMAN backup placed in a storage object on Oracle Cloud Infrastructure.

    This article describes how to take a local to your premises backup of an Oracle database and to store it in OCI, formerly known as Oracle Bare Metal Cloud. Depending on your connectivity to the cloud service this could be useful for small to medium size database backups.
    At the moment of writing Oracle offers a terabyte of redundant storage for about 26 USD/month.
    For bigger databases this solution would not be practical. An option would be to create a standby in the cloud and to backup it locally to the cloud.Thus the only concern would be the redo log generation against your outbound traffic.

    Local setup:
    OS: Oracle Linux 7
    Oracle Database 12c Enterprise Edition Release 12.2
    (ASM, the sample schema installed only)
    Oracle Cloud Infrastructure command line interface 2.4.10 (configured and ready to use)

    Remote cloud setup:
    Basically you would need a valid account that have the rights to create object storage.
    You can assign the following policy to grant the minimum rights for this task:

    Allow group MyBackupGroup to manage buckets in tenancy  
    Allow group MyBackupGroup to manage objects in tenancy  
    

  • Oracle Cloud Infrastructure vs AWS. NVMe SSD test for MemSQL use case - 2

    One of the big use cases for Oracle Cloud Infrastructure (OCI) formerly known as Baremetal Cloud is noSQL and newSQL. Oracle says what big advantage on storage layer would be PCIe based NVMe SSD with super low latency. And elimination of virtualization layer would let it shine at full. While MemSQL row store is in-memory, it’s columnar store persists on disk. When look from filesystem level, columnar store data consists of a lot of small files.
  • Oracle Cloud Infrastructure vs AWS. NVMe SSD test for MemSQL use case.

    One of the big use cases for Oracle Cloud Infrastructure (OCI) formerly known as Baremetal Cloud is noSQL and newSQL. Oracle states what big advantage on storage layer would be PCIe based NVMe SSD with super low latency. And elimination of virtualization layer would let it shine at full. While MemSQL row store is in-memory, it’s columnar store persists on disk. When look from filesystem level, columnar store data consists of a lot of small files.
  • Install oracle bmcs (oraclebmc-cli)

    Here is a quick example how to install Oracle Braremetal cloud cli on MacOS or Linux. Please note what oracle just renamed Braremetal cloud to Oracle Cloud Infrastructure (OCI) First thing first - python. I recommend to start with Python 3.6 or later. Oracle says python 2 is also supported, but when I tried bmcs installed on 2.7.13, I got error: $ bmcs compute image list --compartment-id ocid1.compartment.oc1..aaaaaaaaforqbvs3vdq2a73tfkih4ntll35dobofj4q2qjjk27l5p5gh3xna SSLError: ("bad handshake: SysCallError(54, 'Connection reset by peer')",) Which links to a problem what old python uses TLS 1.