asm commands in oracle 11g

Discover asm commands in oracle 11g, include the articles, news, trends, analysis and practical advice about asm commands in oracle 11g on alibabacloud.com

Oracle 11g R2 ASM: understand basic concepts of Oracle ASM

ASM file allocation in a disk group Oracle ASM striping Oracle ASM strip has the following two purposes: Distribute the Server Load balancer across all disks in the disk group. Reduces I/O latency ASM strip is divided into

New Features of Oracle ASM 11g

"rolling upgrade" for ORACLE11g and later versions. In other words, you cannot use this function to upgrade ORACLE10g databases to 11G. Before performing a rolling upgrade, make sure your environment is ready. For example, if you use the ORACLE Clusterware software, you must complete the upgrade to the next version that meets the requirements before rolling the upgrade. Of course, you should also use the r

Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4

Install Oracle 11g R2 + RAC + ASM in Oracle Linux 6.4 I. Version descriptionMany articles related to the Internet are found, but they are not very specific. Therefore, the detailed version is used to make the article more practical.This is the RAC environment of Oracle

Oracle 11g ASM: how to create an Oracle ACFS File System in ASMCMD command line tool

Oracle 11g ASM: how to create an Oracle ACFS file system experiment environment in ASMCMD command line tool: Oracle 11g R2 RAC (11.2.0.3.5) oracle Enterprise Linux 5.6x86 1. Create an

Oracle 11g ASM: how to create an oracle ACFs File System in asmcmd command line tool

Lab environment: Oracle 11g R2 RAC (11.2.0.3.5) Oracle Enterprise Linux 5.6x86 1. Create an ASM disk group and mount the disk on two nodes. Then, partition the disk on the first node. [root @ Rac1 ~] # Fdisk-ldisk/dev/SDE: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersunits = cylinders of 16065*512

Oracle 11g uses ASM storage migration

For a15sql> Col Path to a15sql> Col State for a10sql> set line 200sql> select Mode_status,header_status, MOD E_status,state,total_mb,free_mb,name,path from V$asm_disk; Mode_status header_status mode_status State total_mb free_mb NAME PATH----------------------------------------------- -----------------------------------------------------------------online FORMER online NORMAL 0 0/dev/asm-diske # #已删除 ONLINE MEMBER online NORMAL 4096 3788 crsdg_0001/d

Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary

Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary 1. Preparations before installation: Operating System: RHEL6.5 Storage: Huawei, multi-path configured Bind the business network card and heartbeat network card and pass the redundancy test. YUM source configuration BASH/SSL vulnerability patches 2. Check System Requirements A. LINUX version

Oracle 11g RAC database on ASM, ACFS or OCFS2

I see a lot of questions on shared file systems the can used when people move from single instance to Oracle RAC Datab ASE and Grid Infrastructure. The most common question are the following: "should I place archive logs in OCFS2 or ASM or ACFS of 11g?" I ' ll try to clarify this topic below.First we need to understand a separation between

28th Oracle 11g R2 ASM

Label:2015-10-24DirectoryResources[1] Management and maintenance of ASM under oracle11g RAC[2] Oracle 11g RAC with ASM installed on RHEL5 (simplified version)[3] Oracle 11g r2+rac+asm+o

Oracle 11g RAC with ASM installed on RHEL5 (simplified version)

location:Oracle Base:/u01/app/oracleSoftware Location:/u01/app/oracle/product/11.2.0/gridFill in the Create inventory:Inventory Directory:/u01/app/orainventoryOrainventory Group Name:oinstallAfter installation is completeRunning in R1/u01/app/orainventory/orainstroot.shRunning in R2/u01/app/orainventory/orainstroot.shRunning in R1/u01/app/11.2.0/grid/root.shRunning in R2/u01/app/11.2.0/grid/root.sh16. Install the databaseFirst, make sure all the impo

Installing ASM on Oracle 11g (RHEL5)

Tags: Oracle 11g ASM Installation1. Oracle 11g InstallationSlightlyFor detailed procedures, please refer to:Http://blog.sina.com.cn/s/blog_7c5a82970101excf.html2. Install the ORACLEASM packageRPM-IVH oracleasm-support-2.1.7-1.el5.x86_64.rpm oracleasmlib-2.0.4-1.el5.x86_64.rp

Installing Oracle 11g R2 using RHEL6 ASM

RHEL6 ASM installation of Oracle 11g R2 tutorial directory: I. Preparations before installationIi. Install the grid infrastructure3. Install database software4. Create a listener5. Create a database instance I. Preparations before installation 1.1 determine the Operating System Environment # Cat/etc/RedHat-release Red Hat Enterprise Linux Server release 6.2 (Sant

ORACLE 11G R2 RAC+MUTILPATH+RAW+ASM+SILENT+ADDNODE+DG Complete installation (v)

file, modified to +fra Disk group)--Modify archive logs and flash-back zone storage path (db_recovery_file_dest and Log_archive_dest conflict, officially deprecated)--official recommendation to write archived logs to local disk , if the shared disk is large enough to put in the ASM (set size to open after)--if you do not enable the flashback log, you will need to rebuild a new standby when a failover occurs. (strongly recommended to turn on flashback

ORA-15260 resolution when Oracle 11g ASM increases Disk

In Oracle 11g, add a disk to an existing disk group. The operation command is "alter diskgroup webdg add disk '/dev/raw/raw4 ';", however, if you use sysdba for connection, an error is returned. ORA-15260: permission denied on ASM disk groupInform the permission to be rejected. [Root @ serv1 ~] # Su-grid/Home/grid @ serv1 => + ASM1 $ sqlplus/as sysdba SQL * Plus:

Oracle 11g RAC Installation INS-30507 error: Empty ASM disk Group

The most recent Oracle 11g RAC installation ran into a INS-30507 error, that is, when the grid was installed to create the ASM Disk Group, no candidate disks were found, and Google did not find any clues to the N-Multiple installation instructions. If you encounter this problem, you might as well look down. 1. Error message and explanation SEVERE: [FATAL] [INS-

Oracle 11g ASM permission problems

In Oracle 11g, use sysdba to connect to ASM.SQL> conn/as sysdbaSQL> alter diskgroup DATA mount;Alter diskgroup DATA mount*ERROR at line 1:ORA-15032: not all alterations saved medORA-15260: permission denied on ASM disk groupORA-15260: permission denied on ASM disk groupInform the permission to be rejected.[Root @ rac1

Use asm for a single Oracle 11g instance and test the migration of data files to other disk groups

Oracle 11G Single Instance uses asm, and test the migration of data files to other disk groups 1. configure/etc/hosts network vi/etc/hosts192.168.1.181 asm asm.oracle.com 1. disable FIREWALL 2. disable SElinux vi/etc/selinux/config => SELINUX = disabled 2. create a user and group groupadd-g 5000 asmadmingroupadd-g 5001

Points to note when using Oracle 11g ASM

1. Configure a minimum of 2 data Group (datagroup), the Fra datagroup as the flash back Zone side archive, backup, etc.) mainly consider the IO performance problem2. Oracle Official documentation recommends a minimum of 4 disks per DG and the same size and performance. No IO will be limited by the slowest disk3. The hardware RAID strip size takes the power of 2, and 4. Support Storage:Disk PartitionA Disk Partition can be the entire disk drives or a s

Control file multiplexing under the RAC 11G ASM for Oracle

you, and the new file name needs to be determined.asmcmd> pwd+flash/devdb/controlfile/Asmcmd> lscurrent.303.956019293 > Not the same as you assigned.5. Modify the control file path in Sqlplus, and after the modification is complete, close the databaseSql> alter system set control_files= ' +data/devdb/controlfile/current.260.936769367 ', ' +flash/devdb/controlfile/ current.256.936769367 ', ' +flash/devdb/controlfile/current.303.956019293 ' scope=spfile sid= ' * ';sql> shutdown immediate;Ora-0150

Oracle 11g asm basic operations

Oracle 11g asm basic operations View: v $ asm_diskgroupv $ asm_diskv $ asm_operation ---- ADD, delete disk alter diskgroup diskgroup_name {ADD ...} {DROP ...} [REBALANCE [POWER integer] [WAIT | NOWAIT]; eg :( avoid multiple rebalance operations) alter diskgroup fra add disk' ORCL: SDE7 'name' FRA _ DISK5 'size 977 M, 'orcl: SDE8 'name' FRA _ disk6' SIZE 977 mddro

Total Pages: 15 1 2 3 4 5 .... 15 Go to: Go

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.