RAC & Failsafe :: ORA-15077 / Could Not Locate ASM Instance Serving Required Diskgroup

Oct 7, 2013

When I try to start the database or ASM instance its showing the following error.

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+FLASH_RECOVERY_AREA/XXXXX/spfileXXXXX.ora'
ORA-17503: ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA/XXXXX/spfileXXXXXX.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>

when am trying to view the data's by below Sql its show name as null for FLASH_RECOVERY_AREA. so I couldn't even set compatible ATTRIBUTE

SQL> select NAME , COMPATIBILITY, DATABASE_COMPATIBILITY from V$ASM_DISKGROUP;
NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------- ---------------------- -----------------------------------
RUBIKON_DATA 10.1.0.0.0 10.1.0.0.0

SQL> show parameter asm_disk
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string RUBIKON_DATA, FLASH_RECOVERY_A
REA
asm_diskstring string /dev/mapper/Rubikon_data1, /dev/mapper/Rubikon_data2, /dev/mapper/Rubikon_fb

because of name is null mount mode as CLOSED and HEADER_STATUS as INCOMPATIBLE.

SQL> select name, mount_status, header_status,mode_status,state, path from v$asm_disk ;
NAME MOUNT_S HEADER_STATU MODE_ST STATE PATH
-------------- ------- ------------ ------- -------- -------------------------
CLOSED INCOMPATIBLE ONLINE NORMAL /dev/mapper/Rubikon_fb
RUBIKON_DATA_0000 CACHED MEMBER ONLINE NORMAL /dev/mapper/Rubikon_data1
RUBIKON_DATA_0001 CACHED MEMBER ONLINE NORMAL /dev/mapper/Rubikon_data2

View 1 Replies


ADVERTISEMENT

Automatic Storage Management :: Diskgroup With Normal Redundancy One Disk Is Failed Then 2nd Instance Down

Mar 27, 2013

My cluster have two node.Data diskgroup uses normal redundancy.Priamry disks are located in one storage.Fail group disks are located in another storage.When we close the failgroup disks' storage the 2nd instance restart.After automatically restarted everything goes well.I want to know why does the 2nd instance restart?Is it normal?

View 2 Replies View Related

RAC & Failsafe :: ORA-29760 - Instance Number Parameter Not Specified?

May 7, 2012

I am getting above error when i ma starting my rac data guard on linux. i specify instance number but still its asking

this is my pfile

timsdr1.__db_cache_size=4345298944
timsdr2.__db_cache_size=4395630592
timsdr2.__java_pool_size=33554432
timsdr1.__java_pool_size=33554432

[code]...

View 3 Replies View Related

RAC & Failsafe :: Single Instance - Migration To Database

Oct 20, 2010

2 Database.

TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

View 4 Replies View Related

RAC & Failsafe :: ASM Instance Not Started On Node 2 In Clusterware

Jan 11, 2011

i am configuring asm on clusterware when i create instance on node1 and node 2 a message screen appear " Cant start asm instance on node 2)When i start asm instance manually on node 2 i found the below error in alert log file.

ORA-27508 IPC error sending a message
ORA-27300 OS system dependent operation:send msg failed with status: 101
ORA-27301 OS failure message: Network is unreachable
ORA-27302 failure occurred at: sskgxpsnd1

View 3 Replies View Related

RAC & Failsafe :: Rac.vip.lsnr Instance Shutdown And Restart Itself?

Jul 7, 2011

'm using oracle rac 10.2.0.4.0 with 3 node and os SLES 10 sp 3 in early days we get error vip and lsnr service on my rac shutdown n restart itself,what happen to my rac ?

View 1 Replies View Related

RAC & Failsafe :: Database Instance Using Srvctl Command

Aug 13, 2013

Would there be any issue in application and database when i down RAC database instance using below srvctl command ?

srvctl stop instance -d DB -i DB1
srvctl start instance -d DB -i DB1

View 18 Replies View Related

Backup & Recovery :: ORA-00265 / Instance Recovery Required - Cannot Set ARCHIVELOG Mode

May 28, 2008

I need to make my database to ARCHIVELOG mode when i try it it gives below following error

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

View 9 Replies View Related

RAC & Failsafe :: Hierarchy To Stop And Start Oracle RAC Instance

Apr 20, 2013

What is the hierarchy to stop and start oracle RAC instance ?

View 10 Replies View Related

RAC & Failsafe :: Query On Dependency Between Database Instance And Service?

Jul 8, 2013

suggest on the dependenecy between the database service and the database instance?

srvctl start instance -i db1
will this start service as well for which the above instance is either preferred or available instance?
will it start the listener as well?

srvctl stop instance -i db1
will this stop service as well for which the above instance is either preferred or available instance?
will it stop the listener as well?

srvctl start service -d db -s dbserve
will this start service as well for which the above instance is either preferred or available instance?

srvctl stop servive -d db -s dbserve
will this stop service as well for which the above instance is either preferred or available instance?

srvctl start database -d db
will it start instance, listener and service as well?

srvctl stop database -d db
will it stop instance, listener and service as well?

View 1 Replies View Related

RAC & Failsafe :: Can't START Instance After Apply Critical Patch And Reboot

Apr 21, 2011

This is 2 node RAC database. Usually every month my system admin was applying OS critical patch then reboot the server.

While doing this activity i have stop all CRS and DB services. As usual i have did same in both the nodes and applied the patch and reboot the server.

After tried to start the CRS service and database services was used the following command. Except node1 instances all services are started.

E:oraclecrsproduct11.1.0crsBIN>crs_Stat -t
Name Type Target State Host
------------------------------------------------------------
ora....main.db application ONLINE ONLINE inf-...b-03
ora....n1.inst application ONLINE OFFLINE
ora....n2.inst application ONLINE ONLINE inf-...b-04
ora....SM1.asm application ONLINE ONLINE inf-...b-03

[code].....

Then i have tried to applied to old ocr backup also, then also i am getting same error.

View 1 Replies View Related

SQL & PL/SQL :: Locate Occurrence Of Symbols Combination

Aug 5, 2011

My need is to locate an occurrence of symbols starting from "s." (non-capital letter), following by word (with any capital letter at the beginning) and ending with ", " (comma and space symbols).

Ex:

select 'jeklghje, s.Glkgje, u.slgjwek, 904869' as tt from dual union all
select 's.Tklgj, u.slgjwek, 23578, elslgjs' as tt from dual union all
select 's.klgj, u.ekgjes, 238573, dlsjkgj' as tt from dual

I'm looking for occurrence of "s.Glkgje, " and "s.Tklgj, ".

I think some combination of REGEXP_INSTR and REGEXP_SUBSTR should be useful, but I'm not familiar with these functions so good yet.

View 7 Replies View Related

Forms :: FRM-47109 - Cannot Locate Image File In Oracle 10G

Dec 17, 2009

below is my scripts for image loading from file to form and save it to database.it is located in when-button-pressed trigger.

Declare
v_file_name VARCHAR2(255);
v_msg varchar2(100);
BEGIN

[Code].....

View 3 Replies View Related

Data Guard :: Possible To Use Dataguard From Single Instance To RAC Instance?

Jul 1, 2010

Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?

View 1 Replies View Related

Server Administration :: How To Get Disk List On Any DB Instance That Uses ASM Instance

Mar 16, 2011

My context on our servers is the following one:

- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks

On each DB instance you can see:

- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view

So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?

View 6 Replies View Related

How To Get I / O Statistics On ASM Diskgroup

Jan 21, 2011

How can we check the I/O statistics on a ASM diskgroup?

Do we have any command which can be run @ sqlplus prompt after logging into the asm instance?

What steps can we take to increase the Read speed and the write speed on the ASM diskgroup.

View 1 Replies View Related

ASM Diskgroup Is Dismounted Alone

Sep 8, 2011

The ASM Diskgroup DATA is dismounted automatically. I can mount the DATA Diskgroup again, but again is dismounted.

The RDBMS instance (XA21) is started along 5 minutes and then is shutdown, until I mount the diskgroup with problems, again

The Oracle version installed is 10g Standard Edition with ASM option, in Windows 2003 Server Standard Edition.

The alert log XA21 (RDBMS) instance, said:

Errors in file e:\cots\oracle\product\10.2.0\admin\xa21\bdump\xa21_lgwr_3108.trc:
ORA-00345: redo log write error block 12257 count 2
ORA-00312: online log 1 thread 1: '+DATA/xa21/onlinelog/group_1.258.681415491'
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-00345: redo log write error block 12257 count 2
ORA-00312: online log 1 thread 1: '+DATA/xa21/onlinelog/group_1.259.681415495'
ORA-15078: ASM diskgroup was forcibly dismounted

ORA-00202: control file: '+DATA/xa21/control01.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DATA/xa21/control01.ctl
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup

The alert log +ASM instance, said:

ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).

I tried to resolve a physical error in file systems, with CHKDSK tool, unsuccessfully.

What can I do, using Oracle Tools?

Attached File(s)

 alert_xa21.zip ( 6.4K )
Number of downloads: 0

 alert__asm.zip ( 2.87K )
Number of downloads: 0

View 2 Replies View Related

ASM Diskgroup Creation Failed

Apr 12, 2011

i am trying to create the ASM diskgroup means it's giving the below error.

[root@racdb3 ~]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb6
Marking disk "VOL1" as an ASM disk: [FAILED]

View 4 Replies View Related

Exadata :: Resize ASM Diskgroup

Oct 9, 2012

My exadata quarter rack machine has two asm diskgroups, DATA1 with 5TB and RECO with 3TB. I'd like to resize RECO to 1TB and DATA1 to 7TB.

I know ALTER DISKGROUP RESIZE command, but my question is about resize RECO volume from 3 to 1 TB: is it supported by Oracle?? Let me know risks /issues with this resize?

View 2 Replies View Related

ASM Diskgroup Creation Failed Using Two Node

Mar 19, 2012

A am new in RAC configuration.I configuring RAC with ASM diskgroup with the external redundency. So now i am facing problem to mount the ASM diskgroup. I am giving the the RAC configuration description below.

1. using two node rac1 and rac2

2. asm disk configuration 3 drive
/dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3
on both node

3. and i am using vmware to configure the both node asmdisk group

after configuring the os level and oracle clustring , i run dbca to configure asm disk group..so in the create disk screen i have found my previous create 3 disks

/dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3

so first two disks

/dev/raw/raw1
/dev/raw/raw2

i named it "dg1" then press ok , when i pressed ok a warring is appear that is "could not mount the diskgroup on remote node on rac2 using the connection service rac2:1521:+ASM2. Ensure that the listener is running on this node and the asm instance is registred to the listener. Receive the following error:

ORA-15032 : not all alterations performed
ORA-15063 : ASM discovered insufficient number of disk for diskgroup "DG1"

as the same way i create another diskgroup "fg" for flash recovery area using disk /dev/raw/raw3

so after creating the two diskgroup i saw the two diskgroup is appere in the "diskgroup appere screen" an saw that only one diskgroup is mounted but not second node i.e. rac2 diskgroup is not mounted . What should i do no .

View 2 Replies View Related

Server Administration :: How To Add Disk To ASM Diskgroup

Jun 7, 2011

Resize or add disk in ASM.

- The storage has partitions like:
- And now, the size of ASM disk was full

Because I've not ever done for adding disk to diskgroup.

Step 1- Format the storage, add partitions (I will create 4 partitions of 120gb, 1 partitions 60gb, 1 partitions 27gb).

Step 2- Add the rawdevice in /etc/sysconfig/rawdevices.In the picture here, I'll not just add rawdevice in /etc/sysconfig/rawdevices. So I'll do:

add lines in /etc/sysconfig/rawdevices

/dev/raw/raw7 /dev/cciss/c0d1p9
/dev/raw/raw8 /dev/cciss/c0d1p10
/dev/raw/raw9 /dev/cciss/c0d1p11
/dev/raw/raw10 /dev/cciss/c0d1p12
[code]....

how to do continue after step 5.

View 5 Replies View Related

Server Administration :: ASM Diskgroup Resize?

Sep 19, 2012

I've been ASM quite a while. I've two diskgroups extdg and nordg which are of external and normal redundancy respectively. Total diskgroup size is 9G, usuable space came down to 3mb when i tried to resize it to itz maximum. the value under usable column shows the same.

FYI... i've totally three disks in nordg, two in one failgroup and one in another.The disk sized equally 3g each.

Quote:
NAME TOTAL_MB FREE_MB USABLE_FILE_MB
------------------------------ ---------- ---------- --------------
EXTDG 2047 1995 1995
NORDG 9201 3073 3

The command i used to resize all disk to their max is Quote:SQL> alter diskgroup nordg resize all size 3067M;

View 3 Replies View Related

Server Administration :: Switch Between Disks In A Diskgroup?

Aug 31, 2011

I have an Oracle database 11.1.0.6 with ASM storage.

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

There is a disk group named +FRA which has only 1 disk (call it disk 0 for later references).

+FRA disk group is in type of EXTERNAL redundancy

I'd like to add another disk to +FRA disk group and copy all files stored in disk 0 to the new disk (call it disk 1 for ex.), then take off disk 0 (not use for +FRA disk group any more).

Expected result: there is only one disk 1 left in the +FRA disk group, with all the data from disk 0 and keep their original file names

View 5 Replies View Related

Separate ASM Diskgroup For Online Redo Logs

Sep 25, 2013

Version: 11.2.0.3Platform : Solaris 10   

One of  the Hitachi support guy has suggested to create a separate disk group for Online redo logs. His rationale was that ORLs was write only files and it would be better to put in a separate disk group.

View 6 Replies View Related

How To Move Spfile On Default Local Filesystem To ASM Diskgroup

Jul 1, 2012

What is correct way to move the default oracle spfile to ASM diskgroup so i can successfully bring up the instance . After bring up the instance , it should point to ASM diskgroup. My oracle database 11.2.0.3 is siting on sun solaris 64 Bit.

View 8 Replies View Related

RAC/ASM Clusterware Installation :: GI Gives Error While Executing Root.sh For ASM Diskgroup?

Oct 4, 2012

We are implementing a 2 node RAC configuration with ASM on vmware and openfiler on LINUX RHEL 6.2. We started our installation with grid infrastructure. While executing root.sh on node 1 it gives error diskgroup cannot be mounted and no alterntions perfomed as below.

+[main] [ 2012-10-04 05:38:33.150 PDT ] [UsmcaLogger.logException:173] SEVERE:method oracle.sysman.assistants.usmca.backend.USMDiskGroupManager:mountDiskGroups+
+[main] [ 2012-10-04 05:38:33.151 PDT ] [UsmcaLogger.logException:174] ORA-15032: not all alterations performed+
ORA-15017: diskgroup "CRS" cannot be mounted

[code]...

View 1 Replies View Related

Server Administration :: How To Assign Size For Disks In Diskgroup

Mar 3, 2012

you have given 500gb of harddisk. how will u implement the size or how to assing the size for disks in the diskgroup.give me the best practice that is used in production

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

Multiplexing Redo Logs And Control Files To Separate Diskgroup In ASM

Mar 1, 2011

I've been using ASM for a few years now and have always installed a new system with 3 diskgroups

+DATA - for datafiles, control files, redo logs
+FRA - for achive logs, flash recovery. RMAN backup

Those I guess are the standards, but I've always created an extra (very small) diskgroup, called +ONLINE where I keep multiplexed copies of the redo logs and control files.

My reasoning behind this is that if there are any issues with the +DATA diskgroup, the redo logs and control files can still be accessed.

In the olden days (all those 5 years ago!), on local storage, this was important, but is it still important now? With all the striping and mirroring going on (both at ASM and RAID level), am I just being overtly paranoid? Does this additional +ONLINE diskgroup actually hamper performance? (with dual write overheads that are not necessary)

View 4 Replies View Related

Server Administration :: Configure Archivelog Stored Inside ASM Diskgroup

Sep 16, 2011

I'm new on 11g, due to my limit storage with mounted internal disk, so I think, may I can store archivelog in ASM without FRA? However, I did not find any document to verify.

View 5 Replies View Related







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