ASM using ASMLib and Raw Devices （for oracle 10g）【不错的
Home?Articles?10g? Here http://www.oracle-base.com/articles/10g/asm-using-asmlib-and-raw-devices.php ASM using ASMLib and Raw Devices Introduction Partition the Disks ASMLib Installation Raw Device Setup ASM Creation Database Creation Swit
| Home ? Articles ? 10g ? Here |
ASM using ASMLib and Raw Devices
- Introduction
- Partition the Disks
- ASMLib Installation
- Raw Device Setup
- ASM Creation
- Database Creation
- Switching from Raw Devices to ASMLib
- Switching from ASMLib to Raw Devices
- Performance Comparison
Related articles.
- Automatic Storage Management (ASM) in Oracle Database 10g
- Using NFS with ASM
- Automatic Storage Manager (ASM) Enhancements in Oracle Database 11g Release 1
- UDEV SCSI Rules Configuration for ASM in Oracle Linux 5 and 6
Introduction
Automatic Storage Management (ASM) simplifies administration of Oracle related files by allowing the administrator to reference disk groups rather than individual disks and files, which ASM manages internally. On Linux, ASM is capable of referencing disks as raw devices or by using the ASMLib software. This article presents the setup details for using either raw devices or ASMLib, as well as the procedures for converting between both methods.
The article assumes the operating system installation is complete, along with an Oracle software installation. The ASM instance shares the Oracle home with the database instance. If you plan on running multiple database instances on the server the ASM instance should be installed in a separate Oracle home.
Note: When running Oracle 10g Release 2 on RHEL 4 you should consider reading this article: Using Block Devices for Oracle 10g Release 2 in RHEL 4
Partition the Disks
Both ASMLib and raw devices require the candidate disks to be partitioned before they can be accessed. In this example, three 10Gig VMware virtual disks are to be used for the ASM storage. The following text shows the "/dev/sdb" disk being partitioned.
# ls sd* sda sda1 sda2 sdb sdc sdd # fdisk /dev/sdb Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only, until you decide to write them. After that, of course, the previous content won't be recoverable. The number of cylinders for this disk is set to 1305. There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with: 1) software that runs at boot time (e.g., old versions of LILO) 2) booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK) Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-1305, default 1): Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305): Using default value 1305 Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. #로그인 후 복사로그인 후 복사
The remaining disks ("/dev/sdc" and "/dev/sdd") must be partitioned in the same way.
ASMLib Installation
This step is only necessary if you want to use ASMLib to access the ASM disks.
Determine your kernel version using the following command as the root user.
# uname -r 2.6.9-34.ELsmp #로그인 후 복사로그인 후 복사
Download the ASMLib software from the OTN website, making sure you pick the version that matches your distribution, kernel and architecture. For this example I used CentOS 4.3, so the following packages were required.
- oracleasm-support-2.0.1-1.i386.rpm
- oracleasmlib-2.0.1-1.i386.rpm
- oracleasm-2.6.9-34.ELsmp-2.0.1-1.i686.rpm
Install the packages as the root user.
# rpm -Uvh oracleasm-support-2.0.1-1.i386.rpm \ oracleasmlib-2.0.1-1.i386.rpm \ oracleasm-2.6.9-34.ELsmp-2.0.1-1.i686.rpm Preparing... ########################################### [100%] 1:oracleasm-support ########################################### [ 33%] 2:oracleasm-2.6.9-34.ELsm########################################### [ 67%] 3:oracleasmlib ########################################### [100%] #로그인 후 복사로그인 후 복사
With the software installed, configure the ASM kernel module.
# /etc/init.d/oracleasm configure Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting <enter> without typing an answer will keep that current value. Ctrl-C will abort. Default user to own the driver interface []: oracle Default group to own the driver interface []: oinstall Start Oracle ASM library driver on boot (y/n) [n]: y Fix permissions of Oracle ASM disks on boot (y/n) [y]: Writing Oracle ASM library driver configuration: [ OK ] Creating /dev/oracleasm mount point: [ OK ] Loading module "oracleasm": [ OK ] Mounting ASMlib driver filesystem: [ OK ] Scanning system for ASM disks: [ OK ] #</enter>로그인 후 복사로그인 후 복사
Once the kernel module is loaded, stamp (or label) the partitions created earlier as ASM disks.
# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1 Marking disk "/dev/sdb1" as an ASM disk: [ OK ] # /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1 Marking disk "/dev/sdc1" as an ASM disk: [ OK ] # /etc/init.d/oracleasm createdisk VOL3 /dev/sdd1 Marking disk "/dev/sdd1" as an ASM disk: [ OK ] #로그인 후 복사로그인 후 복사
If this were a RAC installation, the disks would only be stamped by one node. The other nodes would just scan for the disks.
# /etc/init.d/oracleasm scandisks Scanning system for ASM disks: [ OK ] #로그인 후 복사로그인 후 복사
The stamped disks are listed as follows.
# /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 #로그인 후 복사로그인 후 복사
The disks are now ready to be used by ASM.
Raw Device Setup
This step is only necessary if you want ASM to access the disks as raw devices.
Edit the "/etc/sysconfig/rawdevices" file, adding the following lines.
/dev/raw/raw1 /dev/sdb1 /dev/raw/raw2 /dev/sdc1 /dev/raw/raw3 /dev/sdd1로그인 후 복사로그인 후 복사
Restart the rawdevices service using the following command.
service rawdevices restart로그인 후 복사로그인 후 복사
Run the following commands and add them the "/etc/rc.local" file.
chown oracle:oinstall /dev/raw/raw1 chown oracle:oinstall /dev/raw/raw2 chown oracle:oinstall /dev/raw/raw3 chmod 600 /dev/raw/raw1 chmod 600 /dev/raw/raw2 chmod 600 /dev/raw/raw3로그인 후 복사로그인 후 복사
The ASM raw device disks are now configured.
ASM Creation
Creation of the ASM instance is the same, regardless of the use of ASMLib or raw devices. When using ASMLib, the candidate disks are listed using the stamp associated with them, while the raw devices are listed using their device name.
To configure an ASM instance, start the Database Configuration Assistant by issuing the "dbca" command as the oracle user. On the "Welcome" screen, click the "Next" button.
Select the "Configure Automatic Storage Management" option, then click the "Next" Button.
If the Oracle Cluster Syncronization Service (CSS) is not currently running, a warning screen will be displayed. Follow the instructions and click the "OK" button. Once you've returned to the previous screen, click the "Next" button again.
The script gives the following output.
# /u01/app/oracle/product/10.2.0/db_1/bin/localconfig add /etc/oracle does not exist. Creating it now. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configuration for local CSS has been initialized Adding to inittab Startup will be queued to init within 90 seconds. Checking the status of new Oracle init process... Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. centos2 CSS is active on all nodes. Oracle CSS service is installed and running under init(1M) #로그인 후 복사로그인 후 복사
Enter a password for the ASM instance, then click the "Next" button.
On the confirmation screen, click the "OK" button.
Wait while the ASM instance is created.
Once the ASM instance is created, you are presented with the "ASM Disk Groups" screen. Click the "Create New" button.
On the "Create Disk Group" screen, enter Disk Group Name of "DATA" and select the required level of redundancy:
- External - ASM does not mirror the files. This option should only be used if your disks are already protected by some form of redundancy, like RAID.
- Normal - ASM performs two-way mirroring of all files.
- High - ASM performs three-way mirroring of all files.
In this example, the "High" redundancy is used. Select all three candidate disks and click the "OK" button. The following image shows how the candidate disks are displayed when using ASMLib.
When using raw devices, the candidate discs are listed using the devide names.
On the "ASM Disk Groups" screen. Click the "Finish" button.
Click the "Yes" button to perform another operation.
You are now ready to create a database instance using ASM.
Database Creation
Before continuing with the database creation, check the listener is up and the ASM instance has registered with it. Start the listener using the following command.
$ lsnrctl start LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2006 14:35:46 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.1.0 - Production Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener .log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(POR T=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 29-APR-2006 14:35:47 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listen er.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(PORT=1521))) The listener supports no services The command completed successfully $로그인 후 복사로그인 후 복사
The ASM instance is not registered, so we can force the registration by doing the following.
$ export ORACLE_SID=+ASM $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sat Apr 29 14:37:06 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> alter system register; System altered. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr oduction With the Partitioning, OLAP and Data Mining options $로그인 후 복사로그인 후 복사
Checking the status of the listener shows that the ASM instance is now registered.
$ lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2006 14:37:32 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 29-APR-2006 14:35:47 Uptime 0 days 0 hr. 1 min. 46 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listen er.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status BLOCKED, has 1 handler(s) for this service... Service "+ASM_XPT" has 1 instance(s). Instance "+ASM", status BLOCKED, has 1 handler(s) for this service... The command completed successfully $로그인 후 복사로그인 후 복사
Go back to the DBCA and create a custom database in the normal way, selecting the "Automatic Storage Management (ASM)" storage option.
Enter the ASM password if prompted, then click the "OK" button.
Select the "DATA" disk group, then clicking the "Next" button.
Accept the default "Oracle-Managed Files" database location by clicking the "Next" button.
Enable the "Flash Recovery Area" and Archiving, using the "+DATA" disk group for both.
Continue with the rest of the DBCA, selecting the required options along the way.
Switching from Raw Devices to ASMLib
Shutdown any databases using the ASM instance, but leave the ASM instance itself running. Connect to the running ASM instance.
$ export ORACLE_SID=+ASM $ sqlplus / as sysdba로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
Perform the ASMLib Installation, but stop prior to stamping
the ASM disk. If you attempt to stamp the disks using the createdisk command it will fail.
Alter the ASM disk discovery string to exclude the raw devices used previously, then shutdown the ASM instance.
SQL> ALTER SYSTEM SET asm_diskstring = 'ORCL:VOL*' SCOPE=SPFILE; System altered. SQL> SHUTDOWN IMMEDIATE; ASM diskgroups dismounted ASM instance shutdown SQL>로그인 후 복사로그인 후 복사
If you are planning to remove the raw device mappings (Raw Device Setup),
you could simply reset the ASM_DISKGROUP parameter.
SQL> ALTER SYSTEM RESET asm_diskstring SCOPE=SPFILE SID='*'; System altered. SQL>로그인 후 복사로그인 후 복사
At this point the disks will not be used by ASM because they are not stamped. As mentioned previously, the createdisk command used to stamp new disks would fail, so we must issue the renamedisk command as
the root user for each disk.
# /etc/init.d/oracleasm renamedisk /dev/sdb1 VOL1 Renaming disk "/dev/sdb1" to "VOL1": [ OK ] # /etc/init.d/oracleasm renamedisk /dev/sdc1 VOL2 Renaming disk "/dev/sdc1" to "VOL2": [ OK ] # /etc/init.d/oracleasm renamedisk /dev/sdd1 VOL3 Renaming disk "/dev/sdd1" to "VOL3": [ OK ] #로그인 후 복사로그인 후 복사
Notice, the stamp matches the discovery string set earlier. The ASM instance can now be started.
SQL> STARTUP ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL>로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
The ASM instance is now using ASMLib, rather than raw devices. All dependent databases can now be started.
Switching from ASMLib to Raw Devices
Shutdown any databases using the ASM instance, but leave the ASM instance itself running. Connect to the running ASM instance.
$ export ORACLE_SID=+ASM $ sqlplus / as sysdba로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
Alter the ASM disk discovery string to match the raw devices you plan to set up, then shutdown the ASM instance.
SQL> ALTER SYSTEM SET asm_diskstring = '/dev/raw/raw*' SCOPE=SPFILE; System altered. SQL> SHUTDOWN IMMEDIATE; ASM diskgroups dismounted ASM instance shutdown SQL>로그인 후 복사로그인 후 복사
Perform all the steps listed in the Raw Device Setup, then start the ASM instance.
SQL> STARTUP ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL>로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
The ASM instance is now using the disks as raw devices, rather than as ASMLib disks. All dependent databases can now be started.
Performance Comparison
Some documents suggests using ASMLib with Oracle 10g Release 2 gives superior disk performance, while others say it only reduces the time searching for candidate disks, and hence ASM startup time. I decided to compare the performance of the two methods myself to see if I could tell the difference.
My first thought was to perform a simple insert/update/delete test, so I created the following user and schema for the test in a database using and ASM instance using ASMLib.
export ORACLE_SID=DB10G sqlplus / as sysdba CREATE TABLESPACE test_ts; CREATE USER test_user IDENTIFIED BY test_user DEFAULT TABLESPACE test_ts QUOTA UNLIMITED ON test_ts; GRANT CONNECT, CREATE TABLE TO test_user; CONN test_user/test_user CREATE TABLE test_tab ( id NUMBER, data VARCHAR2(4000), CONSTRAINT test_tab_pk PRIMARY KEY (id) );로그인 후 복사로그인 후 복사
Then, as the test user, I ran the following code several times and calculated an average time for each operation.
SET SERVEROUTPUT ON DECLARE l_loops NUMBER := 1000; l_data VARCHAR2(32767) := RPAD('X', 4000, 'X'); l_start NUMBER; BEGIN l_start := DBMS_UTILITY.get_time; FOR i IN 1 .. l_loops LOOP INSERT INTO test_tab (id, data) VALUES (i, l_data); COMMIT; END LOOP; DBMS_OUTPUT.put_line('Inserts (' || l_loops || '): ' || (DBMS_UTILITY.get_time - l_start) || ' hsecs'); l_start := DBMS_UTILITY.get_time; FOR i IN 1 .. l_loops LOOP UPDATE test_tab SET data = l_data WHERE id = i; COMMIT; END LOOP; DBMS_OUTPUT.put_line('Updates (' || l_loops || '): ' || (DBMS_UTILITY.get_time - l_start) || ' hsecs'); l_start := DBMS_UTILITY.get_time; FOR i IN 1 .. l_loops LOOP DELETE FROM test_tab WHERE id = i; COMMIT; END LOOP; DBMS_OUTPUT.put_line('Deletes (' || l_loops || '): ' || (DBMS_UTILITY.get_time - l_start) || ' hsecs'); EXECUTE IMMEDIATE 'TRUNCATE TABLE test_tab'; END; /로그인 후 복사로그인 후 복사
The code is purposely inefficient, using a single statement and a commit within a loop for each operation. Remember, the ASM instance is using high redundancy, so each physical write operation is effectively done 3 times.
Once the tests on ASMLib were complete, I switched to using raw devices and repeated the tests. The average results for 1000 of each operation are listed below.
Operation ASMLib (hsecs) Raw Devices (hsecs) ============== ============== =================== Inserts (1000) 468 852 Updates (1000) 956 1287 Deletes (1000) 1281 1995로그인 후 복사로그인 후 복사
You can instantly see that the ASMLib results are better than those of the raw devices, but the testing is suspect for the following reasons:
- For each single run of the script, only 1000 operations of each type were performed. That equates to about 4M of data in the table when it is full. When you consider the use of the buffer cache, this is a pitiful amount of data. I originally intended to perform many more operations, but my disk was grinding so badly I thought better of it.
- The tests were performed using VMware virtual disks, so really all this work was being done on a single SATA disk. I can't be sure if these results aren't just an artifact of the setup.
- Although the average results look convincing, the raw data was so eratic I'm not convinced these results mean anything.
For these reasons, I decided not to continue to persue the performance tests, much to the delight of my hard drive. If I get access to a more realistic setup I will attempt some large scale tests and report the outcome.
For more information see:
- Installing ASMLib
- Migrating Raw Devices to ASMLib
- Automatic Storage Management (ASM) in Oracle Database 10g
- Oracle Database 10g Release 2 (10.2.0.1) RAC Installation On Linux (CentOS 4) Using VMware Server
- Configuring I/O for Raw Partitions
Hope this helps. Regards Tim...
Back to the Top.
- Introduction
- Partition the Disks
- ASMLib Installation
- Raw Device Setup
- ASM Creation
- Database Creation
- Switching from Raw Devices to ASMLib
- Switching from ASMLib to Raw Devices
- Performance Comparison
Related articles.
- Automatic Storage Management (ASM) in Oracle Database 10g
- Using NFS with ASM
- Automatic Storage Manager (ASM) Enhancements in Oracle Database 11g Release 1
- UDEV SCSI Rules Configuration for ASM in Oracle Linux 5 and 6
Introduction
Automatic Storage Management (ASM) simplifies administration of Oracle related files by allowing the administrator to reference disk groups rather than individual disks and files, which ASM manages internally. On Linux, ASM is capable of referencing disks as raw devices or by using the ASMLib software. This article presents the setup details for using either raw devices or ASMLib, as well as the procedures for converting between both methods.
The article assumes the operating system installation is complete, along with an Oracle software installation. The ASM instance shares the Oracle home with the database instance. If you plan on running multiple database instances on the server the ASM instance should be installed in a separate Oracle home.
Note: When running Oracle 10g Release 2 on RHEL 4 you should consider reading this article: Using Block Devices for Oracle 10g Release 2 in RHEL 4
Partition the Disks
Both ASMLib and raw devices require the candidate disks to be partitioned before they can be accessed. In this example, three 10Gig VMware virtual disks are to be used for the ASM storage. The following text shows the "/dev/sdb" disk being partitioned.
# ls sd* sda sda1 sda2 sdb sdc sdd # fdisk /dev/sdb Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only, until you decide to write them. After that, of course, the previous content won't be recoverable. The number of cylinders for this disk is set to 1305. There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with: 1) software that runs at boot time (e.g., old versions of LILO) 2) booting and partitioning software from other OSs (e.g., DOS FDISK, OS/2 FDISK) Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite) Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-1305, default 1): Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-1305, default 1305): Using default value 1305 Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. #로그인 후 복사로그인 후 복사
The remaining disks ("/dev/sdc" and "/dev/sdd") must be partitioned in the same way.
ASMLib Installation
This step is only necessary if you want to use ASMLib to access the ASM disks.
Determine your kernel version using the following command as the root user.
# uname -r 2.6.9-34.ELsmp #로그인 후 복사로그인 후 복사
Download the ASMLib software from the OTN website, making sure you pick the version that matches your distribution, kernel and architecture. For this example I used CentOS 4.3, so the following packages were required.
- oracleasm-support-2.0.1-1.i386.rpm
- oracleasmlib-2.0.1-1.i386.rpm
- oracleasm-2.6.9-34.ELsmp-2.0.1-1.i686.rpm
Install the packages as the root user.
# rpm -Uvh oracleasm-support-2.0.1-1.i386.rpm \ oracleasmlib-2.0.1-1.i386.rpm \ oracleasm-2.6.9-34.ELsmp-2.0.1-1.i686.rpm Preparing... ########################################### [100%] 1:oracleasm-support ########################################### [ 33%] 2:oracleasm-2.6.9-34.ELsm########################################### [ 67%] 3:oracleasmlib ########################################### [100%] #로그인 후 복사로그인 후 복사
With the software installed, configure the ASM kernel module.
# /etc/init.d/oracleasm configure Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting <enter> without typing an answer will keep that current value. Ctrl-C will abort. Default user to own the driver interface []: oracle Default group to own the driver interface []: oinstall Start Oracle ASM library driver on boot (y/n) [n]: y Fix permissions of Oracle ASM disks on boot (y/n) [y]: Writing Oracle ASM library driver configuration: [ OK ] Creating /dev/oracleasm mount point: [ OK ] Loading module "oracleasm": [ OK ] Mounting ASMlib driver filesystem: [ OK ] Scanning system for ASM disks: [ OK ] #</enter>로그인 후 복사로그인 후 복사
Once the kernel module is loaded, stamp (or label) the partitions created earlier as ASM disks.
# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1 Marking disk "/dev/sdb1" as an ASM disk: [ OK ] # /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1 Marking disk "/dev/sdc1" as an ASM disk: [ OK ] # /etc/init.d/oracleasm createdisk VOL3 /dev/sdd1 Marking disk "/dev/sdd1" as an ASM disk: [ OK ] #로그인 후 복사로그인 후 복사
If this were a RAC installation, the disks would only be stamped by one node. The other nodes would just scan for the disks.
# /etc/init.d/oracleasm scandisks Scanning system for ASM disks: [ OK ] #로그인 후 복사로그인 후 복사
The stamped disks are listed as follows.
# /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 #로그인 후 복사로그인 후 복사
The disks are now ready to be used by ASM.
Raw Device Setup
This step is only necessary if you want ASM to access the disks as raw devices.
Edit the "/etc/sysconfig/rawdevices" file, adding the following lines.
/dev/raw/raw1 /dev/sdb1 /dev/raw/raw2 /dev/sdc1 /dev/raw/raw3 /dev/sdd1로그인 후 복사로그인 후 복사
Restart the rawdevices service using the following command.
service rawdevices restart로그인 후 복사로그인 후 복사
Run the following commands and add them the "/etc/rc.local" file.
chown oracle:oinstall /dev/raw/raw1 chown oracle:oinstall /dev/raw/raw2 chown oracle:oinstall /dev/raw/raw3 chmod 600 /dev/raw/raw1 chmod 600 /dev/raw/raw2 chmod 600 /dev/raw/raw3로그인 후 복사로그인 후 복사
The ASM raw device disks are now configured.
ASM Creation
Creation of the ASM instance is the same, regardless of the use of ASMLib or raw devices. When using ASMLib, the candidate disks are listed using the stamp associated with them, while the raw devices are listed using their device name.
To configure an ASM instance, start the Database Configuration Assistant by issuing the "dbca" command as the oracle user. On the "Welcome" screen, click the "Next" button.
Select the "Configure Automatic Storage Management" option, then click the "Next" Button.
If the Oracle Cluster Syncronization Service (CSS) is not currently running, a warning screen will be displayed. Follow the instructions and click the "OK" button. Once you've returned to the previous screen, click the "Next" button again.
The script gives the following output.
# /u01/app/oracle/product/10.2.0/db_1/bin/localconfig add /etc/oracle does not exist. Creating it now. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. Configuration for local CSS has been initialized Adding to inittab Startup will be queued to init within 90 seconds. Checking the status of new Oracle init process... Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. centos2 CSS is active on all nodes. Oracle CSS service is installed and running under init(1M) #로그인 후 복사로그인 후 복사
Enter a password for the ASM instance, then click the "Next" button.
On the confirmation screen, click the "OK" button.
Wait while the ASM instance is created.
Once the ASM instance is created, you are presented with the "ASM Disk Groups" screen. Click the "Create New" button.
On the "Create Disk Group" screen, enter Disk Group Name of "DATA" and select the required level of redundancy:
- External - ASM does not mirror the files. This option should only be used if your disks are already protected by some form of redundancy, like RAID.
- Normal - ASM performs two-way mirroring of all files.
- High - ASM performs three-way mirroring of all files.
In this example, the "High" redundancy is used. Select all three candidate disks and click the "OK" button. The following image shows how the candidate disks are displayed when using ASMLib.
When using raw devices, the candidate discs are listed using the devide names.
On the "ASM Disk Groups" screen. Click the "Finish" button.
Click the "Yes" button to perform another operation.
You are now ready to create a database instance using ASM.
Database Creation
Before continuing with the database creation, check the listener is up and the ASM instance has registered with it. Start the listener using the following command.
$ lsnrctl start LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2006 14:35:46 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.1.0 - Production Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener .log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(POR T=1521))) Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 29-APR-2006 14:35:47 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listen er.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(PORT=1521))) The listener supports no services The command completed successfully $로그인 후 복사로그인 후 복사
The ASM instance is not registered, so we can force the registration by doing the following.
$ export ORACLE_SID=+ASM $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sat Apr 29 14:37:06 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> alter system register; System altered. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr oduction With the Partitioning, OLAP and Data Mining options $로그인 후 복사로그인 후 복사
Checking the status of the listener shows that the ASM instance is now registered.
$ lsnrctl status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-APR-2006 14:37:32 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 29-APR-2006 14:35:47 Uptime 0 days 0 hr. 1 min. 46 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listen er.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos2.localdomain)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status BLOCKED, has 1 handler(s) for this service... Service "+ASM_XPT" has 1 instance(s). Instance "+ASM", status BLOCKED, has 1 handler(s) for this service... The command completed successfully $로그인 후 복사로그인 후 복사
Go back to the DBCA and create a custom database in the normal way, selecting the "Automatic Storage Management (ASM)" storage option.
Enter the ASM password if prompted, then click the "OK" button.
Select the "DATA" disk group, then clicking the "Next" button.
Accept the default "Oracle-Managed Files" database location by clicking the "Next" button.
Enable the "Flash Recovery Area" and Archiving, using the "+DATA" disk group for both.
Continue with the rest of the DBCA, selecting the required options along the way.
Switching from Raw Devices to ASMLib
Shutdown any databases using the ASM instance, but leave the ASM instance itself running. Connect to the running ASM instance.
$ export ORACLE_SID=+ASM $ sqlplus / as sysdba로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
Perform the ASMLib Installation, but stop prior to stamping
the ASM disk. If you attempt to stamp the disks using the createdisk command it will fail.
Alter the ASM disk discovery string to exclude the raw devices used previously, then shutdown the ASM instance.
SQL> ALTER SYSTEM SET asm_diskstring = 'ORCL:VOL*' SCOPE=SPFILE; System altered. SQL> SHUTDOWN IMMEDIATE; ASM diskgroups dismounted ASM instance shutdown SQL>로그인 후 복사로그인 후 복사
If you are planning to remove the raw device mappings (Raw Device Setup),
you could simply reset the ASM_DISKGROUP parameter.
SQL> ALTER SYSTEM RESET asm_diskstring SCOPE=SPFILE SID='*'; System altered. SQL>로그인 후 복사로그인 후 복사
At this point the disks will not be used by ASM because they are not stamped. As mentioned previously, the createdisk command used to stamp new disks would fail, so we must issue the renamedisk command as
the root user for each disk.
# /etc/init.d/oracleasm renamedisk /dev/sdb1 VOL1 Renaming disk "/dev/sdb1" to "VOL1": [ OK ] # /etc/init.d/oracleasm renamedisk /dev/sdc1 VOL2 Renaming disk "/dev/sdc1" to "VOL2": [ OK ] # /etc/init.d/oracleasm renamedisk /dev/sdd1 VOL3 Renaming disk "/dev/sdd1" to "VOL3": [ OK ] #로그인 후 복사로그인 후 복사
Notice, the stamp matches the discovery string set earlier. The ASM instance can now be started.
SQL> STARTUP ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL>로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
The ASM instance is now using ASMLib, rather than raw devices. All dependent databases can now be started.
Switching from ASMLib to Raw Devices
Shutdown any databases using the ASM instance, but leave the ASM instance itself running. Connect to the running ASM instance.
$ export ORACLE_SID=+ASM $ sqlplus / as sysdba로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
Alter the ASM disk discovery string to match the raw devices you plan to set up, then shutdown the ASM instance.
SQL> ALTER SYSTEM SET asm_diskstring = '/dev/raw/raw*' SCOPE=SPFILE; System altered. SQL> SHUTDOWN IMMEDIATE; ASM diskgroups dismounted ASM instance shutdown SQL>로그인 후 복사로그인 후 복사
Perform all the steps listed in the Raw Device Setup, then start the ASM instance.
SQL> STARTUP ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL>로그인 후 복사로그인 후 복사로그인 후 복사로그인 후 복사
The ASM instance is now using the disks as raw devices, rather than as ASMLib disks. All dependent databases can now be started.
Performance Comparison
Some documents suggests using ASMLib with Oracle 10g Release 2 gives superior disk performance, while others say it only reduces the time searching for candidate disks, and hence ASM startup time. I decided to compare the performance of the two methods myself to see if I could tell the difference.
My first thought was to perform a simple insert/update/delete test, so I created the following user and schema for the test in a database using and ASM instance using ASMLib.
export ORACLE_SID=DB10G sqlplus / as sysdba CREATE TABLESPACE test_ts; CREATE USER test_user IDENTIFIED BY test_user DEFAULT TABLESPACE test_ts QUOTA UNLIMITED ON test_ts; GRANT CONNECT, CREATE TABLE TO test_user; CONN test_user/test_user CREATE TABLE test_tab ( id NUMBER, data VARCHAR2(4000), CONSTRAINT test_tab_pk PRIMARY KEY (id) );로그인 후 복사로그인 후 복사
Then, as the test user, I ran the following code several times and calculated an average time for each operation.
SET SERVEROUTPUT ON DECLARE l_loops NUMBER := 1000; l_data VARCHAR2(32767) := RPAD('X', 4000, 'X'); l_start NUMBER; BEGIN l_start := DBMS_UTILITY.get_time; FOR i IN 1 .. l_loops LOOP INSERT INTO test_tab (id, data) VALUES (i, l_data); COMMIT; END LOOP; DBMS_OUTPUT.put_line('Inserts (' || l_loops || '): ' || (DBMS_UTILITY.get_time - l_start) || ' hsecs'); l_start := DBMS_UTILITY.get_time; FOR i IN 1 .. l_loops LOOP UPDATE test_tab SET data = l_data WHERE id = i; COMMIT; END LOOP; DBMS_OUTPUT.put_line('Updates (' || l_loops || '): ' || (DBMS_UTILITY.get_time - l_start) || ' hsecs'); l_start := DBMS_UTILITY.get_time; FOR i IN 1 .. l_loops LOOP DELETE FROM test_tab WHERE id = i; COMMIT; END LOOP; DBMS_OUTPUT.put_line('Deletes (' || l_loops || '): ' || (DBMS_UTILITY.get_time - l_start) || ' hsecs'); EXECUTE IMMEDIATE 'TRUNCATE TABLE test_tab'; END; /로그인 후 복사로그인 후 복사
The code is purposely inefficient, using a single statement and a commit within a loop for each operation. Remember, the ASM instance is using high redundancy, so each physical write operation is effectively done 3 times.
Once the tests on ASMLib were complete, I switched to using raw devices and repeated the tests. The average results for 1000 of each operation are listed below.
Operation ASMLib (hsecs) Raw Devices (hsecs) ============== ============== =================== Inserts (1000) 468 852 Updates (1000) 956 1287 Deletes (1000) 1281 1995로그인 후 복사로그인 후 복사
You can instantly see that the ASMLib results are better than those of the raw devices, but the testing is suspect for the following reasons:
- For each single run of the script, only 1000 operations of each type were performed. That equates to about 4M of data in the table when it is full. When you consider the use of the buffer cache, this is a pitiful amount of data. I originally intended to perform many more operations, but my disk was grinding so badly I thought better of it.
- The tests were performed using VMware virtual disks, so really all this work was being done on a single SATA disk. I can't be sure if these results aren't just an artifact of the setup.
- Although the average results look convincing, the raw data was so eratic I'm not convinced these results mean anything.
For these reasons, I decided not to continue to persue the performance tests, much to the delight of my hard drive. If I get access to a more realistic setup I will attempt some large scale tests and report the outcome.
For more information see:
- Installing ASMLib
- Migrating Raw Devices to ASMLib
- Automatic Storage Management (ASM) in Oracle Database 10g
- Oracle Database 10g Release 2 (10.2.0.1) RAC Installation On Linux (CentOS 4) Using VMware Server
- Configuring I/O for Raw Partitions
Hope this helps. Regards Tim...
Back to the Top.
핫 AI 도구
Undresser.AI Undress
사실적인 누드 사진을 만들기 위한 AI 기반 앱
AI Clothes Remover
사진에서 옷을 제거하는 온라인 AI 도구입니다.
Undress AI Tool
무료로 이미지를 벗다
Clothoff.io
AI 옷 제거제
Video Face Swap
완전히 무료인 AI 얼굴 교환 도구를 사용하여 모든 비디오의 얼굴을 쉽게 바꾸세요!
인기 기사
뜨거운 도구
메모장++7.3.1
사용하기 쉬운 무료 코드 편집기
SublimeText3 중국어 버전
중국어 버전, 사용하기 매우 쉽습니다.
스튜디오 13.0.1 보내기
강력한 PHP 통합 개발 환경
드림위버 CS6
시각적 웹 개발 도구
SublimeText3 Mac 버전
신 수준의 코드 편집 소프트웨어(SublimeText3)
뜨거운 주제
7696
15
1640
14
1393
52
1287
25
1229
29
원시 드라이브에서 chkdsk를 사용할 수 없으면 어떻게 해야 합니까?
Mar 06, 2023 pm 03:27 PM
원시 드라이브에서 chkdsk를 사용할 수 없는 문제에 대한 해결 방법: 1. 하단 작업 표시줄에서 Win 아이콘을 마우스 오른쪽 버튼으로 클릭하고 팝업 메뉴 표시줄에서 "실행" 옵션을 클릭합니다. 2. "chkdsk /?"를 입력합니다. 명령줄 창을 열고 Enter 키를 클릭하여 확인합니다. 3. chkdsk 도구가 성공적으로 실행될 때까지 기다립니다.
Linux Raw의 형식은 무엇입니까?
Mar 14, 2023 am 09:33 AM
linux raw는 원시 데이터 형식으로 Linux에서 "기본 장치"를 의미하며 네이키드 파티션 및 원시 파티션이라고도 합니다. linux raw는 형식이 지정되지 않았으며 Unix/Linux에서 파일 시스템을 통해 읽을 수 없는 특수 문자 장치입니다. 원시 장치는 파티션이나 디스크에 바인딩될 수 있습니다.
원시 형식은 무엇입니까?
Feb 01, 2023 pm 01:43 PM
RAW는 처리되지 않고 압축되지 않은 형식입니다. RAW는 "원본 이미지 인코딩 데이터" 또는 더 명확하게는 "디지털 네거티브"로 개념화될 수 있습니다. RAW 형식 파일은 디지털 카메라 센서의 원본 정보를 기록하고 카메라 촬영으로 생성된 일부 메타데이터(ISO 설정, 셔터 속도, 조리개 값, 화이트 밸런스 등의 메타데이터)도 기록하는 파일입니다.
raw photo은 무슨 뜻인가요?
Jan 12, 2021 am 11:05 AM
Raw 사진은 처리되지 않고 압축되지 않은 사진 형식을 의미합니다. Raw의 원래 의미는 "처리되지 않음"이므로 "RAW 이미지는 캡처된 광원 신호를 디지털 신호로 변환하는 CMOS 또는 CCD 이미지 센서입니다. 원본 데이터"로 이해될 수 있습니다.
Raw 형식과 jpg 형식의 차이점은 무엇입니까?
Aug 10, 2023 pm 03:31 PM
Raw 형식과 jpg 형식의 차이점은 다음과 같습니다. 1. JPEG는 널리 사용되는 손실 압축 형식인 반면 RAW 형식은 무손실 이미지 형식입니다. 2. JPEG 형식 이미지 파일은 작은 반면 RAW 형식 파일은 더 큽니다. JPEG 형식은 제한된 후처리만 수행할 수 있는 반면, RAW 형식의 이미지는 더 많은 세부 정보와 색상 정보를 유지하므로 후처리에서 더 많은 조정이 가능합니다.
SQL 문에서 AND 연산자와 OR 연산자를 사용하는 방법
May 28, 2023 pm 04:34 PM
SQLAND&OR 연산자AND 및 OR 연산자는 둘 이상의 조건을 기반으로 레코드를 필터링하는 데 사용됩니다. AND 및 OR은 WHERE 하위 명령문에서 두 개 이상의 조건을 결합합니다. AND 연산자는 첫 번째 조건과 두 번째 조건이 모두 true인 경우 레코드를 표시합니다. OR 연산자는 첫 번째 조건이나 두 번째 조건 중 하나가 true인 경우 레코드를 표시합니다. "Persons" 테이블: LastNameFirstNameAddressCityAdamsJohnOxfordStreetLondonBushGeorgeFifthAvenueNewYorkCarter
게임용 고정밀, 저비용 3D 얼굴 재구성 솔루션, Tencent AI Lab ICCV 2023 논문 해석
Oct 27, 2023 pm 12:13 PM
3D 얼굴 재구성은 게임 영화 및 TV 제작, 디지털 피플, AR/VR, 얼굴 인식 및 편집 등에 널리 사용되는 핵심 기술입니다. 그 목표는 단일 또는 다중 이미지 모델로부터 고품질의 3D 얼굴을 얻는 것입니다. 스튜디오의 복잡한 촬영 시스템의 도움으로 현재 업계의 성숙한 솔루션은 실제 사람과 비교할 수 있는 기공 수준의 정확도로 재구성 효과를 달성할 수 있습니다[2]. 그러나 제작 비용이 높고 제작 주기가 길며, 일반적으로 S급 영화, TV 또는 게임 프로젝트에만 사용됩니다. 최근에는 저비용의 얼굴 재구성 기술(예: 게임 캐릭터 얼굴 꼬집기 게임 플레이, AR/VR 가상 이미지 생성 등)을 기반으로 하는 대화형 게임 플레이가 시장에서 환영을 받고 있습니다. 사용자는 휴대폰으로 촬영한 단일 또는 다중 사진 등 매일 얻을 수 있는 사진만 입력하면 빠르게 3D 모델을 얻을 수 있습니다. 그러나 기존 방법의 영상 품질은 제어할 수 없으며 재구성이 어렵습니다.
Java ASM은 로그백 로그 수준 동적 전환 방법을 사용합니다.
May 09, 2023 pm 01:25 PM
배경 모든 것에는 원인과 결과가 있으며 모든 것은 사건에 의해 좌우됩니다. 이 솔루션의 로그 수준 전환은 단일 프로덕션 환경에 수백, 거의 수천 개의 마이크로서비스가 있는 배경에서 비롯됩니다. 로그 수준 전환으로 인해 서비스가 다시 시작되지는 않습니다. 구성 등은 광범위한 측면을 포함하여 느린 진행을 촉진하고 나중에 실시간으로 정크 로그를 동적으로 필터링하여 IO 및 디스크 공간 비용을 줄입니다. 로그백 소개 적과의 전쟁을 시작하기 전에 먼저 이해해야 합니다. 적의 상황에 따라 모든 전투에서 승리할 수 있습니다. 로그백의 로그 수준을 동적으로 전환하려면 먼저 로그백에 대한 최소한의 사전 이해가 있어야 하며 이것이 기성 구현 솔루션을 제공하는지 확인해야 합니다. logback에 대해 간략히 소개하자면 다음과 같습니다.
