Oracle 第4章+数据库.ppt

第六章 数据库管理与维护 数据库管理内容 数据库创建＆修改 数据库体系结构 控制文件 日志文件 数据文件 数据库备份＆恢复 * 创建数据库的准备 * CREATE DATABASE database_name [CONTROLFILE REUSE] [LOGFILE[GROUP n] (path\file_name) [SIZE n [K | M] [REUSE]], …n] [MAXLOGFILES n] [MAXLOGMEMBERS n] [MAXLOGHISTORY n] [MAXDATAFILES n] [MAXINSTANCES n] [ARCHIVELOG | NOARCHIVELOG] [CHARACTER SET charset] [NATIONAL CHARACTER SET charset] [DATAFILE path\file_name [SIZE n [K | M] [REUSE]] [AUTOEXTEND [ OFF | ON [NEXT n [K | M] MAXSIZE [UNLIMITED| n [K | M]]]]]] 最大的重做日志组数量 组内最大的日志文件数 归档|非归档模式 Oracle数据库体系结构 * Database Data files Online redo log files Control files Databasebuffercache Shared pool Data dictionarycache Library cache PMON SMON Others Serverprocess PGA Archived log files Userprocess Instance ARCn SGA DBWn Redo logbuffer LGWR CKPT 相关概念 进程(s) ＋ 内存 = Instance(实例) SMON(System Monitor ) PMON(Process Monitor DBWn(Database Writer ) CKPT(Checkpoint Process LGWR(Log Writer) ARCn(Archive Process ) …… * Express版本略有不同 * OracleXEClrAgent provides the host for the Microsoft Common Language Runtime - documented in the Oracle Data Provider for .NET Developers Guide and Oracle Database Extensions for .NET Developers Guide SGA内存结构 System Global Area, SGA （v$sgastat） * Database buffercache Redo log buffer Java pool Streams pool Shared pool Large pool Shared SQL area Library cache Data Dictionary cache Other I/O Buffer Response queue Request queue Free memory PMON SMON Others ARCn DBWn LGWR CKPT SGA PGA * v$sgastat v$pgastat 数据存储 * Database PMON SMON Others Data files Online redo log files Control files Instance ARCn DBWn LGWR CKPT Storage structures Userprocess Serverprocess Memory structures Processes Databasebuffercache Shared pool Data dict.cache Library cache SGA Redo logbuffer 数据查看 * select name,value from v$parameter where name like%size 数据库的备份与恢复 * 数据存储结构 * Online redo log files Password file Parameter file Archived redo log files Control files Data files Alert log and trace files Backup