Database Administration (MOSC)

MOSC Banner

adding supplemental log data not finished

edited Jun 15, 2016 5:03AM in Database Administration (MOSC) 5 commentsAnswered

hello. I try to give that command but there is no respond from sqlplus. I use Oracle 12c oda machine.

SQL> alter database add supplemental log data;

In alert log;

Tue Jun 07 22:45:13 2016
SUPLOG: Previous supplemental logging attributes at scn = 206679905442
SUPLOG:  minimal = OFF, primary key = OFF
SUPLOG:  unique = OFF, foreign key = OFF, all column = OFF
SUPLOG:  procedural replication = OFF
Tue Jun 07 22:45:14 2016
SUPLOG: New supplemental logging attributes at scn = 206679905534
SUPLOG:  minimal = ON, primary key = OFF
SUPLOG:  unique = OFF, foreign key = OFF, all column = OFF
SUPLOG:  procedural replication = OFF

there is No "completed" message and my command stil works. When i give break, then I try to drop supplemental log data but there is no respond too. I can drop after "alter system switch logfile". What may the problem be? thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center