asm commands in oracle 11g

This article mainly introduces the installation of Oracle 11g RAC and the creation and migration of 10g databases in the 11g RAC environment, and how to upgrade the database to the 11g version. The architecture of the 11g RAC and some new features of the

Oracle 11g R2 (GI) Startup Process 11gR2 cluster management software (GI) startup sequence and diagnostic methods In this article, we will introduce the Starting sequence of 11gR2GI and introduce common problems and corresponding solutions during GI startup. Basically, we can divide the GI startup process into three phases: ohasd, cluster building, and resource startup. First, the ohasd stage. 1. scripts in

This article mainly describes the installation of Oracle 11gR2 (11.2.0.3) under Oracle Linux 6.3. Starting with Oracle 11g, the Oracle website no longer provides download links to its patches and requires a Meatlink account to download. Children's shoes do not worry, no Meta

/oracleasmMountPoint:/dev/oracleasmloading Module"oracleasm": oracleasmmounting asmlib driver filesystem:/dev/Oracleasm[[email protected]~]#/usr/sbin/oracleasm Createdisk disk1/dev/sdb1writing Disk Header: Doneinstantiating disk: Done[[Email protected]~]#/usr/sbin/oracleasm Createdisk disk2/dev/sdc1writing Disk Header: Doneinstantiating disk: Done[[Email protected]~]#/usr/sbin/oracleasm Createdisk disk3/dev/sdd1writing Disk Header: Doneinstantiating disk: Done[[Email protected]~]#/usr/sbin/oracl

OracleID Gridpasswd Oraclepasswd gridTo create the installation directory:Mkdir-p/u01/app/grid/11.2.0Chown-r grid:oinstall/u01Mkdir-p/u01/app/oracle/11.2.0/db_1Chown-r oracle:oinstall/u01/app/oracleChmod-r 775/u01Configure Server Time synchronization: (10g needs to be configured, not NTP configured in 11GR2)Rac1:Vi/etc/ntp.confServer 127.127.1.0Fudge 127.127.1.0 Stratum 11Driftfile/var/lib/ntp/driftBroadcastdelay 0.008RAC2:Vi/etc/ntp.confServer 192.1

Oracle 11g RMAN: Interpretation of the command for creating dg in Active Database Duplication for standby database, rmanduplicationIf the production-based duplicate replication is not manually configured with pfile (set memory, process, dg-related configuration parameters, database-related path parameters), various parameters cannot be converted;Because duplicate will automatically copy pfile, control file,

necessary. Range partitions and interval partitions can exist in a table at the same time, and range partitions can be converted to interval partitions. ·9. Auto memory Tuning) In 9i, automatic PGA optimization is introduced; in 10g, automatic SGA optimization is introduced. By 11 GB, all memory can be automatically optimized by setting only one parameter. You only need to tell Oracle How much memory is available, it can automatically specify how

Tags: revert to my many help summary pen. NET Preparation SpecialTransferred from: https://www.jb51.net/article/52269.htm This article mainly introduces the Oracle 11g Dataguard parameters in detail, including the independent parameters, the main library parameters, the library parameters detailed description, the need for friends can refer to. Note: This article is translated from

Routine maintenance and troubleshooting of Oracle 11G R2 slave uard 1. About the Forced Logging ModeSome DDL statements can avoid writing redo logs by specifying the NOLOGGING clause (the purpose is to increase the speed, which is indeed valid in some cases). After specifying the database as the force logging mode, the database records all operations except the temporary tablespace or temporary rollback seg

environment variable under a grid userMake the added variable take effectUse gird account to knock command ASMCACreate a FRA disk groupOK exit after successful creationTwo Installing the Database1. First Oracle database software2. UnzipUnzip Linux.x64_11gR2_database_1of2.zipUnzip Linux.x64_11gR2_database_2of2.zip3. Start configuring database information and installThere's no need to fill out an emailChoose to install only the database softwareSelect

default yum source speed of the system is often unsatisfactory and all components are connected overseas. In order to achieve quick installation in China, you must modify the yum source. Http://mirrors.163.com/http://mirrors.sohu.com these two domestic sources. Run the following command. Cd/etc/yum. repos. d Mv CentOS-Base.repo CentOS-Base.repo.bak Wget http://mirrors.163.com/.help/centos-base-163.repoor wget http://mirrors.sohu.com/help/CentOS-Base-sohu.repo Run yum makecache to generate Cach

create a partition of the same size. Range partitions and interval partitions can exist in a table at the same time, and range partitions can be converted to interval partitions.· Auto Memory Tuning)In 9i, automatic PGA optimization is introduced; in 10g, automatic SGA optimization is introduced. By 11 GB, all memory can be automatically optimized by setting only one parameter. As long as you tell oracle How much memory is available, she can automati

backup time based on the disk space on the backup server and the custom policy.Perform Level 0 backup every SundayPerform Level 1 backup every Monday, two, three, four, five, and six. Iv. RMAN backup script configuration 1. Prepare the Directory # Su-oracle Note: You can create related directories based on the actual situation. Pay attention to the directory permissions.$ Mkdir-p/u01/app/oracle/rman_bak/sc

primary database. Flexible set newname commands. If you do not have a data file list, restore a DATABASE to a different platform or file system at a specified time point using RAMN, duplicate database, or tablespace, you will know how welcome these new features. Oracle 11g R2 can now accept the tablespace-level or database-level FORMAT specification for data fil

+ ---------------- Install and configure Oracle 11g R2 on centos 5.5 ----------------- ++ -------------------------------- By kerryhu ------------------------------------ + I. Runtime EnvironmentSystem Environment: centos 5.5 32-bit (graphical installation)Hard Disk Partition:/Boot 150 mSwap 4096 M (at least 3 GB)/10g/Home 5g/Tmp 5g/Usr 10g/Usr/local 10g/Var 10g/OPT 10g/Data all remaining DF-H # S

Install Oracle 11g in CentOS 6.5 I recently started to learn how to use CentOS and make some records. References: Install Oracle 11g in Cent OS 6_5 (x86_64) I. Hardware requirements 1. Memory swap Minimum: 1 GB of RAMRecommended: 2 GB of RAM or more Check memory[Plain] view plaincopy # GrepMemTotal/proc/meminfo

Oracle 11g cluster software cannot be started solution step (2) run the following command to view the cluster software status-bash-3.2 #. /crsctl check cluster-all ********************************** * t5220-1: CRS-4535: Cannot communicate with Cluster Ready Services CRS-4529: Cluster Synchronization Services is online CRS-4533: event Manager is online ************************************ * t5220-2: CRS-4535

provide, and for I/O intensive applications, this mechanism determines that subsequent expansions can only be Scale up type, For hardware costs, developer requirements, maintenance costs are relatively high. Oracle is clearly aware of this problem, in Oracle's MAA (Maximum availability Architecture) architecture, using ASM to consolidate the capabilities of multiple storage devices, so that the RAC-bottom

In $oracle_home/bin, there are two scripts, Dbstart and Dbshut, that enable Oracle to boot from the two Oracle-brought scripts. This script contains Oraclelistener, instance, ASM instances start-up, and the same dbshut is the role of the shutdown service.Method One: Start the Oracle using the/etc/rc.local system boot s

logfileGroup 4('/u01/oracle/oradata/orcl/stdby_redo04.log ')size -MGroup 5('/u01/oracle/oradata/orcl/stdby_redo05.log ')size -MGroup 6('/u01/oracle/oradata/orcl/stdby_redo06.log ')size -MGroup 7('/u01/oracle/oradata/orcl/stdby_redo07.log ')size -M --Create sql> ALTER DATABASE add standby logfile on the standby sta