Sunday, May 18, 2014

Delete Copy using LIKE clause


Like clause should be used only for copy

RMAN> delete copy of database like
2> '+DATA/cvrman/datafile/us%'
3> device type disk;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=24 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=25 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=58 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=60 device type=DISK
List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
78      4    A 18-MAY-14       1246607    17-MAY-14
        Name: +DATA/cvrman/datafile/users.dbf
        Tag: CPY_DB

75      4    A 17-MAY-14       1246607    17-MAY-14
        Name: +DATA/cvrman/datafile/users.340.847803041
        Tag: CPY_DB


Do you really want to delete the above objects (enter YES or NO)?

No comments: