用rman从文件系统迁移数据库到asm
1、备份数据库[oracle@haozg dbs]$ rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 5 14:12:57 2012Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA11 (DBID=729090162)RMAN> run{ allocat...
重新配置与卸载11gR2 Grid Infrastructure
Oracle 11g R2 Grid Infrastructure 的安装与配置较之前的版本提供了更多的灵活性。在Grid Infrastructure安装完毕前执行root.sh经常容易出现错误,并且需要修复该错误才能得以继续。 在这个版本中我们可以直接通过执行脚本rootcrs.pl来重新配置Grid Infrastructure而无需先卸载Grid Infrastructure,然后修...
RAC一个节点错误CRS-4047: No Oracle Clusterware components configured
[grid@his2 install]$ ./rootcrs.pl --help Unknown option: dconfigUsage: rootcrs.pl [-verbose] [-upgrade | -patch] [-paramfile <parameter-file>] ...
LINUX用GPT格式大于2T系统盘
查看os系统块的大小[root]# /sbin/tune2fs -l /dev/sda1[root@his1 ~]# fdisk -lDisk /dev/sda: 12.3 GB, 12328140800 bytes255 heads, 63 sectors/track, 1498 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start &nbs...
RAC修改集群两个节点public ip地址
[root@his1 ~]# vi /etc/hosts 修改hosts#...
rac启动和停止过程
[root@his1 bin]# ./crs_stop -all 停止所有的crs服务CRS-2500: Cannot stop resource ...
OEL 11.2.0.2 RAC 数据库停电导致has进程无法启动OLR文件损坏
[root@his1 ~]#cat/app/grid/product/11.2.0/grid/log/his1/ohasd/ohasd.log[ohasd(28152)]CRS-0704:Oracle High Availability Service aborted due to Oracle Local Registry error [PROCL-26: Error while accessing the physical storage Operating System error [No such file or directory] [2]...