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

learn more… | top users | synonyms

0
votes
2answers
38 views

Is using ASM a pre-requisite for RAC?

I am about to build our first RAC development environment, and as I'm new to RAC and have not used ASM I wanted to keep things as simple as possible. I was under the impression that ASM is a ...
0
votes
1answer
20 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
30 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: ...
0
votes
1answer
43 views

ASM File System type

What is the underlying file system in ASM if exists? I have gone through many sites but neither of them answers my question directly rather each site I visisted raises a different point like 'ASM uses ...
0
votes
0answers
42 views

Problem in ASM starting

iam working on wondows7 and oracle 11.2.0 this is my standalone system as i want to setup the ASM as i haeve createdthree logical Disk and ihave created parameter file for ASM but at the time of ...
1
vote
1answer
120 views

du of directories in a diskgroup in Oracle ASM

In Linux, you could run the below on a directory to find the size of each sub-directory: du -sh * When you're in asmcmdin the +FRA disk group for example, how can I retrieve the size of each ...
0
votes
2answers
49 views

Reinstall Oracle 11G2

Running Oracle 11GR2 instance (non-ASM). Plan to set it up again from the scratch(this time using ASM, Grid infrastructure). And I need the present database. I am thinking of the simple plan: 1) ...
0
votes
1answer
112 views

Striping IO with datafiles on different physical mounts

I have a server with three directly attached disk controllers. Each of these can provide internal redundancy and IO-striping accross disks, but I'm wondering what is the best way to configure the ...
0
votes
2answers
7k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
0
votes
0answers
3k 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 ...
0
votes
1answer
167 views

Kerne module for Oracle 11gR2 RAC on Linux

As per Oracle, it requires three Linux packages to run ASMLib: oracleasm - kernel module oracleasmlib-2.0 - ASMLib libraries oracleasm-support-2.0 - Admin for ASMLib This library versions are OS ...
0
votes
1answer
1k views

determine redo log size, number of redo log files

Having 2 node RAC instance using ASM Log switches happening are too high about 100 per hour causing db to hang for few minutes sometimes GROUP# THREAD# MEMBER ...
1
vote
1answer
323 views

Migrating a tablespace to a different database on the same ASM

How might one go about copying or moving tablespaces between databases that uses the same ASM instances? Might it be possible to cut some corners in RMAN or have ASM remap files belonging to a ...
0
votes
2answers
962 views

How restore from ASM to a new server?

We have a machine that crashed completely. The ASM disks are fine. Is it possible to mount the old ASM disks to a new machine and then restore the datafiles/redo files/ control files/everything to ...
2
votes
1answer
26k views

How to monitor space usage on ASM diskgroups

Last night the recovery area on one of our Oracle Database Appliances went full. This was reported in one of the database alert logs, and we were able to clear out some space before the next log ...
3
votes
2answers
10k views

Add additional disks to FRA diskgroup in ASM

We're running Oracle 11.2.0.3 with a two node RAC and our FRA diskgroup is running low on space. I need to allocate some more disks to it through ASM. I'm not sure how to go about doing this. I can ...
4
votes
2answers
2k views

How many control files should I have?

On the Oracle Database Appliance, the default deployment only gives you a single control file. I find this a little puzzling. The single control file causes a policy violation in the automatically ...
1
vote
3answers
14k views

Shutdown one node in RAC

I want to shutdown one node in RAC. I did the following steps: Shutdown database instance export ORACLE_SID=mydb1 sqlplus / as sysdba shutdown immediate; shutdown ASM instance . oraenv +ASM1 ...
3
votes
1answer
454 views

ASM diskgroup drop from another ASM instance

I have created long time back one ASM RAC setup and I created one diskgroup with some name say xyz. I think that instance is gone but the diskgroup was not dropped exclusively using command: drop ...
1
vote
0answers
201 views

Oracle ASM failover strategies

I inherited a production system with the following setup: Disk A, Failgroup AB Disk B, Failgroup AB Disk C, Failgroup CD Disk D, Failgroup CD Diskgroups AB and CD are configured with normal ...
5
votes
1answer
815 views

How do I have Oracle ASM scan for and repair uncorrectable ECC errors (bad sectors)?

I'm running Oracle ASM (11gR2) with normal redundancy on SATA disks (WD Raptors). This is on a physical standby database, if it matters. Occasionally, disk sectors develop read errors (ECC failures). ...