OraFAQ Forum: Data Guard » logical standby failed

Home » Server Options » Data Guard » logical standby failed (10.2.0.4, os 6.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: logical standby failed [message #553256 is a reply to message #553255]

Wed, 02 May 2012 20:31

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

Report message to a moderator

Re: logical standby failed [message #553257 is a reply to message #553256]

Wed, 02 May 2012 21:34

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

Report message to a moderator

Re: logical standby failed [message #553260 is a reply to message #553257]

Wed, 02 May 2012 22:32

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/

Report message to a moderator

Previous Topic:	How to handle this problem: archivelog gap ?
Next Topic:	logical standby apply slowly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 03 10:34:37 CDT 2025