logical standby failed [message #553255] |
Wed, 02 May 2012 19:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e5975dcc620c2df03efb06de13170c6c?s=64&d=mm&r=g) |
lerry
Messages: 16 Registered: December 2011
|
Junior Member |
|
|
hi:
I configre logical standby online .
when I execute dbms_logstdby.buid,first
SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
it was blcoked by other sesson,then i kill the holding session,but no work.then i cancel
this step and execute it again . the error is
SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
BEGIN DBMS_LOGSTDBY.BUILD; END;
*
ERROR at line 1:
ORA-01354: Supplemental log data must be added to run this command
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3669
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3755
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 370
ORA-06512: at "SYS.DBMS_LOGSTDBY", line 157
ORA-06512: at line 1
SQL> Alter database add supplemental log data;
Alter database add supplemental log data
*
ERROR at line 1:
ORA-32593: database supplemental logging attributes in flux
|
|
|
|
|
|