ITPub博客

I'v been back from USA for more than a week so far and everything is on the right track,like time difference,food,culture and environment etc.This trip is really impressive and absolutely unforgettable,and I'll keep it in mind as a great fortune forever.The American life is amazing at some points.For example,most of them own a big big house,whereas we just own a small small apartment;basically they drive a SUV car but a few of us drive a uncomfortable car;it is leisure time for them to work beca

Due to work and study,sorry for updating my web blog so late!In these several months there were great changes about me.First,I quited my job from Aspire for the consideration of working career.Second,I realized the importantance of English and made great progress on it.Third,It's my honor of being a member of a great foreign company which is expanding my career greatly.Finally,After succeeding in applying for passport and US visa,I'm about to go abord,because I'm going to the US for training nex

1、put the following file(login.sql) into $ORACLE_HOME；2、set environment virable：SQLPATH=$ORACLE_HOME3、the content of file(login.sql) as follows：define _editor=viset serveroutput on size 1000000set trimspool onset long 5000set linesize 100set pagesize 9999column plan_plus_exp format a80column global_name new_value gnameset termout offdefine gname=idlecolumn global_name new_value gnameselect lower(user) || '@' || substr( global_name, 1,decode( dot, 0, length(global_name), dot-1) ) global_nam

RAC：Oracle rac enables multiple independent servers that are linked by an interconnect to share access to database,providing ha,scalability,and redundancy during failure.RAC provide the benefit of the system failure,such as node failures and instance crashes;DG：dg ensures ha,data protection,and disaster recovery for enterprise data,it provide the benefit of the site failure.Flashback Database ：it provide fast recovery from logical data corruption and user errors.RMAN ：it is an utility that s

RPO(Recovery Point Objective) is focus on the loss of data;RTO(Recovery Time Objective) is focus on the loss of service.Some solutions for disaster recovery：1.Disk array copy technology(EMC SRDF,IBM PPRC,HP BusinessCopy,HDS TrueCopy);2.Storage volume copy technology(Veritas VVR);3.Datatabase copy technology(DSG RealSync,Quest SharePlex);4.Application copy technology.You should pay attention to three key considerations:TCO(Total Cost of the Ownership)ROI(Return On Investment)BCM(Business Continu