1 Oracle Database Backup CloudOracle Storage Cloud Oracle Backup Software Appliance Oracle Archival Cloud By Nitin Vengurlekar Charles Kim
2 Nitin Vengurlekar www.viscosityna.comCTO & Chief Architect at Viscosity Responsible for Service Delivery Focus on Virtualization, Engineered & Converged Systems Developed white papers and Best Practices for Application/Database High Availability &Consolidation 18 Years with Oracle 6 years with Oracle Support 9 years with RAC Product Management 3 years a “Private Database Cloud” Evangelist Follow me on Twitter: dbcloudshifu
3 Charles Kim @racdba Oracle ACE DirectorFounder and President of Viscosity Over 25 years of Oracle Expertise: Mission Critical Databases, RAC, Data Guard, ASM, RMAN, Shareplex / GoldenGate Specializing in “Full Automation of Everything” done more than once!! President - IOUG Cloud Computing (and Virtualization) SIG Blog Sites: Oracle Exadata Certified Implementation Specialist, Certified RAC Expert Who am I slide and self promotion page Promote Exadata book Promote Hadoop As A Service book
4 Agenda Review of Oracle Cloud Storage OffereingsWhy Oracle Database Backup as a Service Backup & Restore On-Premise to Oracle Public Cloud (OPC) RMAN Configuration RMAN Backups / Restore from OPC Storage Cloud Standard Storage Archive Storage Storage Cloud Software Appliance Architecture Setup/Configuration and lessons learned What do you think about when you think about backing up to the cloud? Database backups Non-database files BLOBs/CLOBs Small Data Set / Large Data Sets How many of you have a requirement to have off-site backups? Are your backups encrypted? Do you have a Disaster Recovery Plan? What is your data retention plan?
5 Journey to The Enterprise CloudHybrid Cloud Private In House Cloud Public Cloud Multi Cloud In the beginning we had very silo’ed config Then we evolved into a model of simplification, standardization and rationalization …resulting a effcient consolidation Shared infrastructure called Private Cloud, Virtaulization/Clustering/Noisy neighbor containment have played a huge part in this movement and success of Private Cloud Public Cloud vs Private Cloud In Cloud model, customers purchase no hardware, no permanent support cost, thus reducing overall liabilities. Customers subscribe to platform services only when needed and unsubscribe if project is delayed. …. But depends on the Cloud Model Cloud users can quickly test and qualify applications - No need to wait software procurement and deployment process With Hybrid/Ent Cloud …Customers have found is that when it comes to the cloud, one size does not fit all. Businesses large and small are turning to blended infrastructure because it combines the best of all worlds: Enterprise 2015 2018 1995 2000 2010
6 Just To Be Clear…...Um..Er’….CloudyStorage Cloud Appliance is just the on-prem version of Storage Cloud Service
7 Viscosity and the CloudImplement all Oracle Cloud Solutions Healthcheck and Cloud Readiness Assessment Evaluate which Cloud Storage is most appropriate Ensure adherence to SLA Backup as a Service Deployment Determine optimal compression and parallelism Evaluate use of existing offsite backups - Commvault, Data Domain, Avamar We have already converted several Commvault systems to Backup as A Service Review Use Cases
8 Introduction -Oracle Database Backup Cloud ServiceODBS complements your existing backup strategy Use familiar RMAN interface to perform backup & restore operations Provides an off-site storage location No up-front capital costs or hardware expenses. Storage management & data transfer complexities are handled by the service Pay-as-you-go, elastic self-provisioning mode - Scale capacity on demand Create secure, encrypted backups in an off-premises location Oracle ONLY accepts secured encrypted backups Just be cognizant of un-metered and metered offerings
9 Backup/Recovery General GuidelinesFollowing are general guidelines customers typically follow to address RTO and RPO requirements: • Local - Fast Recovery Area (FRA): Typically stores backups for up to 7 days • External Storage (NAS): up to 30 days • Tape media (if available): 1 to 6 months • Tape vaulting (offsite storage): months to years From the backup and recovery perspective, the following are general practice guidelines that customers typically follow to address RTO and RPO requirements: • Local Fast Recovery Area (FRA): Typically stores backups for up to 7 days • External Storage (NAS): up to 30 days • Tape media (if available): 1 to 6 months • Tape vaulting (offsite storage): months to years
10 Database Cloud Backup Service – Easy as 1-2-3 (4 and 5)Subscribing to the Backup service Download the Oracle Database Cloud Backup Module Install the Oracle Database Cloud Backup Module Configure RMAN Backup Channel Backup the database To download Cloud components:
11 Oracle Database Backup Service – Try It !!
12 RMAN Step By Step Configuration
13 Recovery Manager (RMAN) - Tool of ChoiceOracle database integrated backup & recovery tool No new learning curve for the DBAs Perform SET, CONFIGURE, BACKUP, RESTORE & RECOVER operations at various levels Execute Report, List, Backup Validate, Backup Advisor, etc.. Database, data file, tablespace, table, block ASO and Compression bundled w/ ODBS with no additional cost Simple commands RMAN> BACKUP DATABASE; RMAN> RESTORE DATABASE; Regional Data Isolation Have to set a replication policy
14 ODBCS - Installation Download software from Unzip the 'opc_install.zip' file on the ODA server. It will extract 2 files tmp]$ unzip opc_installer.zip Archive: opc_installer.zip inflating: opc_install.jar inflating: opc_readme.txt 3. Install the software $ java -jar opc_install.jar -serviceName Storage -identityDomain ViscTech -opcId -opcPass 'mypass*%' -walletDir $ORACLE_HOME/dbs/opc_wallet -libDir $ORACLE_HOME/lib -libPlatform linux64 Oracle Database Cloud Backup Module Install Tool, build Oracle Database Cloud Backup Module credentials are valid. Oracle Database Cloud Backup Module wallet created in directory /u01/app/oracle/product/ /dbhome_1/dbs/opc_wallet. Oracle Database Cloud Backup Module initialization file /u01/app/oracle/product/ /dbhome_1/dbs/opcproddb1.ora created. Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip. Downloaded bytes in 11 Regional Data Isolation Have to set a replication policy Chicago and Ashburn, Virginia What about list, report , backup advisor functions??? Backup to disk then cloud ???
15 Installation Oracle Cloud Backup ModuleThe installation of the OCBM does the following: Creates the configuration file under $ORACLE_HOME/dbs. Installs the library file (libopc.so). Creates the auto-login Wallet using the Cloud Service credentials. obiwan> cat /u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcorcl.ora OPC_HOST=https://storage.us2.oraclecloud.com/v1/Storage-viscosityna OPC_WALLET='LOCATION=file:/u01/app/oracle/product/12.1.0/dbhome_1/dbs/opc_wallet CREDENTIAL_ALIAS=storage_opc' $ ls $ORACLE_HOME/dbs/opc_wallet/* /u01/app/oracle/product/12.1.0/dbhome_1/dbs/opc_wallet/cwallet.sso $ ls $ORACLE_HOME/lib/libopc.so /u01/app/oracle/product/12.1.0/dbhome_1/lib/libopc.so Parameters set in the OPC configuration ($ORACLE_HOME/dbs/opcSID.ora) file OPC_HOST – HTTPS end point OPC_WALLET - Wallet location OPC_PROXY – Proxy OPC_CONTAINER – Container name OPC_CHUNK_SIZE – Default 20MB (specify in bytes) libopc.so User specified library locaIon. SBT library which enables backup to Oracle Cloud which does REST calls to the cloud opc.ora $ORACLE_HOME/dbs ConfiguraIon informaIon stored – like REST endpoint, wallet informaIon, custom container etc. cwallet.sso User specified wallet locaIon Oracle wallet which securely stores backup service credenIals. This is used implicitly to authenIcate against Oracle cloud during RMAN backups and restore operaIons.
16 Recovery Manager Configurationrun { configure retention policy to recovery window of 30 days; configure channel device type 'sbt_tape' MAXPIECESIZE 2G FORMAT 'VCE_%d_%U' PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcVCE.ora)'; configure encryption for database on; configure device type 'sbt_tape' parallelism 128 backup type to backupset; configure backup optimization on; configure compression algorithm ’MEDIUM' as of release 'default' optimize for load true; configure default device type to sbt_tape; } Parallelism is driven by host CPU power, Internet connection, and Test , Test , Test Compression and Parallelism
17 Recovery Manager - Backup$ cat rman_backup.ksh rman target / <
18 RMAN Backup to Oracle Cloud BackupIf encryption is not enabled, RMAN backups to Oracle Cloud will fail with the following message: ORA-27030: skgfwrt: sbtwrite2 returned error ORA-19511: Error received from media manager layer, error text: KBHS-01602: backup piece 06q9ddqb_1_1 is not encrypted
19 RMAN> list backup summary; using target database control file instead of recovery catalog List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag B 0 A SBT_TAPE 05-SEP YES ONPREM DB TO CLOUD 2 B 0 A SBT_TAPE 05-SEP YES ONPREM DB TO CLOUD 3 B 0 A SBT_TAPE 05-SEP YES ONPREM DB TO CLOUD 4 B 0 A SBT_TAPE 05-SEP YES ONPREM DB TO CLOUD 5 B 0 A SBT_TAPE 05-SEP YES ONPREM DB TO CLOUD 6 B 0 A SBT_TAPE 05-SEP YES ONPREM DB TO CLOUD 7 B A A SBT_TAPE 05-SEP YES ONPREM ARC TO CLOUD 8 B F A SBT_TAPE 05-SEP NO ONPREM CTL TO CLOUD 9 B 1 A DISK 17-SEP YES LOCALDISK ONPREM DB 10 B 1 A DISK 17-SEP YES LOCALDISK ONPREM DB 11 B 1 A DISK 17-SEP YES LOCALDISK ONPREM DB 12 B 1 A DISK 17-SEP YES LOCALDISK ONPREM DB 13 B 1 A DISK 17-SEP YES LOCALDISK ONPREM DB 14 B 1 A DISK 17-SEP YES LOCALDISK ONPREM DB 15 B A A DISK 17-SEP YES TAG T B A A DISK 17-SEP YES TAG T B A A DISK 17-SEP YES TAG T B F A DISK 17-SEP NO LOCALDISK ONPREM CTL 19 B 1 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 20 B 1 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 21 B 1 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 22 B 1 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 23 B 1 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 24 B 1 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 25 B 0 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 26 B 0 A SBT_TAPE 17-SEP YES ONPREM DB TO CLOUD 27 B A A SBT_TAPE 17-SEP YES ONPREM ARC TO CLOUD 28 B F A SBT_TAPE 17-SEP NO ONPREM CTL TO CLOUD
20 Recovery Manager Restore ControlFileset decryption identified by oracle; Run { allocate channel t1 type 'sbt_tape' PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcorcl.ora)'; set dbid= ; restore controlfile from autobackup; release channel t1; }
21 Recovery Manager Restore Databaseset decryption identified by oracle; run { allocate channel t1 type 'sbt_tape' PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcorcl.ora)'; allocate channel t2 type 'sbt_tape' PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcorcl.ora)'; allocate channel t3 type 'sbt_tape' PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcorcl.ora)'; restore database; recover database; release channel t1; release channel t2; release channel t3; } Regional Data Isolation Have to set a replication policy Chicago and Ashburn, Virginia What about list, report , backup advisor functions??? Backup to disk then cloud ???
22 Backup & Recovery to OPCSome Best Practices: Weekly Full Daily Incremental Archive to Oracle Storage Cloud Use multiple RMAN channels for higher parallelism Use multi-section backups BACKUP DEVICE TYPE SBT DATABASE SECTION SIZE 1g; Compression for cloud backups Recommends using MEDIUM Use the RMAN Fast Incremental Backup feature (based on Block Change Tracking) One Backup Option could be: Back up to disk (FRA) then to the cloud Backup directly to the cloud Note: RMAN cannot perform duplexed backups to the Oracle Cloud and disk/ tape at the same time Have heard of folks doing Forever incremental updates to OPC Have heard of folks setting parallelism to hundreds
23 Oracle Database Backup Service – Full OEM Control
24 Common Issues RMAN> backup datafile 9; Starting backup at 16-FEB-17 using target database control file instead of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-03002: failure of backup command at 04/01/ :57:39 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27023: skgfqsbi: media manager protocol error ORA-19511: Error received from media manager layer, error text: KBHS-01404: See trace file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/sbtio_8655_ log for details KBHS-00700: HTTP response error 'No Content’ Storage container needs to be created before issuing OPC backup using following commands 1) To get Authentication token: curl -v -H GET -H 'X-Storage-User:
25 Debugging and Tracing Add the _OPC_TRACE_LEVEL=100 parameter to the opcSID.ora configuration file to enable tracing (set to 0 to disable) allocate channel ch1 device type sbt parms 'SBT_LIBRARY=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/OPC/lib/libopc.so,ENV=(OPC_PFILE=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/opcPRM112.ora,_OPC_TRACE_LEVEL=100)'; This adds trace data to the sbtio.log file. Review RMAN log and the sbtio.log from the same execution. set encryption on identified by 'password' only; RUN { backup device type sbt as compressed backupset incremental level 0 database; } SID OUTPUT 5296 RMAN-03002: failure of backup plus archivelog command at 02/05/ :39:22 5296 ORA-19506: failed to create sequential file, name="u9qt4gtq_1_1", parms="" 5296 ORA-27028: skgfqcre: sbtbackup returned error 5296 ORA-19511: Error received from media manager layer, error text: 5296 KBHS-00715: HTTP error occurred 'oracle-error' 5296 KBHS-00712: ORA received from local HTTP service PUT: https://myIdentityDomain.storage.oraclecloud.com/v1/Storage-myIdentityDomain/oracle-data-storageo-1/?x-SessionId=201BCDC244F827B2E F0196&x-ReqTime= %2014%3a53%3a03.624&x-ReqCnt=2&x-SbtApi=sbtinit2&x-SbtVersion= &x-System=Linux%20x86%2064-bit&x-SystemId=13&x-Node=oel6-em&x-User=oracle&x-LicMaxSessions=0&format=xml&x-SbtOp=CreateBucket Status => 403 Reason => Forbidden ReqId => tx71bf36017a5b4deda58b5-0055fd774aga Access was denied to this resource.Forbidden
26 General Info Most corporations do not allow the Database servers to directly connect to the outside internet Use HTTP Proxy Server. Specify -proxyHost and -proxyPort along with optional -proxyId and -proxyPass parameters What is the difference between metered and unmetered subscription models? Unmetered is a subscription per month. Metered model is available as part of Oracle Database Cloud Service under controlled availability and you burn down the pre-paid subscription based on GB of usage. PUT: https://myIdentityDomain.storage.oraclecloud.com/v1/Storage-myIdentityDomain/oracle-data-storageo-1/?x-SessionId=201BCDC244F827B2E F0196&x-ReqTime= %2014%3a53%3a03.624&x-ReqCnt=2&x-SbtApi=sbtinit2&x-SbtVersion= &x-System=Linux%20x86%2064-bit&x-SystemId=13&x-Node=oel6-em&x-User=oracle&x-LicMaxSessions=0&format=xml&x-SbtOp=CreateBucket Status => 403 Reason => Forbidden ReqId => tx71bf36017a5b4deda58b5-0055fd774aga Access was denied to this resource.Forbidden
27 Oracle Database Backup Service Support Matrix10gR2, 11g, 12c(EE, SE, SE1) Operations Systems (64bit only) Linux, Solaris x86 64, SPARC, Windows, AIX, HP UX, zLinux RMAN Compression HIGH, MEDIUM, BASIC, LOW RMAN Encryption Password, TDE, Dual mode Oracle Database Backup Service - FAQ (Doc ID ) * Standard Editions require a patch for the bug Can I backup Oracle Database Standard Edition databases? Yes. All SE/SE1/SE2 databases are supported. However, you would have to apply Patch 'CANNOT DO BACKUPS WITH ORACLE PUBLIC CLOUD SBT LIBRARY IN STANDARD EDITION' before you can perform backups. That patch allows RMAN encryption to be performed on a standard edition database. Please note that all the backup related restrictions - such as single channel etc. still applies to the standard edition. For Windows platform, refer to the support matrix in the previous question. For additional details, refer to the MOS note
28 Database Backup Cloud Pricing – As of August 2016 https://cloud.oracle.com/en_US/database_backup?tabID= Cloud Product Non-Metered Pricing Database Backup Cloud Pricing $33.00 / TB / Month * ASO Encrypted Backups * RMAN Compression Metered Pricing $ GB per Month (1TB = $26.40/Month) Up to 1TB $ GB per Month ($24.20 / Month) >5000 TB Data Transfer Rates < 1GB Free 1 GB to 9.99 TB .12 per GB per month 1TB = $120 per month Next 40TB .09 per GB / month Next 100TB .07 per GB / month Next 350 TB … .05 per GB / month The more you use, cheaper it gets PUT, COPY, POST or LIST requests: 1,000 Requests / Month = $0.005 GET and all other requests: 10,000 Requests / Month = $0.004 What truly separates Oracle apart from the competition? ASO and Compression
29 DBaaS – Backup and Recovery ConfigurationCloud Storage and Local Storage – 30 days in cloud 7 days local Cloud only – 30 days None What’s new in 2016 before OOW: Create Cloud Storage Container Checkbox
30 Additional Storage for DBaaS & IaaS
31 Oracle Cloud Storage - ArchiveCustomers can use Archive containers to store data that won't be accessed for a while or that will be accessed infrequently. It is ideally suited for data sets such as corporate financial records, medical and pharmaceutical archives, cultural preservation content, insurance records and digital film masters. CloudBerry Explorer provides a sleak user interface to Cloud Archive Storage, allowing easy movement of data form local folder to Cloud Archive An Archive container is a container for which the X-Storage-Class metadata field is set to Archive. curl -v -X PUT -H 'X-Auth-Token: token’ -H 'X-Storage-Class: Archive' https://storage.us2.oraclecloud.com/v1/Storage-IdentityDomain/Container_Name
32 Archive Storage Createcurl -v -X PUT -H "X-Auth-Token: AUTH_tk23be53ac28c3e443de38367f87643eb9" -H "X-Storage-Class: Archive" https://foo.storage.oraclecloud.com/v1/Storage-myIdentityDomain/myFirstArchiveContainer Upload curl -v -X PUT -H "X-Auth-Token: AUTH_tk23be53ac28c3e443de38367f87643eb9" -T myfile https:// foo.storage.oraclecloud.com/v1/Storage-myIdentityDomain/myFirstArchiveContainer/myObject Status curl -v -X HEAD -H "X-Auth-Token: AUTH_tk23be53ac28c3e443de38367f87643eb9" https:// foo.storage.oraclecloud.com /v1/Storage-myIdentityDomain/myFirstArchiveContainer/myObject Restore curl -v -X POST -H "X-Auth-Token: AUTH_tk23be53ac28c3e443de38367f87643eb9" https:// foo.storage.oraclecloud.com /v0/Storage-myIdentityDomain/myFirstArchiveContainer/myObject?restore Status / Tracking curl -v -X GET -H "X-Auth-Token: AUTH_tk23be53ac28c3e443de38367f87643eb9" https:// foo.storage.oraclecloud.com /v0/Storage-myIdentityDomain/myFirstArchiveContainer?jobs&jobid=a75c8bbf53224a88738e68d6628acd83a4b300e4 Download curl -v -X GET -H "X-Auth-Token: AUTH_tk23be53ac28c3e443de38367f87643eb9" -o myObject1 https://foo.storage.oraclecloud.com/v1/Storage-myIdentityDomain /myFirstArchiveContainer/myObject Up to 4 hours to restore, then you can download. This is just like a tape retrieval from library. You submit a job to retrieve, the library will restore There’s three status: archived : Indicates that the object is archived restored : Indicates that the object is restored in-progress : Indicates that restoration of the object is in progress
33 Storage Containers – As of August 2016 https://cloud. oracleCloud Product Non-Metered Pricing Storage Cloud Service $30.00 / TB / Month Storage Cloud Software Appliance Free Metered Pricing $0.024 GB per Month (1TB = $24/Month) Up to 1TB $0.022 GB per Month >5000 TB Want to show you Oracle Pricing versus Amazon Pricing
34 Oracle Cloud – Archive Storage (Aug 2016)1 TB / Month = $1 Archive Small Reads and Writes = .05 per 1000 requests + outbound traffic Data Transfer (Outbound) per Month Price Metric Minimum First Gigabyte/month FREE GB / Month None Next TB/month $0.12 GB / Month None Next 40 TB/month $0.09 GB / Month None Next 100 TB/month $0.07 GB / Month None Next 350 TB/month $0.05 GB / Month None Over 500 TB/month Contact Sales GB / Month None +Need to look at Outbound traffic pricing
35 Oracle Storage Cloud Software Appliance - OSCSAInstall on-premise via VM Appliance offered free of charge. No licenses are required. Only need Oracle Storage Cloud Service account to store/ retrieve data Connect on-premises applications to Oracle Storage Cloud Service Designed for Un-structured datasets Provides POSIX compliant NFS interface - Near local NAS performance through data caching Think of it as a legitimate Dropbox Data security with granular TLS encryption and Data integrity via checksum verification Oracle Storage Cloud Software Appliance stores all uploaded files first in an upload buffer on the local disk. The files are then uploaded asynchronously to Oracle Storage Cloud Service. If the appliance or its host stops running for any reason, then the pending upload operations resume automatically when the appliance starts running again. You can configure the cache to suit your workload. Set the maximum number of files that can be cached and also the maximum cache size (in bytes).
36 Storage Cloud Software ApplianceOracle Storage Cloud Software Appliance is easy to set up and use. Install it on any host and start the appliance. Then, create local filesystems and map them to any of your containers in Oracle Storage Cloud Service. That's it! To upload data to a container, simply copy the data over to the local filesystem. The appliance transparently caches the data, and uploads it to Oracle Storage Cloud Service. create multiple filesystems and connect each filesystem to a container in a different Oracle Storage Cloud Service account. You can store all of your data in one filesystem or distribute it across several filesystems.
37 OSCSA Installation oscsa]# ./oscsa-install.sh -a Checking that docker is installed and using the correct version Pass found docker version Docker version , build 57bf6fd WARNING: Usage of loopback devices is strongly discouraged for production use. Either use `--storage-opt dm.thinpooldev` or use `--storage-opt dm.no_warn_on_loop_devices=true` to suppress this warning. ************************************* Checking host prerequisites Detected linux operating system Checking kernel version Pass kernel version el7uek.x86_64 found Checking NFS version Pass found NFS version 4 All prerequisites have been met Begin install -h for help -a for installation
38 OSCSA Installation Installing to destination /opt/oscsa_gateway/Previous install detected, checking version OSCSA version is already installed. Are you sure you want reinstall? (Y | N) Y Stopping OSCSA Copied install scripts Copied OSCSA image Starting configuration script Enter the mount location for data cache /OPCcache/data Enter the mount location for meta data /OPCcache/meta Enter the mount location for log file information /OPCcache/log Enter the docker network mode (host or bridge), Hit
39 Managing the ApplianceStart Oracle Storage Cloud Software Appliance oscsa up Stop Oracle Storage Cloud Software Appli oscsa down View the latest logs oscsa log View details and how to access the management console oscsa info Configure Oracle Storage Cloud Software Appliance to use a proxy server to connect to OPC oscsa configure proxy [http_proxy_server https_proxy_server] Configure Oracle Storage Cloud Software Appliance to use SSL to access the management console oscsa configure ssl true Determine the version of Oracle Storage Cloud Software Appliance oscsa version Allocate memory for Oracle Storage Cloud Software Appliance in the appliance host oscsa configure memory memory_in_GB View help for the available commands: oscsa help
40 Storage Cloud Software Appliance Tips for 1st timersOracle Linux ships with UEK 3.8 rpm -e kernel-uek el7uek.x86_64 rpm -e kernel-uek-firmware el7uek.noarch Storage Cloud Software Appliance has a UEL 4+ requirement Must upgrade to UEK 4.1 yum install kernel-uek * Will pull in the kernel UEK firmware RPM Requires Oracle Linux 7 New learning curve for old timers Not Red Hat 7 but OL 7 with UEK Requires Docker New technology for old timers Do not modify or maintain OSCSA container with curl REST API Will cause inconsistency --> not recoverable Some Best Practices 1. Start with a read cache setting that is 50% of the size of the local storage volume 2. Provision a volume that can accommodate the local cache and ingest new files (upload buffer) without ever becoming more than 80% full 3. Multiple disks (hard disk drives or solid state drives) in a RAID10 4. Enable read-ahead on the volume. 5. Ensure that the number of objects stored in an appliance filesystem doesn’t exceed one million (1,000,000) 6. bin-pack or zip small files before writing them to the appliance. 7. However, for optimal performance, ensure that each filesystem is hosted on a dedicated appliance If you virtualize the OSCSA, follow VMware Best Practices as if it was a database server
41 Login to the Storage Cloud Software Appliance https://orabkups:32769/login1 2
42 Login to the Storage Cloud Software Appliance https://orabkups:32769/login1 3 2
43 Create a FS to Sync to OPC5 6 3 4
44 OPC Container as a NFS Mount# mount -t nfs -o vers=4,port=32770 orabkups:/docs /docs Name of the Appliance host
45 Summary - Storage ContainersReview the various Cloud options – There’s a solution for Common storage, Archive and Database Backup storage What truly separates Oracle apart from the competition? ASO and Compression The big value differentiator is between Oracle Cloud and AWS/Azure is $/GB Visit cloud.oracle.com for latest news and cloud.oracle.com/storage?tabname=PricingInfo for Pricing info Want to show you Oracle Pricing versus Amazon Pricing Especially for Archive
46