Corporate PPT Template - PowerPoint PPT Presentation

Loading...

PPT – Corporate PPT Template PowerPoint presentation | free to download - id: 62775d-ODA1Y



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Corporate PPT Template

Description:

Title: Corporate PPT Template Last modified by: user Created Date: 11/6/1996 7:19:12 PM Document presentation format: On-screen Show Company: Oracle Corporation – PowerPoint PPT presentation

Number of Views:101
Avg rating:3.0/5.0
Slides: 32
Provided by: gavinsoor5
Learn more at: http://gavinsoorma.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Corporate PPT Template


1
Extending Automatic Storage Management to Manage
ALL DataOracle Database 11g Release 2
Ara Shakian Principal Product Manager
2
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into
any contract. It is not a commitment to deliver
any material, code, or functionality, and should
not be relied upon in making purchasing
decisions.The development, release, and timing
of any features or functionality described for
Oracles products remains at the sole discretion
of Oracle.
3
Table of Contents
  • Storage management challenges
  • ASM Overview
  • ASM in 11gR2 takes it the next level
  • What is it
  • How does it work
  • How do I manage it
  • Benefits
  • How do I get from here to ASM
  • ASM reference customers

4
Challenges of Managing Data Explosion
  • Lack of a single optimal solution for all data
  • Lack of automation to reduce complexity
  • Managing multiple software layers
  • Complexity of managing performance
  • Eliminating hot spots
  • Multi-vendor support logistics and finger
    pointing
  • Reducing storage Total Cost of Ownership

5
ASM Is Most Popular Storage Manager
  • De-facto standard for RAC and grid deployments,
    gt65
  • De-facto standard for VLDB deployments
  • Large and growing adoption for single instance
    deployments, gt20
  • Thousands of customers using ASM
  • One of the most popular features in the database

6
ASM is Storage Management Platform of Choice
  • An optimal storage management solution
    fordatabase and general purpose files
  • Simplifies and automates storage management
  • Integrated cluster and single node framework
  • Storage pooling with easy provisioning
  • Optimal performance by default
  • Best availability and scalability
  • Lowest TCO
  • Consolidates and eliminates waste
  • No additional cost
  • Manages ALL data

ASM Disk Group
11.2
Lowers the cost of storage management
7
Dynamic Rebalancing
  • Simple provisioning
  • Add, drop or resize
  • Benefits
  • On-line capacity management
  • Eliminates manual I/O tuning
  • Maintain optimal performance
  • Storage migration on line

Disk Group
8
Enables Storage Consolidation Clustered Pool of
Storage
Local Area Network
  • Shared storage across several databases
  • RAC and Single Instance
  • Benefits
  • Simplified and Centralized management
  • Higher storage utilization
  • Higher performance

RAC ASM
RDBMS ASM
RDBMS ASM
ERP
CRM
FIN
HR
ERP Database
HR Database
CRM Database
FIN Database
ASM Disk Group
9
Striping, Mirroring and Performance
  • Striping designed to meet
  • RDBMS I/O characteristics
  • General purpose files
  • Flexible file-based mirroring
  • External, Normal and High
  • Optimal performance
  • No tuning

ASM
Non-ASM
Percentage relative to Baseline (TPS)
Time
10
Why You Should Care
  • Reduced complexity thru automation
  • No I/O tuning, reshuffling data files
  • Simplified solution stack
  • No finger pointing, 3rd party LVM/FS
  • Increases utilization and database and
    application uptime
  • No down-time for storage provisioning or
    migration
  • Managing storage pool vs. islands
  • Single vendor cross-platform integrated solution
  • Bundled and tested as one solution
  • Same cross platform tools to install, configure
    and manage
  • No additional cost!

11
Taking It To The Next LevelWith ASM in 11gR2
12
Oracle Grid Infrastructure(ASM Oracle
Clusterware)
  • ASM and Oracle Clusterware integrated and
    installed in a single Grid Infrastructure home
  • Integrated installation, configuration and
    upgrade
  • Installed using Oracle Universal Installer (OUI)
  • Not a part of database install
  • Option to minimally configure ASM and ACFS
  • Automate creation of Oracle DB Homes on ACFS

13
ASM Configuration Assistant (ASMCA)
  • One tool to initialize manage Disk
    Groups Dynamic Volumes ACFS file
    systems
  • Manage ASM before db install
  • Upgrade previous versions of ASM to the current
    version (11g R2)

14
Extending ASM to Manage ALL Data
3rd Party FS
Application
Database RAC
Automatic Storage Management (ASM)
ACFS Snapshot
ASM Instance Managing Oracle DB Files
ASM Cluster Single Node File System (ACFS)
General Purpose Files
Database Files
ASM Disk Group
Dynamic Volumes
DB Datafiles
DB Datafiles
Database files
OCR Voting files
15
What is ASM Dynamic Volume Manager
  • A new cluster (and single host) volume management
    service
  • Standard disk device interface to clients
  • Loadable kernel driver
  • Dynamic Volume is a volume file created in an ASM
    disk group (new file type asmvol)
  • An OS device file is created automatically when a
    dynamic volume is created
  • Managed by SQL/ASMCMD and EM

OS
/dev/asm/vol1-123
ASM DG
DATA/vol1
16
What is ASM Cluster File System (ACFS)
  • General purpose scalable file system
  • Journaling, extent based
  • Single node and cluster
  • POSIX, X/OPEN file system solution for UNIX/Linux
  • Windows file system solution for Windows
    platforms
  • Accessible through NAS protocols (NFS, CIFS)
  • Leverages ASM technology for volume mgt
  • Integrated with Oracle Clusterware for cluster
    support
  • Multi OS platform (Linux and Windows at initial
    release)
  • Integrated with Oracle system mgt tools
  • Oracle installation and configuration
  • Enterprise Manager and ASM Storage mgt tools
  • Native OS File System Management tools

17
What are ACFS Snapshots
  • Dynamic, fast, space efficient, point in time
    read-only copies of ACFS file system files
  • Captures ASM FS file block/extent updates
  • An enabler for
  • On-line, disk-based, file backup model using
    snapshots
  • Individual file recoveries
  • Up to 64 snapshot images per ASM file system
  • Policy based snapshots
  • Schedule snapshots on an interval basis every
    5 seconds, every 30 minutes, daily,
  • Create an ACFS snapshots
  • acfsutil snap create snap_name mountp

18
Leveraging the Power of ASM
ACFS File System /usr1
  • Even distribution of data
  • Dynamic provisioning
  • Dynamic volumes and ACFS FS may be resized
    leveraging ASM file resize features
  • asmcmd volresize dga vol1 -s 50G
  • Can also use Enterprise Manager for
    management and threshold alerts

ACFS file A ACFS file B
Mirrored Mirrored
Linux /dev/asm/vol1 Win \\.\asm_dgname_volnam
e
DATA/dga/vol1
3
Primary ASM File Extent
Mirrored ASM file Extents
19
Managing the Dymanic Volumes and ACFS File
SystemIs Simple And Flexible
  • Native Linux, UNIX, and Windows OS file system
    commands and extensions
  • acfsutil platform independent commands
  • ASM Configuration Assistant (ASMCA)
  • Enterprise Manager

20
An Example Creating an ACFS File System
mkfs -t acfs -b 4k /dev/asm/volume1-62
Create fs on ASM volume su - root mount -t
acfs /dev/asm/volume1-62 /tmp/images su
oracle_usr acfsutil registry -a
/dev/asm/volume1-62 /tmp/images mount t acfs
o all none none Mount everything in the
registry cd /tmp/images cp /home/my_images .
21
ACFS Use Cases
  • Oracle Home
  • Shared or node-local
  • Not Grid Infrastructure home
  • External files
  • Application binaries
  • Not an OS boot FS

22
Managing Oracle Database FilesASM Core
Enhancements
23
ASM 11g Release 2 New Features for Database
Files
  • All files on ASM
  • Oracle Cluster Registry, Voting Disk and SPFILE
  • Tunable Performance
  • Intelligent Data Placement (IDP)
  • Improved Management
  • Full Featured ASMCMD
  • ASM File Access Control
  • ASM Disk Group Rename
  • Datafile to Disk Mapping
  • Installation Configuration mgt
  • ASM Install Configuration Assistant (ASMCA)

24
OCR and Voting Disk on ASM
  • OCR is a regular ASM file
  • A new ASM file type
  • Voting Disk
  • Stored in selected ASM disks
  • crsctl used to specify a disk group for Voting
    disks
  • ASM auto creates1/3/5 Voting Disks based on
    Ext/Normal/High redundancy on Failure Groups
  • Quorum failure group
  • ASM determines redundancy for OCR and Voting Disk
    based on disk group redundancy level
  • ASM SPFILE is also supported on ASM now

25
Intelligent Data Placement (IDP)
  • Placement of files on high performance regions of
    disk
  • 50 performance difference from outer to inner
    tracks
  • Classify or mark an ASM file to be HOT/COLD
  • Alter diskgroup dgname modify file xxx
    attributes HOT/COLD or based on a templates at
    creation time
  • Rebalance to migrate the file to HOT/COLD IDP
    region
  • IDP regions are dynamic
  • New VASMFILE recording IO stats
  • The IDP feature better leveraged when ASM disks
    are whole disks

Hot Files
Disk Platter
Cold Files
26
Complete ASMCMD FunctionalityA complete API for
the system admin
  • Extending ASMCMD to manage
  • ASM instance (startup/shutdown, init.ora, .)
  • Disk group, disk and failure group (create,
    mount, add, drop, )
  • Attribute (list, set)
  • User/Group (add user, change password, )
  • Template (list, add, alter drop)
  • Iostat and df
  • lsof list files that are open by ASM lsod list
    disks that are open by ASM
  • Dynamic Volume

27
Other Features
  • ASM File Access Control (ACL)
  • Introducing 3 classes of permissions
  • owner, group, and other
  • ASM Disk Group Rename
  • Oracle File Mapping support (OFM)
  • View mapping of datafiles to physical devices
  • 4k sector size disk I/O support
  • Possible values are 512b or 4096b (4k)

28
In Summary
29
One Integrated Solution for ALL Data
ACFS Snapshot
Un-structured Data
ASM Cluster FS Dynamic Volumes
ASM Database files
Structured Data
Oracle Database RAC
Oracle Clusterware
Cross PlatformLinux, Windows, Solaris,HP-UX, AIX
30
Some ASM Reference Customers In Production
31
(No Transcript)
About PowerShow.com