Everything about database,how to,example,guide,

Can discuss here make Oracle machine down time the least the measure that turn.Stop multiformly machine- - of the plan perhaps be not a plan- - always happen ceaselessly,A DBA should have right backup strategy,Appear in the database so can restore quickly when the problem.

Assumed backup strategy and database are under ? ? run a condition

File of control of ? ? ? is a mirror

Database of ? ? ? moves in Archivelog mode

Every week undertakes ? ? ? cold backup

? ? ? is daily undertake heating up backup

? ? ? is daily undertake complete database derives

? ?Incident 1:Complete database reframes

? ? falls in this kind of case,The means that you can use complete database to derive cold perhaps hot backup is united in wedlock will reframe database.No matter you choose which kinds of way,those who want an attention is,The general affairs in online Redo Log can be lost.

? ?Incident 2:Restore watch space of the part

The move that ? ? can make in order to falls will restore:

? ? ? 1, start a database with Restrict mode

? ? ? 2, establish watch airspace afresh

? ? ? 3, use newest complete database to derive will guide,And use the option of Ignore=y;

? ? ? 4. Shut and start database example with the mode of Normal afresh

? ?Incident 3:Lose general data document

The refreshment that ? ? loses average data document the data file with measure basis missing place includes express dimensional kind and decide;For example:Time boil paragraph,The user expresses a space,The watch space with index watch read-only perhaps space, you may encounter the following mistake:

? ? ? . The attempt starts a database and the information ORA-1157 that comes up against a mistake, ORA-1110,The likelihood still has the mistake of an operating system

? ? ? . Attempt with Normal or the mode of Immediate shuts a database,May come up against ORA-1116, the wrong message of ORA-1110,Still have error of a system

The measure under ? ? can use as restore:

? ? ? 1, shut a database

? ? ? 2, the data file that in be being backed up by heat, restores to lose

? ? ? 3, Startup Mount database

? ? ? 4, carry out the following inquiry to get files of all your online Redo Log and they corresponding order is mixed modify order first:

...

? ? is before Oracle 8i version,Use Internal user will carry out a database start and shut and the operation such as Create Database;From 8i version later,Oracle had washed out Internal user gradually,Use grant Sysdba or the user of Sysoper part just can carry out a database start and shut wait for an operation,To maintained user habit to withhold Internal user and Svrmgrl as before in 8i,But need not use Svrmgrl tool and Internal user completely already.Newest issuance Oracle 9i washed out Svrmgrl tool and Internal user already completely.The user limits of authority that because provide,has part Sysdba is very great,Can carry out a database start and shut wait for an operation,Want to undertake monitoring to having the user of these parts so

? ? is in the Oracle database product of Unix platform,When landing a database with Sysdba attributive when the user every time,The system founds automatically the name is Ora_The file of.aud,This file acquiesce falls in $ORACLE_HOME/rdbms/audit catalog.Of this file found automatically need a system to open audit function far from.Connective user was recorded in this file,The name of terminal machine and land the information such as time.According to these information,We are OK easily monitoring arrives is why when is the person landing a database with Sysdba attributive.An example is below:

? ? 1. Carry in the client above all join with Sysdba in Sqlplus database server:

SQL of ? ? ?%26gt;Conn Sys@gs1 As Sysdba

? ? inputs countersign please:********

? ? already joined.

? ? 2. Examine a server to carry the newest Ora_ below $ORACLE_HOME/rdbms/audit catalog.aud file content:
Nbtax1%26gt;Cat Ora_589980.aud
Audit File /ora1/oracle/app/product/8.1.6/rdbms/audit/ora_589980.aud
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With The Partitioning And Parallel Server Options
JServer Release 8.1.6.3.0 - Production
ORACLE_HOME = /ora1/oracle/app/product/8.1.6
System Name: OSF1- - systematic tag
Node Name: Nbtax1- - node name
Release: V5.1- - date of operating system version
Version: 732
Machine: Alpha- - server name
Instance Name: Nbgs1- - example name
Redo Thread Mounted By This Instance: 1
Oracle Process Number: 247- - date of Oracle process
Unix Process Pid: 589980, image: Oracle@nbtax1 (TNS V1-V3)
Fri Sep 21 10:26:57 2001- - land time
ACTION: 'connect Internal' OSPRIV: DBA- - carry out why to plant operation
CLIENT USER: Administrator- - the client carries user tag
CLIENT TERMINAL: XIAOFEISHI- - the client carries terminal tag
? ? from above we can see the content in the file,This file was recorded in detail land time,Executive operation,The tag that the client carries an user,And the name that lands server terminal machine.According to these information we decide very easily why when has the person landed database server with Sysdba attributive.The Chinese character explanation in noticing Ora_589980.aud file all is added for author place,Not be the system is generated automatically.

...

? ? is in actual database application,We often encounter a such problems,After the user that receives Oracle database repeatedly was making an operation,Also operate without sequel again,But did not disconnect for long however with the database join.To a diminutive application the system is told,The join number of itself is limited,This is like without what serious consequence,But if large to database applies.The Wu that be like duty, industrial and commercial wait,If the join amount of the database is very much,Will tell to database server,A many join is about to drain a resource more,If many user join enters database system but do not undertake however any operation,This is aeriform in with respect to the waste that created server system natural resources for nothing,Cause a server to rise ladenly at the same time,The user that working really to those will tell,cannot the uses a server resource of utmost,Drop quickly what systematic performance may cause below severe case.

? ? is aimed at this kind of problem,If why are this handled?To current and popular three-layer structure (Browser/Application/Server) development will tell,The connection that this problem can use a server to carry through the setting shares a pool (Shared Pool) will avoid.But two structures to the tradition (Client/Server) apply,Must avoid this kind of resource waste a circumstance by our person for interpose.Specific and OK come through task of a tiring-room all processes in supervisory system,The process that exceeds proper time to those leisure takes certain special processing step,If clew user is carried in the client join time is too long,If do not have follow-up operating system to will kill this automatically,join or join this leisure directly kill.It the automatic monitoring that if why achieve user progress below Oracle 8x environment specific discussion come to below reachs his is certain to exceeding that the automatic monitoring that if why achieve user progress below Oracle 8x environment specific discussion come to below reachs his free time connective handles way.

? ? one, the join that certain and free time exceeds in identifying a system

? ? should realize tiring-room task to be opposite automatically exceed connective of proper time leisure to handle,The first pace works even if should identify a those join to need to handle from inside all join with database server above all,Need to obtain namely with server connective the disembarkation of every user time and the free time after its are operated for the last time.In Oracle system,Have V$session of view of a dynamic function,System of this view in store is current connective all sorts of dynamic information.Among them,Two fields LOGON_TIME and LAST_CALL_ET can get two results above.

? ? L LOGON_TIME is a date model (Date) field,Land time for the user;

? ? L LAST_CALL_ET is numeric (Number) field,Its meaning is an user last statement executes the time after ending,The unit is a second.Every time after the user carries out a new statement,This field restoration is 0,Begin to note number afresh.The free time after we can obtain last time of user of a join to operate a database through this field.

A few fundamental conditions that the SQL below ? ? inquires to the statement can get as all as current database connective user,Like the name of machine of user name, condition, connection,The name of the user in the operating system,The process date of UNIX system,Disconnect in class of UNIX operating system connective statement,Oracle database system disconnects connective statement,Land time and the last operation to be waited a moment to present free time.


...

Of ? ? problem put forward:If where between Oracle of the implementation in the program of FORM and Access watch guide and derive.

? ?The solution of the problem:

? ? intends the work:

? ? 1. Install OCA.The installation of moving Developer dish,The choice is installed from the definition,Choice Oracle Open Client Adapter For ODBC is installed.

...

The OCCI of process designing interface of the C++ that ? ? is learning Oracle recently,Oneself did to be packed simply kind,The source is stuck come out to consult for everybody.The test with this firm without the course order,It is interest place only to,If everybody wants commercial word,Still need to be perfected further,Code is passed in the test in the XlC of Vs2005 and AIX.

...

Whether can want to take out a few EMAIL that accord with a condition randomly for a certain activity in the ? ? job in you or user of mobile phone number,Will issue announcement of bear the palm or other information? The article explains with the means of example how a variety of methods of draw-out and random number.

...

? ? database of the Oracle Lite 10g at the beginning of this month the third edition comes out formally,This is a database that can embed,The employee that cause client is shift,Although be in,with them the network of origanization construction disconnects connective moment,Their need and enterprise database are alternant data and moving shift applies.For instance,A company that Oracle senior official says to be in Japan installed this kind of technology on the automat,So mobile worker can be used hold equipment to need how many goods with respect to understanding or whether does this equipment need to maintain.

...

The news briefing of Oracle 11g on July 11, 2007 time of American the eastpart part 11 when (Beijing time 11 days 22 when) hold in Newyork city,11g is the most important database version that company of inscriptions on bones or tortoise shells of the Shang Dynasty is released 30 years,Realized information lifecycle to manage according to the demand of the user (the multinomial innovation such as Information Lifecycle Management) .Enhanced systematic performance security considerably,Brand-new Data Guard is the biggest changed usability, the defray that used brand-new tall progression to reduce data to store according to compressing a technology,Shortened apparently deploy of environment of applied process test and the time that place of analytic test result spends,The support that increased space of image of medicine of RFID Tag, DICOM, 3D to wait for important data type,The support that strengthened pair of Binary XML and function are optimized.

? ? Oracle undertook network direct seeding to the news briefing,Whole news briefing lasted about 2 hours 18 minutes.

...

?? one, prepare to install

? ? is basic it is step-by-step.

The OS version that ? ? uses:OEL4

It is to cite below extract:
? [Oracle@ractest Orcl]$ Cat /etc/redhat-release
? ? Enterprise Linux Enterprise Linux AS Release 4 (October Update 5)
? ? [Oracle@ractest Orcl]$ Cat /etc/enterprise-release
? ? Enterprise Linux Enterprise Linux AS Release 4 (October Update 5)

...

? ?One. Data controls a statement (DML) part

? ? 1.INSERT (inserts the statement of the record toward data the outside and the inside)

? ? INSERT INTO expresses a name (field name 1, field name 2, ... ) VALUES (is worth 1, value 2, ... ) ;

...