ITPub博客

1.问题：发现ora-16014错误，这是由于在线日志归档不了造成的， db_recovery_file_dest_size参数设置小，还有就是归档空间不够1.1 show parameter db_file_reocvery 1.2(1).检查flash recovery area的使用情况：select * from v$flash_recovery_area_usage(2).计算flash recovery area已经占用的空间：select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;(3).也可以通过删除flash recovery area中不必要的备份来释放flash recovery area空间来解决这个问题：a. delete obsolete;b. crosscheck backupset; delete ex

*********************************Performance Tuning Introduction*********************************一、Oracle Database 11g Enterprise Eidition 二、Oracle Database Enterprise Manager三、Oracle Database Diagnostics Pack 1.Automatic Workload Repository 2.Automatic Database Diagnostic Monitor 3.Active Session History 四、Oracle Database Tuning Pack1.SQL Tuning Advisor 2.SQL Access Advisor五、Oracle Real Application Testing1.Database Replay2.SQL Performance Analyzer*********************************P

--查看rman配置的参数：RMAN>show all;可以显示出RMAN配置参数为:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE

一、备份和恢复概要1、高可用性(1)HA（High Availability，HA）(2)RAC(Real Application Clusters)(3)DG(Data Guard)(4)Oracle Replication(5)RAID和镜像驱动器2、备份和恢复。(1)收集备份与恢复策略需求(2)精心设计备份与恢复计划二、Oracle备份1、ORACLE各种备份(1)类型①物理备份②逻辑备份(2)数据库状态①联机备份(热)和脱机备份(冷)②不一致性备份和一致性备份(3)备份规模①完全备份:归档模式、非模式模式②表空间备份③数据文件备份④控制文件备份⑤归档日志文件备份三 、ORACLE恢复 (1)错误的类型①用户误操作导致错误②系统进程导