其他

        This note explains how to use RMAN to copy an ASM based datafile onto the file system. Once the datafile is on the file system, the OS command dd can be used to extract the block(s) from the datafile. -- 注意，用dd 命令修複壞塊 只適用與邏輯壞塊。 物理壞塊不適用。      

 To change the ASM SYS Password Things tried:SQL> passwordChanging password for SYSOld password:New password:Retype new password:ERROR:ORA-00600: internal error code, arguments: [15051], [], [], [], [], [], [], [] SQL> select INSTANCE_NAME

        Before you add the disk(s) to your production diskgroup, you can use the next steps to validate whether the candidate disk(s) is/are in good shape and can be accessed from each node (without harm the existing production diskgroups), as

        The rebalance power defaults to the value of the ASM_POWER_LIMIT initialization parameter (default = 1).       The higher the limit, the faster a rebalance operation may complete. Lower values cause rebalancing to take longer, but consume

        On release 11g and onwards, you need to create an ASM user and grant the SYSASM role. The purpose of the SYSASM role is to provide a level of separation between the RDBMS & ASM credentials.        The SYSASM role, which has full

  How do you setup / remove / modify Cluster Synchronization Services Daemon (CSSD) on a non-RAC system (init.cssd)?Each of the LOCALCONFIG operations need to be run as ROOT$ORACLE_HOME refers to the home used by ASM  SETUP / ADD ===========      

        Oracle recommends that you configure your system to automatically to start Oracle ASM instances and Database Instances when the system starts up, and to automatically shut them down when the system shuts down. Automating ASM/Database startup

        This document provides information on how to move a controlfile from filesystem to ASM and Vise Versa    Solution 1. Identify the location of the current controlfile:SQL> select name from v$controlfile;NAME---------------------------------

 1. Run the following SQL to find the full path for the archivelog files.SELECT CONCAT('+'||gname, SYS_CONNECT_BY_PATH(aname,'/')) full_path,dir, sys FROM (SELECT g.name gname, a.parent_index pindex, a.name aname,a.reference_index rindex,

Moving a datafile from the file system can be achived in two ways.（1）. While the database is shutdown (in mount stage).（2）. While the database is running (with the selected tablespace offline).一.  While the database is shutdown (in mount stage).     

  This article describe how we can drop and recreate ASM diskgroup when its not possible to perform this through SQL command.When a member disk in external redundancy diskgroup is no longer present (or destroyed beyond repair) and you want to drop

        The present document explains in detail the exact steps to migrate ASM diskgroups from one SAN to another SAN without a downtime.  Solution        If your plans are replacing the current disks associated to your diskgroups with a new storage,

              How to move a datafile from a file system to ASM       http://blog.csdn.net/tianlesoftware/archive/2011/04/22/6342722.aspx              How to move a datafile from ASM to the file system      

        This document discusses the necessary steps to take before creating a 11.2 / 11.1 / 10.2 database with 11.2 Grid Infrastructure when Role Separation is in place.   In case of role separation we typically have the following groups and

 Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2  11g new feature,you can use asmcmd to copy files between remote instances, Enables you to copy files between ASM disk groups on local instances and remote

 How to Change ASM Home on a Node in RAC  步驟如下：1） Install a new Home to be used by ASM 2） Stop the listener, database, asm on the node 3） Listener is recommended to be run from asm home. We can reset the new home using the following command:       $

        This note will guide a DBA in copying archivelog files currently located in a ASM diskgroup to a file system.  This is commonly useful when a DBA needs to copy archivelog files from  a primary to standby database in a dataguard environment.  

         The preferred way of doing the file movement amoung ASM DISKGROUPS is using RMAN. RMAN is critical to Automatic Storage Management and is responsible for tracking the ASM filenames and for deleting obsolete ASM files. Since ASM files cannot

        This note will explain how to create an ASM instance from scratch instead of using DBCA. 步驟如下：       Before you start, its recommended that ASM instance installed in a separate Oracle home, it is very useful in the case of applying patches

  運行asmcmd 命令報錯： [oracle@racdb2 ~]$ asmcmdasmcmd: command disallowed by current instance type 錯誤提示很明顯：       執行個體類型不對。  RAC 有2個執行個體，Oracle 執行個體和 ASM 執行個體。        在pfile 參數裡面設定的是ORACLE 執行個體，這個是預設值。 所以如果不指定ORACLE_SID的情況下，都是使用Oracle 的執行個體。 但是asmcmd