11 Replies Latest reply: Mar 25, 2013 11:40 AM by TSharma-Oracle RSS

    Problem in RMAN

    user13393173
      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
          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
            user13393173
            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
              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
                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
                  user13393173
                  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
                    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
                      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
                        user13393173
                        RMAN> backup database;
                        • 9. Re: Problem in RMAN
                          user13393173
                          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
                            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
                              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.