Oracle_11g培训.pptVIP

相关软件 业务数据库基本信息 ORACLE_ SID：dc_db1 dc_db2 Schema name：dc_db ORACLE_HOME /oracle/product/11.2.0 数据库dc存储情况 使用ASM管理 Oracle DBA的日常管理 DBA的职责-1:系统日常监控 保证数据库正常的运行 数据库日常备份检查 定期查看alert_zd_db1.log,发现现有的问题 定期rebuild索引， 定期analyze tables和indexs 定期检查数据库的空间使用情况 定期检查Unix空间使用情况 定期做数据库的恢复测试 及时发现并解决数据库出现的问题 DBA的职责-2:容量规划 检查和积累主机的CPU、Memory、IO的使用发展情况 检查和积累磁盘阵列的空间使用情况 检查和积累Oracle 系统Load大小和Load Profile 判断什么时候需要添置新设备，给出合理的依据 统计数据库里面重要对象的增长：记录数，使用空间 Oracle进程 定期检查alert日志 /oracle/app/admin/zdora/bdump/alert_zdora1.log 1、可以使用cat、more、vi等操作系统命令查看 2、日志文件定期清理、备份 命令：备份命令cp 清理 cat /dev/null alert_zdora1.log 3、发现有ORA-开头的错误信息，及时报告系统维护工程师 4、相关详细错误信息在/oracle/admin/zdora/udump和/oracle/admin/zdora/bdump中 检查数据库的性能、空间和相关资源 1、性能：iostat、vmstat、prstat等操作系统命令，数据库中的syswait和session_wait等信息； 2、空间使用情况、空间增长情况 3、定期analyze表和索引，详见hbem_analyze_table.sql、hbem_analyze_index.sql 4、定期rebuild索引,详见hbem_rebuild_indexs.sql 常用工具OEM 数据库的空间使用情况 Session信息 感谢您的关注 页 * ASM Concepts ASM does not eliminate any preexisting database functionality. Existing databases are able to operate as they always have. New files may be created as ASM files while existing ones are administered in the old way, or can be migrated to ASM. The diagram depicts the relationships that exists between the various storage components inside an Oracle database. On the left and central parts of the diagram are the relationships that exists in previous releases. On the right are the new concepts introduced by ASM. Database files can now be stored as ASM files. At the top of the new hierarchy are ASM disk groups. Any single ASM file is contained in only one disk group. However, a disk group may contain files belonging to several databases, and a single database may use storage from multiple disk groups. As you can see, one disk group is made up of ASM disks, and each ASM disk belongs to only one disk group. ASM files are always spread across all the ASM disks in the disk group. ASM disks are partitioned in allocation units (AU) of one me