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
39 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
72 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
1answer
2k 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
874 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
122 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
503 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
144 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
426 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 ...
1
vote
1answer
11k 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
6k 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
1answer
1k 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
8k 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
319 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
169 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
674 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). ...