This discussion is archived
11 Replies Latest reply: Mar 25, 2013 9:40 AM by TSharma-Oracle RSS

Problem in RMAN

918147 Newbie
Currently Being Moderated
Pls help,
I setup 11g and I'm learning, and try to do back up using RMAN but always get this error:

MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_3 channel at 03/25/2013 22:59:
58
ORA-19504: failed to create file "D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1\DATAB
ASE\ D:\ADEN_DB\BACKUP\DATABASE\C\1VO5EOJE"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is inco
rrect.


What I have to do ?
  • 1. Re: Problem in RMAN
    TSharma-Oracle Guru
    Currently Being Moderated
    How are you taking the backup ? Are you using command line tool or GUI interface? Post all the steps you are doing to create a backup.
    Also post "show all" command from RMAN.
    RMAN> show all;
  • 2. Re: Problem in RMAN
    918147 Newbie
    Currently Being Moderated
    This is my show all, I used normal backup.

    RMAN>backup database;


    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\app\BACKUP\c
    ontrolfile/%F';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' D:\ADEN_DB\BACKUP\DATABASE\C/%u';
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOA
    D TRUE ; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO ' D:\ADEN_DB\BACKUP\DATABASE\CONTROLFILE/
    %F';
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1
    \DATABASE\ D:\ADEN_DB\BACKUP\DATABASE\CONTROLFILE\%F';
  • 3. Re: Problem in RMAN
    TSharma-Oracle Guru
    Currently Being Moderated
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1
    \DATABASE\ D:\ADEN_DB\BACKUP\DATABASE\CONTROLFILE\%F'; >

    Your snapshot controlfile path seems wrong. Run the following:

    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1\controlfile.ora'

    Also, check if you this directory created/available ? specially the "C" directory.

    D:\ADEN_DB\BACKUP\DATABASE\C
  • 4. Re: Problem in RMAN
    995200 Newbie
    Currently Being Moderated
    Hi,

    Please see, in your configuration, Parameter for Snapshot controlfile is not set properly. Just see the path, its wrongly set with duplication in path
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1
    \DATABASE\ D:\ADEN_DB\BACKUP\DATABASE\CONTROLFILE\%F';
    Please run the following:
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1\DATABASE\%F';
    Thanks,
    Navneet
  • 5. Re: Problem in RMAN
    918147 Newbie
    Currently Being Moderated
    I change the configure to:


    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\app\BACKUP\c
    ontrolfile/%F';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' D:\ADEN_DB\BACKUP\DATABASE\C/%u';
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOA
    D TRUE ; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO ' D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_
    1\controlfile.ora';

    RMAN>



    But after I did back up this is the result:


    channel ORA_DISK_2 disabled, job failed on it will be run on another channel
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on ORA_DISK_3 channel at 03/25/2013 23:32:
    28
    ORA-19504: failed to create file "D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1\DATAB
    ASE\ D:\ADEN_DB\BACKUP\DATABASE\C\2BO5EQGB"
    ORA-27040: file create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 123) The filename, directory name, or volume label syntax is inco
    rrect.

    RMAN>
  • 6. Re: Problem in RMAN
    995200 Newbie
    Currently Being Moderated
    If you can check, its still using the wrong path
    ORA-19504: failed to create file "D:\APP\OMARFAUZI\PRODUCT\11.2.0\DBHOME_1\DATAB
    ASE\ D:\ADEN_DB\BACKUP\DATABASE\C\2BO5EQGB"
    ORA-27040: file create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 123) The filename, directory name, or volume label syntax is inco
    rrect.
    
    RMAN>
    Please post your backup command as well.
  • 7. Re: Problem in RMAN
    TSharma-Oracle Guru
    Currently Being Moderated
    You still seems to have some wrong entries. This is windows sometimes beahves weird. Change these and OPEN a new command prompt session and start RMAN.

    New settings:
     CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\app\BACKUP\c
    ontrolfile\%F'; 
    CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' D:\ADEN_DB\BACKUP\DATABASE\C\%u'; 
  • 8. Re: Problem in RMAN
    918147 Newbie
    Currently Being Moderated
    RMAN> backup database;
  • 9. Re: Problem in RMAN
    918147 Newbie
    Currently Being Moderated
    I change my configure to


    RMAN> show all;

    RMAN configuration parameters for database with db_unique_name ORCL are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\ADEN_DB\BACK
    UP\DATABASE\CONTROLFILE/%F';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' D:\ADEN_DB\BACKUP\DATABASE\C/%u';
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOA
    D TRUE ; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ADEN_DB\BACKUP\DATABASE\SNAPSHOT CONT
    ROLFILE/%F';

    RMAN>
  • 10. Re: Problem in RMAN
    995200 Newbie
    Currently Being Moderated
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ADEN_DB\BACKUP\DATABASE\SNAPSHOT CONT
    ROLFILE/%F';
    Please remove space from the path. Also Make sure the path actually exists there on the OS.
  • 11. Re: Problem in RMAN
    TSharma-Oracle Guru
    Currently Being Moderated
    it could be the forward slash/backslash thing in windows. You can avoid that 1 slash.

    Run this , open a new RMAN session and try


    New settings:
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\app\BACKUP\controlfile\%F'; 
    CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ' D:\ADEN_DB\BACKUP\DATABASE\C\%u';
    Make sure you check you have these directories available at OS level.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points