rman output
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: rman output

  1. #1
    Join Date
    Jul 2006
    Posts
    195

    rman output

    I am using the following backup script (see below) but my output does not appear to be going to the directory specified '/oracle/backup/pri' but is being
    placed in $ORACLE_HOME/dbs/

    Can somebody tell me what the issue is? BTW, I am running Release 10.2.0.1.0


    rman < connect target sys/sys@GOLD_PRI
    connect catalog rman/rman@GOLD_CAT

    crosscheck Backup;
    crosscheck Archivelog All;
    run {
    SQL 'alter system switch logfile';

    CONFIGUE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup/pri/control_file_%F';

    CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

    ALLOCATE CHANNEL t1 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%U';

    ALLOCATE CHANNEL t2 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%U';

    ALLOCATE CHANNEL t3 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%U';

    BACKUP INCREMENTAL LEVEL 0 filesperset 2 DATABASE;
    backup archivelog all delete input;

    release channel t1;
    release channel t2;
    release channel t3;

    }
    delete noprompt obsolete;

    EOF


    RMAN> list backupset;


    List of Backup Sets
    ===================

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1818 Incr 0 26.81M DISK 00:00:25 15-AUG-10
    BP Key: 1822 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
    Piece Name: /oracle/10.2.0.1.0/dbs/12lldm71_1_1
    List of Datafiles in backup set 1818
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    3 0 Incr 334107 15-AUG-10 /oracle/data/pri/sysaux01.dbf
    8 0 Incr 334107 15-AUG-10 /oracle/data/pri/t3.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1819 Incr 0 113.71M DISK 00:00:25 15-AUG-10
    BP Key: 1823 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
    Piece Name: /oracle/10.2.0.1.0/dbs/13lldm71_1_1
    List of Datafiles in backup set 1819
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 0 Incr 334108 15-AUG-10 /oracle/data/pri/system01.dbf
    7 0 Incr 334108 15-AUG-10 /oracle/data/pri/t2.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1820 Incr 0 267.92M DISK 00:00:26 15-AUG-10
    BP Key: 1824 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
    Piece Name: /oracle/10.2.0.1.0/dbs/14lldm71_1_1
    List of Datafiles in backup set 1820
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    2 0 Incr 334109 15-AUG-10 /oracle/data/pri/undotbs.dbf
    6 0 Incr 334109 15-AUG-10 /oracle/data/pri/t1.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1821 Incr 0 97.14M DISK 00:00:07 15-AUG-10
    BP Key: 1825 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
    Piece Name: /oracle/10.2.0.1.0/dbs/15lldm7r_1_1
    List of Datafiles in backup set 1821
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    4 0 Incr 334118 15-AUG-10 /oracle/data/pri/pritable01.dbf
    5 0 Incr 334118 15-AUG-10 /oracle/data/pri/priindex01.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1851 Full 5.95M DISK 00:00:01 15-AUG-10
    BP Key: 1854 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153222
    Piece Name: /oracle/10.2.0.1.0/dbs/c-657688632-20100815-01
    Control File Included: Ckp SCN: 334131 Ckp time: 15-AUG-10

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    1912 2.10M DISK 00:00:02 15-AUG-10
    BP Key: 1916 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153235
    Piece Name: /oracle/10.2.0.1.0/dbs/19lldm8k_1_1

    List of Archived Logs in backup set 1912
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 239 329107 15-AUG-10 334150 15-AUG-10

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    1913 7.49M DISK 00:00:02 15-AUG-10
    BP Key: 1917 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153235
    Piece Name: /oracle/10.2.0.1.0/dbs/18lldm8k_1_1

    List of Archived Logs in backup set 1913
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 236 317012 15-AUG-10 319005 15-AUG-10
    1 237 319005 15-AUG-10 323443 15-AUG-10
    1 238 323443 15-AUG-10 329107 15-AUG-10

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    1914 7.94M DISK 00:00:03 15-AUG-10
    BP Key: 1918 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153235
    Piece Name: /oracle/10.2.0.1.0/dbs/17lldm8j_1_1

    List of Archived Logs in backup set 1914
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 233 305265 14-AUG-10 309184 14-AUG-10
    1 234 309184 14-AUG-10 314975 15-AUG-10
    1 235 314975 15-AUG-10 317012 15-AUG-10

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1945 Full 5.95M DISK 00:00:01 15-AUG-10
    BP Key: 1949 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153243
    Piece Name: /oracle/10.2.0.1.0/dbs/c-657688632-20100815-02
    Control File Included: Ckp SCN: 334170 Ckp time: 15-AUG-10


    Thanks in advance to all who answer this post?

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

    Cool Channels also like a name...

    You may need to configure the parallel channels first, execute these commands ONCE, it' not necessary to execute every time you run the script:
    Code:
    CONFIGUE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup/pri/control_file_%F';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
    CONFIGURE CHANNEL 0 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%s_%u';
    CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%s_%u';
    CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%s_%u';

    Then your script would look something like this:
    Code:
    connect target sys/sys@GOLD_PRI
    connect catalog rman/rman@GOLD_CAT
    
    CROSSCHECK BACKUP DEVICE TYPE DISK;
    CROSSCHECK ARCHIVELOG ALL;
    RUN {
        SQL 'ALTER SYSTEM SWITCH LOGFILE';
        BACKUP INCREMENTAL LEVEL 0 
          FILESPERSET 2 DATABASE
          INCLUDE CURRENT CONTROLFILE
          PLUS ARCHIVELOG DELETE INPUT
        ;
    }
    DELETE NOPROMPT EXPIRED BACKUP;
    DELETE NOPROMPT OBSOLETE;
    EXIT;
    Last edited by LKBrwn_DBA; 08-16-2010 at 11:22 AM. Reason: Added script
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jul 2006
    Posts
    195
    Thanks for the response and I will give it a shot.

    If I configure it for incr_level0...... what happens when I do an level 1 incr it will have the wrong name (incr_level0 instead of incr_level1). Hence, that is why I configured it in the script.

    I guess I really dont need the prefix incr_level# since the ouput does show me what type of back it is.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool It's all in the name...

    Quote Originally Posted by BeefStu View Post
    ...Etc...
    I guess I really dont need the prefix incr_level# since the ouput does show me what type of back it is.
    Correct:
    a) Use generic name in the format '/oracle/backup/pri/%d_%T_%s_%u',
    b) You need two scripts anyway, one for lvl 0 and one for lvl 1,
    c) You could attach a different "TAG" for each backup type,
    d) If you need to know which backup is level 0 or 1, query the catalog.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Jul 2006
    Posts
    195
    Quote Originally Posted by LKBrwn_DBA View Post
    Correct:
    a) Use generic name in the format '/oracle/backup/pri/%d_%T_%s_%u',
    b) You need two scripts anyway, one for lvl 0 and one for lvl 1,
    c) You could attach a different "TAG" for each backup type,
    d) If you need to know which backup is level 0 or 1, query the catalog.
    Thanks it all worked out!!

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