Questions tagged [oracle-asm]

Oracle ASM is a storage management solution for Oracle databases and clusters providing volume management and a filesystem,

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
1answer
685 views

Oracle ASM vs RAID 10

I have oracle ASM 11gR2 on oracle linux 5.8 and i want to install oracle database. I have some disks and i want to use the redundancy strategies of oracle ASM or RAID 10 . I do not know which one is ...
2
votes
2answers
1k views

Empty v$asm_diskgroup with sqlplus

I have an Oracle Database instance installed under an OL7. It is a 12c2. Oracle GI also installed and my database has some files stored in ASM. I am using sqlplus to connect to the database instance ...
1
vote
0answers
107 views

RMAN corrupts passwordfile

please, can you clarify this? My configuration is RAC 12c on ASM on SLES 11 SP 4 on SystemZ. The nodes rac11 and rac12 are the server nodes of the primary database, named "primdb", uniq_name is "...
1
vote
1answer
34 views

Migration query - Oracle

I have two physical servers, hosting 6 two node RAC databases running in 11.2.0.3 version (both grid and database). I'm told to have the grid software in 11.2.0.4 version and the databases in the ...
1
vote
1answer
46 views

ASM and IPv6 Compatibility

In the whitepaper mentioned below, Under 'Limitations' it says ASM and fan based notifications are not supported by IPv6 in Oracle. I'm just curious what ASM has to do with ipv4 or ipv6 or ipv4? ASM ...
0
votes
1answer
85 views

Dataguard the datafiles are created in another diskgroup

I have a recently made physical dataguard configuration and everything works correctly so far, but I've noticed that the datafiles that are created in the primary are created in the standby in a ...
0
votes
1answer
1k views

Oracle ASM: Freeing up space

Oracle RAC 11.2 with asm storage, all type = EXTERN redundancy. I've been cleaning up some tablespaces and shrinking datafiles back down to sizes that they're not likely to grow much larger than (...
0
votes
0answers
454 views

Dropping database in RAC

I need a drop a database which is a 2 node RAC configuration and I will also be drooping the disk groups as well completely. What is the right way to drop the database + diskgroups? Will it be ok to ...
0
votes
0answers
564 views

ASM Query on Diskgroups

Platform - RHEL. Database - 11.2.0.3. I have a diskgroup name TEST with AU as 1. I need to have the diskgroup with AU as 4 therefore I decided to drop the existing DG and recreate the new one with ...
0
votes
1answer
81 views

Query on Asmlib

I have Oracle Linux running on vmware hosting an Oracle database with ASM (single instance). There isn't any operating system device persistence and therefore whenever my OS reboots, the disk number ...
0
votes
1answer
95 views

Backup files not found in ASM

I have an Oracle database 11gr2 and I have installed Oracle Grid on Oracle Linux 5.9. I have two disk groups. /etc/init.d/oracleasm listdisks : flash_recovery_area DATA The first disk group is ...
0
votes
1answer
206 views

Cannot install Oracle Grid on Oracle Linux 6.4

I have an Oracle database 11gr2 and I want to install Oracle Grid on Oracle Linux 6.4. At first, I have installed Oracle Grid with the tutorial on this website: https://eudba.wordpress.com/2012/08/...
0
votes
0answers
8k views

ASM drop disk hangs (STATE DROPPING)

I have added disk into the RAC system by the following way: I have disk /dev/sdh1. Marked it as an ASM disk: --On node 1 oracleasm createdisk DISK7 '/dev/sdh1'; --On node 2 oracleasm createdisk ...
-1
votes
1answer
538 views

ASM Space Usage

Oracle Version: 12.1.0.2 I had about 100 GB freespace on my +ASM diskgroup on Friday. When I came back on Monday, I see only 45 gigs. How can I find what consumed my space? Or is there a SQLPlus ...
-1
votes
2answers
338 views

ASM Diskgroup Creation Issue

I have 6, two node RAC databases running in the two physical servers. While I try to create new diskgroup, I get the following error: ORA-15018: diskgroup cannot be created ORA-04031: unable to ...
-1
votes
1answer
224 views

ASM Query - Oracle 11gR2

I have two node RAC servers hosting 4 databases running on 11.2.0.3 version in RHEL OS. The underlying LUNs assigned to the ASM is not currently multipathed, meaning the disk sequence would change ...