If you add disk to a mirrored disk group, then you should add disk in pairs. If you add an odd number of disks to the disk group, the data cannot be mirrored. Your command to add the disk to the diskgroup looks correct to me. You specified the failure group for each disk to b...
Oracle Server - Enterprise Edition Version: 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2 步骤如下: 1)Create a XML file (e.g. diskgroup.xml) with the next code: <dg name="datadg" redundancy="normal"> <fg name="SAN1"> <dsk string="ORCL:ASMDISK1"/> <dsk string="ORCL:ASMDISK2...
The present document provides a clear example about how to rename an ASM diskgroup on release 11gR2. Solution 1) First of all, the desired diskgroup needs to be dismounted (from each node if this is a RAC configuration): # asmcmd umount DATA 2) Verify that the desired d...
One ASM DISK GROUP contains all of the available disks of the server. Need to re-configure the current DISK GROUP to break it down into three different ASM disk groups. 注意事项: 1). A DISK GROUP with single disk is possible only if the redundancy of diskgroup is EXTERNAL. 2). We can...
One ASM DISK GROUP contains all of the available disks of the server. Need to re-configure the current DISK GROUP to break it down into three different ASM disk groups. 注意事项: 1). A DISK GROUP with single disk is possibleonly if the redundancy of diskgroup is EXTERNAL. ...
This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. 2.关闭日志应用SQL> select name,DATABASE_ROLE,SWITCHOVER_STATUS from v$data...
2.绑定ASM磁盘 [root@danaly data1]# /etc/init.d/oracleasm createdisk VOL5 /dev/cciss/c0d0p10 Marking disk "/dev/cciss/c0d0p10" as an ASM disk: [ OK ] [root@danaly data1]# /etc/init.d/oracleasm createdisk VOL6 /dev/cciss/c0d0p11 ...
Then, it is required to change ASM datafile names accordingly with new database name. RMAN backup copy doesn't work in this case as file still remains in the same diskgroup.SolutionSign In To view full details, sign in with your My Oracle Support account. Register Don't have a My ...
You can use alter tablespace command to extend tablespace in Oracle: SQL> alter tablespace RAIDDATA add datafile 'FILE_LOCATION' size 100m autoextend on maxsize 31G; Note: You can find file location from the 1st query as mentioned above. In case of ASM, use diskgroup name as a file loca...
perform the rolling migration but communicates with all the ASM instances in the cluster.This command informs the other ASM instances of RAC that it is preparing to perform an upgrade.Once the rolling migration is enabled ,you can query each ASM instance to view current state of the ASM; ...