asm commands in oracle 11g

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

"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 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 experiment environment in ASMCMD command line tool: Oracle 11g R2 RAC (11.2.0.3.5) oracle Enterprise Linux 5.6x86 1. Create an

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

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 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

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

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

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

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

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

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

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:

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-

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

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

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

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 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