Discover asm commands in oracle 11g, include the articles, news, trends, analysis and practical advice about asm commands in oracle 11g on alibabacloud.com
1. DemandOracle Linux6.7 uses Udev as ASM/dev/sdb 2, fault phenomenonOracle Linux 6.7 under VMware vshpere5.1, using scsi_id-related commands to see the UUID 3. Treatment methodA. Adding records to/etc/scsi_id.config[Email protected] rules.d]# echo "options=--whitelisted--replace-whitespace" >>/etc/scsi_id.configB. Through the vcenter connection, then "Home"-"inventory"-"data storage and data storage Cluste
Use udev for ASM in Oracle Linux6.7
1. RequirementsOracle Linux6.7 uses udev as asm/Dev/sdb /Dev/sdc /Dev/sdd /Dev/sde /Dev/sdf
2. FaultIn Oracle Linux 6.7 under vmware vshpere5.1, the uuid cannot be viewed using commands related to scsi_id.
3. Handling Method
A. Add the re
>/sys/block/xvdf/queue/schedulerecho Deadline >/sys/block/xvdg/queue/schedulerecho Deadline >/sys/block/xvdh/queue/schedulerecho Deadline >/sys/block/xvdi/queue/schedulerValidating property ResultsMore/sys/block/xvde/queue/scheduler10, #disable transparent hugepages close transparenthugepagesVi/etc/rc.localIf Test-f/sys/kernel/mm/redhat_transparent_hugepage/enabled; Thenecho Never >/sys/kernel/mm/redhat_transparent_hugepage/enabledFi# # #配置互信In the software catalog of the grid software, build t
Today, there are users of the ASM in the disk to do Fdisk, resulting in ASM disc exception, through the manual repair ASM disk HEADER To solve the problem, here through the experiment reproduced, reminding you to operate the ASM hard disk partitions need to be cautious, usually to the
Disk DirectoryDisk directory contains information about all the disks in the disk group. Disk directory information is more detailed than PST. Each disc in a disk group has an entry that is indexed by a number. The file number of disk directory is number 2nd (F2) in each disk group.The fields in Disk directory are as follows:N Disk NameN Failure Group Namen Disk Sizen Disk Free Spacen Disk creation timeMost of the information in disk directory is available in the disk header. Alterdiskgroup ...
the archive logs generated by instance 1 and instance 2 respectively. Each instance is configured with an archive location, archived locally, and then hooked up to a local directory via NFS.
Inter-instance archiving (cross Instance Archive CIA)
Inter-instance archiving (cross Instance Archive) is a variant of the previous approach and is a more common configuration method. Two nodes create 2 directories Arch1 and ARCH2 correspond to the archive logs generated by instance 1 and ins
Connection, further testing is needed.Diagnostic processing ResultsThe fimware of the I/O 1-node HBA card is upgraded to v4.06.03 after connection 200E the failure to find the disk array has been resolved. is actually a problem caused by the inconsistency of the firmware version of a FCHBA card.Shared files OCR and voting DiskOracle Cluster Registry (OCR): Records the configuration information of the OCR record node members, such as database, ASM, in
Use adrci in Oracle 11g to view alert logs
1. Know adrci
This command can view error messages and logs, which are provided to us along with the change of the 11g trace directory location. This tool can not only edit logs like vi. You can also view log files like tail-f.
It can also be used across platforms and windows.
-------------------------------------- Split
Tags: successful dump tor main ini pen network tar getHttp://www.cnblogs.com/beanbee/archive/2012/09/22/2697689.htmlTo manually build a ORACLE11GR2 database using the command line Build a database through the command line can help to better understand the database building process, today try to build ORACLE11GR2 database, feel and 10g manual build library process still have a certain difference, 10g database manual way to establish can refer to Hou (secooler) " http://space.itpub.net/519536/view
The 11203 RAC (ASM) of a customer the day before yesterday appears to be out of power, causing the database to fail to start, noting that the database is in archive mode. Can be seen how unlucky. According to colleagues, the start is due to the redo and undo damage caused the failure to start, some of the information is as follows:
Thu May-20:51:07 2014 dumping diagnostic data in directory=[cdmp_20140508205107], requested by (Insta Nce=1, osid=1
Tags: Ace comm because hand oracle XXX ann Prot ErrorsSystem environment:CentOS Release 6.7 (Final)Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bitOperation Process: 1. When you add a data file or create a tablespace, you specify the path as a single-node local Sql> alter tablespace users add datafile '/home/or
systems, but since we have a grid, it can also be built on ASM disk groups. Vi. creation of ASM disk groupsWe go into the bin directory of the grid and execute the ASMCA command Then create an ASM disk group Specifying ASM Disks Change the path to our ASM disk to sit in
Oracle 11g on July 11, 2007 11 O'Clock (Beijing time 11th 22 o'clock) officially released, 11g is Oracle 30 years to release the most important version of the database, according to the needs of users to achieve information lifecycle management (information Lifecycle Management) and many other innovations.
I. Outline
Tags: node get sql--... acdb node cluster cal offline
Start RAC
The manual start is initiated in the order of has, cluster, database, with the following specific commands:
Start has (high availability Services), must be the root user
[Email protected] ~]# Crsctl start hasCrs-4124:oracle High Availability Services startup failed.Crs-4000:command Start failed, or completed with
Rmanconvert migrate win64-bit oracle to linuxoracle + asm manuscript
startup mountalter database open read only;select open_mode from v$database;set serveroutput ondeclarev_check boolean;beginv_check:=dbms_tdb.check_db('Linux x86 64-bit',dbms_tdb.skip_none);end;/declarev_ext boolean;beginv_ext:=dbms_tdb.check_external;end;/select name from v$database;rman target /convert database new database 'lixora'transp
This article describes how to install Oracle 11gR2 (11.2.0.3) in Oracle Linux 6.3 ). Since Oracle 11g, the official Oracle website does not provide a download link for its Patch. You need to use the Meatlink account to download the Patch. Do not worry about the kids shoes. I
ORA_PSP0_RACG1
Oracle 26477 1 0 15:02:44? 0:00 ORA_RECO_RACG1
Oracle 26475 1 0 15:02:44? 0:00 ORA_SMON_RACG1
Two. ORACLE11G the functionality of a new background process
The new many background processes are: ORA_DBRM_ORCL,ORA_DIA0_ORCL,ORA_PSP0_ORCL,ORA_SMCO_ORCL,ORA_VKTM_ORCL,ORA_W000_ORCL,
The functions of these background processes are as follows:
DBRM: The database resource management process (the D
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.