This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Sep 10, 2013 11:42 PM by Pradeepcmst RSS

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

John-MK Newbie
Currently Being Moderated

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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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

Legend

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