to mismatched status. Use CROSSCHECK command to fix status
郤望
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>
类似资料：