Some knowledge of managing Oracle

Managing a Oralce Software:

How to manage a database, what knowledge you need to know.

1. Installation: location, character set

2. Build Library: What database name

3. Database Startup:

Nomout: Read parameter file, some initialization settings information

Mount: Read the control file (understand the location of the data file, the journal file)

Open: Start (May roll or roll-instance recovery)

close:shutdown-Normal, abort-non-normal

4. Set parameters for the database:-All for memory pool and process parameter configuration

Size settings for the cache pool:

Fast size settings:---the size of the basic physical storage unit *_pool_size

5. Set Table space:

Table Space Size:

Data table Space

Temporary table space

Rollback Segment Table Space

Querying tablespace-----Data dictionary for a database (view)

6. Data files:

Change the file name of the data file inside the database

Data file size change, change name

Querying a data dictionary-----A data dictionary for a database (view)

6.oracle Management of the attempt

Select v$*** Some views

7. Data dictionary: v$***

static data dictionary: Dba_,all_,user_

Dynamic Data dictionary: v$

8. Parameter file

SPFile:

Pfile

9.undo is also recorded in redo.

Undo: Roll Forward (undo the commit)

Redo: Commit (resubmit commit failed)

10. The operation of data deletion, there must be a mechanism similar to the computer Recycle Bin

Flashback: Recycle Bin (essentially the role of the Recycle Bin)-----essentially similar to the Oracle inside recovery mechanism

Delete:redo inside

Drop: Inside the Recycle Bin

11. User, permissions, table, database, tablespace, index, trigger

12. Network management: RAC, client connection, some. ora files, plus some snooping

13.sql

14. Backup and Recovery

15.rac Installation

　　　　

　　　　　　

　　

　　

　　　　

　　

　　　　

Some knowledge of managing Oracle