RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status- 未完待续
来源:互联网 发布:北京好的设计公司知乎 编辑:程序博客网 时间:2024/06/06 19:55
RMAN> delete obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1using channel ORA_DISK_1using channel ORA_DISK_2Deleting the following obsolete backups and copies:Type Key Completion Time Filename/Handle-------------------- ------ ------------------ --------------------Control File Copy 1 14-FEB-14 /tmp/controlfile.ctlBackup 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_.bkpBackup 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_.bkpBackup 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_.bkpBackup 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_.bkpBackup 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_.bkpBackup 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_.bkpBackup 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_.bkpBackup Set 9 28-JAN-15 Backup Piece 9 28-JAN-15 /home/oracle/disk1Backup Set 8 28-JAN-15 Backup Piece 8 28-JAN-15 /home/oracle/disk2Backup 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_.bkpBackup Set 11 28-JAN-15 Backup Piece 11 28-JAN-15 /u01/oracle/11G/dbs/user_bs_DB01119Backup Set 12 28-JAN-15 Backup Piece 12 28-JAN-15 /u01/oracle/11G/dbs/user_bs_DB01120Backup Set 13 28-JAN-15 Backup Piece 13 28-JAN-15 /home/oracle/disk1/user_bs_DB01123.bkpBackup Set 14 28-JAN-15 Backup Piece 14 28-JAN-15 /home/oracle/disk2/user_bs_DB01124.bkpBackup 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_.bkpBackup 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_.bkpBackup 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_.bkpBackup Set 18 28-JAN-15 Backup Piece 18 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-02Backup 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_.bkpBackup Set 20 28-JAN-15 Backup Piece 20 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-03Backup 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_.bkpBackup Set 22 28-JAN-15 Backup Piece 22 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-04Backup 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_.bkpBackup Set 24 28-JAN-15 Backup Piece 24 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-05Backup Set 25 28-JAN-15 Backup Piece 25 28-JAN-15 /home/oracle/disk1/user_bs_DB01135.bkpBackup Set 26 28-JAN-15 Backup Piece 26 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-06Backup 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_.bkpBackup Set 28 28-JAN-15 Backup Piece 28 28-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150128-07Backup Set 29 29-JAN-15 Backup Piece 29 29-JAN-15 /home/oracle/disk/DB01/backupset/2015_01_29/o1_mf_nnndf_TAG20150129T000104_bdl1y10r_.bkpBackup Set 30 29-JAN-15 Backup Piece 30 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-00Backup Set 31 29-JAN-15 Backup Piece 31 29-JAN-15 /home/oracle/disk/same__DB01141.bkpBackup Set 32 29-JAN-15 Backup Piece 32 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-01Backup Set 33 29-JAN-15 Backup Piece 33 29-JAN-15 /home/oracle/disk/same__DB01143.bkpBackup Set 34 29-JAN-15 Backup Piece 34 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-02Backup Set 35 29-JAN-15 Backup Piece 35 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-03Backup Set 36 29-JAN-15 Backup Piece 36 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-04Backup Set 37 29-JAN-15 Backup Piece 37 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-05Backup Set 38 29-JAN-15 Backup Piece 38 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-06Backup Set 39 29-JAN-15 Backup Piece 39 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-07Backup Set 40 29-JAN-15 Backup Piece 40 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-08Backup Set 41 29-JAN-15 Backup Piece 41 29-JAN-15 /home/oracle/disk1/user_bs_DB01151.bkpBackup Set 42 29-JAN-15 Backup Piece 42 29-JAN-15 /home/oracle/disk2/user_bs_DB01152.bkpBackup Set 43 29-JAN-15 Backup Piece 43 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-09Backup Set 44 29-JAN-15 Backup Piece 44 29-JAN-15 /home/oracle/disk1/user_bs_DB01155.bkpBackup Set 45 29-JAN-15 Backup Piece 45 29-JAN-15 /home/oracle/disk2/user_bs_DB01156.bkpBackup Set 46 29-JAN-15 Backup Piece 46 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0aBackup Set 48 29-JAN-15 Backup Piece 48 29-JAN-15 /home/oracle/disk1/user_bs_DB01159.bkpBackup Set 47 29-JAN-15 Backup Piece 47 29-JAN-15 /home/oracle/disk2/user_bs_DB01160.bkpBackup Set 49 29-JAN-15 Backup Piece 49 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0bControl File Copy 3 29-JAN-15 /home/oracle/disk1/user_bs_DB01167.bkpBackup Set 53 29-JAN-15 Backup Piece 53 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0cControl File Copy 4 29-JAN-15 /u01/oracle/11G/dbs/cf_D-DB01_id-1467107934_25ptvig1Backup Set 54 29-JAN-15 Backup Piece 54 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0dBackup Set 55 29-JAN-15 Backup Piece 55 29-JAN-15 /u01/oracle/11G/dbs/c-1467107934-20150129-0eDo you really want to delete the above objects (enter YES or NO)? yesdeleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_26/o1_mf_nnndf_TAG20150126T235449_bddrtcn9_.bkp recid=1 stamp=870047691deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_26/o1_mf_s_870047902_bdds103y_.bkp recid=2 stamp=870047904deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T233853_bdhd8fbr_.bkp recid=3 stamp=870133133deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133136_bdhd8lqh_.bkp recid=4 stamp=870133138deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm4f_.bkp recid=5 stamp=870133363deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_27/o1_mf_nnndf_TAG20150127T234242_bdhdhm7h_.bkp recid=6 stamp=870133363deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_27/o1_mf_s_870133365_bdhdhp9q_.bkp recid=7 stamp=870133366deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870135174_bdhg86lh_.bkp recid=10 stamp=870135174deleted backup piecebackup piece handle=/home/oracle/disk1/user_bs_DB01123.bkp recid=13 stamp=870137495deleted backup piecebackup piece handle=/home/oracle/disk2/user_bs_DB01124.bkp recid=14 stamp=870137495deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T231801_bdkzf9lp_.bkp recid=15 stamp=870218281deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/autobackup/2015_01_28/o1_mf_s_870218284_bdkzff3k_.bkp recid=16 stamp=870218285deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232638_bdkzxgwt_.bkp recid=17 stamp=870218798deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-02 recid=18 stamp=870218802deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T232922_bdl02lq5_.bkp recid=19 stamp=870218962deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-03 recid=20 stamp=870218964deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T233646_bdl0jgck_.bkp recid=21 stamp=870219406deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-04 recid=22 stamp=870219408deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235448_bdl1l922_.bkp recid=23 stamp=870220489deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-05 recid=24 stamp=870220493deleted backup piecebackup piece handle=/home/oracle/disk1/user_bs_DB01135.bkp recid=25 stamp=870220524deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-06 recid=26 stamp=870220526deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/fast_recover_dir/DB01/backupset/2015_01_28/o1_mf_nnndf_TAG20150128T235832_bdl1s8t6_.bkp recid=27 stamp=870220712deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150128-07 recid=28 stamp=870220728deleted backup piecebackup piece handle=/home/oracle/disk/DB01/backupset/2015_01_29/o1_mf_nnndf_TAG20150129T000104_bdl1y10r_.bkp recid=29 stamp=870220865deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-00 recid=30 stamp=870220869deleted backup piecebackup piece handle=/home/oracle/disk/same__DB01141.bkp recid=31 stamp=870220935deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-01 recid=32 stamp=870220938deleted backup piecebackup piece handle=/home/oracle/disk/same__DB01143.bkp recid=33 stamp=870292703deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-02 recid=34 stamp=870292720deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-03 recid=35 stamp=870299417deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-04 recid=36 stamp=870299430deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-05 recid=37 stamp=870299448deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-06 recid=38 stamp=870299463deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-07 recid=39 stamp=870299478deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-08 recid=40 stamp=870299498deleted backup piecebackup piece handle=/home/oracle/disk1/user_bs_DB01151.bkp recid=41 stamp=870299510deleted backup piecebackup piece handle=/home/oracle/disk2/user_bs_DB01152.bkp recid=42 stamp=870299513deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-09 recid=43 stamp=870299657deleted backup piecebackup piece handle=/home/oracle/disk1/user_bs_DB01155.bkp recid=44 stamp=870301670deleted backup piecebackup piece handle=/home/oracle/disk2/user_bs_DB01156.bkp recid=45 stamp=870301671deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0a recid=46 stamp=870301797deleted backup piecebackup piece handle=/home/oracle/disk1/user_bs_DB01159.bkp recid=48 stamp=870302055deleted backup piecebackup piece handle=/home/oracle/disk2/user_bs_DB01160.bkp recid=47 stamp=870302057deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0b recid=49 stamp=870302081deleted control file copycontrol file copy filename=/home/oracle/disk1/user_bs_DB01167.bkp recid=3 stamp=870303931deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0c recid=53 stamp=870302589deleted control file copycontrol file copy filename=/u01/oracle/11G/dbs/cf_D-DB01_id-1467107934_25ptvig1 recid=4 stamp=870304258deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0d recid=54 stamp=870303933deleted backup piecebackup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0e recid=55 stamp=870304260Deleted 50 objectsRMAN-06207: WARNING: 5 objects could not be deleted for DISK channel(s) dueRMAN-06208: to mismatched status. Use CROSSCHECK command to fix statusRMAN-06210: List of Mismatched objectsRMAN-06211: ==========================RMAN-06212: Object Type Filename/HandleRMAN-06213: --------------- ---------------------------------------------------RMAN-06214: Datafile Copy /tmp/controlfile.ctlRMAN-06214: Backup Piece /home/oracle/disk1RMAN-06214: Backup Piece /home/oracle/disk2RMAN-06214: Backup Piece /u01/oracle/11G/dbs/user_bs_DB01119RMAN-06214: Backup Piece /u01/oracle/11G/dbs/user_bs_DB01120RMAN> crosscheck Datafile Copy /tmp/controlfile.ctl;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-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 inputRMAN> crosscheck Datafile Copy '/tmp/controlfile.ctl';RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-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 inputRMAN> crosscheck DatafileCopy '/tmp/controlfile.ctl';released channel: ORA_DISK_1released channel: ORA_DISK_2allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=132 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=131 devtype=DISKRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of crosscheck command at 01/30/2015 00:17:24RMAN-20230: datafile copy not found in the recovery catalogRMAN-06015: error while looking up datafile copy name: /tmp/controlfile.ctlRMAN> crosscheck controlfilecopy '/tmp/controlfile.ctl';released channel: ORA_DISK_1released channel: ORA_DISK_2allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=132 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=131 devtype=DISKvalidation failed for control file copycontrol file copy filename=/tmp/controlfile.ctl recid=1 stamp=839539056Crosschecked 1 objectsRMAN> report ;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-01009: syntax error: found ";": expecting one of: "device, need, obsolete, schema, unrecoverable"RMAN-01007: at line 1 column 8 file: standard inputRMAN>
0 0
- RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status- 未完待续
- to mismatched status. Use CROSSCHECK command to fix status
- RMAN:Use CROSSCHECK command to fix status
- RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due to mismatched status
- Do not use shared variable to check thread status
- Fix it to use EXTRA_CFLAGS
- RMAN常用命令(未完待续)
- How to: Display Command Information in the Status Bar在状态栏中显示命令信息
- You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPAC
- binutils使用错误:this linker was not configured to use sysrootscollect2:ld returned 1 exit status
- Check RMAN Backup Status
- How to use unrar command?
- Use command to create database
- Fix it to use EXTRA_CFLAGS. Stop.
- Fix it to use EXTRA_CFLAGS. Stop.
- Fix it to use EXTRA_CFLAGS. Stop.
- Fix it to use EXTRA_CFLAGS. Stop
- How To Set Screen Elements Status.
- hdu 5120 圆和圆交面积模板
- 忘记Ucenter创始人密码的最快速解决方法
- 在Excel中创建默认的工作簿工作表模板
- Largest Number
- 程序员必须知道的10大基础实用算法及其讲解
- RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status- 未完待续
- sqlserver 删除所有表和视图对象sql
- stl内存池学习(一)——内存池初认识
- skia编译在windows下编译教程
- cocos2x 游戏开发中常用软件
- WINHTTP的API接口说明。
- 坑爹玩意!
- JConsole 远程监控Tomcat服务
- xargs用法详解