Discover asm commands in oracle 11g, include the articles, news, trends, analysis and practical advice about asm commands in oracle 11g on alibabacloud.com
In Oracle 10g, we can use the Asmlib library to create ASM instances, and Oracle has a lot more to offer than a separate download for the Enterprise Linux server image after Rhel 6. So we manage the device mappings used by Udev for ease of administration. In Oracle 11g, it i
.564.83111783556 6244 NEUDOC_DRTBS *** + DATA_NMGT/nmggt/datafile/neudoc_drtbs.565.83111784157 3172 UNIEAP_DRTBS *** + DATA_NMGT/nmggt/datafile/unieap_drtbs.566.83111784158 4196 ELARP_DRTBS *** + DATA_NMGT/nmggt/datafile/elarp_drtbs.567.83111784159 100 NMGADMIN_GTTBS *** + DATA_NMGT/nmggt/datafile/nmgadmin_gttbs.568.83111936360 100 GTDZ_GTTBS *** + DATA_NMGT/nmggt/datafile/gtdz_gttbs.569.83111936361 100 GTKZ_GTTBS *** + DATA_NMGT/nmggt/datafile/gtkz_gttbs.570.83111936562 100 SDE_GTTBS *** + DATA
11g RAC change archive mode ASM This experiment has two nodes: tip01 and tip02.Oracle_sid: tips1, tips2 1. Run the command on node 1 tip01.[[Email protected] ~] # Su-grid[[Email protected] ~] $ Sqlplus/As sysasm SQL> select name from V $ asm_diskgroup; Name------------------------------DataOCR SQL> alter diskgroup data add directory '+ Data/arc1 '; Diskgroup altered. 2. Run the command on node 1 tip02.[[Ema
$ exitYou have mail in/usr/spool/mail/root[Db2/#]chdev-l hdisk8-a Pv=clearHDISK8 changed[DB2/#]LSPVHdisk0 00f9733ef7cf27e9 ROOTVG ActiveHdisk1 00f9733e21b953e6 ROOTVG ActiveHdisk2 00f9733e21b97a83 APPVG ActiveHDISK3 00f9733e21b98434 APPVG ActiveHDISK4 00f9733d67553e0a NoneHdisk5 00f9733d67553f31 NoneHDISK6 00f9733d67554011 NoneHdisk7 00f9733d67554165 NoneHdisk8 None NoneHDISK9 00f9733d675542e4 NoneHdisk10 None None[Db2/#]su-grid$ sqlplus/as SysasmSql*plus:release 11.2.0.4.0 Production on Sun Dec
11g rac rebuilding the SPFILE of the ASM instance 1. PrerequisitesYou need to know the following information:1) number of nodes2) the location of the disk included in the ASM disk group3) There are several disk groups for the instance.2. Steps and reconstruction scripts1) Successful scripts:*. Cluster_database_instances = 2+ ASM1.instance _ name = '+ ASM1'+ ASM1.
11g ASM dbca error prcr-1006 crs-0259 prcr-1071 When creating a single instance DB using ASM mode, it appears when running DBCA PRCR-1006 : Failed to add resource ora.orcl.db for orcl PRCR-1071 : Failed to register or update resource ora.orcl.db PRCR-1001 : Resource ora.orcl.db does not exist After viewing the DBCA log, I found the following error. [
In Oracle 11g, ASM supports both 10g and 11g databases. However, the ASM version cannot be less than the database version.Two parameters related to compatibility now:Compatible.rdbmsThe minimum supported version of the Oracle data
In the previous article wrote the file system library, in the exception recovery before the backup method (Oracle exception recovery before the backup protection site recommended-filesystem environment), for the ASM Library, because the ASM inside the data file can not direct DD file header, As a result, the backup approach has changed. For
/oradata1p1DEVICE/dev/mapper/oradata1p1 retries red AT Mon Mar 21 23:06:06 CST 2016ADHU:/dev/mapper/oradata1p1: Status 0x04 Mon Mar 21 23:06:06 2016ADHU:/dev/mapper/oradata1p1: Diskgroup: DATA Disk: DATA_0000 #0ADHU:/dev/mapper/oradata1p1: snapshot UPT disk header encounteredADHU:/dev/mapper/oradata1p1: valid backup block foundADHU:/dev/mapper/oradata1p1: disk header retries RedXff1:/tmp/adhu> sqlplus/as sysasmSQL * Plus: Release 11.2.0.4.0 Production on Mon Mar 21 23:08:48 2016Copyright (c) 198
]$ kfed read/dev/asm-fra03 |grep grpnameKfdhdb.grpname:FRA; 0x048:length=3[Oracle@rac1 amdu_2016_02_17_14_25_33]$ kfed read/dev/asm-fra04 |grep grpnameKfdhdb.grpname:FRA; 0x048:length=3[Oracle@rac1 amdu_2016_02_17_14_25_33]$ [Oracle@rac1 amdu_2016_02_17_14_25_33]$ Sqlplus "/
| grep pmonoracle 3325 1 0 17:39? 00:00:00 asm_pmon_+asm1oracle 3813 1 0 17:40? 00:00:00 mdb_pmon_-mgmtdboracle 5806 1 0 17:42? 00:00:00 ora_pmon_orcl1oracle 6193 1 0 17:42? 3. Check the status of the ASM instance in the RAC db instance from instance 1 (RAC1)4. Check the cluster status in instance 1 (RAC1)[Email protected] desktop]$ crsctl check clustercrs-4537:cluster ready Services is Onli
command:/U01/APP/11.2.0/GRID/CRS/config. ShThis command launches the grid infrastructure Configuration Wizard. The Wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media. Execute the script according to the above prompt.[[Email protected] softdb] #/u01/APP/11.2.0/GRID/perl/bin/perl-I/u01/APP/11.2.0/GRID/perl/lib-I/u01 /APP/11.2.0/GRID/CRS/install/u01/APP/11.2.0/GRID/CRS/install/roothas. PLUsing configuration
, but it also requires learning new concepts, commands, usage, and management tasks. So before you invest in your production system, let's look at what it solves, what it manages, and what it looks like. Why create it? The best way to answer this question is to directly trace the source, Bill Bridge-the initial architect of Automatic Storage Management. In Oracle ASM
) The configuration is simpler, and maximizes the utilization of storage resources that drive database consolidation; Data files are stored in DiskGroup (DG), which is relatively simple to manage.(3) Intrinsic support for large files, supporting bigfile files.(4) After incremental increase or deletion of storage capacity to perform automatic contact redistribution, that is, automatic rebalance;(5) Maintain redundant copies of data to improve usability;(6) Support 10g,
Label:Chapter II ASM INSTANCEthe type of ASM, for example, can be:The Oracle instance type adds an ASM category after 10g. The parameter instance_type=asm is set.ASM Instance startup command: StartupNomountLaunches the instance and background processes. But the disk group is
1. I used to think that Integer=number (38,0)--38 is the maximum precision of number Integer is a very large data type and can be represented as power (10,126)-1 Because the maximum of one byte represents 256, the largest of n bytes represents power (256,n) >=power (10,126) n=53, an integer type uses a minimum of 53 bytes. So the integer type is still as small as possible, generally rarely use such a large number. In particular, some people deal with the Boolean type;
ASM concepts 1. what is Automatic Storage Management (ASM, it is a disk management tool that can implement strip, image data files, recovery files, and other files among multiple physical devices. The distribution unit is AUs (allocation units) the balance is distributed across all disks in the disk group. ASM uses the index technology to track the positions of e
Label:ASM OverviewAutomatic Storage Management (ASM) is a great new feature in Oracle database 10g that provides services such as file systems, logical volume managers, and software raid in a platform-agnostic manner. ASM can stripe and mirror disks, enabling the addition or removal of disks as the database is loaded, and automatic balancing of I/O to remove "hot
creation Solution: 1. SQL> alter package standard compile; 2. SQL> alter package dbms_standard compile; 3, @ oracle_base \ ORACLE_HOME \ RDBMS \ admin \ utlrp. SQL Step 3 will take a long time, You can select count (*) from OBJ $ where status in (4, 5, 6); view, the number should keep getting smaller. Part 3: asmcmd. Asmcmd also needs to connect to the ASM instance 1. Set the ORACLE_HOME environment variable. If the Registry has one, set it as well
development of Oracle, even if ASM only corresponds to a set of RDBMS also recommended oracle_home separate, 11g ASM Independent to the GI, so it is recommended to separate the good, easy maintenance, in our production environment I am independent open storage 10205 ASM Run
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
