1 2 Previous Next 19 Replies Latest reply: Sep 11, 2013 1:42 AM by Pradeepcmst RSS

    ORA-09925: Unable to create audit trail file with Duplicate database RMAN command

    John-MK

      Hello,

       

      I think I forget to touch the directory topic regarding DUPLICATE DATABASE FROM ACTIVE DATABASE RMAN COMMAND.. and hence, I got the following error at the end of the command:

       

      - - -

      sql statement: alter system set  DB_RECOVERY_FILE_DEST_SIZE =  35000M comment= '''' scope=spfile

       

      Oracle instance shut down

       

      connected to auxiliary database (not started)

      released channel: prmy1

      released channel: prmy2

      released channel: prmy3

      released channel: prmy4

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of Duplicate Db command at 09/10/2013 14:11:10

      RMAN-05501: aborting duplication of target database

      RMAN-03015: error occurred in stored script Memory Script

      RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file

      Linux-x86_64 Error: 2: No such file or directory

      Additional information: 9925

       

      RMAN> exit

       

      After connecting to SQL*Plus I get the same above error while connecting to Physcial Standby db:

       

      SQL> sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 10 15:31:09 2013

       

      Copyright (c) 1982, 2011, Oracle.  All rights reserved.

       

      ERROR:

      ORA-09925: Unable to create audit trail file

      Linux-x86_64 Error: 2: No such file or directory

      Additional information: 9925

      ORA-01075: you are currently logged on

       

       

      Enter user-name:

       

      /oracle/app/base/diag/rdbms/john/john/trace   --background_dump_dest , user_dump_dest

      /oracle/app/base/diag/rdbms/john/john/cdump  --core_dump_dest

       

      /oracle/app/base/admin/john/adump ---audit_file_dest

       

      Thanks a lot for the help.

       

      Best Regards,

        • 1. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
          mseberg

          Hello;

           

          You should use mkdir to create the missing directories and try again.

           

           

          mkdir adump dpdump hdump pfile

           

          I would double check all my parameters before trying the ( for typos etc) RMAN command  again.

           

          Best Regards

           

          mseberg

           

          • 2. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
            John-MK

            Hello,

             

            Thank you.

             

            I created the directories exactly as you wrote by getting tip from one of the blog but that did not help unfortunately....Even I created at two doubtful locations (according to db name / sid)...

             

            But I am seeing following errors in the alert log of this newly physical standby db:

             

            Tue Sep 10 15:47:42 2013

            Could not open audit file: /oracle/app/base/admin/john/adump/john_ora_4512_1.aud

            Retry Iteration No: 1   OS Error: 2

            Retry Iteration No: 2   OS Error: 2

            Retry Iteration No: 3   OS Error: 2

            Retry Iteration No: 4   OS Error: 2

            Retry Iteration No: 5   OS Error: 2

            OS Audit file could not be created; failing after 5 retries

            Could not open audit file: /oracle/app/base/admin/john/adump/john_ora_4512_1.aud

            Retry Iteration No: 1   OS Error: 2

            Retry Iteration No: 2   OS Error: 2

            Retry Iteration No: 3   OS Error: 2

            Retry Iteration No: 4   OS Error: 2

            Retry Iteration No: 5   OS Error: 2

            Tue Sep 10 15:47:52 2013

            OS Audit file could not be created; failing after 5 retries

            My be Standby db trying to find above audits (there are many others) which were present in the adump directory of the PRIMARY db which are not copied to STandby..

             

            Best Regards

            • 3. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
              John-MK

              Yes, you are write, I double checked but somehow I ignore by thinking that directories will be created.

               

              But I wonder, if /oracle/app/oracle/--- are created whats problem with the dump directories..

               

              I have checked the login by creating adump bdump hdump pfile dpdump everywhere but does not help

               

              Thank you.

               

              Best Regards

              • 4. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                mseberg

                Hello again;

                 

                This is what makes me think that you either have a typo, of are missing a permission.

                 

                Linux-x86_64 Error: 2: No such file or directory

                 

                The problem is at the OS level.

                 

                On mine the permission for these are:

                 

                oracle oinstall

                 

                ls -al /u01/app/oracle/admin/PRIMARY

                total 460

                drwxrwxr-x 5 oracle oinstall 4096 Jun 14 2012 .

                drwxrwxr-x 20 oracle oinstall 4096 Aug 9 08:52 ..

                drwxrwxr-x 2 oracle oinstall 450560 Sep 8 05:31 adump

                drwxrwxr-x 2 oracle oinstall 4096 Jun 14 2012 dpdump

                drwxrwxr-x 2 oracle oinstall 4096 Feb 6 2013 pfil

                 

                Best Regards

                 

                mseberg

                • 5. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                  mseberg

                  A simple test for each directory would be to switch to it as the "oracle" user and use an editor like vi to create a small file.

                   

                  In any event the problem is at the OS level. Once that is fixed it will allow oracle to work there.

                   

                  Best Regards

                   

                  mseberg

                  • 6. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                    Pradeepcmst

                    Hi John,

                    Did you check for adump folder permission, in stanby site?

                    Then start the standby instance in nomount stage

                    Then from primary database, connect RMAN as "rman target sys@<Primary_SID>"

                    Then " connect auxiliary sys@<Standby_SID>"

                     

                    let us know the status

                     

                    Regards,

                    Pradeep. V

                    • 7. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                      John-MK

                      I appreciate you help.

                       

                      I think I fixed the problem. According to the note id  1227964.1        more spfile.ora and found the correct destination it is looking for. but now I have another teasing error...

                       

                      SQL> startup mount

                      ORACLE instance started.

                      Total System Global Area  242208768 bytes

                      Fixed Size            2227176 bytes

                      Variable Size          184550424 bytes

                      Database Buffers       50331648 bytes

                      Redo Buffers            5099520 bytes

                      ORA-00205: error in identifying control file, check alert log for more info




                       



                      • 8. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                        John-MK

                        Hello Pradeep,

                         

                        Thanks a lot.

                         

                        # STBY:

                        SQL> startup nomount

                        ORACLE instance started.

                         

                        Total System Global Area  242208768 bytes

                        Fixed Size            2227176 bytes

                        Variable Size          184550424 bytes

                        Database Buffers       50331648 bytes

                        Redo Buffers            5099520 bytes

                        # PRIMARY:

                        RMAN> CONNECT TARGET sys/oracle@JOHN;

                         

                        connected to target database: JOHN (DBID=1575580406)

                         

                        RMAN> CONNECT AUXILIARY sys/oracle@JOHN_DB2;

                         

                        connected to auxiliary database: JOHN (not mounted)

                         

                        # Alert log after:

                        SQL> alter database mount;

                        alter database mount

                        *

                        ERROR at line 1:

                        ORA-00205: error in identifying control file, check alert log for more info

                         

                        Tue Sep 10 16:32:17 2013

                        alter database mount

                        Tue Sep 10 16:32:17 2013

                        NOTE: Loaded library: System

                        Tue Sep 10 16:32:17 2013

                        SUCCESS: diskgroup DATA was mounted

                        ORA-00210: cannot open the specified control file

                        ORA-00202: control file: '+DATA/john_db2/control.ctl'

                        ORA-17503: ksfdopn:2 Failed to open file +DATA/john_db2/control.ctl

                        ORA-15173: entry 'john_db2' does not exist in directory '/'

                        ORA-205 signalled during: alter database mount...

                        Tue Sep 10 16:32:17 2013

                        SUCCESS: diskgroup DATA was dismounted

                        • 9. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                          Pradeepcmst

                          John,

                          Where u getting this error, in primary site or standby site?

                          If its standby you no need to start just instance in nomount state.

                          Then when you execute duplicate command from primary site, rman wil  copy all the data, control files according to the spfile you mounted in standby...

                          Did u copy the spfile from primary to standby and tried to start the standby??

                          • 10. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                            John-MK

                            I used this minimum way to create Physical standby db:

                             

                            RMAN> CONNECT TARGET sys/pwd@primarydb;

                                  CONNECT AUXILIARY sys/pwd@standbydb;

                            run {

                            allocate channel prmy1 type disk;

                            allocate channel prmy2 type disk;

                            allocate channel prmy3 type disk;

                            allocate channel prmy4 type disk;

                            allocate channel prmy5 type disk;

                            allocate auxiliary channel stby1 type disk;

                            duplicate target database for standby from active database

                              spfile

                                 parameter_value_convert 'primary','standby'

                                 set 'db_unique_name'='standbydb-name'

                                 set control_files='+DATA/db_stby/control.ctl'   <<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<

                                 set db_create_file_dest='+DATA01'

                                 set db_create_online_log_dest_1='+DATA01'

                                 set db_create_online_log_dest_2='+DATA01'

                                 set db_recovery_file_dest='+DATA01'

                                 set DB_RECOVERY_FILE_DEST_SIZE='90G'

                            nofilenamecheck;

                            }

                            I would assume that +DATA/db_stby/control.ct db_stby directory will be created. But I think its not there:

                             

                            ASMCMD> ls

                            DATA/

                            FRA/

                            ASMCMD> cd DATA

                            ASMCMD> ls

                            ASM/

                            Jack1/

                            d1john1.dat

                            d2john1.dat

                             

                            SQL> select name from v$asm_diskgroup;

                             

                            NAME

                            ------------------------------

                            DATA

                            FRA

                            • 11. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                              Pradeepcmst

                              HI,

                               

                              # STBY:

                              SQL> startup nomount

                              ORACLE instance started.

                               

                              Total System Global Area  242208768 bytes

                              Fixed Size            2227176 bytes

                              Variable Size          184550424 bytes

                              Database Buffers       50331648 bytes

                              Redo Buffers            5099520 bytes

                              # PRIMARY:

                              RMAN> CONNECT TARGET sys/oracle@JOHN;

                               

                              connected to target database: JOHN (DBID=1575580406)

                               

                              RMAN> CONNECT AUXILIARY sys/oracle@JOHN_DB2;

                                                  

                               

                              Until this you did correct. now just in a run block, like

                              eg

                              run

                              {

                              allocate channel ....

                              allocate channel...

                              duplicate target database for standby from active database;

                              }

                               

                               

                               

                              • 12. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                                Pradeepcmst

                                If you ask me, i will say good option according to me  is starting the standby  instance in nomount using a pfile(which is copied from primary and edited according to standby environment, then create spfile from pfile, then down the instance and start the instance using the newly created spfile ). If you use this method, you can just use the following commands alone.

                                 

                                RMAN> CONNECT TARGET sys/pwd@primarydb;

                                      CONNECT AUXILIARY sys/pwd@standbydb;

                                run {

                                allocate channel prmy1 type disk;

                                allocate channel prmy2 type disk;

                                allocate channel prmy3 type disk;

                                allocate channel prmy4 type disk;

                                allocate channel prmy5 type disk;

                                allocate auxiliary channel stby1 type disk;

                                duplicate target database for standby from active database

                                }

                                 

                                I did the same and worked for me.

                                 

                                Regards,

                                Pradeep. V

                                • 13. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                                  John-MK

                                  I have this book Oracle Data Guard 11g Handbook .... Larry Carpenter and I was following this..

                                   

                                  It said nothing special about creating control file for standby database..only including in the RMAN SCRIPT ...set control_files='+DATA/JOHN_DB2/control.ctl'

                                   

                                   

                                  I am thinking that whether directory JOHN_DB2 would be created itself in the +DATA diskgroup ..?

                                  • 14. Re: ORA-09925: Unable to create audit trail file with Duplicate database RMAN command
                                    John-MK

                                    If it it not fixed, then can you suggest me how to remove whatever partial is created, so that I give a another try?

                                     

                                    Thank you.

                                     

                                    Best Regards

                                    1 2 Previous Next