Oracle 11g中Standby Database AUDIT_TRAIL参数的变化

在10g中Standby Database spfile 中如果 AUDIT_TRAIL=db，Standby Database将会无法启动到 read-only，但在11g中如果参数 AUDIT_TRAIL=db oracle 会自动将Standby Database 的 AUDIT_TRAIL initialization parameter is changed to OS，这样就可以启动到read-only模式.

以下为11g启动日志

Physical Standby Database mounted.
Lost write protection disabled
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE   MOUNT
Fri Dec 20 17:57:45 2013
ALTER DATABASE OPEN
Data Guard Broker initializing...
Data Guard Broker initialization complete
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Fri Dec 20 17:57:48 2013
SMON: enabling cache recovery
Dictionary check beginning
Fri Dec 20 17:57:49 2013
Starting Data Guard Broker (DMON)

10g

Media Recovery Waiting for thread 1 sequence 2847
Mon May 13 14:08:59 CST 2013
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  NODELAY
Mon May 13 14:09:38 CST 2013
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 29986
RFS[1]: Identified database type as 'physical standby'
Mon May 13 14:09:38 CST 2013
RFS LogMiner: Client disabled from further notification
RFS[1]: Archived Log: '/U01/app/oracle/admin/accdb0/arch/1_2847_782776240.dbf'
Mon May 13 14:09:38 CST 2013
Media Recovery Log /U01/app/oracle/admin/accdb0/arch/1_2847_782776240.dbf
Media Recovery Waiting for thread 1 sequence 2848
Mon May 13 14:10:18 CST 2013
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Mon May 13 14:10:18 CST 2013
MRP0: Background Media Recovery cancelled with status 16037
Mon May 13 14:10:18 CST 2013
Errors in file /U01/app/oracle/admin/accdb0/bdump/accdb0_mrp0_29697.trc:
ORA-16037: user requested cancel of managed recovery operation
Recovery interrupted!
Mon May 13 14:10:19 CST 2013
Errors in file /U01/app/oracle/admin/accdb0/bdump/accdb0_mrp0_29697.trc:
ORA-16037: user requested cancel of managed recovery operation
Mon May 13 14:10:19 CST 2013
MRP0: Background Media Recovery process shutdown (accdb0)
Mon May 13 14:10:20 CST 2013
Managed Standby Recovery Canceled (accdb0)
Mon May 13 14:10:20 CST 2013
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Mon May 13 14:10:21 CST 2013
ALTER DATABASE OPEN READ ONLY
ORA-16006 signalled during: ALTER DATABASE OPEN READ ONLY...
Mon May 13 14:11:09 CST 2013
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  NODELAY

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26390465/viewspace-1769375/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26390465/viewspace-1769375/