做最Low逼的DBA
发布时间:2017-04-20 00:31:38
1.停止集群监听程序grid@oranode1:~> srvctl stop listener2.关闭数据库实例grid@oranode1:~> srvctl stop database -d orcl3.查询分配的多路径的盘的信息oranode1:/home/oracle # multipath -ll4.查询多路径盘是否在使用(需要两个节点上进行确认)oranode1:/home/oracle # /etc/init.d/oracleasm querydi.........【阅读全文】
发布时间:2017-04-20 00:20:46
--该文章摘抄Oracle metalink网站(文档 ID 1525761.1)Oracle Database - Enterprise Edition - 版本 10.1.0.5 到 11.1.0.7 [发行版 10.1 到 11.1]UnitedLinux ItaniumLinux x86HP-UX PA-RISC (64-bit)IBM AIX on POWER Systems (64-bit)Oracle Solaris on SPARC (64-bit)HP-UX ItaniumRed Hat Enterprise Linux Ad.........【阅读全文】
发布时间:2017-04-20 00:14:55
以下是通过测试环境验证后的结果:primary : db_name=dg db_unique_name=pdb log_archive_dest_1='location=d:\oracle\archive' log_archive_dest_2='service=sdb lgwr async affirm valid_for=(online_logfiles,primary_role) db_unique_name=.........【阅读全文】
发布时间:2017-04-20 00:11:30
DG BROKER关闭DG以及打开DG步骤1.进入dgmgrl管理oracle@oratest:~> dgmgrl /DGMGRL for Linux: Version 11.2.0.4.0 - 64bit ProductionCopyright (c) 2000, 2009, Oracle. All rights reserved.Welcome to DGMGRL, type "help" for information.Connected.2.检查DG状态DGMGRL> show configuration verbose;Co.........【阅读全文】
发布时间:2017-04-19 23:59:23
1.运行root.sh后,按提示运行roothas.pl报错:[root@oranode1 mnt]# /u01/app/11.2.0/grid/crs/install/roothas.plUsing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsUser ignored Prerequisites during installation/u01/app/11.2.0/grid/bin/crsctl query crs activeversion ...........【阅读全文】