Download as PDF, PPTX
![Copyright © 2016 Oracle and/or its affiliates. All rights reserved. | Run the Installer [oracle@localhost OPC] unzip opc_installer.zip [oracle@localhost OPC] ls opc* opc_install.jar opc_readme.txt [oracle@localhost OPC]$ java -jar opc_install.jar -serviceName myService –identityDomain myDomain -opcid sridhar.ranganathan@oracle.com -opcPass ’myPassword' -libDir /home/oracle/OPC/lib -walletDir /home/oracle/OPC/wallet Oracle Database Cloud Backup Module Install Tool, build 2015-05-12 Oracle Database Cloud Backup Module credentials are valid. Oracle Database Cloud Backup Module wallet created in directory /home/oracle/OPC/wallet. Oracle Database Cloud Backup Module initialization file /u01/products/db/12.1/dbs/opcodbs.ora created. Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip. Downloaded 23169388 bytes in 152 seconds. Transfer rate was 152430 bytes/second. Download complete.](https://image.slidesharecdn.com/pplchoracledatabasebackupserviceclickthroughdemo-160305131118/75/Oracle-Database-Backup-Cloud-Service-14-2048.jpg)
![Copyright © 2016 Oracle and/or its affiliates. All rights reserved. | Simulate Physical Corruption (Accidental Deletion) [oracle@localhost odbs]$ ls -l total 1025880 -rw-r-----. 1 oracle users 10043392 Sep 13 11:04 control01.ctl -rw-r-----. 1 oracle users 52429312 Sep 13 11:02 redo01.log -rw-r-----. 1 oracle users 52429312 Sep 13 10:50 redo02.log -rw-r-----. 1 oracle users 293609472 Sep 13 11:01 sysaux01.dbf -rw-r-----. 1 oracle users 377495552 Sep 13 11:00 system01.dbf -rw-r-----. 1 oracle users 20979712 Sep 13 10:21 temp01.dbf -rw-r-----. 1 oracle users 256909312 Sep 13 11:01 undotbs01.dbf -rw-r-----. 1 oracle users 5251072 Sep 13 10:55 users01.dbf [oracle@localhost odbs]$ rm *.dbf [oracle@localhost odbs]$ ls -l total 112216 -rw-r-----. 1 oracle users 10043392 Sep 13 11:04 control01.ctl -rw-r-----. 1 oracle users 52429312 Sep 13 11:02 redo01.log -rw-r-----. 1 oracle users 52429312 Sep 13 10:50 redo02.log](https://image.slidesharecdn.com/pplchoracledatabasebackupserviceclickthroughdemo-160305131118/75/Oracle-Database-Backup-Cloud-Service-22-2048.jpg)
![Copyright © 2016 Oracle and/or its affiliates. All rights reserved. | Start the Database [oracle@localhost odbs]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 13 11:06:05 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2293880 bytes Variable Size 612372360 bytes Database Buffers 218103808 bytes Redo Buffers 2334720 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u01/products/oradata/odbs/system01.dbf'](https://image.slidesharecdn.com/pplchoracledatabasebackupserviceclickthroughdemo-160305131118/75/Oracle-Database-Backup-Cloud-Service-23-2048.jpg)
Uploaded byMarketingArrowECS_CZ
Oracle Database Backup Cloud Service
The document describes a 4 step demo of using Oracle's Database Backup Cloud Service: 1) Subscribe to the cloud service, 2) Install the backup module, 3) Configure RMAN backups, 4) Perform backups to the cloud, simulate data file deletion, restore and recover files from the cloud backup, and open the database. It includes screenshots and code snippets for configuring RMAN, performing backups, restoring and recovering files from the cloud backup service.
Oracle Database Backup Cloud Service
- 2. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Oracle Database Backup Cloud Service Simplify And Lower The Cost Of Protecting Oracle Databases Click-through Demo using CLI & Enterprise Manager Cloud Control 13c Jan’16 2
- 3. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Demo: Oracle Database Backup Service 4 Simple Steps 1. Subscribe 2. Install 3. Configure RMAN 4. Backup & Recovery
- 4. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Demo: Step #1 1. Subscribe 2. Install 3. Configure RMAN 4. Backup & Recovery • Subscribe Oracle Database Backup Service (or) • Sign-up for a Trial
- 5. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Option #1: Purchase Oracle Database Backup Service https://shop.oracle.com/
- 6. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Option #2: Sign-up for a Trial https://cloud.oracle.com/database_backup
- 7. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Option #2: Sign-up for a Trial – Contd. https://cloud.oracle.com/database_backup
- 8. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Option #2: Sign-up for a Trial – Non-Metered Contd..
- 9. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Option #2: Sign-up for a Trial – Non-Metered Contd.. After Submission, wait for the activation email. Then Activate the Service
- 10. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Add Users & Assign Roles • Add more users • Add Storage Administrator & Storage Read-Write Group roles • Use that account information during client side RMAN module installation
- 11. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Cloud Service Portal
- 12. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | 1. Subscribe 2. Install 3. Configure RMAN 4. Backup & Recovery • Download the Installer from OTN • Install the module Demo: Step #2
- 13. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Download Oracle Database Cloud Backup Module from OTN
- 14. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Run the Installer [oracle@localhost OPC] unzip opc_installer.zip [oracle@localhost OPC] ls opc* opc_install.jar opc_readme.txt [oracle@localhost OPC]$ java -jar opc_install.jar -serviceName myService –identityDomain myDomain -opcid sridhar.ranganathan@oracle.com -opcPass ’myPassword' -libDir /home/oracle/OPC/lib -walletDir /home/oracle/OPC/wallet Oracle Database Cloud Backup Module Install Tool, build 2015-05-12 Oracle Database Cloud Backup Module credentials are valid. Oracle Database Cloud Backup Module wallet created in directory /home/oracle/OPC/wallet. Oracle Database Cloud Backup Module initialization file /u01/products/db/12.1/dbs/opcodbs.ora created. Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip. Downloaded 23169388 bytes in 152 seconds. Transfer rate was 152430 bytes/second. Download complete.
- 15. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Demo: Step #3 1. Subscribe 2. Install 3. Configure RMAN 4. Backup & Recovery • Configure RMAN to use SBT Library, configure Parallelism etc.
- 16. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | RMAN Configuration $ rman target / Recovery Manager: Release 12.1.0.1.0 - Production on Sun Sep 13 09:41:08 2015 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: odbs (DBID=2636081010, open) RMAN>CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/home/oracle/OPC/lib/ libopc.so, ENV=(OPC_PFILE=/u01/products/db/12.1/dbs/opcodbs.ora)'; RMAN> CONFIGURE COMPRESSION ALGORITHM 'MEDIUM’; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET; RMAN> SHOW ALL;
- 17. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Demo: Step #4 1. Subscribe 2. Install 3. Configure RMAN 4. Backup & Recovery • Perform Backup to Oracle Cloud • Simulate accidental deletion of data files • Restore and recovery from Cloud • Open the database
- 18. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Perform RMAN Backups RMAN> SET ENCRYPTION ON IDENTIFIED BY 'abc123' ONLY; executing command: SET encryption RMAN> BACKUP DEVICE TYPE SBT AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG FORMAT '%d_%U'; Starting backup at 13-SEP-15 current log archived released channel: ORA_DISK_1 released channel: ORA_DISK_2 released channel: ORA_DISK_3 released channel: ORA_DISK_4 released channel: ORA_DISK_5 released channel: ORA_DISK_6 released channel: ORA_DISK_7 released channel: ORA_DISK_8 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=42 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=3.15.1.16
- 19. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Perform RMAN Backups Contd.. allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=42 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=3.15.1.16 allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: SID=56 device type=SBT_TAPE channel ORA_SBT_TAPE_2: Oracle Database Backup Service Library VER=3.15.1.16 allocated channel: ORA_SBT_TAPE_3 channel ORA_SBT_TAPE_3: SID=50 device type=SBT_TAPE channel ORA_SBT_TAPE_3: Oracle Database Backup Service Library VER=3.15.1.16 allocated channel: ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_4: SID=58 device type=SBT_TAPE channel ORA_SBT_TAPE_4: Oracle Database Backup Service Library VER=3.15.1.16 channel ORA_SBT_TAPE_1: starting compressed archived log backup set channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set input archived log thread=1 sequence=7 RECID=23 STAMP=890304044 channel ORA_SBT_TAPE_1: starting piece 1 at 13-SEP-15 channel ORA_SBT_TAPE_1: finished piece 1 at 13-SEP-15 piece handle=ODBSLAB_2gqh1thm_1_1 tag=TAG20150913T104054 comment=API Version 2.0,MMS Version 3.15.1.16
- 20. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Perform RMAN Backups Contd.. … Starting backup at 13-SEP-15 current log archived using channel ORA_SBT_TAPE_1 using channel ORA_SBT_TAPE_2 using channel ORA_SBT_TAPE_3 using channel ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_1: starting compressed archived log backup set channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set input archived log thread=1 sequence=8 RECID=24 STAMP=890304635 channel ORA_SBT_TAPE_1: starting piece 1 at 13-SEP-15 channel ORA_SBT_TAPE_1: finished piece 1 at 13-SEP-15 piece handle=ODBSLAB_2lqh1u3s_1_1 tag=TAG20150913T105035 comment=API Version 2.0,MMS Version 3.15.1.16 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:04:05 Finished backup at 13-SEP-15 Starting Control File and SPFILE Autobackup at 13-SEP-15 piece handle=c-2636081010-20150913-00 comment=API Version 2.0,MMS Version 3.15.1.16 Finished Control File and SPFILE Autobackup at 13-SEP-15
- 21. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Confirm Backup Information RMAN> LIST BACKUP; BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 48 Full 42.75M SBT_TAPE 00:01:35 13-SEP-15 BP Key: 48 Status: AVAILABLE Compressed: YES Tag: TAG20150913T104509 Handle: 2iqh1tpm_1_1 Media: myDomain.storage.oraclecloud.com/v1/myService-usoraclei List of Datafiles in backup set 48 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 2 Full 785064 13-SEP-15 /u01/products/oradata/odbslab/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 49 Full 59.00M SBT_TAPE 00:05:23 13-SEP-15 BP Key: 49 Status: AVAILABLE Compressed: YES Tag: TAG20150913T104509 Handle: 2hqh1tpm_1_1 Media: myDomain.storage.oraclecloud.com/v1/myService-usoraclei RMAN> RESTORE VALIDATE;
- 22. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Simulate Physical Corruption (Accidental Deletion) [oracle@localhost odbs]$ ls -l total 1025880 -rw-r-----. 1 oracle users 10043392 Sep 13 11:04 control01.ctl -rw-r-----. 1 oracle users 52429312 Sep 13 11:02 redo01.log -rw-r-----. 1 oracle users 52429312 Sep 13 10:50 redo02.log -rw-r-----. 1 oracle users 293609472 Sep 13 11:01 sysaux01.dbf -rw-r-----. 1 oracle users 377495552 Sep 13 11:00 system01.dbf -rw-r-----. 1 oracle users 20979712 Sep 13 10:21 temp01.dbf -rw-r-----. 1 oracle users 256909312 Sep 13 11:01 undotbs01.dbf -rw-r-----. 1 oracle users 5251072 Sep 13 10:55 users01.dbf [oracle@localhost odbs]$ rm *.dbf [oracle@localhost odbs]$ ls -l total 112216 -rw-r-----. 1 oracle users 10043392 Sep 13 11:04 control01.ctl -rw-r-----. 1 oracle users 52429312 Sep 13 11:02 redo01.log -rw-r-----. 1 oracle users 52429312 Sep 13 10:50 redo02.log
- 23. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Start the Database [oracle@localhost odbs]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 13 11:06:05 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2293880 bytes Variable Size 612372360 bytes Database Buffers 218103808 bytes Redo Buffers 2334720 bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u01/products/oradata/odbs/system01.dbf'
- 24. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Perform RMAN RESTORE RMAN> SET DECRYPTION IDENTIFIED BY 'abc123'; executing command: SET decryption using target database control file instead of recovery catalog RMAN> RESTORE DATABASE; Starting restore at 13-SEP-15 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=22 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=3.15.1.16 allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: SID=19 device type=SBT_TAPE channel ORA_SBT_TAPE_2: Oracle Database Backup Service Library VER=3.15.1.16 allocated channel: ORA_SBT_TAPE_3 channel ORA_SBT_TAPE_3: SID=23 device type=SBT_TAPE channel ORA_SBT_TAPE_3: Oracle Database Backup Service Library VER=3.15.1.16 allocated channel: ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_4: SID=24 device type=SBT_TAPE …
- 25. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Perform RMAN RESTORE Contd.. channel ORA_SBT_TAPE_1: starting datafile backup set restore channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_1: restoring datafile 00004 to /u01/products/oradata/odbs/users01.dbf channel ORA_SBT_TAPE_1: reading from backup piece 2kqh1tpm_1_1 channel ORA_SBT_TAPE_2: starting datafile backup set restore channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set channel ORA_SBT_TAPE_2: restoring datafile 00003 to /u01/products/oradata/odbs/undotbs01.dbf channel ORA_SBT_TAPE_4: restoring datafile 00001 to /u01/products/oradata/odbs/system01.dbf channel ORA_SBT_TAPE_4: reading from backup piece 2hqh1tpm_1_1 channel ORA_SBT_TAPE_1: piece handle=2kqh1tpm_1_1 tag=TAG20150913T104509 channel ORA_SBT_TAPE_1: restored backup piece 1 channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:15 channel ORA_SBT_TAPE_2: piece handle=2jqh1tpm_1_1 tag=TAG20150913T104509 channel ORA_SBT_TAPE_2: restored backup piece 1 … channel ORA_SBT_TAPE_4: piece handle=2hqh1tpm_1_1 tag=TAG20150913T104509 channel ORA_SBT_TAPE_4: restored backup piece 1 channel ORA_SBT_TAPE_4: restore complete, elapsed time: 00:06:05 Finished restore at 13-SEP-15
- 26. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Perform RMAN Recovery RMAN> RECOVER DATABASE; Starting recover at 13-SEP-15 using channel ORA_SBT_TAPE_1 using channel ORA_SBT_TAPE_2 using channel ORA_SBT_TAPE_3 using channel ORA_SBT_TAPE_4 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 using channel ORA_DISK_5 using channel ORA_DISK_6 using channel ORA_DISK_7 using channel ORA_DISK_8 starting media recovery media recovery complete, elapsed time: 00:01:12
- 27. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Open the Database RMAN> alter database open; Statement processed RMAN> select name, open_mode from v$database; NAME OPEN_MODE --------- -------------------- odbs READ WRITE RMAN> select name from v$datafile; NAME -------------------------------------------------------------------------------- /u01/products/oradata/odbs/system01.dbf /u01/products/oradata/odbs/sysaux01.dbf /u01/products/oradata/odbs/undotbs01.dbf /u01/products/oradata/odbs/users01.dbf ✔
- 28. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Enterprise Manager Cloud Control 13c • EM13c has Oracle Cloud as first class entity • Configure Backup Module • Configure RMAN backup settings • Perform backup & Recovery
- 29. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Configuring Cloud Backup for the Database
- 30. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Provide Cloud Credentials Provide Cloud Credentials
- 31. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Confirm and Submit
- 32. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Backup Settings: Choose Customized Option
- 33. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Choose the Type of Backup : Full or Incremental
- 34. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Setup Encryption Choose this for Password Based Encryption For TDE Based Encryption
- 35. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Choose Oracle Cloud as Destination New Oracle Cloud option
- 36. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Choose One Time or Schedule
- 37. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Choose the Parallelism: 2 or more Preferred RMAN Parallelism
- 38. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | RMAN Script Auto Generation RMAN Script Generated
- 39. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | One Time (On-Demand) Backup Job is Scheduled
- 40. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | RMAN Backup Progress can be Monitored RMAN Output
- 41. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Monitor Progress
- 42. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Backup Completed Status
- 43. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Automatic Scheduling – Weekly Full
- 44. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Automatic Scheduling Weekly Full
- 45. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Automatic Scheduling – Daily Incremental
- 46. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Automatic Scheduling – Daily Incremental
- 47. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Monitor the Storage Usage in the Cloud Service Dashboard
- 48. Copyright © 2016Oracle and/or its affiliates. All rights reserved. | Database Backup Service: DEMO Summary Easy to deploy Easy to Backup & Restore No new commands to learn Up and running in no time