Label:First, ASM (Automatic storage management) for the reason: ASM is a new feature introduced in Oracle 10g R2 to simplify the management of Oracle databases, a volume manager provided by Oracle itself, primarily used to replace the LVM provided by the operating system, wh
Upgrading ASM instance from Oracle 10.1 to Oracle 10.2. (Single Instance)Solution
O upgrading of ASM instance from 10.1 to 10.2 can be accomplished through dbua.
O all the database that use the ASM instance being upgraded must be shutdown.
The following steps can be used to
Environment: OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 10 Gb later, Oracle launched the Storage method managed by Using ASM (Auto Storage Management). As the Oralce version keeps changing, the ASM storage management method is becoming more and more stable. the following describes how to use
There is a friend in a storage space for ASM use, there is insufficient space, and then use another storage LUN to the ASM Data Disk group to increase ASM disk, run for about 1 days after the ASM disk group directly dismount, Database crash. And then you can't mount it properly. Several other disk groups, including thi
Oracle 11gR2 uses gpnp profile to store the spfile path of ASM
Since Oracle 11gR2, GI has integrated ASM, and OCR/VOTEDISK has also been stored in the ASM disk group (which must be stored on bare devices before 11gR2 ), at the same time, the functions of
Tags: oracle ASM File ReplicationWork, sometimes you need to copy files from ASM to the file system or, in turn, do some maintenance operations, this article describes 4 ways to copy files:
CP command in Asmcmd (11g)
Dbms_file_transfer Bag
Convert or Backup as copy of Rman
Ftp
These 4 methods are described below1. CP command in Asmcmd (1
For Oracle network configuration, we usually use negmgr or netca to connect the client to the database instance. You can also connect to the ASM instance from a client. However, Oracle does not provide a tool for us to complete the configuration. We can manually configure the listener and the client tnsnames. This section describes and provides examples.
1. serve
CHAPTER ASM Persistent Data structuresAs with traditional file systems and volume managers, ASM storage metadata is used to describe and track the contents of a disk group. All metadata describes the composition and content of the ASM disk group stored above, which enables the disk group to be self-describing. ASM Disk
In the previous article wrote the file system library, in the exception recovery before the backup method (Oracle exception recovery before the backup protection site recommended-filesystem environment), for the ASM Library, because the ASM inside the data file can not direct DD file header, As a result, the backup approach has changed. For
Oracle GoldenGate series: ora-01031 errors when using Oracle asm api dblogreader today test GoldenGate on your new Oracle ACFS file system, the following error is reported when the extract process is started: 14:58:39 ERROR OGG-00446 Opening ASM file + FRA/rac/archivelog/201
In a production environment, DBAs tend to face dozens of of hundreds of g of data, or even the T-level, file system storage data files in these situations, I/O problems will gradually exposed, so the data storage in the production environment generally use ASM, or bare devices, Oracle 11G does not support raw devices to store data at the beginning, so this talk mainly describes the configuration of the guar
ASM: Automatic Storage Management is a practical solution strongly recommended by Oracle for Oracle database Storage. Oracle ASM is very similar to RDBMS, and Oracle ASM is also compose
In the OracleRAC environment, run asmcmd with the grid account to enter the asm command mode, such as: [grid @ oradb-node1 ~] $ AsmcmdASMCMDgt; ASMCMD
In the Oracle RAC environment, use the grid account to run asmcmd to enter the asm command mode, such as: [grid @ oradb-node1 ~] $ Asmcmd ASMCMDgt; ASMCMD
In the Oracle
One of Oracle asm kfed tools, asmkfed
[root@localhost db_1]# su - oracle[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ pwd/u01/app/oracle
I. The following error is reported when 10gRAC uses DBCA to reconstruct asm:The ASM instance configured on the local node is a single-instance ASM. to create a single-instance database using this ASM instance, restart DBCA and select the single-instance database option, to create a RAC database using this ASM instance,
We all know that Oracle ASM and Oracle databases are tightly integrated, and work with tools related to Oracle data management. It can be a simplified database storage management and provide performance related to the original disk I/O.
Configure ASMLib. Configure Oracle ASM
)", "Name-service")
Incident details in:/u01/app/grid/diag/asm/+asm/+asm1/incident/incdir_73/+asm1_lmon_46885_i73.trc
Use Adrci or Support Workbench to package the incident.
411.1 at my Oracle Support for error and packaging details.
Errors in FILE/U01/APP/GRID/DIAG/ASM/+ASM
I. Description
See an ASM upgrade document on the official website, as shown below:
How To Upgrade ASM from 10.2 to 11.1 (RAC)
Unable To Open Database After ASM Upgrade From Release 11.1 To Release 11.2
For database upgrades under RAC, refer:
RedHat 5.4 Orcle RAC database upgraded from 10.2.0.1 to 10.2.0.4
Notes:
1. The Clusterware version must be consistent w
Use VBox to simulate storage migration environments, os:rhel5.9,db:oracle 10.2.0.4 RAC ASM 2Nodes.
ASM uses extern redundancy, which does not use ASM's rebalance functionality, and OCR and Votedisk are stored in raw.
Migration includes Controlfile,datafile,tempfile,spfile,ocr,votedisk.
Path before migration
OCR/DEV/SDF1/DEV/RAW/RAW1,/DEV/SDF2/DEV/RAW/RAW2
VOTEDISK/DEV/SDG1/DEV/RAW/RAW3,/DEV/SDG2/DEV/RA
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.