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
ORA-16006: audit_trail destination incompatible with database open mode
Thanks in advance
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 :
Also please consider closing some of your old questions to keep the forum clean. Thanks!
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.
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
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
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
SQL>startup open pfile='/u01/app/oracle/admin/PRIMARY/pfile/initPRIMARY.ora'
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
SQL> startup mount
( and use your recover command )
SQL> alter database recover managed standby database disconnect from session;