2012年3月7日
摘要: Disk Queue Length vs. Disk Latency Times: Which is Best for Measuring Database PerformanceMonday, 29 September 2008 18:22IntroductionThere are several common metrics that people use to look for performance bottlenecks. They are usually:- Disk queue length- Disk latency/transfer times- MB/sec- IO/sec 阅读全文
posted @ 2012-03-07 14:55 weaver_chen 阅读(231) 评论(0) 推荐(0) 编辑
摘要: Oracle how-tobackup and recovery with RMANSlavo Kozac, 17 Apr 2010, 19:54============================================================BACKUP============================================================-------------------------------------------------------------- backup full database - compressed-- st 阅读全文
posted @ 2012-03-07 13:25 weaver_chen 阅读(244) 评论(0) 推荐(0) 编辑
摘要: RMAN 目录管理维护2010年07月30日 星期五 10:13关于RMAN目录管理和维护的相关知识:LIST,REPORT,CROSSCHECK,VALIDATE,CHANGE.1. LIST LIST命令将使RMAN读取目录或控制文件来显示备份的有关细节,主要是列出已有的备份的相关信息。可以添加过滤条件来查看特定的备份集、表空间、数据文件、控制文件、归档日志文件等。 1). 列出数据库形态incranation信息 RMAN> list incarnation; List of Database Incarnations DB Key Inc Key DB Name DB ID ST 阅读全文
posted @ 2012-03-07 13:16 weaver_chen 阅读(309) 评论(0) 推荐(0) 编辑
摘要: 有关备份验证的官网链接如下: Validating Database Files and Backups http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmvalid.htm#BRADV90064 Rman 对数据文件的验证,主要是验证坏块,包括逻辑坏块和物理坏块。 关于坏块的说明,参考我的Blog: Oracle 坏块 总结 http://blog.csdn.net/tianlesoftware/archive/2009/12/17/5024966.aspx一. 备份DB并查看备份备份脚本参考: Nocatal 阅读全文
posted @ 2012-03-07 12:46 weaver_chen 阅读(310) 评论(0) 推荐(0) 编辑
摘要: RMAN 的备份信息如下:RMAN> list backupset summary;List of Backups===============Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag------- -- -- - ----------- --------------- ------- ------- ---------- ---9 b 1 a disk 01-jun-11 1 1 no dave_lev110 b 1 a disk 01-jun-11 1 1 no dave_lev113 阅读全文
posted @ 2012-03-07 12:42 weaver_chen 阅读(618) 评论(0) 推荐(0) 编辑
摘要: 一、list常用命令总结备忘 list命令列出控制文件、RMAN恢复目录中备份信息, 是我们对所有可见的数据库备份文件的一个最直观的了解的方法 list incarnation; list backup summary; list backup of database summary; list backup of tablespace summary; list backup of datafile n,n summary; list archivelog all summary; list backup by file; list backup; list expired backup; 阅读全文
posted @ 2012-03-07 11:23 weaver_chen 阅读(813) 评论(0) 推荐(0) 编辑