Oracle ASM is a storage management solution for Oracle databases and clusters providing volume management and a filesystem,
5
votes
1answer
464 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). ...
4
votes
1answer
336 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 ...
4
votes
0answers
162 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 ...
2
votes
2answers
593 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 ...
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
...
1
vote
1answer
372 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 ...
1
vote
0answers
87 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 ...
