+ Reply to Thread
Results 1 to 2 of 2

RMAN backup error

  1. RMAN backup error

    I am runnign my backups and started getting this error and don't know
    why. Here is my bakup script. Why is it giving me an error? Thanks
    for your help.

    backup device type disk format 'F:\oracle\product
    \10.2.0\flash_recovery_area\dailyfull_%T_%d.bks' database;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    backup device type disk format 'F:\oracle\product
    \10.2.0\flash_recovery_area\archivelog_%T_%d.bks' archivelog all not
    backed up delete all input;
    restore database validate;
    CROSSCHECK BACKUPSET;
    delete noprompt obsolete device type disk;
    host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\pwdporky.ora F:
    \oracle\product\10.2.0\flash_recovery_area';
    host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora F:
    \oracle\product\10.2.0\flash_recovery_area';
    host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora F:
    \oracle\product\10.2.0\flash_recovery_area';

    Here is my backup log.

    RMAN> backup device type disk format 'F:\oracle\product
    \10.2.0\flash_recovery_area\dailyfull_%T_%d.bks' database;
    2> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    3> backup device type disk format 'F:\oracle\product
    \10.2.0\flash_recovery_area\archivelog_%T_%d.bks' archivelog all not
    backed up delete all input;
    4> restore database validate;
    5> CROSSCHECK BACKUPSET;
    6> delete noprompt obsolete device type disk;
    7> host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\pwdporky.ora
    F:\oracle\product\10.2.0\flash_recovery_area';
    8> host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
    F:\oracle\product\10.2.0\flash_recovery_area';
    9> host 'copy F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
    F:\oracle\product\10.2.0\flash_recovery_area';
    10>
    11> sql 'begin cic3.rman_email_message; end;';
    12> exit;
    Starting backup at 18-AUG-08
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=79 devtype=DISK
    channel ORA_DISK_1: starting compressed full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00004 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
    \PORKY\USERS01.DBF
    input datafile fno=00005 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
    \PORKY\USERS02.DBF
    input datafile fno=00002 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
    \PORKY\UNDOTBS01.DBF
    input datafile fno=00003 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
    \PORKY\SYSAUX01.DBF
    input datafile fno=00001 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA
    \PORKY\SYSTEM01.DBF
    input datafile fno=00006 name=F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
    \PERFSTAT.DBF
    input datafile fno=00007 name=F:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE
    \TOOLS.DBF
    channel ORA_DISK_1: starting piece 1 at 18-AUG-08
    RMAN-00571:
    ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
    ===============
    RMAN-00571:
    ===========================================================
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at
    08/18/2008 20:56:26
    ORA-19504: failed to create file "F:\ORACLE\PRODUCT
    \10.2.0\FLASH_RECOVERY_AREA\DAILYFULL_20080818_PORKY.BKS"
    ORA-27038: created file already exists
    OSD-04010: option specified, file already exists

    Recovery Manager complete.


  2. Re: RMAN backup error

    On Mon, 18 Aug 2008 19:20:41 -0700 (PDT), cptkirkh
    wrote:

    >I am runnign my backups and started getting this error and don't know
    >why. Here is my bakup script. Why is it giving me an error?


    Saveset names have to be *unique*. Using your conventions you can only
    run 1 backup per day, all others will fail.
    You'll need to add_%s_%p
    I won't comment on other aspects of the script and on not using the
    canned backup procedure which comes with 10g.

    --
    Sybrand Bakker
    Senior Oracle DBA

+ Reply to Thread