Embed Size (px)
Citation preview
DBA Monthly August Ausgabe
Business Unit Database
Oracle Deutschland B.V. & Co KG Sebastian Solbach
Beginn um 14:00
Die Audioübertragung erfolgt über Ihre PC-Lautsprecher
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
07. Juli: Oracle Private Cloud Appliance
• Oracle VM basierende Appliance + ZFS Storage
– Trusted Partition für Lizenzierung (DB / MW)
– Cloud Services mit Enterprise Manager
– Unterstützung OVM Templates für schnelles Deployment
• Oracle Website https://www.oracle.com/servers/private-cloud-appliance/index.html
• Oracle Technology Network: http://www.oracle.com/technetwork/server-storage/private-cloud-
appliance/overview/index.html
Neuer Name der Virtual Compute Appliance (OVCA)
4
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
09. Juli: Oracle Virtual Box 5.0 / 21. July OVM 3.3.3
• Virtual Box 5.0
– Festplattenverschlüsselung, USB 3.0, Drag & Drop
• Virtual Box 4.3.30 / 4.2.32 https://www.virtualbox.org/
• Oracle VM 3.3.3
– Neues OVS Image & Neues OVM Manager Image
• https://blogs.oracle.com/virtualization/entry/oracle_vm_3_3_3
• https://linux.oracle.com
• Refresh / Redesign zu http://public-yum.oracle.com
Virtualisierungsupdate im DBA Monthly
5
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
14. Juli: Neue Version In-Memory Advisor
• Analysiert die Datenbank Last in ≥ 11.2.0.3
– Schätzt Verbesserung durch Einsatz von 12c In-Memory
– Empfiehlt Tabellen für den In-Memory Bereich
– Berechnet den In-Memory Verbrauch für diese Objekte
• Verbesserungen:
– Multitenant Support, Single Page Report
• Aktualisiertes In-Memory Whitepaper http://www.oracle.com/technetwork/database/manageability/inmemory-advisor-
2412222.html
• MOS Note: Oracle Database In-Memory Advisor (Doc ID 1965343.1) https://support.oracle.com/epmos/faces/DocumentDisplay?id=1965343.1
6
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
15. Juli: Patch Tag @Oracle
• Oracle Database - Overview of Database Patch Delivery Methods (Doc ID 1962125.1)
– CPU/SPU, PSU, Bundle Patch, GI PSU Patch, w/o OJVM
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1962125.1
• Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)
• GI & Datenbank PSU 12.1.0.2.4 (20996835 / 21150782)
• GI & Datenbank PSU 11.2.0.4.7 (20996923 / 21150864)
• 12.1.0.2 Bundle Patch 10 for Engineered Systems and DB In-Memory (Jul 2015) (21188742)
• Oracle Database, CRS, ASM, Networking and EM Agent Patches for Microsoft Platforms (Doc ID 161549.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?id=756671.1
• Oracle JDK 8 Update 51
http://www.oracle.com/technetwork/topics/security/cpujul2015-2367936.html
7
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
16. Juli: Platinum Service ZDLRA
• Integrierte Backup Lösung für alle Oracle Datenbanken
– Zero Data Loss Sicherung
– Geringe Backup Auswirkung auf Produktion
– Wiederherstellung zu jedem Zeitpunkt
– Enterprise Manager 12c Cloud Control Integration
https://www.oracle.com/engineered-systems/zero-data-loss-recovery-
appliance/index.html
• Jetzt mit Platinum Support Services • http://www.oracle.com/goto/platinumservices
Zero Data Loss Recovery Appliance
8
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
23. Juli: Press Release SAP & 12c In-Memory
• SAP Produkte basierend auf SAP Netweaver 7.x
• Oracle Datenbank 12c
• Single Instance & Oracle Real Application Clusters
• Ohne Änderungen
• Details: SAP Note 2178980 http://service.sap.com/sap/support/notes/2178980
• Oracle Press Release https://www.oracle.com/corporate/pressrelease/sap-certifies-dbim-072315.html
Vollständige Unterstützung
9
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
27. Juli: Oracle Public Cloud News
• Java Cloud Services
– WebLogic Server in der Cloud (VM) 11g oder 12c, VM Größe definierbar
– Self-Managing (Patching, Scaling, Backup)
– Optional: Coherence
https://cloud.oracle.com/java
• File & Document Services
– Dokument & Daten + Collaboration auf Dokumenten, Content Management
– Desktop Sync / Mobile Sync / Versioning
– Verschlüsselung & spezifische Kontrolle
https://cloud.oracle.com/documents
Java & Documents Cloud Services frei verfügbar
10
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
04. August: Oracle Public Cloud News
• Oracle Database Public Cloud Services
– Standard Edition One, Enterprise Edition (no Database Options), Enterprise Edition High Performance (includes most Database Options and Enterprise Manager packs), or Enterprise Edition Extreme Performance (includes all Database Options and Enterprise Manager packs)
– Noch unter CA: Multitenant, Exadata
https://cloud.oracle.com/database
• Oracle Database Backup Service
– $ pro GB (jederzeit Erweiterbar)
– Verschlüsselung, Compression (Optional) & spezifische Kontrolle
https://cloud.oracle.com/database_backup
Database Cloud Backup & Schema Service frei verfügbar
11
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Termine
• 14. August: DOAG Webinar: DB Monitoring – http://www.doag.org/termine/termine.php?tid=492808
• 1. & 3. September 14:00 – 16:00 Uhr: Produkt Management (EM Mughees Minhas): DB Performance mit Diag, Tuning, RAT und SPA (1.9. München / 3.9. Berlin) – mailto:[email protected]
• 25-29. Oktober: Oracle Openworld San Francisco – https://www.oracle.com/openworld/index.html
• 17-20. November: DOAG Konferenz – http://www.doag.org/de/events/konferenzen/doag-2015.html
• Links zu Events: – http://tinyurl.com/oraclebudb / http://www.doag.org
DOAG, Oracle Events in Ihrer Nähe, Internationale Events
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
#apexsummer15
• Erfolgreich abgeschlossen mit über 300 Teilnehmern
• Alles über APEX 5.0
– Page Designer, Universal Theme, SQL und PL/SQL, Migration, Interactive Reports, Plug-Ins, Sample Applications und mehr …
• Von den deutschsprachigen Community-Experten
– Peter Raganitsch, Niels de Bruijn, Oliver Lemm, Denes Kubicek, Tobias Arnhold, Dietmar Aust, Christian Rokitta, Carsten Czarski, Jürgen Schuster
http://tinyurl.com/orclapexsummerschool
• Aufzeichnungen auf Youtube: https://www.youtube.com/channel/UC_x68EhK-AJMAQYbOeoINQw
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
#12cjetzt
• 7 Webinare: 11. August - 27. Oktober: Di. 14:00 Uhr
• Alles über 12c & wie man dorthin gelangt
Upgrade, Testen, Multitenancy, Downtime…
• Interaktives Q&A Portal
• Von den deutschsprachigen Community-Experten
• Berichte / Erfahrungen von Partnern und Kunden
• http://tinyurl.com/12cjetzt
Oracle Database 12c. Jetzt.
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
#12cjetzt - Symposium
• 15. Oktober 2015: 08:30 Uhr - 17:00 Uhr
• Hyatt Regency Köln
• Agenda & Anmeldung
• Über #12cjetzt Website http://tinyurl.com/12cjetzt
• oder direkt: https://eventreg.oracle.com/profile/web/index.cfm?PKWebId=0x24536715ee
Treffen Sie das 12c Team
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Aktuelle Software Release und Patchstände
• Datenbank 12.1.0.2/11.2.0.4 (Doc ID 161818.1) https://blogs.oracle.com/UPGRADE/entry/premier_support_for_oracle_111
• Exadata (Doc ID 888828.1)
– Neuer Exadata Deployment Assistant (OEDA) v15.198
– Exadata Storage Server 12c release 12.1.2.1.2
– Neuer „DB Patch for Engineered Systems and Database In-memory” 12.1.0.2.10
• ODA 12.1.2.3.0 (Doc ID 888888.1)
Database, Exadata, ODA, Enterprise Manager, SQL Developer, OraChk
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Aktuelle Software Release und Patchstände
• Datenbank Patch Sets (Doc ID 756671.1)
– 12.1.0.2.4/11.2.0.4.7 (Jul 2015) Database Patch Set Update (DB PSU)
– Database Bundle Patch 12.1.0.2.10
– Windows (Doc ID 161549.1) : 11.2.0.4.17 / 12.1.0.2.7
• Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5)
– Aufstellung Bundle Patches für Agent & OMS Doc ID 1900943.1
• SQLcl Early Adopter / SQL Developer 4.1.1.19.59 (29. Juni) http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads
• ORAchk 12.1.0.2.4 - Health Checks Oracle Stack (Doc ID 1268927.2)
Database, Exadata, ODA, Enterprise Manager, SQL Developer, OraChk
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Aktuelle Software Release und Patchstände
• Oracle Linux:
– OL 5.11 (UEK 2) / OL 6.7 (UEK 3) / OL 7.1 (UEK 3)
• Oracle VM:
– 3.3.3
http://public-yum.oracle.com
• Virtual Box – 5.0 / 4.3.30
Virtual Box, Oracle VM, Oracle Linux
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
gDBClone Database
• Perl Skript zum:
– Klonen von Datenbanken • Von ASM nach ACFS
• Remote oder Lokal
– Erzeugen von DB-Snapshots (lokal)
– Löschen von DBs
http://www.oracle.com/technetwork/indexes/samplecode/gdbclone-download-
2295388.html
Snapshot Management Script
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
• Remote zu Lokal (Clone) • Lokal zu Lokal
23
gDBClone
ASM/FS ASM
ASM/FS ACFS
ASM/FS ACFS
ACFS SNAP
SNAP SNAP
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
gDBClone
24
# ./gDBClone
Usage:
gDBClone clone -sdbname <source DB name>
-sdbhost <source DB Host SCAN name> | -sbckloc '<backup>'
-tdbname <Target Database Name> -acfs <acfs mount point>
[ -sdbport <Source DB SCAN Listener Port> ]
[ -tdbport <Target DB SCAN Listener Port> ]
[ -syspw <Source DB SYSDBA Password> ] [-racmod <db type> ]
gDBClone snap -sdbname <source DB name> -tdbname <Target Database Name>
[ -sdbport <Source DB SCAN Listener Port> ]
[ -tdbport <Target DB SCAN Listener Port> ]
[ -syspw <Source DB SYSDBA Password> ] [-racmod <db type> ]
gDBClone listdb [ -tree ] | [ -verbose ]
gDBClone deldb -tdbname <database name> [ -force ]
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
RMAN Backup vs. Snapshot
25
6,17
38,35
47,23
59,23
2,23 2,15 2,2 2,43 0
10
20
30
40
50
60
70
5 Gb 25 Gb 35 Gb 45 Gb
Clone Creation Time and DB Size
RMAN Snapshot
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
gDBClone Beispiel
clone: Lokal – Lokal von ASM auf ACFS ASM/FS ACFS
# ./gDBClone clone -sdbname ssdb -sdbhost bumucsvm1-scan -tdbname sclone -acfs
/u01/app/oracle/oradata
2015-06-15 23:16:57: I Checking source host bumucsvm1-scan...
2015-06-15 23:16:57: I Getting host info...
2015-06-15 23:16:57: I Starting.....
2015-06-15 23:16:57: I Validating environment.....
Enter the source ssdb SYSDBA password:
2015-06-15 23:17:02: I Checking SCAN listener bumucsvm1-scan:1521...
2015-06-16 23:32:29: I Successfully created clone "SCLONE" database
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
Neuigkeiten: Announcements, Referenzen etc.
Termine
Release Stand, Patchsets
Feature des Monats
Web 2.0
1
2
3
4
5
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Web 2.0 - Aktuelles
• Blog Update – http://dbakevlar.com/2015/07/zero-data-loss-recovery-appliance-with-em12c/
• Zero Data Loss Appliance
– https://blogs.oracle.com/oem/entry/new_enterprise_manager_release_allows
• Enterprise Manager & die Hybrid Cloud
– https://blogs.oracle.com/UPGRADE/entry/premier_support_for_oracle_111
• Artikel über den Support Status der Oracle Datenbank (11.1,11.2,12.1)
– https://blogs.oracle.com/virtualization/entry/oracle_vm_3_3_3
• OVM Update / Aktuelles zu OVM
Blog Update
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Web 2.0 - Aktuelles
• Whitepaper: Desaster Recovery to Oracle Cloud – http://www.oracle.com/technetwork/database/availability/dr-to-oracle-cloud-
2615770.pdf
• MOS Note: ASMFD (ASM Filter Driver) Support on OS Platforms (Certification Matrix) – https://support.oracle.com/epmos/faces/DocumentDisplay?id=2034681.1
• Twitter – #DB12c, #EM12c, #plsql, #db_inmemory, #DBaaS, #12cjetzt, #apexsummer15
Links, Twitter
Copyright © 2015, Oracle and/or its affiliates. All rights reserved. |
Nächster Oracle DBA Monthly 02. September 2015 – 14:00 Uhr
tinyurl.com/oradba-monthly
Nächster Oracle Developer Monthly 21. August 2015 – 11:00 Uhr
tinyurl.com/oradev-monthly
Fragen und Diskussionen auf Twitter
#oradbamonthly [email protected] Blog: http://blogs.oracle.com/dbacommunity_deutsch Twitter: @oraclebudb, @s2solbach Alle Events auf einen Blick: tinyurl.com/oraclebudb
