Automatic Storage Management :: Place Voting Files In Quorum Or Regular Failgroup?

Oct 29, 2013

About the concept of quorum failgroup ORACLE says:QUORUM disks, or disks in quorum failure groups, cannot contain any database files,the Oracle Cluster Registry (OCR), or dynamic volumes. However, QUORUM diskscan contain the voting file for Cluster Synchronization Services (CSS). Oracle ASMuses quorum disks or disks in quorum failure groups for voting files wheneverpossible.

To sum up, i think the different between a regular failgroup and a quorum failgroup is a quorum failgroup can only contain vote files and a regular one can contains multiple kinds of files.So i didn't see any advantage to place voting files on a quorum failgroup than on a regular one. Why Oracle introduce the concept of quorum failgroup?

View 2 Replies


ADVERTISEMENT

Automatic Storage Management :: Steps For Moving Files Between ASM Diskgroups In 10g Or 11g

Jan 16, 2013

the steps for moving the files between ASM diskgroups in 10g or 11g?

View 4 Replies View Related

Automatic Storage Management :: CMD Delete Files Older Than N Days

Oct 24, 2012

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

View 5 Replies View Related

Automatic Storage Management :: Oracle ASM With Nimble Storage?

Mar 1, 2013

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

View 3 Replies View Related

Automatic Storage Management :: Difference Between ASM And SAN

Sep 26, 2012

what is difference between san and asm because san also provide mirroring like asm,why we should go for asm.

View 7 Replies View Related

What Is Stripping Concept In Automatic Storage Management

Sep 21, 2012

What 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)?

View 2 Replies View Related

Automatic Storage Management :: Upgrading From 10g Raw Devices To 11g?

Dec 27, 2012

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

Automatic Storage Management :: Create Database First Before Creating ASM

Oct 14, 2013

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

Automatic Storage Management :: Build ASM In Linux Box Oracle 11g?

Dec 28, 2012

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

View 5 Replies View Related

Automatic Storage Management :: Does ASM Re Balance Occur Automatically

Apr 18, 2013

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

View 2 Replies View Related

Automatic Storage Management :: Why Does Lun Show Different Size On Different Rac Nodes?

Apr 8, 2013

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

View 4 Replies View Related

Automatic Storage Management :: How To Identify Actual / Dev Nodes

Aug 1, 2012

I'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*".

View 3 Replies View Related

Automatic Storage Management :: 11.1.0.6 Root.sh Fails To Start Css?

Nov 2, 2012

We 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.+

View 5 Replies View Related

Automatic Storage Management :: Is ASMLIB Supported By RHEL6

Jan 29, 2013

SO: 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?

View 20 Replies View Related

Automatic Storage Management :: Disk Add  Query

Sep 28, 2012

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

View 2 Replies View Related

Automatic Storage Management :: How To Start CRS Listener Service / What Is It Used For

Apr 25, 2013

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

View 2 Replies View Related

Automatic Storage Management :: Database Not Coming Up After Bounce

Jun 4, 2013

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

View 3 Replies View Related

Automatic Storage Management :: Where To Find Grid Path In 10g

Mar 6, 2013

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

View 1 Replies View Related

Automatic Storage Management :: Can Drop A Diskgroup While Rebalancing

Nov 10, 2013

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

Automatic Storage Management :: Disk Dropped After The Time Has Passed?

Mar 16, 2013

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

View 4 Replies View Related

Automatic Storage Management :: Re-Balance Operations Run In Serial Or Parallel

Nov 27, 2012

Background: 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.

View 7 Replies View Related

Automatic Storage Management :: Cannot Start ASM On Oracle Database Appliance

Apr 11, 2013

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

View 13 Replies View Related

Automatic Storage Management :: Prepare ASM Disks Using ASMlib And Oracleasm

Jun 28, 2012

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

Automatic Storage Management :: Can't Connect RAC ASM Instance Using Grid Control 12c

Nov 19, 2012

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

View 2 Replies View Related

Automatic Storage Management :: How Many ASM Instance Can Reside On One Single Machine

Apr 16, 2013

How many ASM instance can reside on one single machine....

View 1 Replies View Related

Automatic Storage Management :: 10.2.0.1 RAC - ASM Created - DBCA Could Not Create Database

Jul 30, 2012

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

View 4 Replies View Related

Automatic Storage Management :: DISKSTRING Is Empty And Discover Discs

Feb 26, 2013

SO: 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?

View 1 Replies View Related

Automatic Storage Management :: Data File Recovery Error?

Oct 8, 2012

I 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   

View 2 Replies View Related

Automatic Storage Management :: RAC 11gR2 - Normal Or External Redundancy

May 20, 2013

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

View 7 Replies View Related

Automatic Storage Management :: Normal Redundancy Disk Group

Oct 3, 2013

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







Copyrights 2005-15 www.BigResource.com, All rights reserved