4 Replies Latest reply: Nov 10, 2011 2:20 AM by mseberg RSS

    startup problem with an standby database

    User347578
      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
          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
            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
              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
                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