asm manual

[oracle @ rac1 ~] $ Mkdir-p/home/oracle/ggs [root @ rac2 ~] # Su-oracle [oracle @ rac2 ~] $ Mkdir-p/home/oracle/ggs register the just-created ACFS File System in the cluster mount registery, or manually mount it without registration. The advantage of registering an ACFS file system is that when the cluster checks mount registery every 30 seconds, the file system is automatically mounted on each node, when the cluster software or system is restarted, the file system is automatically mounted. [Ro

Brief introductionOracle Real Application Cluster (RAC) is a well-known product in Oracle Solutions for maintaining high availability of business data. Oracle RAC allows sharing of load across all cluster nodes, using N-1 Fault tolerant configuration to address node failures, where N is the total number of nodes. Oracle RAC is continuously improving every version, and this is no exception. The new 12.1.0.1 edition contains the Flex ASM and flex cluste

system intuitively, which can avoid certain risks and make people feel at ease. If you use this mode and use the LINUX operating system, we recommend that you divide the file system by Linux LVM, which will be very convenient for future expansion. However, this method also has some disadvantages, that is, because it is a Linux local file system, rather than a Cluster file system, the implementation of archiving and backup for two nodes is that the two nodes write independently only belong to th

; -- check whether the flashback database feature is enabled. RMAN> SQL "ALTER DATABASE FLASHBACK OFF "; RMAN> SQL "DROP RESTORE POINT Q106 "; 11. Close the database (clean) RMAN> shutdown immediate; Recommended reading: How to change the password of ASM sys How to copy data files in ASM to the Operating System Restoration After all Oracle 11g rac asm disks ar

installed by default by the General Oracle installer. ASM requires a small amount of memory: 64 MB for most systems-from Baidu encyclopedia Today, the Automatic Storage Management (ASM) technology is configured with Oracle10g_R2 in a virtual environment. I feel that oracle technology is very profound and profound. I will learn more carefully in the future. The configuration process is as follows: Environme

so many disks for ASM also brings a certain amount of management overhead. Finally, some DBAs may put archiving and backup separately on independent Luns and adopt the file system instead of the ASM disk management mode. The advantage is that even if the ASM fails to log on, however, backup and archive files can be seen in the file system intuitively, which can

fault phenomenon is consistent with the fault phenomenon in the document. 3. Solution Based on the content provided in document ID 1383737.1, use ifdown USB 0 to disable the USB 0 Nic of the two nodes, and then dynamically add route information to the node with the missing route information. # Route add-net 169.254.0.0 netmask 255.255.0.0 dev eth2 After adding a route, run the command # Su-grid $ GRID_HOME/bin/crsctl start res ora. crsd-init After crsd resources are started normally, all

recommend that you set permisssive.[Root @ oracle-one ~] #[Root @ oracle-one ~] # Setenforce 0[Root @ oracle-one ~] # GetenforcePermissive[Root @ oracle-one ~] #[Root @ oracle-one ~] #/Etc/init. d/oracleasm createdisk VOL1/dev/sdb1Marking disk "VOL1" as an ASM disk: [OK][Root @ oracle-one ~] # It is also very important that we can quickly locate the problem by viewing the/var/log/oracleasm log information. That's all! Recommended reading: How to

Use srvctl to manage ASMSrvctl can use the status command to view the service status of ASM and use commands similar to start and stop to manage ASM components.The following example shows that the instance cctt1 is running on the cctt1 node, and the ASM instance asm2 is running on the cctt2 node.Srvctl status ASM-N cct

RMAN> backup as backupset spfile; 9. If BCT is enabled, disable SQL> select status, filename from v $ block_change_tracking; RMAN> SQL "ALTER DATABASE DISABLE BLOCK CHANGE TRACKING "; 10. If flashback database is enabled, disable and delete all restore points first. SQL> select FLASHBACK_ON from v $ database; RMAN> SQL "ALTER DATABASE FLASHBACK OFF "; RMAN> SQL "DROP RESTORE POINT Q106 "; 11. Close the database (clean) RMAN> shutdown immediate; Recommended reading: How to change the pas

Document directory ASM, File System On itpub, we can see a problem related to the file transfer in the backup set on ASM. We can see that there are more and more questions about ASM, And we can feel that ASM is becoming more and more popular.The problem in http://www.itpub.net/thread-1299334-1-1.htmlThe l

initialization parameter to asm, and then restart the database to the nomount status: SQL> alter system set control_files = '+ oradata' scope = spfile;SQL> shutdown immediate;SQL> startup nomount Use rman to copy the current control file to asm Rman target/RMAN> restore controlfile from 'f: \ NSOADP \ CONTROL01.CTL ';Start restore on 09:40:30Use the target database control file to replace the recovery dire

ASM SecurityThis section mainly describes the various security configuration topics related to ASM, such asConfigure ASM Required UserIDs, groupids;asm permissions such assysoper,sysdba and new sysasm permissions, and finally ASMUse the Oraclepassword file, Orapwd. an ASM in

Migrate data files in the file system to the ASM Storage The RAC environment uses ASM for storage.Recently, some data files are stored in the file system during database maintenance, which is abnormal. As a result, the running instance on another server is abnormal.Therefore, we need to migrate the data files in the file system to the ASM storage. How to change t

only need to remove this SQL statement from the developer. In addition, why does the application query v $ asm_diskgroup for a single instance or non-ASM database? In fact, we can guess that this is a unified development system. To ensure universality, it involves queries on some RAC and ASM views. This query causes problems. Therefore, developers should fully understand the database features. How to copy

/home/oracle/ggs successfully added to Oracle RegistryThe command for manual mounting is as follows:[root@rac1 ~]# /bin/mount -t acfs /dev/asm/goldengate-257 /home/oracle/ggsWait 30 seconds after running the registration command, and then check whether the ACFs file system is mounted on each node.[root@rac1 ~]# df -hFilesystem Size Used Avail Use% Mounted on/dev/sda1 30G 20G 7.7

The purpose of this document is to provide information about the ASM rolling upgrade feature and step by step to install a patchset or patch in ASM home without downtime.Solution The following conditions shoshould be met for to perform ASM rolling upgrade (*) An ASM rolling upgrade applies only to clustered

started by default.Use the following command to cancel and enable auto-startCancel self-boot: crsctl Disable hasenable self-booting: Crsctl Enable has2) has manual start and stopCrsctl start hasCrsctl Stop has3) View the status of hasCRSCTL Check has4) If you want the ORA.CSS and Ora.diskmon services to start automatically as has, the Auto_start property of both services can beCrsctl Modify Resource "ORA.CSSD"-attr "Auto_start=1"OrCrsctl Modify Resou

Oracle provides a tool for manual query of ASM disk information-kfod. First, let's look at the help information: Db1-> kfod-help_ Asm_a/llow_only_raw_disks KFOD allow only raw devices [_ asm_allow_only_raw_disks = TRUE/(FALSE)]_ Asm_l/ibraries ASM Libraries [_ asm_libraries = lib1, lib2,...]_ Asms/id ASM Instance [_ as

to the system by configuring the parallel (power) limit settings for rebalancing. You can also run the "check all norepair" command on the disk group from time to time. In addition to space problems, if the disk group has any other problems, it will also be reported in ASM alert. log. Recommended reading: How to change the password of ASM sys How to copy data files in