Go to main content
1/40
Contents
List of Examples
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New in Oracle Automatic Storage Management?
Oracle Automatic Storage Management 11
g
Release 2 (11.2.0.3) New Features
Oracle Automatic Storage Management 11
g
Release 2 (11.2.0.2) New Features
Oracle Automatic Storage Management 11
g
Release 2 (11.2.0.1) New Features
Oracle Automatic Storage Management 11
g
Release 1 (11.1) New Features
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 and Dismounting 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 Oracle ASM Instances
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
Connecting To and Starting Up an Oracle ASM Instance
Starting Up an Oracle ASM instance with an Incorrect SPFILE Path
About Mounting Disk Groups at Startup
About Restricted Mode
Shutting Down an Oracle ASM Instance
Upgrading an Oracle ASM Instance in an Oracle Restart Configuration with Oracle Universal Installer
Upgrading an Oracle ASM Instance from 11.1 to 11.2 in an Oracle Restart Configuration with Oracle Universal Installer
Upgrading an Oracle ASM Instance from 11.2.0.x to 11.2.0.3 in an Oracle Restart Configuration with Oracle Universal Installer
Downgrading an Oracle ASM Instance in an Oracle Restart Configuration
Out of Place Upgrades
Configuring Oracle Grid Infrastructure with the Configuration Wizard
Active Session History Sampling for Oracle ASM
Using Oracle ASM Rolling Upgrade
Patching Oracle ASM Instances in Oracle RAC Environments
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
Managing Volumes in a Disk Group
Adding Disks to a Disk Group
Adding Disks to a Disk Group with SQL Statements
Dropping Disks from Disk Groups
Intelligent Data Placement
Resizing Disks in Disk Groups
Undropping Disks in Disk Groups
Manually Rebalancing Disk Groups
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
Mirroring, Redundancy, and Failure Group Options
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
Setting 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
About Oracle ACFS and External Tables on Windows
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
Oracle ACFS Security
Oracle ACFS Encryption
Oracle ACFS Replication
Oracle ACFS Tagging
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 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
Managing Oracle ASM Users with Oracle Enterprise Manager
Managing Disk Groups with Oracle Enterprise Manager
Creating Disk Groups
Adding Disks to Disk Groups
Bringing Disks Online and Offline
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 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
Creating 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
Managing Security and Encryption for 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 Oracle ASM Instances
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 Oracle ACFS Systems
Creating an Oracle ACFS File System
Accessing an Oracle ACFS File System on a Different Node in the Cluster
Managing Oracle ACFS Snapshots
Securing Oracle ACFS File Systems
Encrypting Oracle ACFS File Systems
Tagging Oracle ACFS File Systems
Replicating Oracle ACFS File Systems
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 the Solaris Environment
fsck
mkfs
mount
umount/umountall
Oracle ACFS Command-line Tools for the AIX Environment
fsck
mkfs
mount
umount/umountall
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 Tagging
acfsutil tag info
acfsutil tag set
acfsutil tag unset
Oracle ACFS Command-Line Tools for Replication
acfsutil repl bg
acfsutil repl compare
acfsutil repl info
acfsutil repl init
acfsutil repl pause
acfsutil repl resume
acfsutil repl sync
acfsutil repl terminate
acfsutil repl trace
acfsutil repl update
Oracle ACFS Command-Line Tools for Security
acfsutil sec admin add
acfsutil sec admin password
acfsutil sec admin remove
acfsutil sec batch
acfsutil sec disable
acfsutil sec enable
acfsutil sec info
acfsutil sec info file
acfsutil sec init
acfsutil sec load
acfsutil sec prepare
acfsutil sec realm add
acfsutil sec realm clone
acfsutil sec realm create
acfsutil sec realm delete
acfsutil sec realm destroy
acfsutil sec rule clone
acfsutil sec rule create
acfsutil sec rule destroy
acfsutil sec rule edit
acfsutil sec ruleset clone
acfsutil sec ruleset create
acfsutil sec ruleset destroy
acfsutil sec ruleset edit
acfsutil sec save
Oracle ACFS Command-Line Tools for Encryption
acfsutil encr info
acfsutil encr init
acfsutil encr off
acfsutil encr on
acfsutil encr rekey
acfsutil encr set
Oracle ACFS Command-Line Utilities for Multiple Environments
acfsdbg
acfsutil info file
acfsutil info fs
acfsutil info id
acfsutil registry
acfsutil rmfs
acfsutil size
acfsutil snap create
acfsutil snap delete
acfsutil snap info
acfsutil tune
advmutil canonical
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
Scripting on this page enhances content navigation, but does not change the content in any way.