after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be deleted by "delete obsolete", finally this useful command help to clean up all rubbish files.
I found the this gold from alert log.
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
If files cannot be cataloged, then manually delete them
using OS command.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
The followings are my screen dump.
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
If files cannot be cataloged, then manually delete them
using OS command.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
RMAN> report obsolete;
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 193278 Mar 27 2013 15:43:18
Backup Piece 193279 Mar 27 2013 15:43:18 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
Backup Set 202893 Apr 10 2013 14:02:59
Backup Piece 202897 Apr 10 2013 14:02:59 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812383379_8pb04mdc_.bkp
Backup Set 202894 Apr 10 2013 17:04:19
Backup Piece 202898 Apr 10 2013 17:04:19 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812394259_8pbbrmjd_.bkp
Backup Set 202895 Apr 10 2013 17:23:33
Backup Piece 202899 Apr 10 2013 17:23:33 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812395413_8pbcwopx_.bkp
Backup Set 202896 Apr 10 2013 17:33:06
Backup Piece 202900 Apr 10 2013 17:33:06 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812395986_8pbdglfx_.bkp
Backup Set 203437 Apr 11 2013 13:47:30
Backup Piece 203439 Apr 11 2013 13:47:30 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_11/o1_mf_s_812468850_8pdmmlk7_.bkp
Datafile Copy 203444 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf
Datafile Copy 203445 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf
Backup Set 203471 Apr 11 2013 14:28:02
Backup Piece 203474 Apr 11 2013 14:28:02 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_11/o1_mf_s_812471282_8pdozlbw_.bkp
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 193278 Mar 27 2013 15:43:18
Backup Piece 193279 Mar 27 2013 15:43:18 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
Backup Set 202893 Apr 10 2013 14:02:59
Backup Piece 202897 Apr 10 2013 14:02:59 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812383379_8pb04mdc_.bkp
Backup Set 202894 Apr 10 2013 17:04:19
Backup Piece 202898 Apr 10 2013 17:04:19 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812394259_8pbbrmjd_.bkp
Backup Set 202895 Apr 10 2013 17:23:33
Backup Piece 202899 Apr 10 2013 17:23:33 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812395413_8pbcwopx_.bkp
Backup Set 202896 Apr 10 2013 17:33:06
Backup Piece 202900 Apr 10 2013 17:33:06 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812395986_8pbdglfx_.bkp
Backup Set 203437 Apr 11 2013 13:47:30
Backup Piece 203439 Apr 11 2013 13:47:30 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_11/o1_mf_s_812468850_8pdmmlk7_.bkp
Datafile Copy 203444 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf
Datafile Copy 203445 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf
Backup Set 203471 Apr 11 2013 14:28:02
Backup Piece 203474 Apr 11 2013 14:28:02 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_11/o1_mf_s_812471282_8pdozlbw_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812383379_8pb04mdc_.bkp RECID=178 STAMP=812383379
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812394259_8pbbrmjd_.bkp RECID=179 STAMP=812394259
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812395413_8pbcwopx_.bkp RECID=180 STAMP=812395413
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_10/o1_mf_s_812395986_8pbdglfx_.bkp RECID=181 STAMP=812395986
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_11/o1_mf_s_812468850_8pdmmlk7_.bkp RECID=187 STAMP=812468850
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_11/o1_mf_s_812471282_8pdozlbw_.bkp RECID=189 STAMP=812471282
Deleted 6 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 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
RMAN-06214: Datafile Copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf
RMAN-06214: Datafile Copy /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf
RMAN> crosscheck copy of database;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf RECID=186 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf RECID=185 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf RECID=184 STAMP=812468846
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf RECID=181 STAMP=812468843
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf RECID=183 STAMP=812468844
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf RECID=182 STAMP=812468844
Crosschecked 6 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 193278 Mar 27 2013 15:43:18
Backup Piece 193279 Mar 27 2013 15:43:18 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
Datafile Copy 203444 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf
Datafile Copy 203445 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf
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
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 193278 Mar 27 2013 15:43:18
Backup Piece 193279 Mar 27 2013 15:43:18 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
Datafile Copy 203444 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf
Datafile Copy 203445 Apr 11 2013 13:47:24 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf
Do you really want to delete the above objects (enter YES or NO)? y
deleted datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_testtbs_8owwfv98_.dbf RECID=182 STAMP=812468844
deleted datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tts1_8owwft1v_.dbf RECID=183 STAMP=812468844
Deleted 2 objects
RMAN-06207: WARNING: 1 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 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 193278 Mar 27 2013 15:43:18
Backup Piece 193279 Mar 27 2013 15:43:18 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
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
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 193278 Mar 27 2013 15:43:18
Backup Piece 193279 Mar 27 2013 15:43:18 /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_03_27/o1_mf_s_811179797_8o58rp6r_.bkp RECID=30 STAMP=811179798
Deleted 1 objects
RMAN> exit
Recovery Manager complete.
orarac2poc:TTS:/u02/oradata/TTS> du -sk FRA
2216712 FRA
orarac2poc:TTS:/u02/oradata/TTS> cd FRA
orarac2poc:TTS:/u02/oradata/TTS/FRA> ls
TTS
orarac2poc:TTS:/u02/oradata/TTS/FRA> cd TTS
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> ls
archivelog autobackup backupset datafile flashback onlinelog
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> ls -lrt
total 24
drwxr-x--- 2 oracle asmadmin 4096 Mar 27 15:43 onlinelog
drwxr-x--- 2 oracle asmadmin 4096 Mar 28 17:06 flashback
drwxr-x--- 12 oracle asmadmin 4096 Apr 18 10:54 autobackup
drwxr-x--- 9 oracle asmadmin 4096 Apr 18 10:54 archivelog
drwxr-x--- 4 oracle asmadmin 4096 Apr 18 10:58 backupset
drwxr-x--- 2 oracle asmadmin 4096 Apr 18 10:59 datafile
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> du -sk *
27844 archivelog
336012 autobackup
124364 backupset
1728476 datafile
4 flashback
4 onlinelog
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> cd datafile/
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> ls
o1_mf_sysaux_8owwd7fd_.dbf o1_mf_tbs1_8pyrctho_.dbf o1_mf_users_8owwfwm8_.dbf
o1_mf_system_8owwc247_.dbf o1_mf_undotbs1_8owwfbql_.dbf
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> ls -lrt
total 1728472
-rw-r----- 1 oracle asmadmin 5251072 Apr 18 10:59 o1_mf_tbs1_8pyrctho_.dbf
-rw-r----- 1 oracle asmadmin 11804672 Apr 18 11:02 o1_mf_users_8owwfwm8_.dbf
-rw-r----- 1 oracle asmadmin 387981312 Apr 18 11:02 o1_mf_undotbs1_8owwfbql_.dbf
-rw-r----- 1 oracle asmadmin 734011392 Apr 18 11:03 o1_mf_system_8owwc247_.dbf
-rw-r----- 1 oracle asmadmin 629153792 Apr 18 11:03 o1_mf_sysaux_8owwd7fd_.dbf
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> date
Thu Apr 18 16:57:38 SGT 2013
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> rman target / catalog rman/rman123@RCAT
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Apr 18 16:57:44 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
connected to recovery catalog database
RMAN> crosscheck copy of database;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf RECID=186 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf RECID=185 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf RECID=184 STAMP=812468846
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf RECID=181 STAMP=812468843
Crosschecked 4 objects
RMAN> crosscheck copy ;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
specification does not match any control file copy in the repository
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf RECID=186 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf RECID=185 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf RECID=184 STAMP=812468846
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf RECID=181 STAMP=812468843
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc RECID=25 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc RECID=26 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc RECID=27 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc RECID=28 STAMP=811179063
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc RECID=29 STAMP=811179107
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc RECID=30 STAMP=811179153
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc RECID=31 STAMP=811186813
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc RECID=32 STAMP=811186850
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc RECID=7 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc RECID=4 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc RECID=5 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc RECID=8 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc RECID=2 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc RECID=3 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc RECID=1 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc RECID=6 STAMP=813083029
Crosschecked 20 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
RMAN> crosscheck datafilecopy all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf RECID=186 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf RECID=185 STAMP=812468847
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf RECID=184 STAMP=812468846
validation failed for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf RECID=181 STAMP=812468843
Crosschecked 4 objects
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc RECID=25 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc RECID=26 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc RECID=27 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc RECID=28 STAMP=811179063
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc RECID=29 STAMP=811179107
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc RECID=30 STAMP=811179153
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc RECID=31 STAMP=811186813
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc RECID=32 STAMP=811186850
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc RECID=7 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc RECID=4 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc RECID=5 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc RECID=8 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc RECID=2 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc RECID=3 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc RECID=1 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc RECID=6 STAMP=813083029
Crosschecked 16 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
RMAN> exit
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/datafile> ls -lrt
total 1728472
-rw-r----- 1 oracle asmadmin 5251072 Apr 18 10:59 o1_mf_tbs1_8pyrctho_.dbf
-rw-r----- 1 oracle asmadmin 11804672 Apr 18 11:02 o1_mf_users_8owwfwm8_.dbf
-rw-r----- 1 oracle asmadmin 387981312 Apr 18 11:02 o1_mf_undotbs1_8owwfbql_.dbf
-rw-r----- 1 oracle asmadmin 734011392 Apr 18 11:03 o1_mf_system_8owwc247_.dbf
-rw-r----- 1 oracle asmadmin 629153792 Apr 18 11:03 o1_mf_sysaux_8owwd7fd_.dbf
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> rman target / catalog rman/rman123@RCAT
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Apr 18 17:00:33 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
connected to recovery catalog database
RMAN> backup incremental level 1 for recover of copy with tag daily_incr database;
Starting backup at Apr 18 2013 17:00:44
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 device type=DISK
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 4 found
no parent backup or copy of datafile 5 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u02/oradata/TTS/system01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8pzfkzy0_.dbf tag=DAILY_INCR RECID=1 STAMP=813085269
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u02/oradata/TTS/sysaux01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8pzflsvk_.dbf tag=DAILY_INCR RECID=2 STAMP=813085293
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u02/oradata/TTS/undotbs01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8pzfmm0z_.dbf tag=DAILY_INCR RECID=3 STAMP=813085313
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u02/oradata/TTS/users01.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8pzfn252_.dbf tag=DAILY_INCR RECID=4 STAMP=813085315
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u02/oradata/TTS/tbs1.dbf
output file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pzfn5dq_.dbf tag=DAILY_INCR RECID=5 STAMP=813085317
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at Apr 18 2013 17:01:58
Starting Control File and SPFILE Autobackup at Apr 18 2013 17:01:58
piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813085323_8pzfng0r_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at Apr 18 2013 17:02:10
RMAN> CATALOG RECOVERY AREA ;
searching for all files in the recovery area
List of Files Unknown to the Database
=====================================
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812196568_8p49pr7x_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812200547_8p4fm3nx_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812211264_8p4r20n9_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812201702_8p4gq70f_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812196029_8p495y2y_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813063791_8pyrmhl9_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813080037_8pz8h67t_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813079389_8pz7txqd_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813063753_8pyrlbjs_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_28/o1_mf_s_811272380_8o835wv5_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868418_8ot982xv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868443_8ot98vgk_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868428_8ot98djk_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868201_8ot91b5p_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868233_8ot929rp_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868221_8ot91xwf_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811703243_8oo7ydpz_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706806_8oocfp72_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811702379_8oo73cv1_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811702849_8oo7l23n_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706780_8oocdwsh_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811691536_8onwjk4p_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811693094_8ony16vx_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706022_8oobo6ws_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706727_8oocc868_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811703321_8oo80sjq_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769873_8oq90kjv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769586_8oq8qlmd_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769883_8oq90vbw_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811780266_8oqm5bsv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769838_8oq8zh0h_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769291_8oq8gcoq_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_nnnd1_DAILY_INCR_8pyrbf5y_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_annnn_TAG20130418T110225_8pyrl27w_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pyrctho_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812196568_8p49pr7x_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812200547_8p4fm3nx_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812211264_8p4r20n9_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812201702_8p4gq70f_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_08/o1_mf_s_812196029_8p495y2y_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813063791_8pyrmhl9_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813080037_8pz8h67t_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813079389_8pz7txqd_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813063753_8pyrlbjs_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_05/o1_mf_s_811961042_8ox3plm1_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_03_28/o1_mf_s_811272380_8o835wv5_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868418_8ot982xv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868443_8ot98vgk_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868428_8ot98djk_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868201_8ot91b5p_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868233_8ot929rp_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_04/o1_mf_s_811868221_8ot91xwf_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811703243_8oo7ydpz_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706806_8oocfp72_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811702379_8oo73cv1_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811702849_8oo7l23n_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706780_8oocdwsh_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811691536_8onwjk4p_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811693094_8ony16vx_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706022_8oobo6ws_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811706727_8oocc868_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_02/o1_mf_s_811703321_8oo80sjq_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769873_8oq90kjv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769586_8oq8qlmd_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769883_8oq90vbw_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811780266_8oqm5bsv_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769838_8oq8zh0h_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_03/o1_mf_s_811769291_8oq8gcoq_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_nnnd1_DAILY_INCR_8pyrbf5y_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_annnn_TAG20130418T110225_8pyrl27w_.bkp
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pyrctho_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf
File Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf
RMAN> crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 device type=DISK
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc RECID=25 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc RECID=26 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc RECID=27 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc RECID=28 STAMP=811179063
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc RECID=29 STAMP=811179107
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc RECID=30 STAMP=811179153
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc RECID=31 STAMP=811186813
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc RECID=32 STAMP=811186850
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc RECID=7 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc RECID=4 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc RECID=5 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc RECID=8 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc RECID=2 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc RECID=3 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc RECID=1 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc RECID=6 STAMP=813083029
Crosschecked 16 objects
RMAN> crosscheck copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=25 device type=DISK
specification does not match any control file copy in the repository
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8pzfkzy0_.dbf RECID=1 STAMP=813085269
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf RECID=6 STAMP=813085352
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8pzflsvk_.dbf RECID=2 STAMP=813085293
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf RECID=10 STAMP=813085352
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8pzfmm0z_.dbf RECID=3 STAMP=813085313
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf RECID=8 STAMP=813085352
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8pzfn252_.dbf RECID=4 STAMP=813085315
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf RECID=9 STAMP=813085352
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pzfn5dq_.dbf RECID=5 STAMP=813085317
validation succeeded for datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pyrctho_.dbf RECID=7 STAMP=813085352
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc RECID=25 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc RECID=26 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc RECID=27 STAMP=811177908
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc RECID=28 STAMP=811179063
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc RECID=29 STAMP=811179107
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc RECID=30 STAMP=811179153
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc RECID=31 STAMP=811186813
validation failed for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc RECID=32 STAMP=811186850
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc RECID=7 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc RECID=4 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc RECID=5 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc RECID=8 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc RECID=2 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc RECID=3 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc RECID=1 STAMP=813083029
validation succeeded for archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc RECID=6 STAMP=813083029
Crosschecked 26 objects
RMAN> list copy;
specification does not match any control file copy in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - -------------------- ---------- --------------------
206452 1 A Apr 18 2013 17:01:09 2020497 Apr 18 2013 17:00:47
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8pzfkzy0_.dbf
Tag: DAILY_INCR
206490 1 A Apr 18 2013 17:02:32 1974681 Apr 18 2013 10:58:20
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf
Tag: DAILY_INCR
206453 2 A Apr 18 2013 17:01:33 2020546 Apr 18 2013 17:01:13
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8pzflsvk_.dbf
Tag: DAILY_INCR
206494 2 A Apr 18 2013 17:02:32 1974681 Apr 18 2013 10:58:20
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf
Tag: DAILY_INCR
206454 3 A Apr 18 2013 17:01:53 2020562 Apr 18 2013 17:01:38
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8pzfmm0z_.dbf
Tag: DAILY_INCR
206492 3 A Apr 18 2013 17:02:32 1974681 Apr 18 2013 10:58:20
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf
Tag: DAILY_INCR
206455 4 A Apr 18 2013 17:01:55 2020568 Apr 18 2013 17:01:54
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8pzfn252_.dbf
Tag: DAILY_INCR
206493 4 A Apr 18 2013 17:02:32 1974681 Apr 18 2013 10:58:20
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf
Tag: DAILY_INCR
206456 5 A Apr 18 2013 17:01:57 2020579 Apr 18 2013 17:01:57
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pzfn5dq_.dbf
Tag: DAILY_INCR
206491 5 A Apr 18 2013 17:02:32 1974701 Apr 18 2013 10:59:06
Name: /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pyrctho_.dbf
Tag: DAILY_INCR
List of Archived Log Copies for database with db_unique_name TTS
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - --------------------
192983 1 10 X Mar 27 2013 13:44:57
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc
192984 1 11 X Mar 27 2013 13:55:10
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc
192985 1 12 X Mar 27 2013 13:55:43
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc
193064 1 1 X Mar 27 2013 15:11:48
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc
193072 1 2 X Mar 27 2013 15:31:03
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc
193098 1 3 X Mar 27 2013 15:31:47
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc
193754 1 1 X Mar 27 2013 15:43:03
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc
193761 1 2 X Mar 27 2013 17:40:12
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc
206396 1 11 A Apr 18 2013 00:03:44
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc
206393 1 12 A Apr 18 2013 10:47:12
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc
206394 1 13 A Apr 18 2013 11:02:24
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc
206397 1 13 A Apr 18 2013 11:02:24
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc
206391 1 14 A Apr 18 2013 14:55:22
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc
206392 1 14 A Apr 18 2013 14:55:22
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc
206390 1 15 A Apr 18 2013 15:07:48
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc
206395 1 1 A Apr 18 2013 15:33:54
Name: /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 192740 Mar 27 2013 10:38:06
Backup Piece 192750 Mar 27 2013 10:38:06 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwd59_.bkp
Backup Set 192741 Mar 27 2013 10:38:07
Backup Piece 192751 Mar 27 2013 10:38:07 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp
Backup Set 192742 Mar 27 2013 11:14:59
Backup Piece 192752 Mar 27 2013 11:14:59 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp
Backup Set 192743 Mar 27 2013 11:15:00
Backup Piece 192753 Mar 27 2013 11:15:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp
Backup Set 192744 Mar 27 2013 13:45:00
Backup Piece 192754 Mar 27 2013 13:45:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp
Backup Set 192746 Mar 27 2013 13:55:10
Backup Piece 192756 Mar 27 2013 13:55:10 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp
Archive Log 192983 Mar 27 2013 15:11:48 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc
Backup Set 192748 Mar 27 2013 13:55:43
Backup Piece 192758 Mar 27 2013 13:55:43 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp
Archive Log 192984 Mar 27 2013 15:11:48 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc
Archive Log 192985 Mar 27 2013 15:11:48 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc
Archive Log 193064 Mar 27 2013 15:31:03 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc
Backup Set 193022 Mar 27 2013 15:27:08
Backup Piece 193025 Mar 27 2013 15:27:08 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp
Archive Log 193072 Mar 27 2013 15:31:47 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc
Backup Set 193080 Mar 27 2013 15:31:53
Backup Piece 193084 Mar 27 2013 15:31:53 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp
Archive Log 193098 Mar 27 2013 15:32:33 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc
Backup Set 193081 Mar 27 2013 15:31:54
Backup Piece 193085 Mar 27 2013 15:31:54 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp
Backup Set 193099 Mar 27 2013 15:32:29
Backup Piece 193102 Mar 27 2013 15:32:29 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp
Archive Log 193754 Mar 27 2013 17:40:13 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc
Backup Set 193117 Mar 27 2013 15:32:37
Backup Piece 193123 Mar 27 2013 15:32:37 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp
Archive Log 193761 Mar 27 2013 17:40:50 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc
Backup Set 203436 Apr 11 2013 13:47:11
Backup Piece 203438 Apr 11 2013 13:47:11 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp
Archive Log 206390 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc
Backup Set 203461 Apr 11 2013 14:34:20
Backup Piece 203498 Apr 11 2013 14:34:20 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp
Archive Log 206391 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc
Archive Log 206392 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc
Archive Log 206393 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc
Archive Log 206394 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc
Archive Log 206395 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc
Archive Log 206396 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc
Archive Log 206397 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc
Backup Set 206398 Apr 18 2013 16:40:13
Backup Piece 206399 Apr 18 2013 16:40:13 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813084013_8pzdcfnw_.bkp
Backup Set 206476 Apr 18 2013 17:02:32
Backup Piece 206480 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_nnnd1_DAILY_INCR_8pyrbf5y_.bkp
Datafile Copy 206490 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf
Backup Set 206477 Apr 18 2013 17:02:32
Backup Piece 206481 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_annnn_TAG20130418T110225_8pyrl27w_.bkp
Datafile Copy 206491 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pyrctho_.dbf
Datafile Copy 206492 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf
Datafile Copy 206493 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf
Datafile Copy 206494 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf
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
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 192740 Mar 27 2013 10:38:06
Backup Piece 192750 Mar 27 2013 10:38:06 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwd59_.bkp
Backup Set 192741 Mar 27 2013 10:38:07
Backup Piece 192751 Mar 27 2013 10:38:07 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp
Backup Set 192742 Mar 27 2013 11:14:59
Backup Piece 192752 Mar 27 2013 11:14:59 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp
Backup Set 192743 Mar 27 2013 11:15:00
Backup Piece 192753 Mar 27 2013 11:15:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp
Backup Set 192744 Mar 27 2013 13:45:00
Backup Piece 192754 Mar 27 2013 13:45:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp
Backup Set 192746 Mar 27 2013 13:55:10
Backup Piece 192756 Mar 27 2013 13:55:10 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp
Archive Log 192983 Mar 27 2013 15:11:48 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc
Backup Set 192748 Mar 27 2013 13:55:43
Backup Piece 192758 Mar 27 2013 13:55:43 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp
Archive Log 192984 Mar 27 2013 15:11:48 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc
Archive Log 192985 Mar 27 2013 15:11:48 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc
Archive Log 193064 Mar 27 2013 15:31:03 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc
Backup Set 193022 Mar 27 2013 15:27:08
Backup Piece 193025 Mar 27 2013 15:27:08 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp
Archive Log 193072 Mar 27 2013 15:31:47 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc
Backup Set 193080 Mar 27 2013 15:31:53
Backup Piece 193084 Mar 27 2013 15:31:53 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp
Archive Log 193098 Mar 27 2013 15:32:33 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc
Backup Set 193081 Mar 27 2013 15:31:54
Backup Piece 193085 Mar 27 2013 15:31:54 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp
Backup Set 193099 Mar 27 2013 15:32:29
Backup Piece 193102 Mar 27 2013 15:32:29 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp
Archive Log 193754 Mar 27 2013 17:40:13 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc
Backup Set 193117 Mar 27 2013 15:32:37
Backup Piece 193123 Mar 27 2013 15:32:37 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp
Archive Log 193761 Mar 27 2013 17:40:50 /u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc
Backup Set 203436 Apr 11 2013 13:47:11
Backup Piece 203438 Apr 11 2013 13:47:11 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp
Archive Log 206390 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc
Backup Set 203461 Apr 11 2013 14:34:20
Backup Piece 203498 Apr 11 2013 14:34:20 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp
Archive Log 206391 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc
Archive Log 206392 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc
Archive Log 206393 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc
Archive Log 206394 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc
Archive Log 206395 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc
Archive Log 206396 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc
Archive Log 206397 Apr 18 2013 16:23:49 /u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc
Backup Set 206398 Apr 18 2013 16:40:13
Backup Piece 206399 Apr 18 2013 16:40:13 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813084013_8pzdcfnw_.bkp
Backup Set 206476 Apr 18 2013 17:02:32
Backup Piece 206480 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_nnnd1_DAILY_INCR_8pyrbf5y_.bkp
Datafile Copy 206490 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf
Backup Set 206477 Apr 18 2013 17:02:32
Backup Piece 206481 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_annnn_TAG20130418T110225_8pyrl27w_.bkp
Datafile Copy 206491 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pyrctho_.dbf
Datafile Copy 206492 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf
Datafile Copy 206493 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf
Datafile Copy 206494 Apr 18 2013 17:02:32 /u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_10_8o56xnsv_.arc RECID=25 STAMP=811177908
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_11_8o56xnwb_.arc RECID=26 STAMP=811177908
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_12_8o56xnxm_.arc RECID=27 STAMP=811177908
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o581ql6_.arc RECID=28 STAMP=811179063
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5833vd_.arc RECID=29 STAMP=811179107
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_3_8o584kto_.arc RECID=30 STAMP=811179153
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_1_8o5hmwv7_.arc RECID=31 STAMP=811186813
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_03_27/o1_mf_1_2_8o5ho2xl_.arc RECID=32 STAMP=811186850
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_15_8pz7tsf3_.arc RECID=1 STAMP=813083029
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz6y4mw_.arc RECID=2 STAMP=813083029
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_14_8pz7tsc0_.arc RECID=3 STAMP=813083029
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_12_8pz66thv_.arc RECID=4 STAMP=813083029
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz66ttc_.arc RECID=5 STAMP=813083029
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_1_8pzc5ghs_.arc RECID=6 STAMP=813083029
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_11_8pz66tdt_.arc RECID=7 STAMP=813083029
deleted archived log
archived log file name=/u02/oradata/TTS/FRA/TTS/archivelog/2013_04_18/o1_mf_1_13_8pz7ts9g_.arc RECID=8 STAMP=813083029
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813084013_8pzdcfnw_.bkp RECID=1 STAMP=813084013
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_nnnd1_DAILY_INCR_8pyrbf5y_.bkp RECID=3 STAMP=813085352
deleted datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_system_8owwc247_.dbf RECID=6 STAMP=813085352
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_18/o1_mf_annnn_TAG20130418T110225_8pyrl27w_.bkp RECID=4 STAMP=813085352
deleted datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_tbs1_8pyrctho_.dbf RECID=7 STAMP=813085352
deleted datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_undotbs1_8owwfbql_.dbf RECID=8 STAMP=813085352
deleted datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_users_8owwfwm8_.dbf RECID=9 STAMP=813085352
deleted datafile copy
datafile copy file name=/u02/oradata/TTS/FRA/TTS/datafile/o1_mf_sysaux_8owwd7fd_.dbf RECID=10 STAMP=813085352
Deleted 24 objects
RMAN-06207: WARNING: 14 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 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwd59_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp
RMAN> exit
Recovery Manager complete.
ls -lrorarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> t
-bash: t: command not found
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> ls -lrt
total 24
drwxr-x--- 2 oracle asmadmin 4096 Mar 27 15:43 onlinelog
drwxr-x--- 2 oracle asmadmin 4096 Mar 28 17:06 flashback
drwxr-x--- 9 oracle asmadmin 4096 Apr 18 10:54 archivelog
drwxr-x--- 4 oracle asmadmin 4096 Apr 18 10:58 backupset
drwxr-x--- 10 oracle asmadmin 4096 Apr 18 17:02 autobackup
drwxr-x--- 2 oracle asmadmin 4096 Apr 18 17:03 datafile
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> du -sk *
32 archivelog
336004 autobackup
12 backupset
1728476 datafile
4 flashback
4 onlinelog
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS> ls -l datafile/
total 1728472
-rw-r----- 1 oracle asmadmin 629153792 Apr 18 17:01 o1_mf_sysaux_8pzflsvk_.dbf
-rw-r----- 1 oracle asmadmin 734011392 Apr 18 17:01 o1_mf_system_8pzfkzy0_.dbf
-rw-r----- 1 oracle asmadmin 5251072 Apr 18 17:01 o1_mf_tbs1_8pzfn5dq_.dbf
-rw-r----- 1 oracle asmadmin 387981312 Apr 18 17:01 o1_mf_undotbs1_8pzfmm0z_.dbf
-rw-r----- 1 oracle asmadmin 11804672 Apr 18 17:01 o1_mf_users_8pzfn252_.dbf
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS>
orarac2poc:TTS:/u02/oradata/TTS/FRA/TTS/backupset> rman target / catalog rman/rman123@RCAT
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Apr 18 17:36:07 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: TTS (DBID=1769654909)
connected to recovery catalog database
RMAN> crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwd59_.bkp';
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwd59_.bkp RECID=8 STAMP=811161484
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
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 192740 Mar 27 2013 10:38:06
Backup Piece 192750 Mar 27 2013 10:38:06 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwd59_.bkp
Backup Set 192741 Mar 27 2013 10:38:07
Backup Piece 192751 Mar 27 2013 10:38:07 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp
Backup Set 192742 Mar 27 2013 11:14:59
Backup Piece 192752 Mar 27 2013 11:14:59 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp
Backup Set 192743 Mar 27 2013 11:15:00
Backup Piece 192753 Mar 27 2013 11:15:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp
Backup Set 192744 Mar 27 2013 13:45:00
Backup Piece 192754 Mar 27 2013 13:45:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp
Backup Set 192746 Mar 27 2013 13:55:10
Backup Piece 192756 Mar 27 2013 13:55:10 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp
Backup Set 192748 Mar 27 2013 13:55:43
Backup Piece 192758 Mar 27 2013 13:55:43 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp
Backup Set 193022 Mar 27 2013 15:27:08
Backup Piece 193025 Mar 27 2013 15:27:08 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp
Backup Set 193080 Mar 27 2013 15:31:53
Backup Piece 193084 Mar 27 2013 15:31:53 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp
Backup Set 193081 Mar 27 2013 15:31:54
Backup Piece 193085 Mar 27 2013 15:31:54 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp
Backup Set 193099 Mar 27 2013 15:32:29
Backup Piece 193102 Mar 27 2013 15:32:29 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp
Backup Set 193117 Mar 27 2013 15:32:37
Backup Piece 193123 Mar 27 2013 15:32:37 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp
Backup Set 203436 Apr 11 2013 13:47:11
Backup Piece 203438 Apr 11 2013 13:47:11 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp
Backup Set 203461 Apr 11 2013 14:34:20
Backup Piece 203498 Apr 11 2013 14:34:20 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp
Backup Set 206461 Apr 18 2013 17:02:06
Backup Piece 206464 Apr 18 2013 17:02:06 /u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813085323_8pzfng0r_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwd59_.bkp RECID=8 STAMP=811161484
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/autobackup/2013_04_18/o1_mf_s_813085323_8pzfng0r_.bkp RECID=2 STAMP=813085326
Deleted 2 objects
RMAN-06207: WARNING: 13 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 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp
RMAN-06214: Backup Piece /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp
RMAN>
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp';
RMAN>
RMAN> crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp';
using channel ORA_DISK_1
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp';
scheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp';
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp';
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp RECID=9 STAMP=811161487
Crosschecked 1 objects
crosscheck backuppiece '/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp';
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp RECID=11 STAMP=811163697
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp RECID=12 STAMP=811163700
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp RECID=14 STAMP=811172699
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp RECID=16 STAMP=811173310
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp RECID=18 STAMP=811173343
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp RECID=24 STAMP=811178749
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp RECID=26 STAMP=811179113
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp RECID=27 STAMP=811179114
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp RECID=28 STAMP=811179118
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp RECID=29 STAMP=811179157
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp RECID=185 STAMP=812468831
Crosschecked 1 objects
RMAN>
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp RECID=187 STAMP=812471660
Crosschecked 1 objects
RMAN>
RMAN>
RMAN>
RMAN>
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
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 192741 Mar 27 2013 10:38:07
Backup Piece 192751 Mar 27 2013 10:38:07 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp
Backup Set 192742 Mar 27 2013 11:14:59
Backup Piece 192752 Mar 27 2013 11:14:59 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp
Backup Set 192743 Mar 27 2013 11:15:00
Backup Piece 192753 Mar 27 2013 11:15:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp
Backup Set 192744 Mar 27 2013 13:45:00
Backup Piece 192754 Mar 27 2013 13:45:00 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp
Backup Set 192746 Mar 27 2013 13:55:10
Backup Piece 192756 Mar 27 2013 13:55:10 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp
Backup Set 192748 Mar 27 2013 13:55:43
Backup Piece 192758 Mar 27 2013 13:55:43 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp
Backup Set 193022 Mar 27 2013 15:27:08
Backup Piece 193025 Mar 27 2013 15:27:08 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp
Backup Set 193080 Mar 27 2013 15:31:53
Backup Piece 193084 Mar 27 2013 15:31:53 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp
Backup Set 193081 Mar 27 2013 15:31:54
Backup Piece 193085 Mar 27 2013 15:31:54 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp
Backup Set 193099 Mar 27 2013 15:32:29
Backup Piece 193102 Mar 27 2013 15:32:29 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp
Backup Set 193117 Mar 27 2013 15:32:37
Backup Piece 193123 Mar 27 2013 15:32:37 /u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp
Backup Set 203436 Apr 11 2013 13:47:11
Backup Piece 203438 Apr 11 2013 13:47:11 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp
Backup Set 203461 Apr 11 2013 14:34:20
Backup Piece 203498 Apr 11 2013 14:34:20 /u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T103803_8o4pwhc0_.bkp RECID=9 STAMP=811161487
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1k6w_.bkp RECID=11 STAMP=811163697
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T111456_8o4s1nf9_.bkp RECID=12 STAMP=811163700
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T134459_8o51tvpf_.bkp RECID=14 STAMP=811172699
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135510_8o52fynz_.bkp RECID=16 STAMP=811173310
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T135543_8o52gzjq_.bkp RECID=18 STAMP=811173343
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd0_TAG20130327T152547_8o57qx5l_.bkp RECID=24 STAMP=811178749
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o5839h3_.bkp RECID=26 STAMP=811179113
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153151_8o583bmq_.bkp RECID=27 STAMP=811179114
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_nnnd1_TAG20130327T153155_8o583gsl_.bkp RECID=28 STAMP=811179118
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_03_27/o1_mf_annnn_TAG20130327T153235_8o584ob7_.bkp RECID=29 STAMP=811179157
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T134706_8pdmlzrc_.bkp RECID=185 STAMP=812468831
deleted backup piece
backup piece handle=/u02/oradata/TTS/FRA/TTS/backupset/2013_04_11/o1_mf_annnn_TAG20130411T142757_8pdozh87_.bkp RECID=187 STAMP=812471660
Deleted 13 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
Popular Posts
-
configured "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK; " when RMAN> delete noprompt archivelog u...
-
I have one PT env using storage sync for database sync. Thought need to re-register DB after DB refresh, so unregister and register again....
-
[symptoms] orarac2poc:ORCL2:/home/oracle> . ./oms_agent_env orarac2poc:ORCL2:/home/oracle> $AGENT_HOME/bin/emctl start agent Oracl...
-
Oracle collects Active Session History (ASH) statistics (mostly wait statistics for different events) for all active sessions every second f...
-
backup piece The physical file format used to store RMAN backup sets backup set A backup of one or more datafiles, control files, SPFILEs...
-
after rounds of recovery testing, I believer there are tons of obsolete files in FRA. There are some stubborn datafile copy can't be de...
-
This installation extended to my home hour, since both Postgresql and Zabbix are new to me. Followed few articles without much difficulty.... -
1. The application error message orarac2poc:ORCL2:/u01/app/oracle/oms12c/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs&g... -
1. The dictionary view of dba_tab_col_statistics https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_2089.htm#REFRN20275 No...
-
SQL> select * from dba_data_files where tablespace_name='TESTBS'; FILE_NAME ...