NTP时间同步 For AIX
1.查看当前时区$echo $TZ2.更改时区# chtz BEIST-8 --(BEIST-8) Peoples Rep. China (CUT +8)3.客户端查询ntp server,并调整时间# ntpdate -d xxx.xxx.xxx.xxx# date# ntpdate xxx.xxx.xxx.xxx# date4.在client端上添加ntp server# vi /etc/ntp.conf内容如下:#broadcastclientserver xxx.xxx.xxx.xxxdriftfile /etc/ntp.drifttracefile /etc/ntp.trace5.start xntpd on client# startsrc -s xntpd6.重起后xntpd自动起动# smitty xntpdStart Using the xntpd Subsystem > BOTH7.查看xntpd状态# lssrc -g tcpip# lssrc -ls xntpd --当
Activity Monitor log保存时间调整
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font
登陆sqlplus hang /telnet很慢 for Aix
方法一:vi /etc/netsvc.conf 更改为hosts=local方法二:vi /etc/netsvc.conf 更改为hosts=local,bind,nis vi /etc/resolv.conf添加nameserver X.X.X.X [@more@]
dataguard-(ORA-16004/ORA-01196/ORA-01110)-(转)
author:skatetime: 2009/08/011. 故障现象:一次突然断电导致我的standby,open时报如下的错误:ORA-16004: 备份数据库需要恢复ORA-01196: 文件 1 由于介质恢复会话失败而不一致ORA-01110: 数据文件 1: 'D:ORACLEPRODUCT10.2.0ORADATAORCLDGSYSTEM01.DBF'[@more@]author:skatetime: 2009/08/011. 故障现象:一次突然断电导致我的standby,open时报如下的错误:ORA-16004: 备份数据库需要恢复ORA-01196: 文件 1 由于介质恢复会话失败而不一致ORA-01110: 数据文件 1: 'D:ORACLEPRODUCT10.2.0ORADATAORCLDGSYSTEM01.DBF'2. 环境:os: wi
Create Trigger(建立DML/DDL触发器)
CREATE OR REPLACE TRIGGER loc_dtl_monitorBEFORE INSERT OR UPDATE OR DELETEON loc_dtlREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGININSERT INTO loc_dtl_new(LOC,ITEM_NO,QLT,LOT_NO,VERSION,FLAG,DATECODE,BRANCH,VENDOR,PLT_QTY,ACT_QTY,IN_DTE,IN_TIM,CHK_DTE,CHK_TIM,REMARK,GET_TIME) values(:OLD.LOC,:OLD.ITEM_NO,:OLD.QLT,:OLD.LOT_NO,:OLD.VERSION,:OLD.FLAG,:OLD.DATECODE,:OLD.BRANCH,:OLD.VENDOR,:OLD.PLT_QTY,:OLD.ACT_QTY,:OLD.IN_DTE,:OLD.IN_TIM,:OLD.CHK_DTE,:OLD.CHK_TIM,:OLD.REMARK,SYSDATE);END;/[@more@
持续数据保护技术/重复数据删除/MAID/IP SAN/自动精简配置/ETL/ODS/云安全
1.存储基础知识:什么是持续数据保护技术?http://product.ccidnet.com/art/6599/20080319/1394843_1.html2.什么是重复数据删除技术?http://tech.ccidnet.com/art/3089/20080509/1443885_1.html[@more@]1.存储基础知识:什么是持续数据保护技术?http://product.ccidnet.com/art/6599/20080319/1394843_1.html2.什么是重复数据删除技术?http://tech.ccidnet.com/art/3089/20080509/1443885_1.html3.什么是MAID存储?http://storage.chinabyte.com/6/8190506.shtmlhttp://product.ccidnet.com/art/6587/20080229/1376027_1.html4.什么是IP S
Sequence 批量更改与建立
select 'alter sequence '||sequence_name||' maxvalue 1300000000 cycle nocache;' from user_sequences where sequence_name not like 'SEQ%' and sequence_name not like 'A20%' and sequence_name not like 'F51%';select 'create sequence '||sequence_name||' start with 1300000001 maxvalue 1800000000 cycle nocache;' from user_sequences where sequence_name not like 'SEQ%' and sequence_name not like 'A20%' and sequence_name not like 'F51%';select 'drop sequence '||sequence_name||';' from user_sequences where s
VERITA备份日常监控及相关命令操作
VERITA备份日常监控1. 日常检查流程1)确认VERITAS NBU进程状态2)确认备份任务状态3)确认磁带、磁带机的工作状态4)确认文件系统状态5)磁带机清洗[@more@]VERITA备份日常监控1. 日常检查流程1)确认VERITAS NBU进程状态2)确认备份任务状态3)确认磁带、磁带机的工作状态4)确认文件系统状态5)磁带机清洗2. 相关检查命令启动NBU的图形管理界面:/usr/openv/netbackup/bin/jnbSA &1) 检查NBU进程状态:需要每天监控activity monitor,确认在备份服务器上运行的进程有:avrd、vmd、tldd、ltid、bprd、nbdbd、bpdbm、bpsched、bpjobd。如果前