Sunday, May 18, 2014

Change archivelog and delete

RMAN>change archivelog all
backed up 1 times to device type disk
delete;
Ouput of the script execution
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 Archived Log Copies for database with db_unique_name CVRMAN

=====================================================================



Key     Thrd Seq     S Low Time

------- ---- ------- - ---------

70      1    4       A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_4.295.847791843



68      1    5       A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_5.296.847791841



72      1    6       A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.304.847791845



74      1    7       A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_7.284.847791839



69      1    8       A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_8.315.847791843



71      1    9       A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_9.269.847791843



67      1    12      A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_12.310.847791839



75      1    13      A 15-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_13.311.847791847



84      1    1       A 17-MAY-14

        Name: /SHARED/backup1/CVRMAN_1_1_847769732.arc



78      1    1       A 17-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_1.301.847792345



79      1    2       A 17-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_2.289.847792561



80      1    3       A 17-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_3.328.847792661



81      1    4       A 17-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_4.292.847802345



82      1    5       A 17-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_5.312.847802453



83      1    6       A 17-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_17/thread_1_seq_6.332.847836579



85      1    7       A 17-MAY-14

        Name: +DATA/cvrman/archivelog/2014_05_18/thread_1_seq_7.288.847857575





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

No comments: