Monday 10 September 2012

11g - automatically changes audit_trail to OS



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.

No comments: