What Is Stripping Concept In Automatic Storage Management
Sep 21, 2012What is Stripping concept in Automatic Storage Management?
How it spreads the database files across the disk group (Suppose i am having 4 disks in my disk group)?
ADVERTISEMENT
Automatic Storage Management :: Oracle ASM With Nimble Storage?
Mar 1, 2013My organisation is currently discussing different storage options for the database storage. Our production database is nearly 2TB and we do not want to continue with the existing NetApp storage (we use a 2 node RAC running 11.2.02 with nfs filesystem from NetApp filer).
We were looking at different options and came across Nimble Storage, they are very fast growing company aiming mid-range storage customers. The initial talks and demonstration looked very promising in terms of IO performance (they claim 40,000 - 60,000 IOPs for their CS400 series Nimble Storage array) and other options they are providing but we understand that majority of their customers are using it for VDI and other infrastructures.
They have demonstrated us using if for Oracle database with ASM storage over iSCSI LUNs. We are yet to do the POCs and benchmarking.
Has anyone come across Nimble Storage for running Oracle databases?
Automatic Storage Management :: Difference Between ASM And SAN
Sep 26, 2012what is difference between san and asm because san also provide mirroring like asm,why we should go for asm.
View 7 Replies View RelatedAutomatic Storage Management :: Upgrading From 10g Raw Devices To 11g?
Dec 27, 2012We have a 2 node rac cluster running on HPUX Itanium platform running oracle rdbms 10.2.0.4 that is currently configured using raw devices for ocr, voting disk, and all of the datafiles. We have a business requirement that is mandating that we have to use TDE tablespace encryption and in order to do so we must now upgrade to 11g.We are in the planning stages for the upgrade process and I am just trying to understand or find out what is going to be the best method to move the data that is currently in the tablespaces on the raw devices over to new tablespaces that will be created within ASM and will be created as TDE encrypted tablespaces?Our database is about 1.8 TB and we have alot of fairly large critical transactional tables that support a 24 x 7 oltp environment that cannot afford downtime.
View 2 Replies View RelatedAutomatic Storage Management :: Create Database First Before Creating ASM
Oct 14, 2013Sun Solaris 10, Oracle 11gr2 x86 How are you doing? I am trying to build a test system. I never build ASM before. if I need to install database first then Migrating to ASM? The other problem I am having is that I only have a Raw disk. I have one disk for root and oracle and the other one for Raw disk for ASM. Do you know it's possible to build ASM on 1 raw disk?
View 3 Replies View RelatedAutomatic Storage Management :: Build ASM In Linux Box Oracle 11g?
Dec 28, 2012I have a Linux box with the below configurations:-
Linux blrulvremoradb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
Last time my UNIX administrator have done a partition in this box. I have 100GB lun allocated to this box which is spilitted in two mount points.
/u01 is having 30GB and /u02 is having 70GB. I want to build a ASM in this box and install Oracle 11.2.0.1 and for that I need raw disk.
Is there any useful links or can you guide me to achieve this... My UNIX admin is on leave for new year and I want to do this by my own..
Automatic Storage Management :: Does ASM Re Balance Occur Automatically
Apr 18, 2013If the ASM Re balance occur automatically. What events can cause the ASM Re balance to be triggered?
I understand, we can manually re balance the disks in a disk group. I would like to know when this will happen automatically.
Automatic Storage Management :: Why Does Lun Show Different Size On Different Rac Nodes?
Apr 8, 2013We are trying to increase ASM disk space and with respect to it when we are trying to allocate more space this question came across my mind. Now this was previously configured by my previous SA.
[root@oracledbtest1 ~]# /etc/init.d/oracleasm querydisk -d `/etc/init.d/oracl
cut -f2,10,11 -d" " | perl -pe 's/"(.*)".*[(.*), *(.*)]/$1 $2 $3/g;' |
while read v_asmdisk v_minor v_major
do
v_device=`ls -la /dev | grep " $v_minor, *$v_major " | awk '{print $10}'`
echo "ASM disk $v_asmdisk based on /dev/$v_device [$v_minor, $v_major]"
[code]....
why are my LUN's showing different sizes on RAC and also the best way to allocate the space to the disks in the above scenario.
Automatic Storage Management :: How To Identify Actual / Dev Nodes
Aug 1, 2012I'm using ASM on LUNs from an EMC SAN, fronted by PowerPath. Right now I have only one fiber path to the SAN, so /dev/emcpowera3 maps directly to /dev/sda3, for example. Oracle had a typo in what they told me to do in /etc/sysconfig/oracleasm*, so the scan picks up both devices.
#/etc/init.d/oracleasm querydisk -p ASMVOL_01
Disk "ASMVOL_01" is a valid ASM disk
/dev/emcpowera3: LABEL="ASMVOL_01" TYPE="oracleasm"
/dev/sda3: LABEL="ASMVOL_01" TYPE="oracleasm"
But I don't think it can be using both. How do I see which one it's actually using?
*They said:
ORACLEASM_SCANORDER="emcpower*"
ORACLEASM_SCANEXCLUDE="sd"
But I think that should be "sd*".
Automatic Storage Management :: 11.1.0.6 Root.sh Fails To Start Css?
Nov 2, 2012We have Oracle ASM and installing 11.1.0.6 on a new machine (eventually will apply 11.1.0.7 patchset). So we are on 11g R1 in production environments.
When installing Oracle ASM 11.1.0.6, the root.sh fails
I checked various metalink notes, all settings are OK. We have ASMLib and i have configured ASMLib with the new disks prior to the ASM installation
Just to rule out the rootcause is with ASMLib , I have also disabled it. Still same problem. I ran the usual localconfig delete and localconfig add too.
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
Giving up: Oracle CSS stack appears NOT to be running.+
Oracle CSS service would not start as installed+
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started+
Finished product-specific root actions.+
Automatic Storage Management :: Is ASMLIB Supported By RHEL6
Jan 29, 2013SO: RHEL6
RDBMS: 11.2.0.3
Standalone Server
I'll install a Oracle Database 11gR2 with ASM on RHEL6 (standalone, not RAC).
Is ASMLIB supported by RHEL6?
Automatic Storage Management :: Disk Add Query
Sep 28, 2012Suppose i have created a diskgroup using
CREATE DISKGROUP disk_group_1 NORMAL REDUNDANCY
FAILGROUP failure_group_1 DISK
'/devices/diska1' NAME diska1,
'/devices/diska2' NAME diska2
FAILGROUP failure_group_2 DISK
'/devices/diskb1' NAME diskb1,
'/devices/diskb2' NAME diskb2;
now i want to add more disk in diskgroup then we can use
ALTER DISKGROUP disk_group_1 ADD DISK
'/devices/disk*3',
now my question is
(1) in which failgroup thE Disk*3 will be added ?
(2) How ican maintain eqal no of disk with same size availble in each FAILGROUP for data mirroring or redundancy by ASM ?
Automatic Storage Management :: How To Start CRS Listener Service / What Is It Used For
Apr 25, 2013I am not using RAC (to my knowledge), but I installed grid so I can use ASM with my RDBMS.
Recently I noticed that the "CRS Listener" service was not started, when I try to start it then it immediately stops. It does not seem to affect the databases, they are still up and running. What is this service used for and how can I get it to start. I am using Oracle Enterprise Server 11.2.0.3 and Grid 11.2.0.3 on a Windows 2008 R2 64-bit server.
Automatic Storage Management :: Database Not Coming Up After Bounce
Jun 4, 2013We have standalone database running on ASM. Its 11Gr2 linux version5 server. After the Database bounce, the DB isnt coming up and is showing the below error.
SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/test/spfiletest.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:2 Failed to open file +DATA/test/spfiletest.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-00450: background process 'ASMB' did not start
ORA-00443: background process "ASMB" did not start
ORA-06512: at line 4
Also i checked the ASM disk groups. I can see all those are MOUNTED properly. In fact i could also see the spfile present in ASM disk physically. It looks like it couldn't identify the spfile to start up the db. however i could see it physically present in ASM disk group.
Find below snapshot.
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 358400 329103 0 329103 0 N DATA/
MOUNTED EXTERN N 512 4096 4194304 358368 358288 0 358288 0 N FRA/
MOUNTED EXTERN N 512 4096 4194304 20480 18780 0 18780 0 N REDO/
Automatic Storage Management :: Where To Find Grid Path In 10g
Mar 6, 2013i am adding luns to the asm diskgroups in 10g where to find the grid path in 10g .
in 11g i can find
/orainfra/11.2.0.3/grid/bin/amdu -diskstring '/dev/oracleasm/disks/DATCSLGGPA*' -dump 'DATCSLGGPA'
but i can't able to find in 10g .
Automatic Storage Management :: Can Drop A Diskgroup While Rebalancing
Nov 10, 2013I added a new disk to a diskgroup. It starts to rebalance. However, I plan to drop the diskgroup anyhow and recreate it since I want to restore a database to it.(I shouldn't have added the new disk beforehand, my mistake) So now it's rebalancing and may take some hours.Can I drop the diskgroup now?I think there is no way to stop the rebalance?
View 2 Replies View RelatedAutomatic Storage Management :: Disk Dropped After The Time Has Passed?
Mar 16, 2013After a power failure, I have now dropped disks in my 2 diskgroups DG_RACDATA1 and OCRVD.
Disks has been renamed and prefixed by DROPPED...
Their state is now "FORCING"
Mount status = missing
header status = unknown
Mode status = Offline
These disks was belonging to a failure group with redundancy so the cluster still works ...but I have lost the redundancy.
How to reuse these offline disk or confirm that what I plan to do is good:
Shall I put them online ? ALTER DISKGROUP DG_RACDATA1 ONLINE DISK DROPPED0000_DG_RACDATA1
Shall I drop them ? ALTER DISKGROUP DG_RACDATA1 DROP DISK DROPPED0000_DG_RACDATA1 FORCE
and then: zeroing them and readd to failgroup ? but how ?
Automatic Storage Management :: Re-Balance Operations Run In Serial Or Parallel
Nov 27, 2012Background: We are migrating a lot of databases from one SAN appliance to another. We are doing this by adding new disks from the new SAN appliance to the existing disk groups, re balancing, removing the old disks from the disk groups, and then re balancing again.
Question: If I execute two ALTER commands with the same power on 2 or more separate disk groups, do both operations start executing right away? Or do they queue up and execute one after another?
I ask because we would like to queue up several re-balances so we don't have DBAs watching status bars all day.
Automatic Storage Management :: Cannot Start ASM On Oracle Database Appliance
Apr 11, 2013I cannot start ASM on my Oracle Database Appliance.
crsctl status resource -t says:
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
however, if I try to access the ASMCMD it says:
[grid@node1 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> startup
ORA-00304: requested INSTANCE_NUMBER is busy
Connected to an idle instance.
Automatic Storage Management :: Prepare ASM Disks Using ASMlib And Oracleasm
Jun 28, 2012Normally ASMlib/oracleasm is used to prepare the disks for ASM. I just wonder, besides this tool, is there any other GUI based tool to use for preparing the ASM disks?
View 2 Replies View RelatedAutomatic Storage Management :: Steps For Moving Files Between ASM Diskgroups In 10g Or 11g
Jan 16, 2013the steps for moving the files between ASM diskgroups in 10g or 11g?
View 4 Replies View RelatedAutomatic Storage Management :: Can't Connect RAC ASM Instance Using Grid Control 12c
Nov 19, 2012when i configure monitor target in GC12C,1 find i can not add asm instance target, and i use scan ip in 11GR2 rac ( two nodes )the problem is plublic IP's 1521 port not accept connect request from remote IP
error from gc12c
Failed to connect to the ASM: IO Error: The Network Adapter could not establish the connection The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.101.78)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)(SERVER=DEDICATED)))
[code]....
how can i let GC12C see ASM instance on each node in cluster??
Automatic Storage Management :: How Many ASM Instance Can Reside On One Single Machine
Apr 16, 2013How many ASM instance can reside on one single machine....
View 1 Replies View RelatedAutomatic Storage Management :: CMD Delete Files Older Than N Days
Oct 24, 2012in ASM disk group,
(under one directory)
ASMCMD> ls -lt
...(thousands of log files looks like, for example, log_19.26718.790635667),
how can I delete those files older than 10 days in one command line?
Automatic Storage Management :: 10.2.0.1 RAC - ASM Created - DBCA Could Not Create Database
Jul 30, 2012I am using 10.2.0.1 on OEL5. I have installed CRS, Oracle home, ASM on both nodes and everything is fine.
When invoked dbca to create a database, it says:
*'DBCA could not startup the ASM instance configured on this node. To proceed with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?'*
Is it a bug? because some blogs say this is a bug. And patch 8288940 will solve this. They also say this patch is to solve the incompatibility between 11g ASM incompatibility with 10g. But here I am using everything of 10.2.0.1.
Automatic Storage Management :: DISKSTRING Is Empty And Discover Discs
Feb 26, 2013SO: RHEL6
GI: 11.2.0.3
User owner: grid
The parameter ASM_DISKSTRING is null string however discovers disks.
SQL> select name, path from v$asm_disk;
NAME PATH
------------------------------ --------------------------------------------------
/dev/vg_hdisk_ora/lv_hd10
/dev/vg_hdisk_ora/lv_hd15
/dev/vg_hdisk_ora/lv_hd3
/dev/vg_hdisk_ora/lv_hd6
/dev/vg_hdisk_ora/lv_hd4
[Code] .....
20 rows selected.
SQL> show parameters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring stringAfter setting asm_diskstring to "/dev/asm*", list 40 disks (kernel-assigned device file names & UDEV name)
DISK_NUMBER PATH
----------- ----------------------------------------
0 /dev/asm-disk10
39 /dev/vg_hdisk_ora/lv_hd15
2 /dev/asm-disk3
3 /dev/asm-disk6
4 /dev/asm-disk4
5 /dev/asm-disk7
[Code] ...
40 rows selected.1. Why not list only the names of devices UDEV?
2. Is this normal when creating UDEV rules to ASM?
Automatic Storage Management :: Data File Recovery Error?
Oct 8, 2012I have Oracle 10.2.0.4.0 on RAC environment. I had 19 Data files on ASM. However one of my colleague has created new data file on a Node using Physical Drive which like this.
G:ORACLEPRODUCT10.2.0DB_1DATABASEDATA_001.DBF instead of +DATA/ref/datafile/data.400.70812332
Now this file is in Recover State and when i try to make it online it says Block # 12 of this file is corrupted.
select * from v$datafile
20 20 6463317847 06/10/2012 10:11:18 6 20 RECOVER READ WRITE 6467876664 07/10/2012 08:39:09 0 6468047778 07/10/2012 09:30:53 0 0 104857600 12800 104857600 8192 G:ORACLEPRODUCT10.2.0DB_1DATABASEIFSAPP_DATA_001.DBF 0 8192 NONE 0
Automatic Storage Management :: RAC 11gR2 - Normal Or External Redundancy
May 20, 2013My comp is running with RAC 11gR2 with ASM on external redundancy. we are planning to move on normal redundancy.
which will be better normal redundancy or external redundancy.
Automatic Storage Management :: Normal Redundancy Disk Group
Oct 3, 2013One of my collegues created an ASM disk group with normal redundancy using 2 disks. But the disks are not of same size, one disk is 100GB and another one is 10GB. Now the usable space out of diskgroup is showing 55GB. When I checked the diskgroup properties it is showing 2 fail groups one is DATA1_ 0000 with 10GB and other is DATA_0001 with 100GB. My question is why it is showing 55GB as usable space? My assumption is as it is having 2 fail groups with different disks of different sizes. For the failgroup 2 even it is of 100GB size, in order to maintain the redundancy with other small FG(10G) it will consider only 10GB out of 100GB. So, the 2nd FG size also should be 10GB. So that the usable space should show as 10GB as opposed to 55GB (not (100+10)/2).
View 12 Replies View RelatedAutomatic Storage Management :: Create A Raw Device On A Logical Volume?
Mar 4, 2013The db is 11.2.0.3 on a linux machine.
Is it possible to create a raw device on a logical volume WITHOUT cluster service from os vendor such as HACMP(AIX), Service Guard(HP)?
The following is os information.
[aa@mm01(abc):/home/abc] uname -a
Linux aa 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[aa@mm01(abc):/home/abc]