Home » Server Options » Data Guard » logical standby failed (10.2.0.4, os 6.1)
logical standby failed [message #553255] Wed, 02 May 2012 19:29 Go to next message
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
Re: logical standby failed [message #553256 is a reply to message #553255] Wed, 02 May 2012 20:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
While you are waiting for a better solution, consider doing as below

sqlplus
/ as sysdba
shutdown immediate
startup
Alter database add supplemental log data;
exit
Re: logical standby failed [message #553257 is a reply to message #553256] Wed, 02 May 2012 21:34 Go to previous messageGo to next message
lerry
Messages: 16
Registered: December 2011
Junior Member
before configure standby, i had do as bleow:
startup mount;
alter database add supplemental log data;
alter database opne;
then select * from v$database;

SUPPLEMENTAL_LOG_DATA_UI, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_FK,
SUPPLEMENTAL_LOG_DATA_ALL

NO NO YES NO
NO

if the supplemental log not work
Re: logical standby failed [message #553260 is a reply to message #553257] Wed, 02 May 2012 22:32 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: How to handle this problem: archivelog gap ?
Next Topic: logical standby apply slowly
Goto Forum:
  


Current Time: Thu Mar 28 10:01:51 CDT 2024