Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Database Storage?

• New Storage Features for Oracle Database 11g Release 2 (11.2)
• New Storage Features for Oracle Database 11g Release 1 (11.1)

1 Introduction to Oracle Automatic Storage Management

• Overview of Oracle Automatic Storage Management
• Understanding Oracle ASM Concepts
  • About Oracle ASM Instances
  • About Oracle ASM Disk Groups
  • About Mirroring and Failure Groups
  • About Oracle ASM Disks
    • Allocation Units
  • About Oracle ASM Files
    • Extents
    • Oracle ASM Striping
    • File Templates
• Understanding Oracle ASM Disk Group Administration
  • About Discovering Disks
  • About Mounting Disk Groups
  • About Adding and Dropping Disks
  • About Online Storage Reconfigurations and Dynamic Rebalancing

2 Considerations for Oracle ASM Storage

• Storage Resources for Disk Groups
• Oracle ASM and Multipathing
• Recommendations for Storage Preparation

3 Administering Oracle ASM Instances

• Operating With Different Releases of Oracle ASM and Database Instances Simultaneously
• Configuring Initialization Parameters for an Oracle ASM Instance
  • Initialization Parameter Files for an Oracle ASM Instance
  • Backing Up, Copying, and Moving an Oracle ASM Initialization Parameter File
  • Setting Oracle ASM Initialization Parameters
    • Automatic Memory Management for Oracle ASM
  • Oracle ASM Parameter Setting Recommendations
    • ASM_DISKGROUPS
    • ASM_DISKSTRING
    • ASM_POWER_LIMIT
    • ASM_PREFERRED_READ_FAILURE_GROUPS
    • DB_CACHE_SIZE
    • DIAGNOSTIC_DEST
    • INSTANCE_TYPE
    • LARGE_POOL_SIZE
    • PROCESSES
    • REMOTE_LOGIN_PASSWORDFILE
    • SHARED_POOL_SIZE
  • Setting Database Initialization Parameters for Use with Oracle ASM
• Managing Oracle ASM Instances
  • Administering Oracle ASM Instances with Server Control Utility
  • Using Oracle Restart
  • Starting Up an Oracle ASM Instance
    • About Mounting Disk Groups at Startup
    • About Restricted Mode
  • Shutting Down an Oracle ASM Instance
  • Upgrading an Oracle ASM Instance With Oracle Universal Installer
  • Downgrading an Oracle ASM Instance
  • Active Session History Sampling for Oracle ASM
• Using Oracle ASM Rolling Upgrade
• Patching Oracle ASM Instances
• Authentication for Accessing Oracle ASM Instances
  • About Privileges for Oracle ASM
    • Using One Operating System Group for Oracle ASM Users
    • Using Separate Operating System Groups for Oracle ASM Users
    • The SYSASM Privilege for Administering Oracle ASM
    • The SYSDBA Privilege for Managing Oracle ASM Components
  • Creating Users with the SYSASM Privilege
  • Operating System Authentication for Oracle ASM
  • Password File Authentication for Oracle ASM
• Migrating a Database to Use Oracle ASM
  • Using Oracle Enterprise Manager to Migrate Databases to Oracle ASM
  • Using Oracle Recovery Manager to Migrate Databases to Oracle ASM
  • Best Practices White Papers on Migrating to Oracle ASM

4 Administering Oracle ASM Disk Groups

• Disk Group Attributes
• Creating Disk Groups
  • Using the CREATE DISKGROUP SQL Statement
  • Example: Creating a Disk Group
  • Creating Disk Groups for a New Oracle Installation
  • Specifying the Allocation Unit Size
  • Specifying the Sector Size for Drives
  • Oracle Cluster Registry and Voting Files in Oracle ASM Disk Groups
• Altering Disk Groups
  • Adding Disks to a Disk Group
    • Example: Adding Disks to a Disk Group
  • Adding Volumes to Disk Groups
  • Dropping Disks from Disk Groups
    • Example: Dropping Disks from Disk Groups
  • Intelligent Data Placement
  • Resizing Disks in Disk Groups
    • Example: Resizing Disks in Disk Groups
  • Undropping Disks in Disk Groups
    • Example: Undropping Disks in Disk Groups
  • Manually Rebalancing Disk Groups
    • Example: Manually Rebalancing a Disk Group
  • Tuning Rebalance Operations
• Oracle ASM Disk Discovery
  • How A Disk is Discovered
  • Disk Discovery Rules
  • Improving Disk Discovery Time
• Managing Capacity in Disk Groups
  • Negative Values of USABLE_FILE_MB
• Oracle ASM Mirroring and Disk Group Redundancy
  • Oracle ASM Mirroring and Failure Groups
    • Oracle ASM Failure Groups
    • How Oracle ASM Manages Disk Failures
    • Guidelines for Using Failure Groups
    • Failure Group Frequently Asked Questions
  • Oracle ASM Recovery from Read and Write I/O Errors
  • Oracle ASM Fast Mirror Resync
  • Preferred Read Failure Groups
    • Configuring and Administering Preferred Read Failure Groups
• Performance and Scalability Considerations for Disk Groups
  • Determining the Number of Disk Groups
  • Performance Characteristics When Grouping Disks
  • Oracle ASM Storage Limits
• Disk Group Compatibility
  • Overview of Disk Group Compatibility
  • Disk Group Compatibility Attributes
    • COMPATIBLE.ASM
    • COMPATIBLE.RDBMS
    • COMPATIBLE.ADVM
  • Setting Disk Group Compatibility Attributes
    • Valid Combinations of Compatibility Attribute Settings
    • Using CREATE DISKGROUP with Compatibility Attributes
    • Using ALTER DISKGROUP with Compatibility Attributes
    • Viewing Compatibility Attribute Settings
    • Features Enabled By Disk Group Compatibility Attribute Settings
    • Reverting Disk Group Compatibility
  • Considerations When Setting Disk Group Compatibility in Replicated Environments
• Managing Oracle ASM File Access Control for Disk Groups
  • About Oracle ASM File Access Control
  • Using SQL Statements to Set Disk Group Attributes for Oracle ASM File Access Control
  • Using SQL Statements to Manage Oracle ASM File Access Control
• Mounting and Dismounting Disk Groups
  • Mounting Disk Groups Using the FORCE Option
• Checking the Internal Consistency of Disk Group Metadata
• Dropping Disk Groups
• Renaming Disks Groups

5 Introduction to Oracle ACFS

• Overview of Oracle ACFS
• Understanding Oracle ACFS Concepts
  • About Oracle ACFS
  • About Oracle ACFS and Oracle Database Homes
  • About Oracle ASM Dynamic Volume Manager
  • About the Oracle ACFS Driver Model
  • About the Oracle ACFS Mount Model and Namespace
  • About the Oracle ACFS Mount Registry
  • About Oracle ACFS Snapshots
  • About Oracle ACFS and Backup and Restore
  • About Oracle ACFS Integration with Oracle ASM
• Understanding Oracle ACFS Administration
  • Oracle ACFS and File Access and Administration Security
  • Oracle ACFS and Grid Infrastructure Installation
  • Oracle ACFS and Grid Infrastructure Configuration
  • Clusterware Resources and Oracle ACFS Administration
  • Oracle ACFS and Dismount or Shutdown Operations
• Overview of Oracle ASM Dynamic Volume Manager

6 Using Views to Display Information

• Views Containing Oracle ASM Disk Group Information
  • Viewing Oracle ASM File Access Control Information
  • Viewing Disk Region Information
• Views Containing Oracle ACFS Information

7 Administering Oracle ASM Files, Directories, and Templates

• What Types of Files Does Oracle ASM Support?
• About Oracle ASM Filenames
  • Single File Creation Form
  • Multiple File Creation Form
  • Fully qualified File Name Form
  • Alias Oracle ASM Filename Forms
    • Creating a Tablespace in Oracle ASM: Using a Data File with an Alias Name
  • Alias Oracle ASM Filename with Template Form
  • Incomplete Oracle ASM Filename Form
  • Incomplete Oracle ASM Filename with Template Form
• Creating and Referencing Oracle ASM Files in the Database
  • Creating Oracle ASM Files Using a Default File Location for Disk Group Specification
  • Using Oracle ASM Filenames in SQL Statements
• Managing Alias Names for Oracle ASM Filenames
  • Adding an Alias Name for an Oracle ASM Filename
  • Renaming an Alias Name for an Oracle ASM Filename
  • Dropping an Alias Name for an Oracle ASM Filename
  • Dropping Files and Associated Aliases from a Disk Group
• Managing Disk Group Directories
  • Creating a New Directory
  • Renaming a Directory
  • Dropping a Directory
• Accessing Oracle ASM Files with the XML DB Virtual Folder
  • Inside /sys/asm
• Using DBMS_FILE Transfer Utility for Oracle ASM
• Managing Disk Group Templates
  • Template Attributes
  • Adding Templates to a Disk Group
  • Modifying a Disk Group Template
  • Dropping Templates from a Disk Group
  • Creating Tablespaces in Oracle ASM: Specifying Attributes with Templates

8 Performing Oracle ASM Data Migration With RMAN

• Overview of Oracle ASM Data Migration
  • Purpose of Oracle ASM Data Migration
  • Basic Concepts of Oracle ASM Data Migration
  • Basics Steps of Data Migration to Oracle ASM Using RMAN
• Preparing to Migrate the Database to Oracle ASM Using RMAN
• Migrating the Database to Oracle ASM Using RMAN
• Migrating a Database from Oracle ASM to Alternative Storage
• Moving Data Files Between Oracle ASM Disk Groups Using RMAN

9 Administering Oracle ASM with Oracle Enterprise Manager

• Oracle Automatic Storage Management Home Page
  • Accessing the Oracle ASM Home Page in Single-Instance Oracle Databases
  • Accessing the Oracle ASM Home Page in Oracle RAC Databases
• Configuring Oracle ASM Initialization Parameters with Oracle Enterprise Manager
  • Bringing Disks Online and Offline
• Managing Oracle ASM Users with Oracle Enterprise Manager
• Managing Disk Groups with Oracle Enterprise Manager
  • Creating Disk Groups
  • Adding Disks to Disk Groups
  • Dropping Disks from Disk Groups
  • Dropping Disk Groups
  • Monitoring Disk Group Usage
  • Mounting and Dismounting Disk Groups
  • Administering Advanced Disk Group Properties
    • Configuring Disk Group Compatibility Attributes
    • Configuring Disk Repair Time
    • Configuring Smart Scan Compatibility
    • Configuring File Access Control
• Managing Oracle ASM File Access Control with Oracle Enterprise Manager
• Managing Directories, Files, and Aliases with Oracle Enterprise Manager
• Managing Disk Group Templates with Oracle Enterprise Manager
• Monitoring Oracle ASM Performance with Oracle Enterprise Manager
  • Monitoring General Oracle ASM Performance
  • Checking Disk Group Integrity
• Backing Up Oracle ASM Files with Oracle Enterprise Manager
• Performing Bad Block Recovery with Oracle Enterprise Manager
• Migrating to Oracle ASM with Oracle Enterprise Manager
• Oracle ASM Support Workbench
• Oracle ASM: Oracle by Example Series

10 Administering Oracle ACFS With Oracle Enterprise Manager

• Managing Oracle ACFS with Oracle Enterprise Manager
  • Creating Oracle ACFS Volumes and File Systems
  • Viewing and Modifying Oracle ACFS Volumes and File Systems
• Managing Oracle ACFS Snapshots with Oracle Enterprise Manager

11 Oracle ASM Configuration Assistant

• Oracle ASM Configuration Assistant GUI Tool
  • Starting Oracle ASM Configuration Assistant
  • Managing Oracle ASM Instances With Oracle ASM Configuration Assistant
  • Upgrading an Oracle ASM Instance with Oracle ASM Configuration Assistant
  • Managing Disk Groups With Oracle ASM Configuration Assistant
  • Managing Oracle ADVM Volumes With Oracle ASM Configuration Assistant
  • Managing Oracle ACFS File Systems With Oracle ASM Configuration Assistant
  • Creating an Oracle ACFS File System for a Database Home
• Oracle ASM Configuration Assistant Command-Line Interface
  • Running ASMCA Command-Line
  • ASMCA Commands
    • Configure an Oracle ASM Instance
    • Upgrade an Oracle ASM Instance
    • Configure Parameters for an Oracle ASM Instance
    • Delete an Oracle ASM Instance
    • Create a Disk Group
    • Add a Disk to a Disk Group
    • Create a Volume
    • Create an Oracle ACFS File System

12 Oracle ASM Command-Line Utility

• About ASMCMD
  • Types of ASMCMD Commands
  • About Oracle ASM Files, Filenames, Directories, and Aliases
    • System-Generated Filename or Fully Qualified Filename
    • Directory
    • Alias
    • Absolute Path and Relative Path
    • Wildcard Characters
  • Preparing to Run ASMCMD
  • Running ASMCMD in Interactive Mode
    • Running ASMCMD Without Any Options
    • Specifying the Type of Connection
    • Specifying the Verbose Mode
    • Including the Current Directory in the ASMCMD Prompt
    • Displaying the ASMCMD Version Number
  • Running ASMCMD in Noninteractive Mode
  • Getting Help
• ASMCMD Instance Management Commands
  • dsget
  • dsset
  • lsct
  • lsop
  • lspwusr
  • orapwusr
  • shutdown
  • spbackup
  • spcopy
  • spget
  • spmove
  • spset
  • startup
• ASMCMD File Management Commands
  • cd
  • cp
  • du
  • find
  • ls
  • lsof
  • mkalias
  • mkdir
  • pwd
  • rm
  • rmalias
• ASMCMD Disk Group Management Commands
  • chdg
  • chkdg
  • dropdg
  • iostat
  • lsattr
  • lsdg
  • lsdsk
  • lsod
  • md_backup
  • md_restore
  • mkdg
  • mount
  • offline
  • online
  • rebal
  • remap
  • setattr
  • umount
• ASMCMD Template Management Commands
  • chtmpl
  • lstmpl
  • mktmpl
  • rmtmpl
• ASMCMD File Access Control Commands
  • chgrp
  • chmod
  • chown
  • groups
  • grpmod
  • lsgrp
  • lsusr
  • mkgrp
  • mkusr
  • passwd
  • rmgrp
  • rmusr
• ASMCMD Volume Management Commands
  • volcreate
  • voldelete
  • voldisable
  • volenable
  • volinfo
  • volresize
  • volset
  • volstat

13 Oracle ACFS Command-Line Tools

• Basic Steps to Manage an Oracle ACFS
  • Creating an Oracle ACFS File System
  • Accessing an Oracle ACFS File System on a Different Node in the Cluster
  • Managing Oracle ACFS Snapshots
  • Deregistering, Dismounting, and Disabling Volumes and Oracle ACFS File Systems
    • Deregistering an Oracle ACFS File System
    • Dismounting an Oracle ACFS File System
    • Disabling a Volume
  • Removing an Oracle ACFS File System and a Volume
• Oracle ACFS Command-line Tools for Linux and UNIX Environments
  • fsck
  • mkfs
  • mount
  • umount
• Oracle ACFS Command-line Tools for Windows Environments
  • acfschkdsk
  • acfsdismount
  • acfsformat
  • acfsmountvol
  • acfsutil detach
  • advmutil dismount
  • advmutil list
  • advmutil mount
• Oracle ACFS Command-Line Tools for All Environments
  • acfsdbg
  • acfsutil info
  • acfsutil registry
  • acfsutil rmfs
  • acfsutil size
  • acfsutil snap create
  • acfsutil snap delete
  • acfsutil tune
  • advmutil tune
  • advmutil volinfo

A Creating Database Files in Oracle ASM Using SQL*Plus

• Creating a Database that Uses Oracle ASM
  • Creating a Database that Uses Oracle ASM: Example
• Creating Tablespaces in Oracle ASM
• Creating Redo Logs in Oracle ASM
• Creating Control Files in Oracle ASM
  • Creating Control Files in Oracle ASM: Example 1
  • Creating Control Files in Oracle ASM: Example 2
• Creating Archive Log Files in Oracle ASM

B Oracle ACFS Advanced Topics

• Limits of Oracle ACFS
  • Oracle ACFS Disk Space Usage
  • Oracle ACFS Error Handling
  • Oracle ACFS and NFS
• Limits of Oracle ADVM
• Oracle ACFS Drivers Resource Management
• Oracle ACFS Registry Resource Management
• Oracle ACFS Individual File System Resource Management
• Oracle ACFS and Oracle Restart
• Understanding Oracle ACFS I/O Failure Console Messages

Glossary

Index