RMAN behaves different with FORMAT cmnd
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN behaves different with FORMAT cmnd

  1. #1
    Join Date
    Nov 2000
    Posts
    224
    Target:Oracle 816/NT 4 - RMAN DB:Oracle 816 /NT

    I am trying to implement RMAN at my site. When trying different options I found different unusual scenario:

    If I don't specify format command, It generates one backup set with all the datafiles in one piece at default location.

    I thought I want specific location for my backup, so,
    If I specify format command with fixed filename, it errors out.

    Specifying format with variables (_%U), it generates two backup set.

    Does it mean that format command force it to generate more backup set or does it apply the restriction of filesize and force it to generate more than one files.
    No other options like, FILESPERSET or SET LIMIT used.

    For your reference, here is the actual output:
    ******************* First Case ********************
    RMAN> run{
    2> allocate channel d1 type disk;
    3> backup
    4> (database include current controlfile);
    5> }

    RMAN> list backup;

    RMAN-03022: compiling command: list

    List of Backup Sets
    Key Recid Stamp LV Set Stamp Set Count Completion Time
    ------- ---------- ---------- -- ---------- ---------- ----------------------
    2688 50 450784014 0 450783988 57 10-JAN-02

    List of Backup Pieces
    Key Pc# Cp# Status Completion Time Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2689 1 1 AVAILABLE 10-JAN-02 D:\ORACLE\ORACLE816\DATABASE\1PDDSQNK_1_1

    List of Datafiles Included
    File Name LV Type Ckp SCN Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    1 D:\ORACLE\ORADATA\ORCL\SYSTEM\SYSTEM01.ORA 0 Full 3228966 10-JAN-02
    2 D:\ORACLE\ORADATA\ORCL\USERDATA\USER01.ORA 0 Full 3228966 10-JAN-02
    3 D:\ORACLE\ORADATA\ORCL\TEMPORARY\TEMPORARY01.ORA 0 Full 3228966 10-JAN-02
    4 D:\ORACLE\ORADATA\ORCL\RBS\RBS01.ORA 0 Full 3228966 10-JAN-02

    RMAN>

    ******************* Second Case ********************
    RMAN> run{
    2> allocate channel d1 type disk;
    3> backup
    4> format 'd:\oracle\oraclebackup\rman\DATA_011002.bak'
    5> (database include current controlfile);
    6> }

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-07004: unhandled exception during command execution on channel d1
    RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "d:\oracle\oraclebackup\rman\D
    ATA_011002.bak"
    ORA-27038: skgfrcre: file exists
    OSD-04010: option specified, file already exists
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

    ******************* Third Case ********************
    RMAN> run{
    2> allocate channel d1 type disk;
    3> backup
    4> format 'd:\oracle\oraclebackup\rman\DATA_%U.bak'
    5> (database include current controlfile);
    6> }

    RMAN> list backup;

    RMAN-03022: compiling command: list

    List of Backup Sets
    Key Recid Stamp LV Set Stamp Set Count Completion Time
    ------- ---------- ---------- -- ---------- ---------- ----------------------
    2708 52 450784468 0 450784456 60 10-JAN-02

    List of Backup Pieces
    Key Pc# Cp# Status Completion Time Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2710 1 1 AVAILABLE 10-JAN-02 D:\ORACLE\ORACLEBACKUP\RMAN\DATA_1SDDSR68_1_1
    .BAK

    List of Datafiles Included
    File Name LV Type Ckp SCN Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    1 D:\ORACLE\ORADATA\ORCL\SYSTEM\SYSTEM01.ORA 0 Full 3229065 10-JAN-02
    4 D:\ORACLE\ORADATA\ORCL\RBS\RBS01.ORA 0 Full 3229065 10-JAN-02

    List of Backup Sets
    Key Recid Stamp LV Set Stamp Set Count Completion Time
    ------- ---------- ---------- -- ---------- ---------- ----------------------
    2709 53 450784488 0 450784472 61 10-JAN-02

    List of Backup Pieces
    Key Pc# Cp# Status Completion Time Piece Name
    ------- --- --- ----------- ---------------------- ------------------------
    2711 1 1 AVAILABLE 10-JAN-02 D:\ORACLE\ORACLEBACKUP\RMAN\DATA_1TDDSR6O_1_1
    .BAK

    List of Datafiles Included
    File Name LV Type Ckp SCN Ckp Time
    ---- ------------------------------------- -- ---- ---------- -------------
    2 D:\ORACLE\ORADATA\ORCL\USERDATA\USER01.ORA 0 Full 3229066 10-JAN-02
    3 D:\ORACLE\ORADATA\ORCL\TEMPORARY\TEMPORARY01.ORA 0 Full 3229066 10-JAN-02









    [Edited by Sharma on 01-10-2002 at 11:23 AM]

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Code:
              
             allocate channel d1 type disk; 
             backup
                 full
               #skip offline
               #skip readonly
                 skip inaccessible
                 tag backup_db_full 
                 filesperset 5 
                 format 'df_%d_t%t_s%s_p%p'
                 (database include current controlfile);
              release channel d1;
    Hope this would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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