Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

Dell PowerStore Importing External Storage to PowerStore Guide

Setting the Oracle ASM logical block size

Prerequisites

CAUTION:Avoid running anything below when Oracle is already installed. This procedure only applies when the Oracle database has not been created.
Determine whether you need to set the Oracle ASM logical block size before starting import. Check the logical and physical sector size on the Compellent SC LUN by running fdisk -l. The following is an example of the command output:
Disk /dev/mapper/36000d3100116f2000000000000001484: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 2097152 bytes / 2097152 bytes
The Sector size shown in the command output represents the logical and physical values. You do not need to run the following procedure when the physical sector size is 512 bytes. The physical sector size shown in the example is not supported by PowerStore and would need to be changed. Also note that the logical sector size needs to be 512 bytes.

About this task

Import to PowerStore from a Linux host running Oracle on a Compellent SC appliance is allowed only when the Oracle configuration, ASM or AFD, uses the logical sector size for ASM disk groups. Import of external storage to PowerStore does not support 4096 bytes sector size devices. It supports only 512 bytes sector size devices.

If you are planning to Import external storage to PowerStore from a Linux host running Oracle with ASM on Compellent SC storage and you need to set the Oracle ASM logical block size at the time of creating the database, use the following procedure before getting started with import.

Steps

  1. Depending on the Oracle configuration, do one of the following when you create the Oracle database:
    NOTE: PowerStore does not support import an existing database on Compellent SC storage that is created with ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false" or oracleafd_use_logical_block_size defined with a value of 0.
    • For an ASMLib configuration, set ORACLEASM_USE_LOGICAL_BLOCK_SIZE="true". Use the following standard oracleasm configure command to set the parameter to true: oracleasm configure -b. This setting allows Oracle ASM to use the logical sector size.
    • For an AFD configuration, create a file in the folder /sys/module/oracleafd/parameters by setting echo 1 > oracleafd_use_logical_block_size when you create the database. Make the setting permanent by creating a file in the folder /etc/modprobe.d, echo "options oracleafd oracleafd_use_logical_block_size=1" > oracleafd.conf
  2. Before starting import, ensure that the logical sector size is 512 bytes by verifying that the SQL output shows 512 bytes for all the disks in the database.

    SQL> select disk_number, mount_status, header_status, state, sector_size, path from v$asm_disk;


Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\