广告

扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >如何解决RMAN-20207报错问题
  • 903

0
分享到

如何解决RMAN-20207报错问题

2024-04-02 19:04:59 903人浏览 安东尼
摘要

这篇文章将为大家详细讲解有关如何解决RMAN-20207报错问题，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。 RMAN-20207: UNTIL TIME or RE

这篇文章将为大家详细讲解有关如何解决RMAN-20207报错问题，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。

RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time错误的解决办法如下：
我们在做RMAN恢复的时候，可以使用list incarnation 命令查看控制文件包含了哪些对应物。
当在做Media Recover的不完全恢复时，通过resetlogs打开库，则Incarnation（数据库对应物）表示这个数据库的特定的逻辑生存期。
DBA可能有时需要这样的恢复：需要使用上次执行resetlogs命令打开数据库前生成的一个备份来进行还原数据库，或者可能需要还原到执行上一个resetlogs命令之前的时间点。
比如下面的操作是将数据库恢复到2014年6月16日的状态。

因为我们没有使用catalog。所以我们先恢复控制文件。
RMAN> restore controlfile from '/db_backup/AJU_POST_CLONE/AJU_POST_BP23_EXP90/pajup/backupset_103_PAJUP_37pb14rh';
Starting restore at 21-JUL-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=242 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA/pajup/control01.ctl
output file name=+DATA/pajup/control02.ctl
output file name=+DATA/pajup/control03.ctl
Finished restore at 21-JUL-14
准备恢复数据库
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN>  run {
2>  restore database;
3>  set until time "to_date('Jun 16 2014 23:21:00','Mon DD YYYY HH24:MI:SS')";
4> recover database;
 alter database open resetlogs;
 }
下面这些是restore的过程。
Starting restore at 21-JUL-14
Starting implicit crosscheck backup at 21-JUL-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=242 device type=DISK
Crosschecked 72 objects
Finished implicit crosscheck backup at 21-JUL-14

Starting implicit crosscheck copy at 21-JUL-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 21-JUL-14

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +reco/pajup/ARCHiveLOG/2014_07_21/thread_2_seq_8.410521.853479197
File Name: +reco/pajup/ARCHIVELOG/2014_07_21/thread_1_seq_9.410522.853479197
File Name: +reco/pajup/ARCHIVELOG/2014_07_21/thread_1_seq_10.410523.853479215
File Name: +reco/pajup/ARCHIVELOG/2014_07_21/thread_1_seq_11.410576.853482583
File Name: +reco/pajup/ARCHIVELOG/2014_07_19/thread_1_seq_8.408628.853351343
File Name: +reco/pajup/ARCHIVELOG/2014_07_17/thread_2_seq_7.405955.853179347
File Name: +reco/pajup/ARCHIVELOG/2014_07_13/thread_1_seq_7.398318.852836481
File Name: +reco/pajup/ARCHIVELOG/2014_07_07/thread_2_seq_6.386816.852292813
File Name: +reco/pajup/ARCHIVELOG/2014_07_07/thread_1_seq_6.387446.852321621
File Name: +reco/pajup/ARCHIVELOG/2014_07_02/thread_1_seq_5.370578.851823445
File Name: +reco/pajup/ARCHIVELOG/2014_06_26/thread_2_seq_4.201949.851231251
File Name: +reco/pajup/ARCHIVELOG/2014_06_26/thread_1_seq_3.362093.851231251
File Name: +reco/pajup/ARCHIVELOG/2014_06_26/thread_1_seq_4.201943.851231313
File Name: +reco/pajup/ARCHIVELOG/2014_06_26/thread_2_seq_5.201969.851231313
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_1_seq_13.336310.851135615
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_1_seq_14.313117.851135615
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_1_seq_12.313662.851135629
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_2_seq_10.336295.851135629
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_2_seq_11.313730.851135633
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_2_seq_9.336277.851135633
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_2_seq_1.313806.851135651
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_2_seq_2.244417.851199885
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_1_seq_1.244552.851199885
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_1_seq_2.359503.851199943
File Name: +reco/pajup/ARCHIVELOG/2014_06_25/thread_2_seq_3.245263.851199945
File Name: +reco/pajup/ARCHIVELOG/2014_06_24/thread_2_seq_10.361501.851124225
File Name: +reco/pajup/ARCHIVELOG/2014_06_23/thread_1_seq_10.368614.850989033
File Name: +reco/pajup/ARCHIVELOG/2014_06_23/thread_1_seq_11.368758.850989567
File Name: +reco/pajup/ARCHIVELOG/2014_06_23/thread_1_seq_12.368840.850990925
File Name: +reco/pajup/ARCHIVELOG/2014_06_23/thread_2_seq_8.368841.850990927
File Name: +reco/pajup/ARCHIVELOG/2014_06_23/thread_1_seq_13.368842.850990985
File Name: +reco/pajup/ARCHIVELOG/2014_06_23/thread_2_seq_9.368843.850990985
File Name: +reco/pajup/ARCHIVELOG/2014_06_21/thread_2_seq_5.364394.850786171
File Name: +reco/pajup/ARCHIVELOG/2014_06_21/thread_2_seq_6.364405.850786185
File Name: +reco/pajup/ARCHIVELOG/2014_06_21/thread_2_seq_7.364406.850786185
File Name: +reco/pajup/ARCHIVELOG/2014_06_21/thread_1_seq_9.364407.850786187
File Name: +reco/pajup/ARCHIVELOG/2014_06_20/thread_1_seq_7.364188.850780167
File Name: +reco/pajup/ARCHIVELOG/2014_06_20/thread_1_seq_8.364176.850780547

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to +DATA/pajup/datafile/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DATA/pajup/datafile/fa_oam.dbf
channel ORA_DISK_1: restoring datafile 00008 to +DATA/pajup/datafile/fa_iassdpm.dbf
channel ORA_DISK_1: restoring datafile 00012 to +DATA/pajup/datafile/fa_oimlob.dbf
channel ORA_DISK_1: reading from backup piece /db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_79_PAJUP_2fp8rnnk
channel ORA_DISK_1: piece handle=/db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_79_PAJUP_2fp8rnnk tag=FULL_ARCHIVE_TO_NFS
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to +DATA/pajup/datafile/example01.dbf
channel ORA_DISK_1: restoring datafile 00010 to +DATA/pajup/datafile/fa_ias_iau.dbf
channel ORA_DISK_1: restoring datafile 00011 to +DATA/pajup/datafile/fa_oim.dbf
channel ORA_DISK_1: restoring datafile 00015 to +DATA/pajup/datafile/rman_data_1_tbs.3263.839401565
channel ORA_DISK_1: reading from backup piece /db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_78_PAJUP_2ep8rnnk
channel ORA_DISK_1: piece handle=/db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_78_PAJUP_2ep8rnnk tag=FULL_ARCHIVE_TO_NFS
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/pajup/datafile/system01.dbf
channel ORA_DISK_1: restoring datafile 00006 to +DATA/pajup/datafile/fa_iasoif.dbf
channel ORA_DISK_1: restoring datafile 00013 to +DATA/pajup/datafile/fa_soainfra.dbf
channel ORA_DISK_1: restoring datafile 00014 to +DATA/pajup/datafile/undotbs2.dbf
channel ORA_DISK_1: reading from backup piece /db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_80_PAJUP_2gp8rnnl
channel ORA_DISK_1: piece handle=/db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_80_PAJUP_2gp8rnnl tag=FULL_ARCHIVE_TO_NFS
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to +DATA/pajup/datafile/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to +DATA/pajup/datafile/users01.dbf
channel ORA_DISK_1: restoring datafile 00009 to +DATA/pajup/datafile/fa_mds.dbf
channel ORA_DISK_1: reading from backup piece /db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_77_PAJUP_2dp8rnnk
channel ORA_DISK_1: piece handle=/db_backup/AJU_BACKUP/POST_REL8FA_UPG/pajup/backupset_77_PAJUP_2dp8rnnk tag=FULL_ARCHIVE_TO_NFS
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
Finished restore at 21-JUL-14

executing command: SET until clause

Starting recover at 21-JUL-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/21/2014 07:13:24
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
这是准备recovery时比较常见的一个错误信息。通常我们可以通过下面的办法来解决。
RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       PAJUP    2941400143       PARENT  1383125    29-JUL-13
2       2       PAJUP    2941400143       PARENT  32325998   13-FEB-14
4       4       PAJUP    2941400143       PARENT  34279940   11-APR-14
3       3       PAJUP    2941400143       ORPHAN  34279997   20-FEB-14
5       5       PAJUP    2941400143       PARENT  36067904   22-APR-14
8       8       PAJUP    2941400143       PARENT  43039998   16-JUN-14
9       9       PAJUP    2941400143       CURRENT 44911476   25-JUN-14
7       7       PAJUP    2941400143       ORPHAN  45126273   04-JUN-14
6       6       PAJUP    2941400143       ORPHAN  45404604   06-JUN-14

RMAN> reset database to incarnation 8;

database reset to incarnation 8

RMAN>  run {
2>   restore database;
3>   set until time "to_date('Jun 16 2014 23:21:26','Mon DD YYYY HH24:MI:SS')";
4>  recover database;
 alter database open resetlogs;
 } 5> 6>

Starting restore at 21-JUL-14
using channel ORA_DISK_1

skipping datafile 1; already restored to file +DATA/pajup/datafile/system01.dbf
skipping datafile 6; already restored to file +DATA/pajup/datafile/fa_iasoif.dbf
skipping datafile 13; already restored to file +DATA/pajup/datafile/fa_soainfra.dbf
skipping datafile 14; already restored to file +DATA/pajup/datafile/undotbs2.dbf
skipping datafile 2; already restored to file +DATA/pajup/datafile/sysaux01.dbf
skipping datafile 4; already restored to file +DATA/pajup/datafile/users01.dbf
skipping datafile 9; already restored to file +DATA/pajup/datafile/fa_mds.dbf
skipping datafile 3; already restored to file +DATA/pajup/datafile/undotbs01.dbf
skipping datafile 7; already restored to file +DATA/pajup/datafile/fa_oam.dbf
skipping datafile 8; already restored to file +DATA/pajup/datafile/fa_iassdpm.dbf
skipping datafile 12; already restored to file +DATA/pajup/datafile/fa_oimlob.dbf
skipping datafile 5; already restored to file +DATA/pajup/datafile/example01.dbf
skipping datafile 10; already restored to file +DATA/pajup/datafile/fa_ias_iau.dbf
skipping datafile 11; already restored to file +DATA/pajup/datafile/fa_oim.dbf
skipping datafile 15; already restored to file +DATA/pajup/datafile/rman_data_1_tbs.3263.839401565
restore not done; all files read only, offline, or already restored
Finished restore at 21-JUL-14

executing command: SET until clause

Starting recover at 21-JUL-14
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 13 is already on disk as file +RECO/pajup/archivelog/2014_05_21/thread_1_seq_13.327534.848158501
archived log for thread 2 with sequence 9 is already on disk as file +RECO/pajup/archivelog/2014_05_21/thread_2_seq_9.327535.848158501
archived log for thread 1 with sequence 1 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_1_seq_1.358127.850419155
archived log for thread 1 with sequence 2 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_1_seq_2.358128.850419159
archived log for thread 1 with sequence 3 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_1_seq_3.358331.850429549
archived log for thread 1 with sequence 4 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_1_seq_4.358332.850429567
archived log for thread 1 with sequence 5 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_1_seq_5.358553.850432819
archived log for thread 1 with sequence 6 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_1_seq_6.358556.850432877
archived log for thread 1 with sequence 7 is already on disk as file +RECO/pajup/archivelog/2014_06_20/thread_1_seq_7.364188.850780167
archived log for thread 2 with sequence 1 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_2_seq_1.358123.850419045
archived log for thread 2 with sequence 2 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_2_seq_2.358201.850425435
archived log for thread 2 with sequence 3 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_2_seq_3.358554.850432821
archived log for thread 2 with sequence 4 is already on disk as file +RECO/pajup/archivelog/2014_06_16/thread_2_seq_4.358557.850432877
archived log for thread 2 with sequence 5 is already on disk as file +RECO/pajup/archivelog/2014_06_21/thread_2_seq_5.364394.850786171
archived log file name=+RECO/pajup/archivelog/2014_05_21/thread_1_seq_13.327534.848158501 thread=1 sequence=13
archived log file name=+RECO/pajup/archivelog/2014_05_21/thread_2_seq_9.327535.848158501 thread=2 sequence=9
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_1_seq_1.358127.850419155 thread=1 sequence=1
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_2_seq_1.358123.850419045 thread=2 sequence=1
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_1_seq_2.358128.850419159 thread=1 sequence=2
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_2_seq_2.358201.850425435 thread=2 sequence=2
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_1_seq_3.358331.850429549 thread=1 sequence=3
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_1_seq_4.358332.850429567 thread=1 sequence=4
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_2_seq_3.358554.850432821 thread=2 sequence=3
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_1_seq_5.358553.850432819 thread=1 sequence=5
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_1_seq_6.358556.850432877 thread=1 sequence=6
archived log file name=+RECO/pajup/archivelog/2014_06_16/thread_2_seq_4.358557.850432877 thread=2 sequence=4
archived log file name=+RECO/pajup/archivelog/2014_06_20/thread_1_seq_7.364188.850780167 thread=1 sequence=7
archived log file name=+RECO/pajup/archivelog/2014_06_21/thread_2_seq_5.364394.850786171 thread=2 sequence=5
media recovery complete, elapsed time: 00:00:23
Finished recover at 21-JUL-14

database opened
检查一下恢复的结果。
RMAN> validate database check logical;

Starting validate at 21-JUL-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/pajup/datafile/sysaux01.dbf
input datafile file number=00011 name=+DATA/pajup/datafile/fa_oim.dbf
input datafile file number=00001 name=+DATA/pajup/datafile/system01.dbf
input datafile file number=00003 name=+DATA/pajup/datafile/undotbs01.dbf
input datafile file number=00012 name=+DATA/pajup/datafile/fa_oimlob.dbf
input datafile file number=00014 name=+DATA/pajup/datafile/undotbs2.dbf
input datafile file number=00005 name=+DATA/pajup/datafile/example01.dbf
input datafile file number=00008 name=+DATA/pajup/datafile/fa_iassdpm.dbf
input datafile file number=00013 name=+DATA/pajup/datafile/fa_soainfra.dbf
input datafile file number=00015 name=+DATA/pajup/datafile/rman_data_1_tbs.3263.839401565
input datafile file number=00009 name=+DATA/pajup/datafile/fa_mds.dbf
input datafile file number=00007 name=+DATA/pajup/datafile/fa_oam.dbf
input datafile file number=00006 name=+DATA/pajup/datafile/fa_iasoif.dbf
input datafile file number=00010 name=+DATA/pajup/datafile/fa_ias_iau.dbf
input datafile file number=00004 name=+DATA/pajup/datafile/users01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              12976        98617           43263327 
  File Name: +DATA/pajup/datafile/system01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              64570          
  Index      0              14789          
  Other      0              6225           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2    OK     0              18614        185673          43263403 
  File Name: +DATA/pajup/datafile/sysaux01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              57085          
  Index      0              53422          
  Other      0              56479          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              1            74252           43263402 
  File Name: +DATA/pajup/datafile/undotbs01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0              
  Index      0              0              
  Other      0              74239          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4    OK     0              18           667             1540593  
  File Name: +DATA/pajup/datafile/users01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              91             
  Index      0              39             
  Other      0              492            

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     2179           31362        44244           43237510 
  File Name: +DATA/pajup/datafile/example01.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              4418           
  Index      0              1148           
  Other      0              7312           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6    OK     0              37           7682            1190254  
  File Name: +DATA/pajup/datafile/fa_iasoif.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              5              
  Index      0              14             
  Other      0              7624           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7    OK     0              337          12815           43242072 
  File Name: +DATA/pajup/datafile/fa_oam.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              2194           
  Index      0              1887           
  Other      0              8382           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8    OK     0              358          38412           42846314 
  File Name: +DATA/pajup/datafile/fa_iassdpm.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              121            
  Index      0              71             
  Other      0              37850          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              6449         19219           43241292 
  File Name: +DATA/pajup/datafile/fa_mds.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              1766           
  Index      0              4339           
  Other      0              6646           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10   OK     0              49           7681            1104562  
  File Name: +DATA/pajup/datafile/fa_ias_iau.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              38             
  Index      0              28             
  Other      0              7565           

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11   OK     2834           7482         115201          43243571 
  File Name: +DATA/pajup/datafile/fa_oim.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              49738          
  Index      0              16023          
  Other      0              41957          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12   OK     0              2111         64002           43038970 
  File Name: +DATA/pajup/datafile/fa_oimlob.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0              
  Index      0              876            
  Other      0              61013          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13   OK     0              542          25601           43038980 
  File Name: +DATA/pajup/datafile/fa_soainfra.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              188            
  Index      0              85             
  Other      0              24785          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14   OK     0              1            53362           43260164 
  File Name: +DATA/pajup/datafile/undotbs2.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0              
  Index      0              0              
  Other      0              53359          

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15   OK     0              1            25601           1638736  
  File Name: +DATA/pajup/datafile/rman_data_1_tbs.3263.839401565
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0              
  Index      0              0              
  Other      0              25599          

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation 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              614            
Finished validate at 21-JUL-14

RMAN> exit

关于“如何解决RMAN-20207报错问题”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。

您可能感兴趣的文档:
点击免费下载>>软考高级考试备考技巧/历年真题/备考精华资料

--结束END--

本文标题: 如何解决RMAN-20207报错问题

本文链接: https://www.lsjlt.com/news/64327.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑，方便收藏和打印～

下载Word文档
去做题
猜你喜欢
  • 如何解决RMAN-20207报错问题
    这篇文章将为大家详细讲解有关如何解决RMAN-20207报错问题，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。 RMAN-20207: UNTIL TIME or RE...
    99+
    2022-10-18
  • 如何解决RMAN-06019错误问题
    小编给大家分享一下如何解决RMAN-06019错误问题，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！ RMAN-06019: could not t...
    99+
    2022-10-18
  • 如何解决Oracle RMAN 备份控制文件报错问题
    本篇文章为大家展示了如何解决Oracle RMAN 备份控制文件报错问题，内容简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。从11gR2开始，控制文件备份在不保留控制文件...
    99+
    2022-10-19
  • 如何解决ORA-00245和RMAN-08132问题
    小编给大家分享一下如何解决ORA-00245和RMAN-08132问题，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！从Oracl...
    99+
    2022-10-19
  • 如何解决php 40001报错问题
    本文操作环境：Windows7系统，PHP7.4版，Dell G3电脑。如何解决php 40001报错问题？PHP 发送微信模板消息报40001 invalid credential, access_token is invalid or ...
    99+
    2021-10-22
    php
  • 如何解决php define 报错问题
    本文操作环境：Windows7系统、PHP7.1版、DELL G3电脑如何解决php define 报错问题？define()方法定义ture后报错    在PHP中，通常情况下我们可以使用define()方法定义常量，同时还可以通过定义第...
    99+
    2016-01-30
    php define
  • 如何解决php exec报错问题
    本文操作环境：Windows7系统、PHP7.1版、DELL G3电脑如何解决php exec报错问题？PHP中exec()函数执行系统命令失败？0.说明在php中，我们可以使用exec()来执行系统命令，但有时我们会遇到exec()命令执...
    99+
    2020-05-31
    php linux exec
  • 如何解决git pull报错问题
    在使用Git进行代码管理时，经常会用到git pull命令来拉取最新的代码。但是，在使用git pull时，有时候会遇到报错的情况，如何解决这些问题呢？本文将从以下几个方面介绍如何解决git pull报错问题：分析错误信息查看git log...
    99+
    2023-10-22
  • 如何解决php中use报错问题
    这篇文章将为大家详细讲解有关如何解决php中use报错问题，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。php use报错的解决办法：1、打开相应的代码文件；2、使用require引入文件；3、使用use...
    99+
    2023-06-22
  • composer依赖报错问题如何解决
    今天小编给大家分享一下composer依赖报错问题如何解决的相关知识点，内容详细，逻辑清晰，相信大部分人都还太了解这方面的知识，所以分享这篇文章给大家参考一下，希望大家阅读完这篇文章后有所收获，下面我们一起来了解一下吧。composer依赖...
    99+
    2023-07-05
  • 如何解决php make test报错问题
    本文操作环境：Windows7系统、php-5.4.5、Dell G3电脑。如何解决php make test报错问题安装php时，make test报错Build complete. Don't forget to run ...
    99+
    2020-09-19
    php make test
  • 如何解决strict standards php报错问题
    本文操作环境：Windows7系统，PHP5.3.3版，Dell G3电脑。如何解决strict standards php报错问题？PHP中Strict Standards错误解决方法在PHP5.3.3 中安装wordpress 3.0....
    99+
    2016-03-05
    strict standards php
  • 如何解决Node安装报错问题
    Node.js是一款基于Chrome V8引擎的JavaScript运行环境。它可以在服务器端运行JavaScript代码，具有高效、易学、跨平台等多种优点，因此广泛应用于后端开发、前端构建等领域。但是，在使用Node.js时，有时会遇到安...
    99+
    2023-05-14
  • 如何解决安装thinkphp报错问题
    这篇文章主要介绍了如何解决安装thinkphp报错问题的相关知识，内容详细易懂，操作简单快捷，具有一定借鉴价值，相信大家阅读完这篇如何解决安装thinkphp报错问题文章都会有所收获，下面我们一起来看看吧。一、错误提示在安装ThinkPHP...
    99+
    2023-07-05
  • Vuexunknownactiontype报错问题及解决
    目录Vuex unknown action type报错vuex unknown action type:***总结Vuex unknown action type报错 在项目中使用...
    99+
    2023-02-12
    Vuex unknown action type Vuex报错
  • pipsearch报错问题及解决
    目录pip search报错解决如下其他常见的操作总结pip search报错 在用pip查包名时搜到的都是：pip search xxx。但这样是报错的： 查找发现pip sea...
    99+
    2022-12-17
    pip search报错 pip search search报错
  • numbaCUDA报错的问题解决
    先打开cmd控制面板，输入nvcc --version，确认电脑上没有cuda 打开nvidia控制面板，看到显卡型号是3050 在帮助–系统信息下打开弹窗，在&ld...
    99+
    2023-02-02
    numba CUDA报错 numba CUDA
  • vue-cli空格报错问题如何解决
    这篇文章主要介绍“vue-cli空格报错问题如何解决”的相关知识，小编通过实际案例向大家展示操作过程，操作方法简单快捷，实用性强，希望这篇“vue-cli空格报错问题如何解决”文章能帮助大家解决问题。一、问题现象在使用 vue-cli 构建...
    99+
    2023-07-06
  • 如何解决php界定符报错问题
    本文操作环境：Windows7系统、PHP7.1版、DELL G3电脑如何解决php界定符报错问题PHP定界符出现错误Parse error: syntax error, unexpected end of file, expecting ...
    99+
    2020-10-19
    php 界定符
  • 如何解决mysql中workbench报错的问题
    这篇文章主要介绍如何解决mysql中workbench报错的问题，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！mysql 中workbench报错的解决办法：首先打开找到workbe...
    99+
    2022-10-18
软考高级职称资格查询
软考职称历年真题下载
软考职称资料下载
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作