错误提示sys@ETMCDB> alter database open read only;alter database open read only*ERROR at line 1:ORA-16006: audit_trail destination incompatible with database open mode
解决方法 sys@ETMCDB> show parameter audit_trail;NAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_trail string DB, EXTENDEDsys@ETMCDB> alter system set audit_trail='os' scope=spfile;System altered. sys@ETMCDB> shutdown immediate; sys@ETMCDB> startup mount; sys@ETMCDB> alter database open read only;Database altered. 错误原因 sys@ETMCDB> !oerr ora 1600616006, 00000, "audit_trail destination incompatible with database open mode"// *Cause: The audit_trail initialization parameter was set to "DB" (or// TRUE), which is incompatible with a database opened for read-only// access.// *Action: When the database is opened for read-only access, the audit_trail// initialization parameter can only be set to "OS" or "NONE" (FALSE).// sys@ETMCDB> show parameter audit_trail;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_trail string DB, EXTENDED 后来查了一下，发现是主库设置了审计数据存放到数据库表这个参数，而备库参数是从主库参数修改过来的，现在由于备库要打开只读模式，所以有冲突，那就把审计信息放倒操作系统目录下吧。 只读模式打开成功。以后如果这个备库switchover或failover成主库的时候，它的审计信息会放到audit_file_dest参数指定的目录里。 --引用<<以只读模式打开物理备库的时候，遇到ORA-16006错误>> sys@ETMCDB> show parameter audit_trail NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_trail string OSsys@ETMCDB> show parameter audit_fileNAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_file_dest string /u01/app/oracle/admin/ETMCDB/adump转载于:https://www.cnblogs.com/buro79xxd/archive/2009/12/01/1682578.html
相关资源：JAVA上百实例源码以及开源项目