Sunday, May 18, 2014

change and delete copy



RMAN> change copy
 tag="CPY_DB"
 delete ;

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
specification does not match any control file copy in the repository
List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time
------- ---- - --------------- ---------- ---------------
74      1    A 17-MAY-14       1246558    17-MAY-14
        Name: +DATA/cvrman/datafile/system.314.847802947
        Tag: CPY_DB

73      2    A 17-MAY-14       1246561    17-MAY-14
        Name: +DATA/cvrman/datafile/sysaux.344.847802947
        Tag: CPY_DB

71      3    A 17-MAY-14       1246567    17-MAY-14
        Name: +DATA/cvrman/datafile/undotbs1.342.847802951
        Tag: CPY_DB

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

72      5    A 17-MAY-14       1246564    17-MAY-14
        Name: +DATA/cvrman/datafile/example.273.847802947
        Tag: CPY_DB

70      6    A 17-MAY-14       1246570    17-MAY-14
        Name: +DATA/cvrman/datafile/tbs1.341.847802953
        Tag: CPY_DB


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

No comments: