11g - automatically changes audit_trail to OS
From Audit Trail-----
Mon Sep 10 10:53:06 2012
alter database open read only
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-onlyccess
SYS@STANDBY >> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@STANDBY >> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2225064 bytes
Variable Size 159386712 bytes
Database Buffers 50331648 bytes
Redo Buffers 5214208 bytes
Database mounted.
SYS@STANDBY >> show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /cluster/app/grid/product/11.2
.0/db_1/admin/STANDBY/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB
SYS@STANDBY >> alter database open read only;
Database altered.
SYS@STANDBY >> show parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /cluster/app/grid/product/11.2
.0/db_1/admin/STANDBY/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string OS
SYS@STANDBY >>
SYS@STANDBY >>
SYS@STANDBY >> alter database recover managed standby database using current logfile disconnect;
Database altered.
