RMAN tag question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN tag question

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    RMAN tag question

    When I run the following RMAN script


    RMAN> run
    2> {
    3> SQL 'alter system switch logfile';
    4> backup full database tag='fullbkup' plus archivelog delete all input;
    5> delete noprompt obsolete;
    6> }



    As you can see I specifiy the tag='fullbkup'. My question is how come everything
    does not contain that tag (see below). Why do I see tags like this "Tag: TAG20090324T15504".

    How do I get everything to have the same tag name?


    RMAN> list backupset;

    List of Backup Sets
    ===================
    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    4807 Full 318.57M DISK 00:00:44 24-MAR-09
    BP Key: 4809 Status: AVAILABLE Compressed: NO Tag: FULLBKUP
    Piece Name: /rdbms/oracle_data/10.2.0/backup/pbh1020/backup_2akant10_1_1
    List of Datafiles in backup set 4807
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 695328 24-MAR-09 /ctron/oracle/pbh10.2.0/system01.dbf
    2 Full 695328 24-MAR-09 /ctron/oracle/pbh10.2.0/undotbs.dbf
    3 Full 695328 24-MAR-09 /ctron/oracle/pbh10.2.0/sysaux01.dbf
    4 Full 695328 24-MAR-09 /ctron/oracle/pbh10.2.0/pbhtable01.dbf
    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    4840 2.00K DISK 00:00:01 24-MAR-09
    BP Key: 4845 Status: AVAILABLE Compressed: NO Tag: TAG20090324T15504
    0
    Piece Name: /rdbms/oracle_data/10.2.0/backup/pbh1020/backup_2bkant2h_1_1
    List of Archived Logs in backup set 4840
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 151 695317 24-MAR-09 695346 24-MAR-09
    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    4871 Full 6.80M DISK 00:00:01 24-MAR-09
    BP Key: 4873 Status: AVAILABLE Compressed: NO Tag: TAG20090324T15504
    5
    Piece Name: /rdbms/oracle/10g2/dbs/c-3969725195-20090324-03
    Control File Included: Ckp SCN: 695365 Ckp time: 24-MAR-09
    SPFILE Included: Modification time: 22-MAR-09
    RMAN>

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,441

    Cool Order, everything in order...

    In your script the tag is only assigned to the datafile backups not the archive logs.
    The controlfile backup is an 'autobackup' and is assigned a different tag by rman.

    Try this:
    Code:
    Crosscheck Backup;
    Crosscheck Archivelog All;
    run {
      SQL 'alter system switch logfile';
      backup tag='FullBkup' full database
        plus archivelog delete all input;
    }
    Delete noprompt obsolete;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width