AskDBA.org Forum » Tag: ASM

AskDBA.org Forum » Tag: ASM - Recent Posts http://www.forum.askdba.org/ Forum for Oracle DBA's en Thu, 09 Feb 2012 22:12:15 +0000 Amit Bansal on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-233 Thu, 07 Jul 2011 03:55:35 +0000 Amit Bansal 233@http://www.forum.askdba.org/ Actually when you take backup on disk (assuming you have linked rman library with tape and set sbt_type) and are using catalog. Oracle will know which backup to restore. Check in Myoracle support for 'rman tape' and you will find many articles related to it. orabcn on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-225 Mon, 04 Jul 2011 12:20:44 +0000 orabcn 225@http://www.forum.askdba.org/ Thank you, The new instance will use file system instead of ASM. I don't care about this part of restoring the database when the backup is in disk! I care about the part of restoring the FRA from the tape! Amit Bansal on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-224 Mon, 04 Jul 2011 03:37:00 +0000 Amit Bansal 224@http://www.forum.askdba.org/ I think you should check regarding licensing terms with Oracle sales representative. I believe if you restore on new server and use it for some number of days, you have to pay license cost. Not sure on this. I have done ASM restore operation in past but don't have documented steps. You will have to create the ASM Diskgroup disk's prior to running the restore operation. Also if you are having any aliases like '+DG/orabcn (where orabcn is not oracle_sid), you will have to pre-create before starting restore. Regards Amit orabcn on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-223 Fri, 01 Jul 2011 12:36:08 +0000 orabcn 223@http://www.forum.askdba.org/ than you, the thing is we don't have license to use dataguard. I have to think about the best, easier solution to restore from tapes and then restore/recover my database (database + ASM) to a dedicated single instance on a separated server located in another data center. could you share your experience and advice the step by step of doing it? Amit Bansal on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-221 Thu, 30 Jun 2011 05:50:17 +0000 Amit Bansal 221@http://www.forum.askdba.org/ hi Orabcn, I think what you require is disaster recover solution which is provided by using Oracle dataguard. So you can create a bcp for your existing RAC database which will help in case your primary RAC servers are gone. Also note that restoring from tape can take time, so you should have 1 backup copy on disk's. orabcn on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-217 Tue, 28 Jun 2011 12:33:30 +0000 orabcn 217@http://www.forum.askdba.org/ Hello, I need your advice about a project I am doing now: I have 7 RAC 11gR2 nodes on Redhat Linux. We are backing up the database (one instance node) using incremental updated backups via RMAN, and then we move the backups to tape. I autobackup the controlfile and spfile with RMAN and my retention window is 60 days. I am also, running md_backup every night to backup ASM metadata. until now everything is ok. But, what happens if I completely loose the 7 nodes RAC? if all the servers are down and completely lost? I am backing up the archive log files also using RMAN. My database is in archivelog mode and block change tracking is enabled also, I am using control file instead of recovery catalogue. And, I am saving the DBID of the instances. And I am backing up the FRA to tape. I have to think about the best, easier solution to restore from tapes and then restore/recover my database (database + ASM) to a dedicated single instance on a separated server located in another data center. could you share your experience and advice the step by step of doing it? thank you taraldesai on "ASM DiskGroup" http://www.forum.askdba.org/topic/asm-diskgroup#post-182 Wed, 15 Sep 2010 15:09:36 +0000 taraldesai 182@http://www.forum.askdba.org/ Sorry for late reply I was on vacation. Thanks Amit for information. Amit Bansal on "ASM DiskGroup" http://www.forum.askdba.org/topic/asm-diskgroup#post-180 Mon, 30 Aug 2010 04:57:44 +0000 Amit Bansal 180@http://www.forum.askdba.org/ Taral, When you don't define failgroup while creating normal redundancy diskgroup, oracle would automatically create diskgroup for you. Run following query to identify this select name,path,failgroup,header_status from V$ASM_DISKGROUP; taraldesai on "ASM DiskGroup" http://www.forum.askdba.org/topic/asm-diskgroup#post-179 Sun, 29 Aug 2010 18:52:22 +0000 taraldesai 179@http://www.forum.askdba.org/ Hi Amit/Saurabh, I have question regarding adding diskgroup. Let's say if we add any diskgroup with normal redundancy without using failgroup it will create diskgroup. So, how redundancy is maintained. Where would it write block image on same disk. deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-111 Wed, 09 Dec 2009 12:29:40 +0000 deepika.dhamija@gmail.com 111@http://www.forum.askdba.org/ Amit, I am finally able to achieve what I intended to do. Many Thanks to you for your valuable suggestions. Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-110 Wed, 09 Dec 2009 09:30:43 +0000 Amit Bansal 110@http://www.forum.askdba.org/ Hi, >>Actually I have an application that runs on every node on the cluster and creates the devices /dev/multipath/sd* Can't understand this statement. Anyways if you use udev, you can set permissions in rules file /etc/udev/rules.d/50-udev.rules I think your sysadmin can help you with that. -Amit deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-109 Wed, 09 Dec 2009 09:03:19 +0000 deepika.dhamija@gmail.com 109@http://www.forum.askdba.org/ Hi Amit, Actually I have an application that runs on every node on the cluster and creates the devices /dev/multipath/sd*. I am new to this entire setup, but I can tell you that it uses udev. On Node 1 [oracle@linux1 ~]$ uname -a Linux linux1 2.6.9-78.0.13.ELsmp #1 SMP Wed Jan 7 17:52:47 EST 2009 i686 i686 i386 GNU/Linux Does this much information answer your questions? Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-108 Wed, 09 Dec 2009 07:58:21 +0000 Amit Bansal 108@http://www.forum.askdba.org/ Deepika, How have you configured multipathing? Are you using udev and device mapper? Also let me know your linux release details. -Amit deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-107 Wed, 09 Dec 2009 07:10:39 +0000 deepika.dhamija@gmail.com 107@http://www.forum.askdba.org/ Thanks Amit for the prompt reply. I had ORACLE_SID SET to orcl1 and orcl2 on both the nodes respectively. On node1, I did the above steps, and I luckily was able to connect to Oracle. It did not say 'connected to idle instance'. The O/P of the query on Node1 (ORACLE_SID=+ASM1) is NAME PATH MOUNT_S HEADER_STATUS ORCL:VOL1 CLOSED UNKNOWN ORCL:VOL1 CLOSED UNKNOWN ORCL:VOL1 CLOSED UNKNOWN The O/P of the query on Node2 (ORACLE_SID=orcl2) is NAME PATH MOUNT_S HEADER_STATUS VOL1 ORCL:VOL1 OPENED UNKNOWN VOL2 ORCL:VOL2 OPENED UNKNOWN VOL3 ORCL:VOL3 OPENED UNKNOWN Does that mean that the multipath disks have not been picked up by asm at all. What about the permissions. I ran the foll commands (for sdb2, sdb3, sdb4) on Node1 # chown -R oracle:dba /dev/multipath/sdb2 # chmod -R 775 /dev/multipath/sdb2 # /etc/init.d/oracleasm scandisks # /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 How do these permissions remain intact after a reboot to the node? Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-106 Wed, 09 Dec 2009 06:54:50 +0000 Amit Bansal 106@http://www.forum.askdba.org/ Hi, Try logging into ASM instance and query V$ASM_DISK i.e export ORACLE_SID=+ASM1 sqlplus "/ as sysdba" select name,path,mount_status,header_status from V$ASM_DISK; with regards to naming convention, I think naming convention should follow /dev/[a-z]* naming convention instead of /dev/multipath/[a-z]* It could be this or it could be that as the name of multipath device is also ending with sdb2,sdb3 and we are also excluding the disk ending with sdb2,sdb3. I am not too sure on this. I think best way would be to actually first query V$ASM_DISK output. deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-105 Wed, 09 Dec 2009 06:33:44 +0000 deepika.dhamija@gmail.com 105@http://www.forum.askdba.org/ Hi Amit, Yes, I am following the above URL. On Node1: [root@linux1 ~]# /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 [root@linux1 ~]# /etc/init.d/oracleasm querydisk /dev/multipath/sdb2 Device "/dev/multipath/sdb2" is marked an ASM disk with the label "VOL1" [root@linux1 ~]# /etc/init.d/oracleasm querydisk /dev/sdb2 Device "/dev/sdb2" is marked an ASM disk with the label "VOL1" The O/P is same for sdb3 and sdb4 (both multipath & single path devices) Is this what you mean when you say if disks are visible on node1? [oracle@linux1 ~]$ srvctl status asm -n linux1 ASM instance +ASM1 is running on node linux1. [oracle@linux1 ~]$ srvctl status instance -d orcl -i orcl1 Instance orcl1 is not running on node linux1 [oracle@linux1 ~]$ srvctl start instance -d orcl -i orcl1 PRKP-1001 : Error starting instance orcl1 on node linux1 CRS-0215: Could not start resource 'ora.orcl.orcl1.inst'. [oracle@linux1 ~]$ I am unable to start the instance orcl1 on node1. Also what is the significance of naming multipath devices in a particular way? Amit Bansal on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-104 Tue, 08 Dec 2009 13:32:15 +0000 Amit Bansal 104@http://www.forum.askdba.org/ Hi Deepika, I believe you are following below article available on Oracle website <a href="http://www.oracle.com/technology/tech/linux/asmlib/multipath.html" rel="nofollow">http://www.oracle.com/technology/tech/linux/asmlib/multipath.html</a> First I believe that you should check ASM instance and see if you are able to see the disks on Node 1. From above output it looks that you connected to node 1 DB instance and not asm instance. This can also be seen from crs_stat output which shows that asm instance is up on node 1. Secondly name multipath device as multipatha,multibathc instead of /multipath/sdb1 etc deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-103 Tue, 08 Dec 2009 09:37:34 +0000 deepika.dhamija@gmail.com 103@http://www.forum.askdba.org/ Hi I have a 2node RAC Setup 10gR2. I have three ASM Volumes configured, out of devices sdb2, sdb3, sdb4 /etc/init.d/oracleasm createdisk VOL1 /dev/sdb2 /etc/init.d/oracleasm createdisk VOL2 /dev/sdb3 /etc/init.d/oracleasm createdisk VOL3 /dev/sdb4. where VOL1 & VOL2 belong to the Disk Group ORCL_DATA1 and Vol3 to the group FLASH_RECOVERY_AREA. I want to use the multipath disks namely /dev/multipath/sdb2, /dev/multipath/sdb3 and /dev/multipath/sdb4 for asm volumes. I created the multipath disks on node1 and edited the file /etc/sysconfig/oracleasm and set ORACLEASM_SCANORDER="multipath" and ORACLEASM_SCANEXCLUDE="sdb2 sdb3 sdb4". After a Reboot, the crs_stat shows On Node1 -------------------------------------------------------------------------------- Name Type Target State Host -------------------------------------------------------------------------------- ora....SM1.asm application ONLINE ONLINE linux1 ora....X1.lsnr application ONLINE ONLINE linux1 ora.linux1.gsd application ONLINE ONLINE linux1 ora.linux1.ons application ONLINE ONLINE linux1 ora.linux1.vip application ONLINE ONLINE linux1 ora....SM2.asm application ONLINE ONLINE linux2 ora....X2.lsnr application ONLINE ONLINE linux2 ora.linux2.gsd application ONLINE ONLINE linux2 ora.linux2.ons application ONLINE ONLINE linux2 ora.linux2.vip application ONLINE ONLINE linux2 ora.orcl.db application ONLINE ONLINE linux1 ora....l1.inst application ONLINE OFFLINE ora....l2.inst application ONLINE ONLINE linux2 ora....test.cs application ONLINE ONLINE linux2 ora....cl1.srv application ONLINE OFFLINE ora....cl2.srv application ONLINE ONLINE linux2 oracle@linux1 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 12:04:53 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> select name, path from v$asm_disk; select name, path from v$asm_disk * ERROR at line 1: ORA-01034: ORACLE not available I try to start the instance manually, oracle@linux1 ~$ srvctl start instance -d orcl -i orcl1 PRKP-1001 : Error starting instance orcl1 on node linux1 CRS-0215: Could not start resource 'ora.orcl.orcl1.inst'. Also from sql SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ORCL_DATA1/orcl/spfileorcl.ora' ORA-17503: ksfdopn:2 Failed to open file +ORCL_DATA1/orcl/spfileorcl.ora ORA-15077: could not locate ASM instance serving a required diskgroup On Node2 -------------------------------------------------------------------------------- oracle@linux2 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 11:56:13 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> select name, path from v$asm_disk; NAME -------------------------------------------------------------------------------- PATH -------------------------------------------------------------------------------- VOL1 ORCL:VOL1 VOL2 ORCL:VOL2 VOL3 ORCL:VOL3 Plz note, that I have the multipath devices only on one node currently. I am new to the multipathing concept. Plz advise, on what (above) steps are wrong and what additional things are to be taken care of. And the causes/solutions to the errors. Saurabh Sood on "error while addign a disk to asm diskgroup" http://www.forum.askdba.org/topic/error-while-addign-a-disk-to-asm-diskgroup#post-19 Fri, 12 Sep 2008 16:18:31 +0000 Saurabh Sood 19@http://www.forum.askdba.org/ Anu, 1. Does the disk appear under v$asm_disk? You can check it as: select group_number, name, path from v$asm_disk; 2. Is this a new LUN created? 3. Have you used asmtoolg to delete any existing lun ? If asmtoolg was used to delete any existing lun then it is mandatory to bounce the ASM instance and then try to add a lun from scratch. -Saurabh Sood anu.kmth on "error while addign a disk to asm diskgroup" http://www.forum.askdba.org/topic/error-while-addign-a-disk-to-asm-diskgroup#post-18 Fri, 12 Sep 2008 15:20:03 +0000 anu.kmth 18@http://www.forum.askdba.org/ 1. asmtool is listing the disks as shown below. -------------------------------------------------------------------- C:\oracle\product\10.2.0\db_1\BIN\BIN>asmtool -list NTFS \Device\Harddisk0\Partition1 25595M NTFS \Device\Harddisk1\Partition1 35998M NTFS \Device\Harddisk1\Partition2 33994M NTFS \Device\Harddisk2\Partition1 34994M NTFS \Device\Harddisk3\Partition1 34946M ORCLDISKASM0 \Device\Harddisk4\Partition1 1011M ORCLDISKASM2 \Device\Harddisk5\Partition1 1011M NTFS \Device\Harddisk7\Partition1 5122M ORCLDISKASM0 \Device\Harddisk9\Partition1 1004M ORCLDISKASM1 \Device\Harddisk10\Partition1 1004M ORCLDISKASM3 \Device\Harddisk10\Partition2 1004M ORCLDISKASM0 \Device\Harddisk10\Partition3 1004M ORCLDISKASM1040 \Device\Harddisk10\Partition4 1004M 2. When tried to add ORCLDISKASM1040 to existing ASm disk group following error is seen ----------------------------------------------------------- SQL> ALTER DISKGROUP disk_group_1 ADD DISK '\\.\ORCLDISKASM1040'; ALTER DISKGROUP disk_group_1 ADD DISK '\\.\ORCLDISKASM1040' * ERROR at line 1: ORA-15032: not all alterations performed ORA-15031: disk specification '\\.\ORCLDISKASM1040' matches no disks Please help/suggest on how to fix this.................................... Amit Bansal on "ASM not starting up after system reboot" http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-15 Fri, 29 Aug 2008 07:21:04 +0000 Amit Bansal 15@http://www.forum.askdba.org/ Cool!! Do update ASM alert log entry also in case issue does not resolve.. Amit Bansal on "ASM not starting up after system reboot" http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-14 Fri, 29 Aug 2008 07:14:36 +0000 Amit Bansal 14@http://www.forum.askdba.org/ Cool!! Do update ASM alert log entry also in case issue does not resolve.. nukavarapu on "ASM not starting up after system reboot" http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-13 Thu, 28 Aug 2008 17:58:04 +0000 nukavarapu 13@http://www.forum.askdba.org/ Thank You, Amit. I will check back with you after making that change. Amit Bansal on "ASM not starting up after system reboot" http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-12 Thu, 28 Aug 2008 08:00:14 +0000 Amit Bansal 12@http://www.forum.askdba.org/ Hi Satya, Looking at description for error ORA-2970 we see following <pre> oerr ora 29760 29760, 00000, "instance_number parameter not specified" // *Cause: The init.ora file did not contain a value for the instance_number // which is required to identify this instance to other instances of // the database running on the same cluster // *Action: Assign a value to the instance_number parameter in the init.ora // parameter file </pre> So it looks like the instance_number parameter is not specified. Or it could be that instance is not able to access the correct spfile. Is your ASM spfile on OCFS? If yes, can you check if it can access it. Cheers Amit nukavarapu on "ASM not starting up after system reboot" http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-11 Wed, 27 Aug 2008 19:06:55 +0000 nukavarapu 11@http://www.forum.askdba.org/ We have a 2 node prototype RAC cluster running on 2 nodes using iscsi and OCFS, ASM. After reboot of the 2 nodes ASM is giving the following error message. ORA-29760: instance_number parameter not specified Here is the result of crs_stat -t.. [oracle@satya dbs]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora....SRV1.cs application ONLINE UNKNOWN usha ora....cl2.srv application ONLINE UNKNOWN usha ora.orcl.db application ONLINE UNKNOWN usha ora....l1.inst application OFFLINE OFFLINE ora....l2.inst application OFFLINE OFFLINE ora...._taf.cs application ONLINE UNKNOWN usha ora....cl1.srv application ONLINE UNKNOWN satya ora....cl2.srv application ONLINE UNKNOWN usha ora....SM1.asm application ONLINE OFFLINE ora....YA.lsnr application ONLINE ONLINE satya ora.satya.gsd application ONLINE ONLINE satya ora.satya.ons application ONLINE ONLINE satya ora.satya.vip application ONLINE ONLINE satya ora....SM2.asm application ONLINE OFFLINE ora....HA.lsnr application OFFLINE OFFLINE ora.usha.gsd application ONLINE ONLINE usha ora.usha.ons application ONLINE ONLINE usha ora.usha.vip application ONLINE ONLINE usha Can you please advise me,what is missing here. thanks, satya