oracle asm training

I see a lot of questions on shared file systems the can used when people move from single instance to Oracle RAC Datab ASE and Grid Infrastructure. The most common question are the following: "should I place archive logs in OCFS2 or ASM or ACFS of 11g?" I ' ll try to clarify this topic below.First we need to understand a separation between Oracle database files a

1. Migration of ASM files ASM file migration refers to migrating database files located on the file system to the ASM disk group, or migrating database files located on the ASM disk group to the file system. As shown in: Ii. migrate from the file system to the ASM disk grou

Oracle ASM errors-ORA-15031, ORA-15014 Oracle ASM errors-ORA-15031, ORA-15014 System Environment: Operating System: AIX 5.3.8 Oracle: Oracle 10gR2 Fault symptom: [Oracle @ aix213 ~] $ S

1. Clear TasksPrepare a RHEL5 PC to act as a San device, a SAN (both as a DNS and timing system)Prepare two RHEL5 PCs to act as RAC nodes, R1 and R2Install RAC on ASM disk, including OCR, voting, library2. Modify kernel parameters and shell limitations of R1 and R2On R1 and R2, respectively.Vim/etc/sysctl.conf------------------------------------------Kernel.shmmax = 4294967296Kernel.shmmni = 4096Kernel.shmall = 2097152Kernel.sem = 250 32000 100 128Fs.

The steps to install the ASM database are much more repetitive than the steps to install RAC, so the installation documentation for the previous RAC has been modified to successfully install the ASM-managed database. The installed environment is the centos6.5_64 bit, and the database to be installed is the 11GR2 version.The steps to install are as follows:1. Create operating system groups and usersGROUPADD-

Migrate Oracle database files to ASM Read navigation Migrate data files to ASM Migrate log files to ASM Migrate control files to ASM Migrate data files to ASM Database migration in the case of Database Consistency: Start the

First, fault descriptionASM Disk group dropped, ASM instance cannot mount. ASM Disk Group has 4 500G disks, database and ASM software 10.2.0.1, the Oracle database is in urgent need of recovery.Second, fault analysisAnalyze the disks that make up the ASM disk group, remove t

Comparison of two-live solutions: ASM vs V-plexWang WenjieOracle Company Principle System AnalystOracle Advanced ServicesThe evolution of Oracle Database Center disaster Recovery has evolved over the years from initial cold backup, to hot backup, to storage replication, to Dg,adg,rac one node, RAC, and eventually to the hottest dual-live dual-center architecture, This is the remote RAC (Extended RAC) we oft

Today on the Internet to see a friend asked: Why in the way of ASM storage Management is clearly set only log_archive_dest_1 to specify the path of the archive, but in ASM found two archived log files? (Not open Flashback)I looked up some information and thought it was like this:Every file created in ASM gets a system-generated filename, otherwise known as a full

UDEV ASMDisk ConfigurationBecause Oracle does not support the RHEL6 series ASMLib, we can change it to Udev to configure ASMDisk as follows:Use udev to configure the block device information stored in ASM.1. confirm that the udev package is installed.[Root @ rac01 ~] # Rpm-qa | grep udevUdev-147-2.40.el6.x86_642. Obtain the WWID system information of the hard disk.(1) Use the following command in

How to create Oracle ASM devices using Device-mapper multipath devices in Red Hat Enterprise Linux 6?EnvironmentRed Hat Enterprise Linux 6 device-mapper Multipath (DM Multipath) Oracle ASM UdevResolutionFollowing steps to create Oracle A