今天配置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.
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.