Questions tagged [oracle-asm]
Oracle ASM is a storage management solution for Oracle databases and clusters providing volume management and a filesystem,
64 questions
1
vote
1
answer
84
views
Is it safe to add a datafile to a tablespace while Oracle Database is running in production?
I have an Oracle Database running in a production environment, and it’s currently under load. I need to add a new datafile to an existing tablespace. Is it safe to do this operation while the database ...
- 13
1
vote
1
answer
406
views
It's possible share a disk between two diskgroups after limit the disk space in ASM?
I am not able to get a new disk in the moment and I was woldering if it's possible to share a disk between two diskgroup.
I have a FRA diskgroup with a disk of 200gb and I need to add 100gb in DATA ...
- 871
0
votes
1
answer
258
views
Oracle RAC 18c Patching - datapatch
After patching GI Home and DB Home simultaneously using command:
.oraenv
+ASM1
opatchauto apply /patchlocation
Should i run ./datapatch from DB home or GI home? Or it doesn't matter from which home? ...
- 144
0
votes
1
answer
3k
views
Changing the grid listener port of an Oracle Database Appliance X8-2M
I need to add an extra Port: 1522
Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/xxxx/listener/alert/log.xml
Listening ...
- 1,078
0
votes
1
answer
994
views
ORACLE ASM present one or more LUNs?
I have the following question regarding the allocation of disks or LUNs to ASM in Oracle, specifically, I have an Oracle 18c DB in Cluster and I have created several diskgroups, now, I need to ...
- 169
0
votes
1
answer
2k
views
ASM trying to mount droped diskgroup
In my envoriment I am getting the following erro:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "OCR" cannot be mounted
ORA-15040: diskgroup is incomplete
The problem is: I already ...
- 871
1
vote
2
answers
1k
views
RMAN restoring datafile out of ASM
Why is RMAN restoring the datafiles out of ASM and how to restore a backup into ASM?
Here is one output. The tablespace triscaltb was restored in /u01/app/oracle/product/12.1.0/dbhome_1/dbs/...
- 871
2
votes
2
answers
8k
views
Oracle 19c GI Install on OL7 : ASM disks stamped via AsmLib not getting discovered via GridSetup.sh
I am trying to install GI 19c on Oracle Linux 7 (required for 19c), and have used AsmLib to try to achieve device persistence (owner,group) for ASM devices/disks. Prior to that I used udev rules for ...
- 21
0
votes
4
answers
1k
views
Need to choose ASM performance for production database
We have a 1.5 TB of data (nonasm) and we plan to move into ASM by choose normal redundancy.
Normal Redundancy ==> Two Way Mirroring , So we need 3TB data storage for 1.5TB data including mirroring(...
0
votes
1
answer
61
views
RMAN or Fresh install
I'm trying to reduce the time to install Oracle on a pipeline we have. At the moment, it's installed using dbca in silent mode with a database template file. The majority of the time seems to be ...
- 679
2
votes
3
answers
3k
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 ...
- 109
1
vote
1
answer
3k
views
Flash Recovery Area full
I have oracle 11g that runs on Linux serve.
I have a Flash Recovery Area, I backup my archive logs to another location.
presently I have very little space left in my Flash Recovery Area (FRA) thereby ...
- 21
0
votes
1
answer
2k
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 (...
- 1,569
0
votes
1
answer
2k
views
Oracle asm disk string profile string vs param string
Oracle Database ASM disk string profile string vs param string ?
ASMCMD [+] > dsget
profile: /dev/disk*
parameter: /dev/disk*
Do we need to set both of them ?
what is consequence of setting one in ...
- 194
1
vote
1
answer
1k
views
Map ASM files to physical Linux Devices
We are having problems with log file sync waits periodically. We have a 2 node RAC cluster using ASM. I'd like to monitor the physical device(s) containing the REDO log files using iostat, but I'm ...
- 279
-1
votes
1
answer
365
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 ...
- 1,910
0
votes
1
answer
145
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 ...
- 1,910
1
vote
1
answer
476
views
Is there any trick to Resize LVM online that raw by UDEV rule without filesystem?
Here is the Logic Volume for example:
lvcreate -L2G -n Lv_OraD1 vg_db
lvcreate -L180G -n Lv_OraD2 vg_db
lvdisplay /dev/mapper/Lv_OraD*
UDEV rule to raw the LV:
vi /etc/udev/rules.d/60-...
0
votes
1
answer
2k
views
How is the password file accessed when it's on an ASM diskgroup and required to connect to ASM?
When a RAC is turned on, it will try to accessing the OCR registry which is located on ASM.
ASM also holds the asm password file.
However to open ASM, it needs to access the password file.
If the ...
- 1,875
3
votes
2
answers
13k
views
Unable to turn off automatic memory management (AMM)
i am running oracle 11.2.0.4 SE RAC on Red Hat linux 6, the database is using ASM for datafile management
i have been experimenting with turning on AMM and set the following parameters
alter system ...
- 572
0
votes
1
answer
5k
views
oracle cannot start
I have oracle database 11.2.0.4 on oracle linux 6.7 .
I have install oracle database single instance with asm option .
I have 2 users : oracle and grid
My database is open and all of things are ...
- 216
1
vote
2
answers
6k
views
ASM 12c compatibility
Can I use ASM 12c version with database 11g? This link and MOS Doc ID 337737.1 says I cannot use 12c version of ASM with a lower database version. Am I right? Or is it otherwise?
- 1,910
5
votes
1
answer
1k
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 ...
- 216
0
votes
1
answer
192
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 ...
- 216
0
votes
1
answer
1k
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 ...
- 15