12cR2中使用validate命令

最新推荐文章于 2022-07-15 17:13:01 发布
最新推荐文章于 2022-07-15 17:13:01 发布
阅读量384 收藏
点赞数
分类专栏： 12C/18C/19C RMAN
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xxzhaobb/article/details/80159929
版权

可以使用validate命令验证物理坏块和逻辑坏块

RMAN> validate database include current controlfile plus archivelog;

Starting validate at 01-MAY-18
using channel ORA_DISK_1
specification does not match any archived log in the repository
validate cancelled because there are no files to validate
Finished validate at 01-MAY-18

Starting validate at 01-MAY-18
using channel ORA_DISK_1
file 12 is excluded from whole database backup
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              7204         33280           2368794   
  File Name: /u01/app/oracle/oradata/test/pdb1/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              16140           
  Index      0              8547            
  Other      0              1389            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10   OK     0              10752        47360           2362905   
  File Name: /u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              3964            
  Index      0              2369            
  Other      0              30275           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11   OK     0              4065         12800           2368794   
  File Name: /u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              8735            

Finished validate at 01-MAY-18

RMAN> 
RMAN> validate check logical database include current controlfile plus archivelog;

Starting validate at 01-MAY-18
using channel ORA_DISK_1
specification does not match any archived log in the repository
validate cancelled because there are no files to validate
Finished validate at 01-MAY-18

Starting validate at 01-MAY-18
using channel ORA_DISK_1
file 12 is excluded from whole database backup
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              7204         33280           2368794   
  File Name: /u01/app/oracle/oradata/test/pdb1/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              16140           
  Index      0              8547            
  Other      0              1389            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10   OK     0              10752        47360           2362905   
  File Name: /u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              3964            
  Index      0              2369            
  Other      0              30275           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11   OK     0              4065         12800           2368794   
  File Name: /u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              8735            

Finished validate at 01-MAY-18

RMAN>

检查容器数据库中指定的数据库

RMAN> validate pluggable database pdb1;

Starting validate at 2018-05-01 19:35:09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=66 device type=DISK
file 12 is excluded from whole database backup
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              7204         33280           2368794   
  File Name: /u01/app/oracle/oradata/test/pdb1/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              16140           
  Index      0              8547            
  Other      0              1389            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10   OK     0              10752        47360           2362905   
  File Name: /u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              3964            
  Index      0              2369            
  Other      0              30275           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11   OK     0              4065         12800           2368794   
  File Name: /u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              8735            

Finished validate at 2018-05-01 19:35:10

RMAN>

检查数据文件是否可用以及数据文件中是否有坏块

RMAN> backup validate database;

Starting backup at 2018-05-01 19:42:36
using channel ORA_DISK_1
file 7 is excluded from whole database backup
file 12 is excluded from whole database backup
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/test/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/test/undotbs01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              17851        104961          2370998   
  File Name: /u01/app/oracle/oradata/test/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              69507           
  Index      0              13131           
  Other      0              4471            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              19156        80675           2371434   
  File Name: /u01/app/oracle/oradata/test/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              10816           
  Index      0              11453           
  Other      0              39215           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4    OK     0              249          8960            2371434   
  File Name: /u01/app/oracle/oradata/test/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              8711            

channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              7204         33280           2371349   
  File Name: /u01/app/oracle/oradata/test/pdb1/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              16140           
  Index      0              8547            
  Other      0              1389            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10   OK     0              10752        47360           2371350   
  File Name: /u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              3964            
  Index      0              2369            
  Other      0              30275           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11   OK     0              4065         12800           2371350   
  File Name: /u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              8735            

channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00014 name=/u01/app/oracle/oradata/test/pdb2/sysaux01.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/test/pdb2/system01.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/test/pdb2/undotbs01.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/test/pdb2/users01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13   OK     0              7301         32000           1721715   
  File Name: /u01/app/oracle/oradata/test/pdb2/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              15079           
  Index      0              8239            
  Other      0              1381            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14   OK     0              7768         42240           1477258   
  File Name: /u01/app/oracle/oradata/test/pdb2/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              3528            
  Index      0              1939            
  Other      0              29005           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15   OK     0              7866         12800           1478542   
  File Name: /u01/app/oracle/oradata/test/pdb2/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              4934            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16   OK     0              513          640             1445660   
  File Name: /u01/app/oracle/oradata/test/pdb2/users01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              127             

channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/test/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/test/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/test/pdbseed/undotbs01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     0              7316         32000           1441911   
  File Name: /u01/app/oracle/oradata/test/pdbseed/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              15068           
  Index      0              8237            
  Other      0              1379            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6    OK     0              7902         42240           1441629   
  File Name: /u01/app/oracle/oradata/test/pdbseed/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              3483            
  Index      0              1929            
  Other      0              28926           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8    OK     0              7983         12800           1441909   
  File Name: /u01/app/oracle/oradata/test/pdbseed/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              4817            

channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE       OK     0              2               
Control File OK     0              1160            
Finished backup at 2018-05-01 19:43:56

RMAN>

检查是否有逻辑坏块

backup validate check logical database;

RMAN> backup validate check logical database;

Starting backup at 2018-05-01 19:43:24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=72 device type=DISK
file 12 is excluded from whole database backup
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/test/pdb1/system01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              7204         33280           2371349   
  File Name: /u01/app/oracle/oradata/test/pdb1/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              16140           
  Index      0              8547            
  Other      0              1389            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10   OK     0              10752        47360           2371350   
  File Name: /u01/app/oracle/oradata/test/pdb1/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              3964            
  Index      0              2369            
  Other      0              30275           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11   OK     0              4065         12800           2371350   
  File Name: /u01/app/oracle/oradata/test/pdb1/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0               
  Index      0              0               
  Other      0              8735            

Finished backup at 2018-05-01 19:43:25
END。。
文档搬运工
关注
专栏目录
RMAN-03002 RMAN-20242: specification does not match any archived log in the repository
EVISWANG的博客
03-21 7020
RMAN> run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_SERV=nbusrv, NB_ORA_CLIENT=Pbdopdb'; restore archivelog from sequence 34722 until sequence 34723 INCARNATION ALL; RELEAS...
mysql 归档日志恢复_RMAN 还原归档日志(restore archivelog)
weixin_33574009的博客
02-07 1783
听说过还原(restore)数据库，表空间及数据库文件，使用归档日志恢复(recover)数据库，表空间，数据库文件。咦，还有还原归档日志这一说法呢？没错，可能我们忽略了还原归档日志这一个过程，原因是还原归档日志通常情况下是Oracle在recover时自动完成的。大多数情况下我们是先还原数据库，恢复数据库，打开数据库。实际上在恢复数据库之前有一个动作，那就是还原归档日志，也就是将日志文件还原到缺...
specification does not match any archive log in the recovery catalog;
congnie1720的博客
05-20 1796
问 题：为什么会出现specification does not match any archive log in the recovery catalog； 备份脚本： run{ .....
How to delete expired archive log files using rman?
weixin_33775572的博客
06-25 126
he following commands will helpful to delete the expired archive log files using Oracle Recovery Manager(RMAN).Connect to the Rman prompt and try the bellow commands.     RMAN>list expired archive...
RMAN备份数据
weixin_33720078的博客
04-13 117
RMAN使用 1、 数据库状态 打开数据库，检查数据库是否处于归档模式 conn /as sysdba SQL> startup mount ORACLE instance started. Total System Global Area443592704 bytes Fixed Size...
jQuery中使用validate插件校验表单功能
12-29
在表单某选项中增加代码 表单中选项的name> 例如 : 性别必选 <input type=radio id=male value=m name=sex/>男 <input type=radio id=female value=f name=sex/>女 <!--这里设置表单校验错误...
Vue中使用vee-validate表单验证的方法
08-27
在模板中使用自定义规则： ```html <input type="text" name="idCard" v-model="idCard" v-validate="'idCard'" placeholder="请输入身份证号"> ('idCard')">身份证号无效 ``` 如果希望在验证失败时改变输入框的...
vue中vee validate表单校验的几种基本使用
12-29
今天主要记录一下用vee-validate来进行表单校验的几个基本使用。包括最基础的必填和长度校验；异步请求服务的校验（重名校验），还有延迟校验。如何引入等就不在这里赘述了，直接进入主题。 1.必填和长度校验 直接...
jquery_validate使用攻略中文WORD版
07-22
资源名称：jquery_validate使用攻略 中文WORD版内容简介：本文档主要讲述的是jquery.validate使用攻略；希望对大家学习jquery.validate时会有帮助；感兴趣的朋友可以过来看看资源截图：  资源太大，传百度网盘了，...
RMAN ---delete obsolete 不能删除 控制文件copy
xxjj2003的专栏
10-08 874
RMAN ---delete obsolete 不能删除 控制文件copy lixora   RMAN ---delete obsolete  不能删除 控制文件copy 说明 /tmp/contrlfile   /tmp/controlfile.bkp    /home/oracle/control01.ctl  已经通过os命令删除了 现在的疑问是如何删除这些...
DG环境RMAN删除归档报错RMAN-08137: archived log not deleted
yangjunfeng0604的博客
06-26 1013
Oracle 12C DG环境，备库归档目录告警，查看crontab脚本，发现有删除操作，保持两天的，后手动执行，查看具体报错原因； RMAN> delete noprompt expired archivelog all; released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=540...
VALIDATE DATABASE
搞怪的索引
07-20 2450
摘自：http://www.oracle.com/technetwork/cn/articles/sql/11g-rman-094332-zhs.html 主动的运行状况检查 知道数据库运行良好并且没有受损块，会让您晚上睡得更好。但是如何才能做到这一点？由于受损块仅在它们被访问时才会暴露出来，因此您希望提前识别它们并可以在用户收到错误消息之前使用简单的命令修复它们。 工具
oracle 报错归档日志文件,oracle 归档日志开启，关闭
weixin_29061041的博客
04-05 299
小白今天登陆数据库，报错：No space left on Device，查看磁盘空间：oracle@linux101:~>df -hFilesystem Size Used Avail Use% Mounted on/dev/hda1 30G 28G 2.7G 92% /udev 12G 68...
检查数据库坏块并处理
顺其自然~专栏
07-08 1187
外部命令，物理介质数据结构完整性检查；只能用于数据文件（offline或online），不支持控制文件和重做日志文件的块检查；也可以验证备份文件（rman的copy命令备份或操作系统CP命令备份）；进入盘符，然后执行以下脚本:D:\app\Administrator\oradata\orcl>dbv file=ZL9MTLBASE.DBF blocksize=8192;逻辑数据结构完整性检查；在线使用Recovery Manager扫描坏块和备份时，需要数据库运行在归档模式（archive log），否则只
oracle坏块处理
elvis的Oracle Lab
10-08 1212
1. Checksum：将data block上存储内容通过算法算出值，存放在block头上，每次读写是验证是否一致 功能查看：show parameter db_block_checksum; 默认：true 2. Checking：在内存中验证datablock address(DBA)值是否一致 功能查看：show parameter db_block_checking; 默认：f
删除备份的时候无法删除
anshejd70787的博客
06-13 228
在进行备份之后，先删除了备份文件，然后在进行删除备份记录，无法删除，显示如下： RMAN> delete copy; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=145 devtype=DISK specification does not ma...
坏块检查命令
jisen_huang的专栏
03-13 397
select * from V$DATABASE_BLOCK_CORRUPTION; execute dbms_backup_restore.resetCfileSection(35); 逻辑坏块的理解:就是内容错乱了，文件没有任何问题，例如dbwr告诉操作系统IO要写1234，但是IO出现问题导致写成了0000。 DATAGUARD环境下主库有逻辑坏块，备库不会同时生成逻辑坏块，IO是操作系统层面的独立于数据库，因为主库的IO出了问题不代表备库的IO也出问题 数据块损坏类型官方文档 块损坏可..
RMAN详细教程(二) —— 备份、检查、维护、恢复
Ruishine的博客
07-15 3979
RMAN详细教程(二) —— 备份、检查、维护、恢复
检测数据块损坏(Block Corruption)
congjiu2607的博客
11-23 1212
数据块的损坏分两种情况，第一种是物理性的，第二种是逻辑性的。物理性一般指数据块头部不可以访问、数据块校验值不合法。逻辑性一般是在物理性结构完整的情况下，数据的内容在含义上不正确，比如保存了不允许的字段值。 下面分别用两种情...
mvn validate 命令怎么使用
最新发布
05-12
要使用 `mvn validate` 命令，只需在命令行中进入 Maven 项目的根目录，然后运行以下命令： ``` mvn validate ``` 如果项目的基本信息不完整或存在错误，该命令将失败并输出错误信息。如果项目的基本信息没有问题...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值