Oracle Server - Enterprise Edition - Version: 11.2.0.0 and later [Release: 11.2 and later ] Oracle ASM Configuration Assistant (ASMCA) can be used in silent command-line mode. ASMCA supports only alias-based (net service name based)
-- Suppose that the database instance name is "osmdr"-- In the database instance When trying to create a new spfile from a pfile under sqlplusSQL> create SPFILE='+DATA/osmdr/spfileosmdr.ora' from pfile='/home/oracle/osmdr.init';File
We have introduced three new functionalities to the ASMCMD utility to improve node recovery after a crash,repair bad blocks on a disk, copy files and simplify the listing of ASM disks in a diskgroup ASMCMD is also extended to include
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 This article will show how to display in dbconsole, information for the ASM instance used by the database. This is particularly usefull if:(1). The database and ASM
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
1) Please backup the database(s) contained inside the associated diskgroup.2) Then shutdown the databases contained inside the associated diskgroup.3) Dismount the associated diskgroup to verify no client database connections are accessing this
This operation will DESTROY any databases that are currently running on the +ASM instance 1) Shutdown all databases that are running on the box using the +ASM instance for storage management2) Use emca -x <sid> to remove the Database
rename diskgroup option is a new feature of 11gR2 . The command renamedg was introduced in 11gR2; however, there are many cases where a diskgroup in a 10g or 11.1 environment needs to be renamed. You can use this tool to rename your
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
If all you are doing is changing the name of the disk, then the only thing that should be necessary from Oracle's perspective is to change the ASM_DISKSTRING parameter on the ASM instance. Alternatively, you may be able to just rename or
之前做的一個實驗: RAC 修改 ASM執行個體名 的步驟 http://blog.csdn.net/tianlesoftware/archive/2011/03/25/6275827.aspx The following procedures do require some down time. One node at a time, we will shutdown all database instances that store their
Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later [Release: 11.1 and later ] The purpose of this note is to provide insight on how space allocation ( v$asm_file.space column ) in ASM can be calculated depending on Allocation
Oracle Server - Enterprise Edition - Version: 11.2.0.2 to 11.2.0.2 - Release: 11.2 to 11.2 you cannot create more than 1 voting disk in the same or on another/different diskgroup disk when using External Redundancy in 11.2. The rules are
Sometimes it can happen that the ASM contains empty system directories which cannot be removed. According to Note 3751057.8(ALTER DISKGROUP DROP DIRECTORY FORCE removes system aliases) the system generated directories should be removed
This document describes how to prepare your storage sub-system before you configure Automatic Storage Management (ASM). When preparing your storage to use ASM, first determine the storage option for your system and then prepare the disk