导航

2015年8月22日

摘要: ln -s /usr/openv/netbackup/bin/libobk.a64 /oraclev3/product/10.2.0/lib/libobk.a不建软连接会报如下错误:using target database control file instead of recovery cata... 阅读全文

posted @ 2015-08-22 10:40 datalife 阅读(365) 评论(0) 推荐(0)

摘要: PSU补丁:p22191577_112040_Linux-x86-64.zipOPATCH工具:p6880880_112000_LINUX.zip 解压OPATCH工具 覆盖到/u01/11.2.0/grid/和/u01/app/oracle/product/11.2.0/db_1这两个目录。(两上 阅读全文

posted @ 2015-08-22 09:58 datalife 阅读(390) 评论(0) 推荐(0)

摘要: 一.、/etc/sysconfig/network-scripts下新建文件ifcfg-bond01.编辑文件viifcfg-bond0DEVICE=bond0ONBOOT=yesBOOTPROTO=staticTYPE=EthernetUSERCTL=noIPADDP=NETMASK=GATEWA... 阅读全文

posted @ 2015-08-22 09:57 datalife 阅读(344) 评论(0) 推荐(0)

摘要: ***************节点2的arch2目录挂载到节点1下。那么节点2是主节点1是备********10.230.39.234(节点1)cat /etc/exports /arch2 10.230.39.235(rw)10.230.39.235(节点2)cat /etc/exports /a... 阅读全文

posted @ 2015-08-22 09:55 datalife 阅读(345) 评论(0) 推荐(0)

摘要: ****************ORACLE 11G RAC***********************Disk /dev/sdb: 2147 MB, 2147483648 bytes67 heads, 62 sectors/track, 1009 cylindersUnits = cylinde... 阅读全文

posted @ 2015-08-22 09:52 datalife 阅读(307) 评论(2) 推荐(0)

摘要: 一 检验条件二 准备工作1 创建相关目录mkdir -p /oracle/admin/orcl/adumpmkdir -p /oracle/admin/orcl/bdumpmkdir -p /oracle/admin/orcl/cdumpmkdir -p /oracle/admin/orcl/udu... 阅读全文

posted @ 2015-08-22 09:49 datalife 阅读(891) 评论(0) 推荐(0)

摘要: 1、创建用户组。以root身份运行以下命令:/usr/sbin/groupadd -g 501 oinstall /usr/sbin/groupadd -g 502 dba /usr/sbin/groupadd -g 504 asmadmin /usr/sbin/groupadd -g 506 as... 阅读全文

posted @ 2015-08-22 09:42 datalife 阅读(470) 评论(0) 推荐(0)

摘要: ORACLE11G RAC alert报错如下:Errors in file /u01/app/oracle/diag/rdbms/dljyzs/dljyzs1/trace/dljyzs1_ora_81734.trc:ORA-00245: control file backup failed; ta... 阅读全文

posted @ 2015-08-22 09:40 datalife 阅读(845) 评论(0) 推荐(0)

摘要: RMAN> run {2> allocate channel ch00 type 'sbt_tape' parms='ENV=(NB_ORA_CLIENT=rac1)';3> restore controlfile from '/cntrl_7418_1_888200750'; 4> rele... 阅读全文

posted @ 2015-08-22 09:38 datalife 阅读(3448) 评论(0) 推荐(1)

摘要: alter database add logfile thread 1 group 5 ('+DATA/idb/onlinelog/group5.log') size 256m;alter database add logfile thread 2 group 6 ('+DATA/idb/onlin... 阅读全文

posted @ 2015-08-22 09:37 datalife 阅读(220) 评论(0) 推荐(0)

摘要: OS:rh6.4ORACLE 11g RAC ASMOCR和VOTING DISK在crs磁盘组,控制文件、数据文件、参数文件在DATA组。1、备份数据库RUN {ALLOCATE CHANNEL ch00 DEVICE TYPE disk;ALLOCATE CHANNEL ch01 DEVICE ... 阅读全文

posted @ 2015-08-22 09:30 datalife 阅读(885) 评论(0) 推荐(0)

摘要: !echo ''!echo '##########查看表空间使用情况##########'set linesize 1000col tablespace_name for a30select a.tablespace_name,a.all_space,b.free_space,b.free_spac... 阅读全文

posted @ 2015-08-22 09:20 datalife 阅读(404) 评论(0) 推荐(0)