What does a startup upgrade internally?
Hi,
Does some know what "startup upgrade" in Oracle 10g internally does? In the alert log I see the following:
ALTER SYSTEM enable restricted session;
MMNL started with pid=12, OS id=3872
Fri Jan 22 10:26:35 2010 ALTER SYSTEM SET systemtrig_enabled=FALSE SCOPE=MEMORY;
Autotune of undo retention is turned off.
Fri Jan 22 10:26:35 2010 ALTER SYSTEM SET undoautotune=FALSE SCOPE=MEMORY;
Fri Jan 22 10:26:35 2010 ALTER SYSTEM SET undo_retention=900 SCOPE=MEMORY;
Fri Jan 22 10:26:35 2010 ALTER SYSTEM SET aq_tm_processes=0 SCOPE=MEMORY;
Resource Manager disabled during database migration: plan '' not set
Fri Jan 22 10:26:35 2010 ALTER SYSTEM SET resource_manager_plan='' SCOPE=MEMORY;
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN MIGRATE
Fri Jan 22 10:27:00 2010 FAST_START_MTTR_TARGET 30 is out of the valid MTTR range, use 52 instead.
I wanted to trace the oracle instance with ORACLE_TRACE_ENABLE but that parameter is obsolete in 10g (is there an equivalent in 10G?) and I'm not usre that sql_trace will give all the actions of STARTUP UPGRADE.
I need to know what startup upgrade (SU) does because a customer wants reassurance that SU will not change anything in the database.
regards,
Ivan