Redhat 6.4 comes with supporting ASM

Exciting with This new feature in Redhat 6.4. I decide to give a test.

Oracle ASMLib Availability and Support

Oracle ASM (Automated Storage Management) is a data volume manager for Oracle databases. ASMLib is an optional utility that can be used on Linux systems to manage Oracle ASM devices. ASMLib consists of the following components:

• kmod-oracleasm (open-source (GPL) kernel module package)
• oracleasm-support (open-source (GPL) utilities package)
• oracleasmlib (proprietary library package)

ASM features and functionality are available without ASMLib. The use of ASMLib does not affect database performance. The ASMLib kernel module package is now available in the Red Hat Enterprise Linux 6 Supplementary RHN channel. Red Hat Enterprise Linux 6 customers who use ASMLib can obtain the other two components using the instructions in the following KnowledgeBase article:

https://access.redhat.com/knowledge/solutions/315643

1. Download and install the three packages.

With external help , I managed to download the above saying 3 packages from

https://access.redhat.com/site/solutions/315643

note that:

a.) they can't be found in the supplementary disc(iso file), a bit strange to me, as I thought redhat's document seems quite nice .
b.) only oracleasmlib can be downloaded in Oracle Unbreakable Linux 6, as the rest two are already pre-built into the OS.
c.) It seems no 32bit packages.

For installation, I encoutered no error in CentOS 6.4


[root@localhost Desktop]# ls -lrt *.rpm
-rw-r--r--. 1 root root  35044 Apr 20 01:00 kmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpm
-rw-r--r--. 1 root root  74984 Apr 20 01:00 oracleasm-support-2.1.8-1.el6.x86_64.rpm
-rw-r--r--. 1 root root  13300 Apr 20 01:00 oracleasmlib-2.0.4-1.el6.x86_64.rpm
[root@localhost Desktop]# rpm -qa |grep oracleasm
[root@localhost Desktop]# rpm -i kmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpm
warning: kmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
[root@localhost Desktop]# rpm -i oracleasm-support-2.1.8-1.el6.x86_64.rpm
warning: oracleasm-support-2.1.8-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
[root@localhost Desktop]# rpm -i oracleasmlib-2.0.4-1.el6.x86_64.rpm
warning: oracleasmlib-2.0.4-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY


2.  Some basic verification, looks fine.

[root@localhost Desktop]# uname -a
Linux localhost.localdomain 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost Desktop]# which oracleasm
/usr/sbin/oracleasm
[root@localhost Desktop]# oracleasm listdisks
[root@localhost Desktop]# oracleasm -V
oracleasm version 2.1.8


For comparing purpose , here is more info for Linux 5.6  ASMLib provided by Oracle.

[root@rac1 ~]# uname -a
Linux rac1.localdomain 2.6.18-238.el5 #1 SMP Tue Jan 4 15:24:05 EST 2011 i686 i686 i386 GNU/Linux
[root@rac1 ~]# which oracleasm
/usr/sbin/oracleasm
[root@rac1 ~]# oracleasm -V
oracleasm version 2.1.4

3. Now add a disk for testing.

3.1 fdisk info before add a new disk.
[root@localhost Desktop]#  fdisk -l

Disk /dev/sda: 34.6 GB, 34625028096 bytes
255 heads, 63 sectors/track, 4209 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x0000bdcd

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          64      512000   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2              64        4210    33300480   8e  Linux LVM

Disk /dev/mapper/VolGroup-lv_root: 31.6 GB, 31578914816 bytes
255 heads, 63 sectors/track, 3839 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Disk /dev/mapper/VolGroup-lv_swap: 2516 MB, 2516582400 bytes
255 heads, 63 sectors/track, 305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

[root@localhost Desktop]# shutdown -h now


--after reboot the new disk is /dev/sdb


[root@localhost ~]# fdisk -l

Disk /dev/sda: 34.6 GB, 34625028096 bytes
255 heads, 63 sectors/track, 4209 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x0000bdcd

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          64      512000   83  Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2              64        4210    33300480   8e  Linux LVM

Disk /dev/sdb: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Disk /dev/mapper/VolGroup-lv_root: 31.6 GB, 31578914816 bytes
255 heads, 63 sectors/track, 3839 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000


Disk /dev/mapper/VolGroup-lv_swap: 2516 MB, 2516582400 bytes
255 heads, 63 sectors/track, 305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

[root@localhost ~]# ls -l /dev/oracleasm
ls: cannot access /dev/oracleasm: No such file or directory
[root@localhost ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xb9020b75.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').

Command (m for help): p

Disk /dev/sdb: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xb9020b75

   Device Boot      Start         End      Blocks   Id  System

Command (m for help): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete a partition
   l   list known partition types
   m   print this menu
   n   add a new partition
   o   create a new empty DOS partition table
   p   print the partition table
   q   quit without saving changes
   s   create a new empty Sun disklabel
   t   change a partition's system id
   u   change display/entry units
   v   verify the partition table
   w   write table to disk and exit
   x   extra functionality (experts only)

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1044, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-1044, default 1044):
Using default value 1044

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@localhost ~]# fdisk -l /dev/sdb

Disk /dev/sdb: 8589 MB, 8589934592 bytes
255 heads, 63 sectors/track, 1044 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0xb9020b75

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1        1044     8385898+  83  Linux


4. Things before proper configure and load the asmlib

[root@localhost ~]# oracleasm listdisks


[root@localhost ~]# oracleasm createdisk -help
Usage: oracleasm-createdisk [-l ] [-v]
[root@localhost ~]# oracleasm createdisk TestVol1 /dev/sdb1
Writing disk header: done
Instantiating disk: failed
Clearing disk header: done
[root@localhost ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@localhost ~]# oracleasm listdisks
[root@localhost ~]# ls -l /dev/oracleasm
ls: cannot access /dev/oracleasm: No such file or directory
[root@localhost ~]# oracleasm-createdisk TestVol1 /dev/sdb1
bash: oracleasm-createdisk: command not found
[root@localhost ~]# which oracleasm
/usr/sbin/oracleasm

[root@localhost ~]# cd /
[root@localhost /]# find ./ -name oracleasm-createdisk
./usr/lib/oracleasm/oracleasm-createdisk


[root@localhost ~]# ls -l /usr/lib/oracleasm/oracleasm*
-rwxr-xr-x. 1 root root  9840 Feb  9 06:46 /usr/lib/oracleasm/oracleasm-candidate-p
-rwxr-xr-x. 1 root root  9920 Feb  9 06:46 /usr/lib/oracleasm/oracleasm-clean-disk
-rwxr-xr-x. 1 root root 10006 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-configure
-rwxr-xr-x. 1 root root  2964 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-createdisk
-rwxr-xr-x. 1 root root  2676 Feb  9 06:44 /usr/lib/oracleasm/oracleasm_debug_link
-rwxr-xr-x. 1 root root  3785 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-deletedisk
-rwxr-xr-x. 1 root root  2039 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-dropdisks
-rwxr-xr-x. 1 root root  2142 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-exit
-rwxr-xr-x. 1 root root  2796 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-get-driver
-rwxr-xr-x. 1 root root  3543 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-init
-rwxr-xr-x. 1 root root  9928 Feb  9 06:46 /usr/lib/oracleasm/oracleasm-instantiate-disk
-rwxr-xr-x. 1 root root   812 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-listdisks
-rwxr-xr-x. 1 root root  3862 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-querydisk
-rwxr-xr-x. 1 root root 12352 Feb  9 06:46 /usr/lib/oracleasm/oracleasm-read-label
-rwxr-xr-x. 1 root root  7016 Feb  9 06:46 /usr/lib/oracleasm/oracleasm-reload-partitions
-rwxr-xr-x. 1 root root  6081 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-renamedisk
-rwxr-xr-x. 1 root root  3506 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-scandisks
-rwxr-xr-x. 1 root root  9480 Feb  9 06:46 /usr/lib/oracleasm/oracleasm-scan-partitions
-rwxr-xr-x. 1 root root  1143 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-status
-rwxr-xr-x. 1 root root  2865 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-update-driver
-rwxr-xr-x. 1 root root  6794 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-update-driver-otn
-rwxr-xr-x. 1 root root  2480 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-update-driver-uln
-rwxr-xr-x. 1 root root 12352 Feb  9 06:46 /usr/lib/oracleasm/oracleasm-write-label
-rwxr-xr-x. 1 root root  3768 Feb  9 06:44 /usr/lib/oracleasm/oracleasm-Xshlib
[root@localhost ~]#  /usr/lib/oracleasm/oracleasm-createdisk TestVOL1 /dev/sdb1
/usr/lib/oracleasm/oracleasm-createdisk: line 52: oracleasm-Xshlib: No such file or directory
/usr/lib/oracleasm/oracleasm-createdisk: line 160: upper_disk: command not found


5. Then realized , need to configure and load the ASMLib first.

[root@localhost Desktop]# oracleasm configure
ORACLEASM_ENABLED=false
ORACLEASM_UID=
ORACLEASM_GID=
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"
[root@localhost Desktop]#  /usr/lib/oracleasm/oracleasm-createdisk TestVOL1 /dev/sdb1
/usr/lib/oracleasm/oracleasm-createdisk: line 52: oracleasm-Xshlib: No such file or directory
/usr/lib/oracleasm/oracleasm-createdisk: line 160: upper_disk: command not found
[root@localhost Desktop]# ps -ef |grep asm
root      2485  2454  0 22:29 pts/0    00:00:00 grep asm
[root@localhost Desktop]# oracleasm status
Checking if ASM is loaded: no
Checking if /dev/oracleasm is mounted: no
[root@localhost Desktop]# oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
[root@localhost Desktop]# ps -ef |grep asm
root      2552  2454  0 22:29 pts/0    00:00:00 grep asm
[root@localhost Desktop]# oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes


6. still encounter error.

[root@localhost Desktop]# oracleasm createdisk TestVol1 /dev/sdb1Writing disk header: done
Instantiating disk: failed
Clearing disk header: done
[root@localhost Desktop]# oracleasm listdisks
[root@localhost Desktop]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...


[root@localhost Desktop]# cd /etc/init.d
[root@localhost init.d]# ls oracle*
oracleasm
[root@localhost init.d]# ls -l oracle*
-rwxr-xr-x. 1 root root 7124 Feb  9 06:44 oracleasm
[root@localhost init.d]# ./oracleasm createdisk TestVol1 /dev/sdb1
Marking disk "TestVol1" as an ASM disk:                    [FAILED]
[root@localhost init.d]# echo $?
1
[root@localhost init.d]#  /usr/lib/oracleasm/oracleasm-createdisk TestVOL1 /dev/sdb1
/usr/lib/oracleasm/oracleasm-createdisk: line 52: oracleasm-Xshlib: No such file or directory
/usr/lib/oracleasm/oracleasm-createdisk: line 160: upper_disk: command not found
[root@localhost init.d]#

7. then I google for racleasm-Xshlib , and I found it is inside oracleasm-support package.

[root@localhost Desktop]# rpm -ql oracleasm-support-2.1.8-1.el6.x86_64.rpm
package oracleasm-support-2.1.8-1.el6.x86_64.rpm is not installed
[root@localhost Desktop]# rpm -ql oracleasm-support-2.1.8-1.el6.x86_64
/etc/init.d/oracleasm
/etc/sysconfig/oracleasm
/usr/lib/oracleasm
/usr/lib/oracleasm/oracleasm-Xshlib
/usr/lib/oracleasm/oracleasm-candidate-p
/usr/lib/oracleasm/oracleasm-clean-disk
/usr/lib/oracleasm/oracleasm-configure
/usr/lib/oracleasm/oracleasm-createdisk
/usr/lib/oracleasm/oracleasm-deletedisk
/usr/lib/oracleasm/oracleasm-dropdisks
/usr/lib/oracleasm/oracleasm-exit
/usr/lib/oracleasm/oracleasm-get-driver
/usr/lib/oracleasm/oracleasm-init
/usr/lib/oracleasm/oracleasm-instantiate-disk
/usr/lib/oracleasm/oracleasm-listdisks
/usr/lib/oracleasm/oracleasm-querydisk
/usr/lib/oracleasm/oracleasm-read-label
/usr/lib/oracleasm/oracleasm-reload-partitions
/usr/lib/oracleasm/oracleasm-renamedisk
/usr/lib/oracleasm/oracleasm-scan-partitions
/usr/lib/oracleasm/oracleasm-scandisks
/usr/lib/oracleasm/oracleasm-status
/usr/lib/oracleasm/oracleasm-update-driver
/usr/lib/oracleasm/oracleasm-update-driver-otn
/usr/lib/oracleasm/oracleasm-update-driver-uln
/usr/lib/oracleasm/oracleasm-write-label
/usr/lib/oracleasm/oracleasm_debug_link
/usr/sbin/asmscan
/usr/sbin/asmtool
/usr/sbin/oracleasm
/usr/share/doc/oracleasm-support-2.1.8
/usr/share/doc/oracleasm-support-2.1.8/ReleaseNotes
/usr/share/man
/usr/share/man/man8
/usr/share/man/man8/oracleasm-configure.8.gz
/usr/share/man/man8/oracleasm-createdisk.8.gz
/usr/share/man/man8/oracleasm-deletedisk.8.gz
/usr/share/man/man8/oracleasm-dropdisks.8.gz
/usr/share/man/man8/oracleasm-exit.8.gz
/usr/share/man/man8/oracleasm-help.8.gz
/usr/share/man/man8/oracleasm-init.8.gz
/usr/share/man/man8/oracleasm-listdisks.8.gz
/usr/share/man/man8/oracleasm-querydisk.8.gz
/usr/share/man/man8/oracleasm-renamedisk.8.gz
/usr/share/man/man8/oracleasm-scandisks.8.gz
/usr/share/man/man8/oracleasm-status.8.gz
/usr/share/man/man8/oracleasm-update-driver-otn.8.gz
/usr/share/man/man8/oracleasm-update-driver-uln.8.gz
/usr/share/man/man8/oracleasm-update-driver.8.gz
/usr/share/man/man8/oracleasm.8.gz
/usr/share/man/man8/oracleasm.init.8.gz

8. but why oracleasm-createdisk can't find it?! even I execute in the /usr/lib/oracleasm, evenmore I include "./" to $PATH.

[root@localhost oracleasm]# ls -l *Xshlib
-rwxr-xr-x. 1 root root 3768 Feb  9 06:44 oracleasm-Xshlib
[root@localhost oracleasm]#  /usr/lib/oracleasm/oracleasm-createdisk -v TestVOL1 /dev/sdb1
line 76: oracleasm-candidate-p: command not found
[root@localhost oracleasm]# ls -l *candi*
-rwxr-xr-x. 1 root root 9840 Feb  9 06:46 oracleasm-candidate-p
-rwxr-xr-x. 1 root root 3506 Feb  9 06:44 oracleasm-scandisks
[root@localhost oracleasm]# ./oracleasm-createdisk -v TestVOL1 /dev/sdb1line 76: oracleasm-candidate-p: command not found
[root@localhost oracleasm]# ehoc $PATH
bash: ehoc: command not found
[root@localhost oracleasm]# echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/usr/bin:/bin:/root/bin
[root@localhost oracleasm]# export PATH=./:$PATH
[root@localhost oracleasm]# ./oracleasm-createdisk -v TestVOL1 /dev/sdb1
Disk "TESTVOL1" does not exist or is not instantiated
Writing disk header: done
Instantiating disk: oracleasm-instantiate-disk: Unable to create ASM disk "TESTVOL1": Permission denied
failed
Clearing disk header: done


9. Now I get a new error message, goolged again for Instantiating disk: oracleasm-instantiate-disk: Unable to create ASM disk "TESTVOL1": Permission denied.

Although I am running as root, still compared the permission of /dev/oracleasm and subdirectories, which is same my another vm of CentOS 5.6.

By luck, I found the following two links, which is saying caused by SELINUX.

http://dbaforums.org/oracle/index.php?showtopic=21688
http://www.dba-oracle.com/t_asm_disk_does_not_exist_or_is_not_instantiated.htm





10. now follow the instruciton to disable SELINUX.

[root@localhost oracleasm]# cat /etc/sysconfig/selinux

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=enforcing
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted


[root@localhost oracleasm]# vi /etc/sysconfig/selinux
[root@localhost oracleasm]# cat /etc/sysconfig/selinux

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
#SELINUX=enforcing
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted

--after reboot

[root@localhost ~]# which getenforce
/usr/sbin/getenforce
[root@localhost ~]# getenforce Disabled
Disabled
[root@localhost ~]# ps -ef |grep -i asm
root      2620  2604  0 23:28 pts/0    00:00:00 grep -i asm
[root@localhost ~]# cd /etc/init.d
[root@localhost init.d]# ./oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes

11. Cheers!

[root@localhost ~]# oracleasm createdisk TestVOL1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@localhost ~]# oracleasm listdisks
TESTVOL1
[root@localhost ~]# oracleasm querydisk Testvol1
Disk "TESTVOL1" is a valid ASM disk

[root@localhost ~]# oracleasm querydisk -p Testvol1
Disk "TESTVOL1" is a valid ASM disk
/dev/sdb1: LABEL="TESTVOL1" TYPE="oracleasm"


oot@localhost ~]# cd /etc/init.d
[root@localhost init.d]# ls -ld /dev/oracleasm
drwxr-xr-x 4 root root 0 Apr 22 23:21 /dev/oracleasm
[root@localhost init.d]# ls -ld /dev/oracleasm/
drwxr-xr-x 4 root root 0 Apr 22 23:21 /dev/oracleasm/
[root@localhost init.d]# ls -l /dev/oracleasm/
total 0
drwxr-xr-x 1 root   root   0 Apr 22 23:21 disks
drwxrwx--- 1 oracle oracle 0 Apr 22 23:21 iid
[root@localhost init.d]# ls -l /dev/oracleasm/disks
total 0
brw-rw---- 1 oracle oracle 8, 17 Apr 22 23:30 TESTVOL1
[root@localhost init.d]# ls -l /dev/oracleasm/iid
total 0



12. Thought

So what will happen to ASMLib next (from competing of Oracle and RedHat)?

CATALOG RECOVERY AREA

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