Oracle ASM is a storage management solution for Oracle databases and clusters providing volume management and a filesystem,
1
vote
1answer
425 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 ...
2
votes
2answers
641 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
344 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
2k 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
...
4
votes
0answers
164 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
88 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
465 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). ...
