Oracle ASM
ZhongWeicheng
这个作者很懒,什么都没留下…
展开
-
How to move ASM spfile to a different disk group
Copy spfile with -u option - to update GPnP profile in RAC environment[grid@zhongwc1 ~]$ asmcmd lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file原创 2013-01-24 16:01:11 · 1448 阅读 · 0 评论 -
Add a Node to Oracle 12cR1 RAC on RHEL 6
The generic steps to follow when adding the new node to the cluster are:Install Operating SystemInstall required softwareAdd/modify users and groups required for the installationConfigure netw原创 2013-10-21 22:22:43 · 3133 阅读 · 0 评论 -
Oracle ASM hidden parameters
[oracle@vzwc2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 9 21:43:58 2013Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g E原创 2013-11-09 21:50:07 · 5757 阅读 · 0 评论 -
Oracle 10g RAC ASM存储迁移
使用VBOX模拟存储迁移的环境,OS:RHEL5.9,DB:Oracle 10.2.0.4 RAC ASM 2Nodes。ASM使用Extern Redundancy,不使用ASM的rebalance功能,ocr和votedisk存放在raw里。迁移包括controlfile,datafile,tempfile,spfile,ocr,votedisk。迁移前路径ocr原创 2013-11-24 21:34:51 · 3638 阅读 · 0 评论 -
Oracle11gR2 找出ASM diskgroup中的ASM spfile
[grid@vzwc1 ~]$ crsctl query crs activeversionOracle Clusterware active version on the cluster is [11.2.0.4.0][grid@vzwc1 ~]$ [grid@vzwc1 ~]$ crsctl query css votedisk## STATE File Universal I原创 2013-11-29 14:05:45 · 1831 阅读 · 0 评论 -
SUSE Linux 使用UDEV配置ASMdisk
vzwc1:~ # uname -aLinux vzwc1 3.0.76-0.11-default #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990) x86_64 x86_64 x86_64 GNU/Linuxvzwc1:~ # cat /etc/issueWelcome to SUSE Linux Enterprise Server 11 SP3原创 2013-12-30 13:59:41 · 6354 阅读 · 1 评论 -
Installation Oracle11gR2 RAC on SuSE Linux Enterprise Server 11
SLES11安装参考博文Installation SUSE Linux Enterprise Server 11vzwc1:~ # cat /etc/issueWelcome to SUSE Linux Enterprise Server 11 SP3 (x86_64) - Kernel \r (\l).vzwc1:~ # 配置/etc/hosts文件192.1原创 2013-12-30 18:09:48 · 6741 阅读 · 1 评论 -
Solaris11配置Oracle RAC ASMDisk 以及运行root.sh注意事项
root@vzwc1:~# isainfo -namd64root@vzwc1:~# unameSunOSroot@vzwc1:~# cat /etc/release Oracle Solaris 11.1 X86 Copyright (c) 1983, 2012, Oracle and/or its affiliates.原创 2014-01-11 22:30:58 · 3880 阅读 · 0 评论 -
Extracting Datafile Blocks From ASM
查看数据存放的file#和block#[oracle@db11g ~]$ sqlplus zwcSQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 16 14:02:27 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Enter password: Conn原创 2014-01-16 13:57:35 · 134 阅读 · 0 评论 -
Master Note for Automatic Storage Management (ASM) (Doc ID 1187723.1)
Automatic Storage Management (ASM) Alerts: Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 (Doc ID 1145365.1) Automatic Storage Management (ASM) Concep转载 2014-01-19 18:36:08 · 2771 阅读 · 0 评论 -
Oracle GoldenGate 11gR2 Configuration On Oracle Database 11gR2 RAC ACFS
sourceOracle 11gR2 RAC#public IP192.168.1.51 vzwc1192.168.1.52 vzwc2#private IP172.168.1.51 vzwc1-priv172.168.1.52 vzwc2-priv#VIP192.168.1.151 vzwc1-vip192.168.1原创 2013-10-17 00:10:25 · 5937 阅读 · 0 评论 -
Using RMAN duplicate Created Remote Auxiliary Database with ASM to ASM
target SID=zwcauxiliary SID=zwcon target[oracle@source ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Thu Sep 26 13:10:41 2013Copyright (c) 1982, 2011, Oracle原创 2013-09-26 13:49:45 · 1303 阅读 · 0 评论 -
Oracle 11gR2 RAC add ASM disk
Use "grid" user inquires the current diskgroup,disk.[grid@node1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 7 15:33:06 2013Copyright (c) 1982, 2011, Oracle. All原创 2013-01-07 15:55:31 · 3140 阅读 · 0 评论 -
Oracle ASM Advanced Tranning 1 —— Configuration of Devices for ASM
Part 1 : Configure devices for ASM using file system files and loop devicesCheck the amount of space available on file system[root@vasm ~]# df -THFilesystem Type Size Used Avail Use原创 2013-02-20 15:09:03 · 1118 阅读 · 0 评论 -
Oracle ASM Advanced Tranning 2 —— Install and Configure ASMLib
Part 1 : Install The ASMLib DriversCheking The Kernel Version[root@vasm ~]# uname -aLinux vasm 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/LinuxDownl原创 2013-02-20 16:11:11 · 1937 阅读 · 0 评论 -
Oracle ASM Advanced Tranning 3 —— Create ASM Instance and Managing Diskgroups
Create The ASM InstanceCreate the Cluster Synchronization Services DaemonOn a single instance ASM running "localconfig add" as root configures CSS.On a RAC environment CSS is one of the Oracle原创 2013-02-20 17:54:41 · 1187 阅读 · 0 评论 -
Oracle ASM Advanced Tranning 4 —— RMAN Migrate into ASM
One of the ways to migrate a database to ASM storage is to use Rman to make a “Backup as Copy” into ASM and then switching the database to the copy.This technique can be used, combined with increm原创 2013-02-21 14:03:19 · 1036 阅读 · 0 评论 -
Oracle ASM Advanced Tranning 5 —— Configure XDB for ASM Access Through FTP and HTML
Configure FTP and HTTP Ports Using DBMS_XDBSetup the ports to be used by http and ftp protocolsSQL> execute dbms_xdb.sethttpport(8080);PL/SQL procedure successfully completed.SQL> execute db原创 2013-02-21 14:54:47 · 1098 阅读 · 0 评论 -
ACFS Support On OS Platforms
11.2.0.1 ACFS new supported OS platforms and data services OL5 and RHEL5Windows 2003 R1 (64-bit)Windows 2003 R2 (64-bit) 11.2.0.2 ACFS new support原创 2013-04-17 11:34:31 · 1872 阅读 · 0 评论 -
Create Oracle ASM Cluster File Systems (ACFS) in Oracle Database 11g Release 2
OS版本是Oracle Linux5.8 x86_64,Oracle Database和Grid Infrastructure版本是11.2.0.3,双节点RAC。[root@vzwc1 ~]# cat /etc/issueOracle Linux Server release 5.8Kernel \r on an \m[root@vzwc1 ~]# uname -p x8原创 2013-04-17 17:17:03 · 2166 阅读 · 0 评论 -
Configuring Oracle 11.2.0.3 3-Nodes RAC Primary to 2-Nodes RAC Physical Standby DataGuard on OL
操作环境PrimaryStandbyClusterware11.2.0.3 Grid Infrastructure11.2.0.3 Grid InfrastructureCluster Nodesvzwc1,vzwc2,vzwc3(3-Nodes)sd-vzwc1,s原创 2013-05-02 11:25:31 · 3799 阅读 · 1 评论 -
RHEL5使用multipath配置ASMdisk
fdisk查看磁盘[root@db11g ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.9 (Tikanga)[root@db11g ~]# [root@db11g ~]# [root@db11g ~]# fdisk -lDisk /dev/sda: 32.2 GB, 3221225472原创 2014-01-15 13:17:30 · 3496 阅读 · 0 评论