logical standby failed [message #553255] |
Wed, 02 May 2012 19:29 |
|
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
|
|
|
|
|
|