今天配置ogg，对源端oracle配置追加日志的时候，命令长时间挂起：
SQL> alter database add supplemental log data;
长时间挂起

alter日志如下：
Thu Oct 23 10:14:35 2014
alter database add supplemental log data
SUPLOG: Previous supplemental logging attributes at scn = 11000495655
SUPLOG:  minimal = OFF, primary key = OFF
SUPLOG:  unique = OFF, foreign key = OFF, all column = OFF
SUPLOG:  procedural replication = OFF
SUPLOG: New supplemental logging attributes at scn = 11000495655
SUPLOG:  minimal = ON, primary key = OFF
SUPLOG:  unique = OFF, foreign key = OFF, all column = OFF
SUPLOG:  procedural replication = OFF
Thu Oct 23 10:24:26 2014

临时解决方法是先关闭数据库，在mount下操作：
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1.6034E+10 bytes
Fixed Size                  2219552 bytes
Variable Size            4697620960 bytes
Database Buffers         1.1207E+10 bytes
Redo Buffers              127193088 bytes
Database mounted.
SQL> alter database add supplemental log data;

Database altered.

SQL> alter database open;

Database altered.