to mismatched status. Use CROSSCHECK command to fix status

最新推荐文章于 2021-08-05 11:46:39 发布
最新推荐文章于 2021-08-05 11:46:39 发布
阅读量1.7k 收藏
点赞数
分类专栏： rman 文章标签： crosscheck
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hzdxw/article/details/43370831
版权 
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/disk1/user_bs_%d%p%s.bkp';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/user_bs_%d%p%s.bkp';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/disk2/same_bs_%d%p%s.bkp';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11G/dbs/snapcf_db01.f'; # default

RMAN> configure controlfile autobackuo off;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "autobackup"
RMAN-01008: the bad identifier was: autobackuo
RMAN-01007: at line 1 column 23 file: standard input

RMAN> configure controlfile autobackup off;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored

RMAN> backup as compressed backupset format '/home/oracle/nosetdesc/whole_%d_%U' filesperset=4  database;

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/oracle/oradata/db01/system01.dbf
input datafile fno=00009 name=/u01/oracle/oradata/db01/ts_test_me/frankts2.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00002 name=/u01/oracle/oradata/db01/undotbs01.dbf
input datafile fno=00010 name=/u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
input datafile fno=00007 name=/u01/oracle/oradata/db01/ts_test_me/demots01.dbf
input datafile fno=00012 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_3: starting compressed full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00003 name=/u01/oracle/oradata/db01/sysaux01.dbf
input datafile fno=00008 name=/u01/oracle/oradata/db01/ts_test_me/undots01.dbf
input datafile fno=00011 name=/u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
input datafile fno=00013 name=/tmp/local.dbf
channel ORA_DISK_3: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4dpu69mn_1_1 tag=TAG20150201T122350 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/oracle/oradata/db01/users01.dbf
input datafile fno=00020 name=/u01/oracle/11G/dbs/f:test.dbf
input datafile fno=00018 name=/u01/test.dbf
input datafile fno=00006 name=/u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_3: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4fpu69mo_1_1 tag=TAG20150201T122350 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:41
channel ORA_DISK_3: starting compressed full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_3: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4epu69mn_1_1 tag=TAG20150201T122350 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:44
channel ORA_DISK_2: starting compressed full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00005 name=/tmp/test_block_size.dbf
channel ORA_DISK_2: starting piece 1 at 01-FEB-15
channel ORA_DISK_3: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4hpu69o2_1_1 tag=TAG20150201T122350 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_3: starting compressed full datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_3: starting piece 1 at 01-FEB-15
channel ORA_DISK_2: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4ipu69o4_1_1 tag=TAG20150201T122350 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_3: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4jpu69o5_1_1 tag=TAG20150201T122350 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4gpu69ni_1_1 tag=TAG20150201T122350 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:27
Finished backup at 01-FEB-15

RMAN> backup as compressed backupset format '/home/oracle/nosetdesc/whole_%d_%U' filesperset=4  tablespase users;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, as, backup, backupset, blocks, channel, check, copy, copies, controlfilecopy, cumulative, current, database, datafile, datafilecopy, device, diskratio, db_recovery_file_dest, db_file_name_convert, duration, filesperset, for, format, full, force, incremental, keep, (, maxsetsize, nochecksum, noexclude, nokeep, not, proxy, pool, reuse, recovery, skip, spfile, setsize, tablespace, tag, to, validate"
RMAN-01008: the bad identifier was: tablespase
RMAN-01007: at line 1 column 91 file: standard input

RMAN> backup as compressed backupset format '/home/oracle/nosetdesc/whole_%d_%U' filesperset=4  tablespace users;

Starting backup at 01-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/oracle/oradata/db01/users01.dbf
channel ORA_DISK_1: starting piece 1 at 01-FEB-15
channel ORA_DISK_1: finished piece 1 at 01-FEB-15
piece handle=/home/oracle/nosetdesc/whole_DB01_4kpu69tm_1_1 tag=TAG20150201T122734 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-FEB-15

RMAN> list backup;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    4.15M      DISK        00:00:02     28-JAN-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150128T001250
        Piece Name: /home/oracle/disk2
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 1647826    28-JAN-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Full    3.16M      DISK        00:00:02     28-JAN-15      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20150128T001250
        Piece Name: /home/oracle/disk1
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 1647825    28-JAN-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    3.16M      DISK        00:00:02     28-JAN-15      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20150128T003949
        Piece Name: /u01/oracle/11G/dbs/user_bs_DB01119
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 1648452    28-JAN-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    4.15M      DISK        00:00:02     28-JAN-15      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20150128T003949
        Piece Name: /u01/oracle/11G/dbs/user_bs_DB01120
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 1648453    28-JAN-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
50      Incr 0  142.44M    DISK        00:00:38     29-JAN-15      
        BP Key: 50   Status: AVAILABLE  Compressed: NO  Tag: TAG20150129T224143
        Piece Name: /home/oracle/disk1/user_bs_DB01163.bkp
  List of Datafiles in backup set 50
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1723263    29-JAN-15 /u01/oracle/oradata/db01/undotbs01.dbf
  4    0  Incr 1723263    29-JAN-15 /u01/oracle/oradata/db01/users01.dbf
  7    0  Incr 1723263    29-JAN-15 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
  8    0  Incr 1723263    29-JAN-15 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
  9    0  Incr 1723263    29-JAN-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf
  10   0  Incr 819502     23-FEB-14 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
  13   0  Incr 896185     03-MAR-14 /tmp/local.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
51      Incr 0  64.00K     DISK        00:00:05     29-JAN-15      
        BP Key: 51   Status: AVAILABLE  Compressed: NO  Tag: TAG20150129T224143
        Piece Name: /home/oracle/disk1/user_bs_DB01165.bkp
  List of Datafiles in backup set 51
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 392648     22-JAN-14 /tmp/test_block_size.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
52      Incr 0  269.60M    DISK        00:01:20     29-JAN-15      
        BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20150129T224143
        Piece Name: /home/oracle/disk2/user_bs_DB01164.bkp
  List of Datafiles in backup set 52
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1723264    29-JAN-15 /u01/oracle/oradata/db01/system01.dbf
  3    0  Incr 1723264    29-JAN-15 /u01/oracle/oradata/db01/sysaux01.dbf
  6    0  Incr 1723264    29-JAN-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
  11   0  Incr 1723264    29-JAN-15 /u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
  12   0  Incr 846455     24-FEB-14 /u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
  18   0  Incr 1718978    29-JAN-15 /u01/test.dbf
  20   0  Incr 1718978    29-JAN-15 /u01/oracle/11G/dbs/f:test.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
56      Full    6.86M      DISK        00:00:01     29-JAN-15      
        BP Key: 56   Status: AVAILABLE  Compressed: NO  Tag: TAG20150129T235010
        Piece Name: /u01/oracle/11G/dbs/c-1467107934-20150129-0f
  Control File Included: Ckp SCN: 1725049      Ckp time: 29-JAN-15
  SPFILE Included: Modification time: 29-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
57      Full    1.34M      DISK        00:00:23     01-FEB-15      
        BP Key: 57   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T121057
        Piece Name: /home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1
  List of Datafiles in backup set 57
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1728843    01-FEB-15 /u01/oracle/oradata/db01/users01.dbf
  12      Full 846455     24-FEB-14 /u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf
  18      Full 1718978    29-JAN-15 /u01/test.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
58      Full    29.08M     DISK        00:00:45     01-FEB-15      
        BP Key: 58   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T121057
        Piece Name: /home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1
  List of Datafiles in backup set 58
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1728841    01-FEB-15 /u01/oracle/oradata/db01/undotbs01.dbf
  6       Full 1728841    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
  13      Full 896185     03-MAR-14 /tmp/local.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
59      Full    28.46M     DISK        00:00:48     01-FEB-15      
        BP Key: 59   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T121057
        Piece Name: /home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1
  List of Datafiles in backup set 59
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1728840    01-FEB-15 /u01/oracle/oradata/db01/system01.dbf
  9       Full 1728840    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
60      Full    3.42M      DISK        00:00:24     01-FEB-15      
        BP Key: 60   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T121057
        Piece Name: /home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1
  List of Datafiles in backup set 60
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 1728853    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
  8       Full 1728853    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
  20      Full 1718978    29-JAN-15 /u01/oracle/11G/dbs/f:test.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
61      Full    64.00K     DISK        00:00:02     01-FEB-15      
        BP Key: 61   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T121057
        Piece Name: /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1
  List of Datafiles in backup set 61
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 392648     22-JAN-14 /tmp/test_block_size.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
62      Full    7.27M      DISK        00:00:15     01-FEB-15      
        BP Key: 62   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T121057
        Piece Name: /home/oracle/nosetdesc/whole_DB01_41pu690a_1_1
  List of Datafiles in backup set 62
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1728863    01-FEB-15 /u01/oracle/oradata/db01/sysaux01.dbf
  10      Full 819502     23-FEB-14 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
  11      Full 1728863    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
63      Full    6.86M      DISK        00:00:02     01-FEB-15      
        BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20150201T121212
        Piece Name: /u01/oracle/11G/dbs/c-1467107934-20150201-00
  Control File Included: Ckp SCN: 1728873      Ckp time: 01-FEB-15
  SPFILE Included: Modification time: 29-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64      Full    6.76M      DISK        00:00:11     01-FEB-15      
        BP Key: 64   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_49pu69il_1_1
  List of Datafiles in backup set 64
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/sysaux01.dbf
  8       Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
  11      Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
  13      Full 896185     03-MAR-14 /tmp/local.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
65      Full    28.46M     DISK        00:00:18     01-FEB-15      
        BP Key: 65   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_47pu69il_1_1
  List of Datafiles in backup set 65
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1729089    01-FEB-15 /u01/oracle/oradata/db01/system01.dbf
  9       Full 1729089    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
66      Full    29.34M     DISK        00:00:19     01-FEB-15      
        BP Key: 66   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_48pu69il_1_1
  List of Datafiles in backup set 66
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1729090    01-FEB-15 /u01/oracle/oradata/db01/undotbs01.dbf
  7       Full 1729090    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
  10      Full 819502     23-FEB-14 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
  12      Full 846455     24-FEB-14 /u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67      Full    64.00K     DISK        00:00:01     01-FEB-15      
        BP Key: 67   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1
  List of Datafiles in backup set 67
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 392648     22-JAN-14 /tmp/test_block_size.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68      Full    4.21M      DISK        00:00:12     01-FEB-15      
        BP Key: 68   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1
  List of Datafiles in backup set 68
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1729098    01-FEB-15 /u01/oracle/oradata/db01/users01.dbf
  6       Full 1729098    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
  18      Full 1718978    29-JAN-15 /u01/test.dbf
  20      Full 1718978    29-JAN-15 /u01/oracle/11G/dbs/f:test.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
69      Full    6.86M      DISK        00:00:02     01-FEB-15      
        BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: TAG20150201T122218
        Piece Name: /u01/oracle/11G/dbs/c-1467107934-20150201-01
  Control File Included: Ckp SCN: 1729109      Ckp time: 01-FEB-15
  SPFILE Included: Modification time: 29-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
70      Full    28.46M     DISK        00:00:20     01-FEB-15      
        BP Key: 70   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122350
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4dpu69mn_1_1
  List of Datafiles in backup set 70
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1729156    01-FEB-15 /u01/oracle/oradata/db01/system01.dbf
  9       Full 1729156    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
71      Full    6.76M      DISK        00:00:39     01-FEB-15      
        BP Key: 71   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122350
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4fpu69mo_1_1
  List of Datafiles in backup set 71
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1729159    01-FEB-15 /u01/oracle/oradata/db01/sysaux01.dbf
  8       Full 1729159    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
  11      Full 1729159    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
  13      Full 896185     03-MAR-14 /tmp/local.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
72      Full    29.34M     DISK        00:00:43     01-FEB-15      
        BP Key: 72   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122350
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4epu69mn_1_1
  List of Datafiles in backup set 72
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1729157    01-FEB-15 /u01/oracle/oradata/db01/undotbs01.dbf
  7       Full 1729157    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
  10      Full 819502     23-FEB-14 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
  12      Full 846455     24-FEB-14 /u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
73      Full    1.06M      DISK        00:00:02     01-FEB-15      
        BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122350
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4hpu69o2_1_1
  Control File Included: Ckp SCN: 1729174      Ckp time: 01-FEB-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
74      Full    64.00K     DISK        00:00:01     01-FEB-15      
        BP Key: 74   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122350
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4ipu69o4_1_1
  List of Datafiles in backup set 74
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 392648     22-JAN-14 /tmp/test_block_size.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
75      Full    80.00K     DISK        00:00:00     01-FEB-15      
        BP Key: 75   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122350
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4jpu69o5_1_1
  SPFILE Included: Modification time: 29-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
76      Full    4.21M      DISK        00:00:25     01-FEB-15      
        BP Key: 76   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122350
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4gpu69ni_1_1
  List of Datafiles in backup set 76
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1729169    01-FEB-15 /u01/oracle/oradata/db01/users01.dbf
  6       Full 1729169    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
  18      Full 1718978    29-JAN-15 /u01/test.dbf
  20      Full 1718978    29-JAN-15 /u01/oracle/11G/dbs/f:test.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
77      Full    1.13M      DISK        00:00:00     01-FEB-15      
        BP Key: 77   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122734
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4kpu69tm_1_1
  List of Datafiles in backup set 77
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1729241    01-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> delete backup;

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
8       8       1   1   AVAILABLE   DISK        /home/oracle/disk2
9       9       1   1   AVAILABLE   DISK        /home/oracle/disk1
11      11      1   1   AVAILABLE   DISK        /u01/oracle/11G/dbs/user_bs_DB01119
12      12      1   1   AVAILABLE   DISK        /u01/oracle/11G/dbs/user_bs_DB01120
50      50      1   1   AVAILABLE   DISK        /home/oracle/disk1/user_bs_DB01163.bkp
51      51      1   1   AVAILABLE   DISK        /home/oracle/disk1/user_bs_DB01165.bkp
52      52      1   1   AVAILABLE   DISK        /home/oracle/disk2/user_bs_DB01164.bkp
56      56      1   1   AVAILABLE   DISK        /u01/oracle/11G/dbs/c-1467107934-20150129-0f
57      57      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1
58      58      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1
59      59      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1
60      60      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1
61      61      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1
62      62      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_41pu690a_1_1
63      63      1   1   AVAILABLE   DISK        /u01/oracle/11G/dbs/c-1467107934-20150201-00
64      64      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_49pu69il_1_1
65      65      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_47pu69il_1_1
66      66      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_48pu69il_1_1
67      67      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1
68      68      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1
69      69      1   1   AVAILABLE   DISK        /u01/oracle/11G/dbs/c-1467107934-20150201-01
70      70      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4dpu69mn_1_1
71      71      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4fpu69mo_1_1
72      72      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4epu69mn_1_1
73      73      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4hpu69o2_1_1
74      74      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4ipu69o4_1_1
75      75      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4jpu69o5_1_1
76      76      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4gpu69ni_1_1
77      77      1   1   AVAILABLE   DISK        /home/oracle/nosetdesc/whole_DB01_4kpu69tm_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01163.bkp recid=50 stamp=870302504
deleted backup piece
backup piece handle=/home/oracle/disk1/user_bs_DB01165.bkp recid=51 stamp=870302562
deleted backup piece
backup piece handle=/home/oracle/disk2/user_bs_DB01164.bkp recid=52 stamp=870302505
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150129-0f recid=56 stamp=870306610
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150201-00 recid=63 stamp=870523934
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/c-1467107934-20150201-01 recid=69 stamp=870524540
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4dpu69mn_1_1 recid=70 stamp=870524631
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4fpu69mo_1_1 recid=71 stamp=870524634
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4epu69mn_1_1 recid=72 stamp=870524632
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4hpu69o2_1_1 recid=73 stamp=870524675
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4ipu69o4_1_1 recid=74 stamp=870524676
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4jpu69o5_1_1 recid=75 stamp=870524677
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4gpu69ni_1_1 recid=76 stamp=870524660
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4kpu69tm_1_1 recid=77 stamp=870524854
Deleted 14 objects


RMAN-06207: WARNING: 15 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: Backup Piece    /home/oracle/disk2
RMAN-06214: Backup Piece    /home/oracle/disk1
RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01119
RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01120
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_41pu690a_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_49pu69il_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_47pu69il_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_48pu69il_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1


RMAN>

RMAN> crosscheck;


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: "archivelog, backup, backuppiece, backupset, copy, controlfilecopy, datafilecopy, proxy"
RMAN-01007: at line 1 column 11 file: standard input

RMAN> crosscheck backuppiece; 

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: "double-quoted-string, integer, single-quoted-string, tag"
RMAN-01007: at line 1 column 23 file: standard input

RMAN> crosscheck backuppiece '/home/oracle/disk1';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/disk1 recid=9 stamp=870135170
Crosschecked 1 objects


RMAN> crosscheck backuppiece '/home/oracle/disk2';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/disk2 recid=8 stamp=870135170
Crosschecked 1 objects


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
using channel ORA_DISK_3
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
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           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           59     01-FEB-15         
  Backup Piece       59     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1
Backup Set           58     01-FEB-15         
  Backup Piece       58     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1
Backup Set           57     01-FEB-15         
  Backup Piece       57     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1
Backup Set           60     01-FEB-15         
  Backup Piece       60     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1
Backup Set           62     01-FEB-15         
  Backup Piece       62     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_41pu690a_1_1
Backup Set           61     01-FEB-15         
  Backup Piece       61     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/home/oracle/disk1 recid=9 stamp=870135170
deleted backup piece
backup piece handle=/home/oracle/disk2 recid=8 stamp=870135170
Deleted 2 objects

RMAN-06207: WARNING: 8 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: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01119
RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01120
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_41pu690a_1_1
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1


RMAN>
的确删了两个文件了. 

RMAN> crosscheck backuppiece '/home/oracle/nosetdesc/*';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 02/01/2015 12:39:47
RMAN-20260: backup piece not found in the recovery catalog
RMAN-06092: error while looking up backup piece

RMAN> crosscheck backuppiece '/home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1 recid=59 stamp=870523858
Crosschecked 1 objects


RMAN> crosscheck backuppiece '/home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1 recid=58 stamp=870523859
Crosschecked 1 objects


RMAN> crosscheck backuppiece '/home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1 recid=57 stamp=870523860
Crosschecked 1 objects


RMAN> crosscheck backuppiece '';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 02/01/2015 12:40:49
RMAN-20261: ambiguous backup piece handle
RMAN-06092: error while looking up backup piece

RMAN> crosscheck backuppiece '/home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1 recid=60 stamp=870523891
Crosschecked 1 objects


RMAN> crosscheck backuppiece '/home/oracle/nosetdesc/whole_DB01_41pu690a_1_1';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_41pu690a_1_1 recid=62 stamp=870523914
Crosschecked 1 objects


RMAN> crosscheck backuppiece '';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 02/01/2015 12:41:21
RMAN-20261: ambiguous backup piece handle
RMAN-06092: error while looking up backup piece

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
using channel ORA_DISK_3
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
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           59     01-FEB-15         
  Backup Piece       59     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1
Backup Set           58     01-FEB-15         
  Backup Piece       58     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1
Backup Set           57     01-FEB-15         
  Backup Piece       57     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1
Backup Set           60     01-FEB-15         
  Backup Piece       60     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1
Backup Set           62     01-FEB-15         
  Backup Piece       62     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_41pu690a_1_1
Backup Set           61     01-FEB-15         
  Backup Piece       61     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_3tpu68ui_1_1 recid=59 stamp=870523858
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_3upu68ui_1_1 recid=58 stamp=870523859
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_3vpu68ui_1_1 recid=57 stamp=870523860
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_40pu68vg_1_1 recid=60 stamp=870523891
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_41pu690a_1_1 recid=62 stamp=870523914
Deleted 5 objects

RMAN-06207: WARNING: 3 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: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01119
RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/user_bs_DB01120
RMAN-06214: Backup Piece    /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1


RMAN> crosscheck backuppiece '/home/oracle/nosetdesc/whole_DB01_42pu690a_1_1';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_42pu690a_1_1 recid=61 stamp=870523914
Crosschecked 1 objects


RMAN> crosscheck backuppiece '/u01/oracle/11G/dbs/user_bs_DB01120';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/user_bs_DB01120 recid=12 stamp=870136790
Crosschecked 1 objects


RMAN> crosscheck backuppiece '/u01/oracle/11G/dbs/user_bs_DB01119';  

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/user_bs_DB01119 recid=11 stamp=870136790
Crosschecked 1 objects


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
using channel ORA_DISK_3
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
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           61     01-FEB-15         
  Backup Piece       61     01-FEB-15          /home/oracle/nosetdesc/whole_DB01_42pu690a_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/user_bs_DB01119 recid=11 stamp=870136790
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/user_bs_DB01120 recid=12 stamp=870136790
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_42pu690a_1_1 recid=61 stamp=870523914
Deleted 3 objects


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
using channel ORA_DISK_3
no obsolete backups found

RMAN>
已经没有过期的备份文件了.

5icode.top
关注
专栏目录
Debezium报错处理系列之三十三：Unexpected error while connecting to MySQL and looking at BINLOG_FORMAT
zhengzaifeidelushang的博客
11-10 918
Debezium报错处理系列之三十三：Unexpected error while connecting to MySQL and looking at BINLOG_FORMAT
RMAN：Use CROSSCHECK command to fix status
My Oracle Recipe
10-17 1738
问题描述 定期执行的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: Use CROSSCHECK command to fix status
ckj37786的博客
08-16 297
What to do when an obsolete rman object can't be found. Make sure ORACLE_HOME, ORACLE_SID and PATH are set corr...
RMAN-06208： to mismatched status. Use CROSSCHECK command to fix status- 未完待续
hzdxw的专栏
01-30 1302
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 obsol
转载-RMAN下CROSSCHECK命令详解
还不算晕的专栏
04-21 1638
RMAN下CROSSCHECK命令详解   在用DELETE OBSOLETE 命令删除废弃的备份文件，如果出现如下错误（RMAN-06207  &  RMAN-06208），那么需要用CROSSCHECK命令来解决： RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due RMAN-06208
RMAN 备份报错 RMAN-06207 RMAN-06208 解决方法
David Dai -- Focus on Oracle
10-21 1万+
新搭建的环境，还没上线，今天在部署脚本，RMAN 备份中有一个警告，内容如下： RMAN-06207: WARNING: 1 objects could not bedeleted for DISK channel(s) dueRMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix statusRMAN-0
ERROR 604 (42P00): Syntax error. Mismatched input. Expecting "RPAREN", got "ffffd72e"
柔情岁月的博客
10-10 5955
sqoop 导hbase数据到hive sqoop import --driver org.apache.phoenix.jdbc.PhoenixDriver --connect jdbc:phoenix:192.168.35.27,192.168.35.32,192.168.35.33:2181 --query "select * from \"ods_app_deviceInfo\...
Ruby Quick Syntax Reference.pdf
05-10
Ruby是一种动态的脚本语言，它在程序员群体中因其简洁和优雅的语法而备受喜爱。《Ruby速查手册》是一本为Ruby编程语言提供的快速参考书籍，它将Ruby的核心语法以易于查找的格式进行整理，适合于初学者到中级水平的...
三思笔记Rman
08-08
三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。三思笔记Rman。...
UnityEditor报错GUILayout: Mismatched
u011134889的博客
05-27 2759
UnityEditor报错GUILayout: Mismatched 自己编写Unity的EditorWindow时，有时候会出现类似这样的错误：ArgumentException: GUILayout: Mismatched LayoutGroup.ignore，多次出现这个错误后，发现是在与控件产生交互，同时有逻辑插入的情况造成的，而交互代码（如 GUILayout.Button() 或者 Event事件等）通常处于 BeginHorizontal() -- EndHorizontal() 或者 Beg
RMAN CROSSCHECK命令 说明
热门推荐
好记忆也需烂博客
12-19 1万+
CROSSCHECK命令:      用于核对磁盘和磁带上的备份文件，以确保RMAN资料库与备份文件保持同步。注意：该命令只会检查RMAN资料库所记载的备份文件。当执行crosscheck命令时，如果资料库记录不匹配于备份文件的物理状态，那么该命令会更新资料库记录的状态信息。备份文件的状态包括：AVALIABLE、UNAVALIABLE、EXPIRED。    1、核对所有备份集    
oracle 03002,RMAN-03002 RMAN-06091 错误解决方法
weixin_36373860的博客
04-11 2330
RMAN-03002 RMAN-06091 错误解决方法客户自从使用nbu 以来一直报这个错误。因为以前一直都是正常的。所以晚上先让停止了nbu的备份。单独使用以前的脚本正常。报错信息一样。所以怀疑是不是脚本的问题。查询网上分析原因如下：SymptomsWhen attempting to delete obsolete backups from RMAN using the following ...
Oracle 053 课程 配置备份设置
u011868279的博客
10-22 479
Last login: Mon Oct 21 16:08:22 2019 from 192.168.142.1 [root@localhost ~]# su - oracle [oracle@localhost ~]$ rman target / rlwrap: error: Cannot execute rman: No such file or directory [or...
rman备份文件删除3天前的_值得一看的RMAN 下CROSSCHECK命令详解
weixin_42502601的博客
01-25 444
概述在用DELETE OBSOLETE 命令删除废弃的备份文件，如果出现如下错误(RMAN-06207 & RMAN-06208)，那么需要用CROSSCHECK命令来解决：RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) dueRMAN-06208: to mismatched status. ...
HOW TO USE RMAN
彦祖的小号的博客
08-05 923
RMAN的详细语法查《Database Backup and Recovery Reference》,此文档未看有时间可以看一遍 如果忘记RMAN语法可以慢慢试出来，如忘记LIST语法则输入LIST后显示 RMAN-01009: syntax error: found ";": expecting one of: "all, archivelog, backed, backuppiece, backupset, backup, completed, controlfilecopy, copy, da..
oracle清除过期备份,删除过期备份报错RMAN-06207 RMAN-06208解决方案
weixin_31951365的博客
04-03 530
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-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due to mismatched status
wonder_2012的专栏
07-11 3039
使用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-01009: syntax error: found "dot" 解决办法
rudy gao
06-03 5291
RMAN-01009: syntax error: found "dot" 解决方法 　　今天调试一个RMAN 的备份脚本，这个脚本以前也用过很多次，并没有什么问题，今天执行时，就是过不去。 　　操作系统：Redhat 5.8 　　数据库：11.2.0.3 　　错误如下： 　　RMAN-00571:===================================
Not enough information to list load addresses in the image map.
最新发布
05-19
This error message usually occurs when trying to debug a program using a debugger tool. It means that the debugger cannot find the load addresses for the different sections of the program in memory. There could be several reasons for this error, such as incorrect memory mapping, mismatched build configurations, or missing debugging symbols. To solve this issue, you can try the following steps: 1. Check the memory map settings in your project and make sure it matches the actual memory layout of your target system. 2. Make sure that you are using the correct build configuration that matches the target system. 3. Check if the debugging symbols are generated correctly and are available to the debugger. 4. Try rebuilding the project and reloading it into the debugger. 5. If none of these steps work, try using a different debugger tool or consult the documentation or support resources for the debugger you are using.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

打赏作者

5icode.top

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

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

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

打赏作者

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

抵扣说明：

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

余额充值