化妆品网站建设平台的分析,企业建站免费模板,安徽富通建设工程有限公司网站,app打包网站开发源码RMAN即recovery manager可以通过在执行的备份任务中#xff0c;仅仅验证数据文件中的数据块而不生成实际的备份#xff0c;这样做的目的是纯粹为了了解数据文件中是否有坏块。RMAN在这个环境中#xff1a;验证数据文件是否存在数据文件位于正确的存放位置在RMAN尝试检验这些…RMAN即recovery manager可以通过在执行的备份任务中仅仅验证数据文件中的数据块而不生成实际的备份这样做的目的是纯粹为了了解数据文件中是否有坏块。RMAN在这个环境中验证数据文件是否存在数据文件位于正确的存放位置在RMAN尝试检验这些数据文件时将逻辑或物理讹误的块找出来并临时记录到V$DATABASE_BLOCK_CORRUPTION视图中具体的使用为检验整个数据库backup check logical validate database;检验个别数据文件backup check logical validate datafile 1;检验多个指定数据文件backup check logical validate datafile 1, 2;Script:1) $ rman target / nocatalog2) RMAN run {allocate channel d1 type disk;allocate channel d2 type disk;allocate channel d3 type disk;allocate channel d4 type disk;backup validate check logical database;}3) select * from V$DATABASE_BLOCK_CORRUPTION ;REM www.oracledatabase12g.com www.askmaclean.com4) If V$DATABASE_BLOCK_CORRUPTION contains rows please run this query tofind the objects that contains the corrupted blocks:SELECT e.owner,e.segment_type,e.segment_name,e.partition_name,c.file#,greatest(e.block_id, c.block#) corr_start_block#,least(e.block_id e.blocks - 1, c.block# c.blocks - 1) corr_end_block#,least(e.block_id e.blocks - 1, c.block# c.blocks - 1) -greatest(e.block_id, c.block#) 1 blocks_corrupted,null descriptionFROM dba_extents e, v$database_block_corruption cWHERE e.file_id c.file#AND e.block_id c.block# c.blocks - 1AND e.block_id e.blocks - 1 c.block#UNIONSELECT s.owner,s.segment_type,s.segment_name,s.partition_name,c.file#,header_block corr_start_block#,header_block corr_end_block#,1 blocks_corrupted,Segment Header descriptionFROM dba_segments s, v$database_block_corruption cWHERE s.header_file c.file#AND s.header_block between c.block# and c.block# c.blocks - 1UNIONSELECT null owner,null segment_type,null segment_name,null partition_name,c.file#,greatest(f.block_id, c.block#) corr_start_block#,least(f.block_id f.blocks - 1, c.block# c.blocks - 1) corr_end_block#,least(f.block_id f.blocks - 1, c.block# c.blocks - 1) -greatest(f.block_id, c.block#) 1 blocks_corrupted,Free Block descriptionFROM dba_free_space f, v$database_block_corruption cWHERE f.file_id c.file#AND f.block_id c.block# c.blocks - 1AND f.block_id f.blocks - 1 c.block#order by file#, corr_start_block#;SELECT tablespace_name, segment_type, owner, segment_nameFROM dba_extentsWHERE file_id fileidand blockid between block_id AND block_id blocks - 1;
