This discussion is archived
4 Replies Latest reply: Nov 10, 2011 12:20 AM by mseberg RSS

startup problem with an standby database

User347578 Newbie
Currently Being Moderated
Hi gurus,

Can some one put some light on an issue with starting the standby database.

when i startup the standby database i have this error message .


11:00:44 SYS@APEX> startup
ORACLE instance started.

Total System Global Area 314572800 bytes
Fixed Size 2083656 bytes
Variable Size 121636024 bytes
Database Buffers 188743680 bytes
Redo Buffers 2109440 bytes
Database mounted.
ORA-16006: audit_trail destination incompatible with database open mode


Thanks in advance
  • 1. Re: startup problem with an standby database
    mseberg Guru
    Currently Being Moderated
    Hello;

    I'm thinking you are using Oracle 10 or lower. If this is correct your problem is probably having audit set to DB on a read-only database ( standby).

    In Oracle 11 its smart enough to protect you from this. Change your audit form DB and the issue should go away.

    Here's my note ( to self ) on this :

    http://www.visi.com/~mseberg/audit_trail_and_data_guard.html

    Also please consider closing some of your old questions to keep the forum clean. Thanks!

    Best Regards

    mseberg
  • 2. Re: startup problem with an standby database
    User347578 Newbie
    Currently Being Moderated
    Hi

    Thanks so much for the expert suggestion

    i tryed the sql

    alter system set AUDIT_TRAIL = none;

    which throw the error message

    ORA-02095: specified initialization parameter cannot be modified

    the data base is in mount stage when i try to run the sql above.

    any suggestion is highly apprciiated.

    Thanks
  • 3. Re: startup problem with an standby database
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    If you are using an SPFILE, you can run CREATE PFILE FROM SPFILE after a STARTUP MOUNT and then edit the AUDIT_TRAIL entry in the initSID.ora file that get's created.
    Next STARTUP PFILE=initSID.ora
    Then CREATE SPFILE FROM PFILE
    and then SHUTDOWN and STARTUP again to use the SPFILE.

    Hemant K Chitale
  • 4. Re: startup problem with an standby database
    mseberg Guru
    Currently Being Moderated
    As Hemant said, so you exact step would be something like this:


    1. create pfile='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora' from spfile;

    2. Edit the new initPRIMARY.ora set AUDIT_TRAIL = NONE

    audit_trail=none

    3. Shutdown the database

    SQL> shutdown immediate

    ( If its the standby make sure you issuean " alter database recover managed standby database cancel" first)

    4. Start the datatabase using the pfile

    If Primary

    SQL>startup open pfile='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora'

    If Standby

    SQL>startup mount pfile='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora'

    5.Create a new spfile

    SQL>create spfile from pfile='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora';

    6. shutdown the database

    SQL> shutdown immediate

    ( If Standby will bark because its not mounted, this is expected )

    7. Retstart the database

    If Primary

    SQL>startup

    If Standby

    SQL> startup mount

    ( and use your recover command )

    SQL> alter database recover managed standby database disconnect from session;



    Best Regards

    mseberg

Legend

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