RA-16006 audit_trail destination incompatible with database open mode

物理standby，我打算以open read only的方式打开备库，结果报错：

SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16006: audit_trail destination incompatible with database open mode

查看这个错误：

# oerr ora 16006
16006, 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).
//    

查看参数

SQL> show parameter audit_trail;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_trail                          string      DB_EXTENDED

原来是这个参数的问题。

主库设置了审计数据存放到数据库表这个参数，而备库参数是从主库参数修改过来的，现在由于备库要打开只读模式，所以有冲突

可以把审计信息放到操作系统的文件。

这个参数不可以动态修改：

SQL> alter system set audit_trail='os' scope=spfile;

然后重启

SQL> alter database open read only;

Database altered.

如需转载，请注明出处：http://blog.csdn.net/nanaranran/article/details/30475239