AskDBA.org Forum » Forum: Automatic Storage Management

AskDBA.org Forum » Forum: Automatic Storage Management - Recent Topics http://www.forum.askdba.org/ Forum for Oracle DBA's en Sun, 12 Feb 2012 10:32:03 +0000 daniesh on "register standby database in recovery catalog." http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-184 Thu, 07 Oct 2010 17:27:36 +0000 daniesh 184@http://www.forum.askdba.org/ Hi, Can we register the standby database in recovery catalog. I know that if the catalog database is same for both the standby and primary then both will have same dbid and we can use unique dbid. However in our case, Catalog is different for primary and standby whenever i try to register the standby database. I am getting the below error. RMAN> register database; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of register command at 10/07/2010 18:26:04 RMAN-08040: full resync skipped, control file is not current or backup Can you please let me know your view on this? Thanks in advance. 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. bhatia.ish@gmail.com on "What are the pre-requisites of ASM on AIX 6.1?" http://www.forum.askdba.org/topic/what-are-the-pre-requisites-of-asm-on-aix-61#post-164 Tue, 22 Jun 2010 11:29:28 +0000 bhatia.ish@gmail.com 164@http://www.forum.askdba.org/ Hi, What are the pre-requisites of ASM on AIX 6.1? Regards, Bhatia daniesh on "PKRS-1009 failed to start ASM instance" http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-97 Mon, 12 Oct 2009 06:01:09 +0000 daniesh 97@http://www.forum.askdba.org/ Hi , I have installed RAC on AS-4 platform. cluster and database s/w is installed successfully however when i try to install ASM i am getting an following error. PKRS-1009 : failed to start ASM instance. CRS-1005: failed to get required resources. CRS:0223: node 1 has placement erro. could you please help me on this? Thanks, 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. daniesh on "asmcmd register" http://www.forum.askdba.org/topic/asmcmd-register#post-90 Mon, 21 Sep 2009 13:56:02 +0000 daniesh 90@http://www.forum.askdba.org/ Hi, Is there anyway to register a database using asmcmd command? lata on "asm tool" http://www.forum.askdba.org/topic/asm-tool#post-35 Thu, 20 Nov 2008 07:44:37 +0000 lata 35@http://www.forum.askdba.org/ what is asm tool and how to use it 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.................................... 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 nsayyappan on "ASM installation" http://www.forum.askdba.org/topic/asm-installation#post-4 Mon, 21 Jul 2008 18:29:57 +0000 nsayyappan 4@http://www.forum.askdba.org/ Are there any quick installation guide for ASM on rac on AIX