RMAN-06208： to mismatched status. Use CROSSCHECK command to fix status- 未完待续

最新推荐文章于 2024-04-19 22:35:18 发布
最新推荐文章于 2024-04-19 22:35:18 发布
阅读量1.2k 收藏
点赞数
分类专栏： rman 文章标签： rman
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hzdxw/article/details/43287305
版权 
RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     1      14-FEB-14          /tmp/controlfile.ctl
Backup Set           1      26-JAN-15         
  Backup Piece       1      26-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_26/o1_mf_nnndf_TAG20150126T235449_bddrtcn9_.bkp
Backup Set           2      26-JAN-15         
  Backup Piece       2      26-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_26/o1_mf_s_870047902_bdds103y_.bkp
Backup Set           3      27-JAN-15         
  Backup Piece       3      27-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T233853_bdhd8fbr_.bkp
Backup Set           4      27-JAN-15         
  Backup Piece       4      27-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133136_bdhd8lqh_.bkp
Backup Set           5      27-JAN-15         
  Backup Piece       5      27-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm4f_.bkp
Backup Set           6      27-JAN-15         
  Backup Piece       6      27-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm7h_.bkp
Backup Set           7      27-JAN-15         
  Backup Piece       7      27-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133365_bdhdhp9q_.bkp
Backup Set           9      28-JAN-15         
  Backup Piece       9      28-JAN-15          /home/oracle/disk1
Backup Set           8      28-JAN-15         
  Backup Piece       8      28-JAN-15          /home/oracle/disk2
Backup Set           10     28-JAN-15         
  Backup Piece       10     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870135174_bdhg86lh_.bkp
Backup Set           11     28-JAN-15         
  Backup Piece       11     28-JAN-15          /u01/oracle/11G/dbs/user_bs_DB01119
Backup Set           12     28-JAN-15         
  Backup Piece       12     28-JAN-15          /u01/oracle/11G/dbs/user_bs_DB01120
Backup Set           13     28-JAN-15         
  Backup Piece       13     28-JAN-15          /home/oracle/disk1/user_bs_DB01123.bkp
Backup Set           14     28-JAN-15         
  Backup Piece       14     28-JAN-15          /home/oracle/disk2/user_bs_DB01124.bkp
Backup Set           15     28-JAN-15         
  Backup Piece       15     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T231801_bdkzf9lp_.bkp
Backup Set           16     28-JAN-15         
  Backup Piece       16     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870218284_bdkzff3k_.bkp
Backup Set           17     28-JAN-15         
  Backup Piece       17     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232638_bdkzxgwt_.bkp
Backup Set           18     28-JAN-15         
  Backup Piece       18     28-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150128-02
Backup Set           19     28-JAN-15         
  Backup Piece       19     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232922_bdl02lq5_.bkp
Backup Set           20     28-JAN-15         
  Backup Piece       20     28-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150128-03
Backup Set           21     28-JAN-15         
  Backup Piece       21     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T233646_bdl0jgck_.bkp
Backup Set           22     28-JAN-15         
  Backup Piece       22     28-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150128-04
Backup Set           23     28-JAN-15         
  Backup Piece       23     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235448_bdl1l922_.bkp
Backup Set           24     28-JAN-15         
  Backup Piece       24     28-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150128-05
Backup Set           25     28-JAN-15         
  Backup Piece       25     28-JAN-15          /home/oracle/disk1/user_bs_DB01135.bkp
Backup Set           26     28-JAN-15         
  Backup Piece       26     28-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150128-06
Backup Set           27     28-JAN-15         
  Backup Piece       27     28-JAN-15          /u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235832_bdl1s8t6_.bkp
Backup Set           28     28-JAN-15         
  Backup Piece       28     28-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150128-07
Backup Set           29     29-JAN-15         
  Backup Piece       29     29-JAN-15          /home/oracle/disk/DB01/backupset/2015_01_29/o1_mf_nnndf_TAG20150129T000104_bdl1y10r_.bkp
Backup Set           30     29-JAN-15         
  Backup Piece       30     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-00
Backup Set           31     29-JAN-15         
  Backup Piece       31     29-JAN-15          /home/oracle/disk/same__DB01141.bkp
Backup Set           32     29-JAN-15         
  Backup Piece       32     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-01
Backup Set           33     29-JAN-15         
  Backup Piece       33     29-JAN-15          /home/oracle/disk/same__DB01143.bkp
Backup Set           34     29-JAN-15         
  Backup Piece       34     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-02
Backup Set           35     29-JAN-15         
  Backup Piece       35     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-03
Backup Set           36     29-JAN-15         
  Backup Piece       36     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-04
Backup Set           37     29-JAN-15         
  Backup Piece       37     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-05
Backup Set           38     29-JAN-15         
  Backup Piece       38     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-06
Backup Set           39     29-JAN-15         
  Backup Piece       39     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-07
Backup Set           40     29-JAN-15         
  Backup Piece       40     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-08
Backup Set           41     29-JAN-15         
  Backup Piece       41     29-JAN-15          /home/oracle/disk1/user_bs_DB01151.bkp
Backup Set           42     29-JAN-15         
  Backup Piece       42     29-JAN-15          /home/oracle/disk2/user_bs_DB01152.bkp
Backup Set           43     29-JAN-15         
  Backup Piece       43     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-09
Backup Set           44     29-JAN-15         
  Backup Piece       44     29-JAN-15          /home/oracle/disk1/user_bs_DB01155.bkp
Backup Set           45     29-JAN-15         
  Backup Piece       45     29-JAN-15          /home/oracle/disk2/user_bs_DB01156.bkp
Backup Set           46     29-JAN-15         
  Backup Piece       46     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-0a
Backup Set           48     29-JAN-15         
  Backup Piece       48     29-JAN-15          /home/oracle/disk1/user_bs_DB01159.bkp
Backup Set           47     29-JAN-15         
  Backup Piece       47     29-JAN-15          /home/oracle/disk2/user_bs_DB01160.bkp
Backup Set           49     29-JAN-15         
  Backup Piece       49     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-0b
Control File Copy     3      29-JAN-15          /home/oracle/disk1/user_bs_DB01167.bkp
Backup Set           53     29-JAN-15         
  Backup Piece       53     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-0c
Control File Copy     4      29-JAN-15          /u01/oracle/11G/dbs/cf_D-DB01_id-1467107934_25ptvig1
Backup Set           54     29-JAN-15         
  Backup Piece       54     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-0d
Backup Set           55     29-JAN-15         
  Backup Piece       55     29-JAN-15          /u01/oracle/11G/dbs/c-1467107934-20150129-0e

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_26/o1_mf_nnndf_TAG20150126T235449_bddrtcn9_.bkp recid=1 stamp=870047691
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_26/o1_mf_s_870047902_bdds103y_.bkp recid=2 stamp=870047904
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T233853_bdhd8fbr_.bkp recid=3 stamp=870133133
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133136_bdhd8lqh_.bkp recid=4 stamp=870133138
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm4f_.bkp recid=5 stamp=870133363
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm7h_.bkp recid=6 stamp=870133363
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133365_bdhdhp9q_.bkp recid=7 stamp=870133366
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870135174_bdhg86lh_.bkp recid=10 stamp=870135174
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01123.bkp recid=13 stamp=870137495
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01124.bkp recid=14 stamp=870137495
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T231801_bdkzf9lp_.bkp recid=15 stamp=870218281
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870218284_bdkzff3k_.bkp recid=16 stamp=870218285
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232638_bdkzxgwt_.bkp recid=17 stamp=870218798
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-02 recid=18 stamp=870218802
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232922_bdl02lq5_.bkp recid=19 stamp=870218962
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-03 recid=20 stamp=870218964
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T233646_bdl0jgck_.bkp recid=21 stamp=870219406
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-04 recid=22 stamp=870219408
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235448_bdl1l922_.bkp recid=23 stamp=870220489
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-05 recid=24 stamp=870220493
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01135.bkp recid=25 stamp=870220524
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-06 recid=26 stamp=870220526
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235832_bdl1s8t6_.bkp recid=27 stamp=870220712
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-07 recid=28 stamp=870220728
deleted backup piece
backup piece handle=/home/oracle/disk/DB01/backupset/2015_01_29/o1_mf_nnndf_TAG20150129T000104_bdl1y10r_.bkp recid=29 stamp=870220865
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-00 recid=30 stamp=870220869
deleted backup piece
backup piece handle=/home/oracle/disk/same__DB01141.bkp recid=31 stamp=870220935
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-01 recid=32 stamp=870220938
deleted backup piece
backup piece handle=/home/oracle/disk/same__DB01143.bkp recid=33 stamp=870292703
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-02 recid=34 stamp=870292720
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-03 recid=35 stamp=870299417
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-04 recid=36 stamp=870299430
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-05 recid=37 stamp=870299448
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-06 recid=38 stamp=870299463
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-07 recid=39 stamp=870299478
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-08 recid=40 stamp=870299498
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01151.bkp recid=41 stamp=870299510
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01152.bkp recid=42 stamp=870299513
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-09 recid=43 stamp=870299657
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01155.bkp recid=44 stamp=870301670
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01156.bkp recid=45 stamp=870301671
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0a recid=46 stamp=870301797
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01159.bkp recid=48 stamp=870302055
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01160.bkp recid=47 stamp=870302057
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0b recid=49 stamp=870302081
deleted control file copy
control file copy filename=/home/oracle/disk1/user_bs_DB01167.bkp recid=3 stamp=870303931
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0c recid=53 stamp=870302589
deleted control file copy
control file copy filename=/u01/oracle/11G/dbs/cf_D-DB01_id-1467107934_25ptvig1 recid=4 stamp=870304258
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0d recid=54 stamp=870303933
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0e recid=55 stamp=870304260
Deleted 50 objects


RMAN-06207: WARNING: 5 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy   /tmp/controlfile.ctl
RMAN-06214: Backup Piece    /home/oracle/disk1
RMAN-06214: Backup Piece    /home/oracle/disk2
RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01119
RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01120


RMAN> crosscheck Datafile Copy   /tmp/controlfile.ctl;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "datafile": expecting one of: "archivelog, backup, backuppiece, backupset, copy, controlfilecopy, datafilecopy, proxy"
RMAN-01007: at line 1 column 12 file: standard input

RMAN> crosscheck Datafile Copy   '/tmp/controlfile.ctl';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "datafile": expecting one of: "archivelog, backup, backuppiece, backupset, copy, controlfilecopy, datafilecopy, proxy"
RMAN-01007: at line 1 column 12 file: standard input

RMAN> crosscheck DatafileCopy   '/tmp/controlfile.ctl';

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=132 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=131 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 01/30/2015 00:17:24
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: /tmp/controlfile.ctl

RMAN> crosscheck controlfilecopy  '/tmp/controlfile.ctl';

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=132 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=131 devtype=DISK
validation failed for control file copy
control file copy filename=/tmp/controlfile.ctl recid=1 stamp=839539056
Crosschecked 1 objects


RMAN> report ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "device, need, obsolete, schema, unrecoverable"
RMAN-01007: at line 1 column 8 file: standard input

RMAN>

5icode.top
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
RMAN：Use CROSSCHECK command to fix status
My Oracle Recipe
10-17 1702
问题描述 定期执行的rman备份的维护脚本，输出的日志中提示： RMAN-06207: WARNING: 26 objects could not be deleted for DISKchannel(s) due RMAN-06208:          tomismatched status.  Use CROSSCHECK command to fix status 环境    
删除过期备份报错RMAN-06207 RMAN-06208解决方案
weixin_30907523的博客
09-12 134
RMAN备份日志中出现了警告 日志文件目录如下： [root@erpdbs rmanback]# ll total 88 -rw-r--r-- 1 oraprod dba 81011 Sep 7 22:52 rmanback.log -rwxr--r-- 1 oraprod dba 2581 Jun 24 2011 rmanback.sh [root@erpdbs rmanback]# ...
RMAN 解决（RMAN-06208，RMAN-06207，ORA-19606）删除过期文件问题
csdn426523的博客
08-14 267
RMAN 解决（RMAN-06208，RMAN-06207，ORA-19606）删除过期文件问题 - RMAN> Delete noprompt obsolete; RMAN retention policy w...
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due to mismatched status
wonder_2012的专栏
07-11 3003
使用RMAN备份，运行delete noprompt obsolete; 报以上错误   RMAN> show all; RMAN configuration parameters for database with db_unique_name HZ_DG1 are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFI
自动清理过期备份文件报RMAN-06207和RMAN-06214错误
最新发布
PWY13148的专栏
04-19 447
本期将为大家分享“自动清理过期备份文件报RMAN-06207和RMAN-06214错误”的案例。
RMAN 下CROSSCHECK命令 详解
05-14 178
在用DELETE OBSOLETE 命令删除废弃的备份文件，如果出现如下错误（RMAN-06207 & RMAN-06208），那么需要用CROSSCHECK命令来解决： RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due RMAN-06208: to mismatched st...
rlwrap-0.42-1.el7.x86_64.rpm
03-12
在Linux下使用sqlplus或者rman时，经常需要调用上次或之前运行过的命令 下载包地址： http://rpm.pbone.net/index.php3/stat/4/idpl/28195042/dir/redhat_el_7/com/rlwrap-0.42-1.el7.x86_64.rpm.html 地址2： ...
rman-xttconvert_2.0.rar
05-23
在"rman-xttconvert_2.0.rar"这个压缩包中，包含了XTTConvert工具的最新版本2.0。这个版本可能引入了更多的性能优化和新特性，例如更快的转换速度、更好的错误处理机制、支持更大规模的XML数据处理等。对于那些拥有...
Oracle-RMAN增量备份恢复测试记录.docx
11-16
Oracle-RMAN增量备份恢复测试记录 Oracle-RMAN增量备份恢复测试记录是对Oracle数据库进行增量备份和恢复的测试记录，旨在记录增量备份和恢复的过程、命令和结果。下面是该测试记录的详细说明和知识点： 1. 概述： ...
instantclient-basic-windows.x64-12.1.0.2.0.zip
04-10
如果你的应用还需要ODBC、RMAN或其他高级特性，可能需要下载并安装额外的组件包，如"instantclient-sdk"或"instantclient-sqlplus"。 总的来说，Oracle Instant Client是连接Oracle数据库的必备工具，尤其适合开发...
Oracle-RMAN快速入门指南.doc
11-21
"Oracle RMAN 快速入门指南" Oracle RMAN 是一种强大的备份和恢复工具，可以用来备份和还原数据库文件、归档日志和操纵文件，同时也可以执行完全或不完全的数据库复原。以下是 Oracle RMAN 快速入门指南的详细知识...
RMAN 备份报错 RMAN-06207 RMAN-06208 解决方法
数据库天地
10-21 108
新搭建的环境，还没上线，今天在部署脚本，RMAN 备份中有一个警告，内容如下： RMAN-06207: WARNING: 1 objects could not bedeleted for DISK channel(s) due RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status RMAN-06210: ...
oracle清除过期备份,删除过期备份报错RMAN-06207 RMAN-06208解决方案
weixin_31951365的博客
04-03 491
RMAN备份日志中出现了警告日志文件目录如下：[root@erpdbs rmanback]# lltotal 88-rw-r--r-- 1 oraprod dba 81011 Sep 7 22:52 rmanback.log -rwxr--r-- 1 oraprod dba 2581 Jun 24 2011 rmanback.sh[root@erpdbs rmanback]# pwd/data/s...
在rman备份日志中出现RMAN-06207和RMAN-06208错误
Stainky的专栏
07-27 1273
原文地址：http://blog.163.com/ttlltt@126/blog/static/802861322008850484235/ 今天数据库服务公司的一位高手来我们公司进行数据库巡检，他看到在rman的备份log中有如下的警告： RMAN-06207: 警告: 由于状态不匹配, 所以不能删除 4 对象 (对于 DISK 通道)。 RMAN-06208: 请用 CROS
【Oracle】oracle用rman异机恢复部分表空间方案
Tinko123的博客
06-14 1858
RMAN异机恢复部分表空间 RMAN单独恢复表空间(异机)并不是简单的restore tablespace tbs;recover tablespace tbs; 会报错如下： RMAN-03002: failure of switch command at 11/12/2014 10:36:09 RMAN-20230: datafile copy not found in the repository RMAN-06015: error while looking up datafile copy nam
手动删除oracle 归档文件,Oracle手动删除归档日志厚，出现ORA-19571错误
weixin_34670892的博客
04-13 549
一、使用以下的命令清理了空间：1.cd/orabak2.find.-typef-mtime+30-execrm-rf{}\;二、然后开始使用rman备份的脚本进行备份，备份到最后出现以下报错----------------------------------------------------------------------------------------...
RMAN-06564: must use the TO clause when the instance is started with SPFILE
03-28
The error message RMAN-06564 is related to the Oracle Recovery Manager (RMAN) utility, and it occurs when you try to execute a command to back up or restore the database, and the instance is started ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

5icode.top

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值