摘要:
php code in D:\10\11\php test in D:\10\11\php\test issue 1: <html><head><title>标记应用</title></head><body> <p align="center">分段标记</p> 换行标记<br/> <center> 阅读全文
摘要:
Stop tsprod1, tsprod2 DB in 181 lsnrctl stop tsprod1 ps -ef|grep LOCAL=NO |grep -v grep |awk '{print $2}' | xargs kill -9 sqlplus / as sysdba sql>shut 阅读全文
摘要:
http://www.sosdb.com/tech/oracle_rac/56bbs2.htm Schema Change:sqlplus system/oracle123@"192.168.4.75:15021/etmsprod"select * from dba_tab_privs where 阅读全文
摘要:
Check OGG until no data queuing in replication process:testRO:a)login test5 –l oggmgrb)oggc)#ggsci> lag *check lag=0{note: when check lag result = 0, 阅读全文
摘要:
192.168.27.33test11ghdb11gtrandata: 同步delete,update 使用config 文件:同步表使用进程根据SCN号和RBA和主键同步##目的:数据定时同步,从源库 test11g同步到目标库 hdb11g testDATA.TEST 同步到 MCPDATA.T 阅读全文
摘要:
windows bat 1,C:\dba\utility\rman\rman.bat del C:\dba\utility\rman\full_db_* /qset TNSNAME=ceipuatrman target /@%TNSNAME% cmdfile=C:\dba\utility\rman\ 阅读全文
摘要:
12C引进了pdb的概念,使得rman的恢复相对来说复杂了一些,这里对pdb的常规备份和恢复进行了简单测试,供大家参考 1.cdb启动和pdb关系测试 [oracle@xifenfei tmp]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.0.2 Be 阅读全文
摘要:
--config for oralce_envlog as must run in a command window that was opened As Administrator(Due to Windows security, OPatch must run in a command wind 阅读全文
摘要:
1 删除0字节文件 find . -type f -size 0 -exec rm -rf {} \; find . type f -size 0 -delete 2 查看进程,按内存从大到小排列 ps -e -o "%C : %p : %z : %a"|sort -k5 -nr 3 按cpu利用率 阅读全文