Home » Server Options » Data Guard » logstdby.build is taking time to execute (11g, 11.2.0.3, Solaris 10)
logstdby.build is taking time to execute [message #617547] Tue, 01 July 2014 07:58 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

At primary side, after addition of supplemental log data, dbms_logstdby.build script is executed which is keep on executing.

* This is the second time, I am refreshing ODS database. And OLTP is open mode, users are connected.

Alert log at primary side -

Tue Jul 01 18:12:18 2014

Archived Log entry 13366 added for thread 1 sequence 7748 ID 0x65037b9c dest 1:

Tue Jul 01 18:13:27 2014

Thread 1 cannot allocate new log, sequence 7750

Checkpoint not complete

Current log# 3 seq# 7749 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_3.270.833318051

Thread 1 advanced to log sequence 7750 (LGWR switch)

Current log# 1 seq# 7750 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_1.271.833318051

Tue Jul 01 18:13:36 2014

LNS: Standby redo logfile selected for thread 1 sequence 7750 for destination LOG_ARCHIVE_DEST_2

Tue Jul 01 18:13:38 2014

Archived Log entry 13368 added for thread 1 sequence 7749 ID 0x65037b9c dest 1:



Alert log at standby side -
Tue Jul 01 18:11:02 2014

Archived Log entry 300 added for thread 1 sequence 7747 ID 0x65037b9c dest 1:

Archived Log entry 301 added for thread 1 sequence 7747 ID 0x65037b9c dest 3:

Tue Jul 01 18:12:15 2014

RFS[20]: Selected log 5 for thread 1 sequence 7749 dbid 1694747807 branch 833318050

Tue Jul 01 18:12:19 2014

Archived Log entry 302 added for thread 1 sequence 7748 ID 0x65037b9c dest 1:

Archived Log entry 303 added for thread 1 sequence 7748 ID 0x65037b9c dest 3:

Tue Jul 01 18:13:36 2014

RFS[20]: Selected log 4 for thread 1 sequence 7750 dbid 1694747807 branch 833318050

Tue Jul 01 18:13:42 2014

Archived Log entry 304 added for thread 1 sequence 7749 ID 0x65037b9c dest 1:

Archived Log entry 305 added for thread 1 sequence 7749 ID 0x65037b9c dest 3:


Kindly suggest what would be the possibilities of the issues? (more than 2 hours taken and still executing...)

Regards,
Ashish Kumar Mahanta
Re: logstdby.build is taking time to execute [message #617549 is a reply to message #617547] Tue, 01 July 2014 08:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Kindly suggest what would be the possibilities of the issues?
heavy DML generation on the Primary
Re: logstdby.build is taking time to execute [message #617550 is a reply to message #617547] Tue, 01 July 2014 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

First of all, fix this one:
Thread 1 cannot allocate new log, sequence 7750

Checkpoint not complete


http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=39671#142275

Re: logstdby.build is taking time to execute [message #617556 is a reply to message #617550] Tue, 01 July 2014 08:33 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John / Michel,

It means, either needs to enlarge log files or execute the script in restricted mode?

Regards,

Ashish Kumar Mahanta
Re: logstdby.build is taking time to execute [message #617558 is a reply to message #617556] Tue, 01 July 2014 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Here's another link to answer your question:
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=46309#160126

You can also use the link Bruno gave in the post just before mine in this link.

Re: logstdby.build is taking time to execute [message #617609 is a reply to message #617558] Wed, 02 July 2014 04:24 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Michel,

After doing the changes (redo log file sizes increases to avoid checkpoint incomplete issuse), still logstdby.build is keeping on executing. Alert log after executing duplicate command.

Below are the alert logs -
TRNGOLTP Alert Log:

Wed Jul 02 12:07:41 2014
alter database add supplemental log data
Completed: alter database add supplemental log data
Wed Jul 02 12:08:12 2014
Wed Jul 02 12:08:12 2014
Logminer Bld: Build started
ALTER SYSTEM SWITCH ALL LOGFILE start (TRNGOLTP)
ALTER SYSTEM SWITCH ALL LOGFILE complete (TRNGOLTP)
Wed Jul 02 12:08:13 2014
Thread 1 advanced to log sequence 8143 (LGWR switch)
  Current log# 2 seq# 8143 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_2.273.85                                  1857077
Wed Jul 02 12:08:13 2014
Logminer Bld: Lockdown Complete.  DB_TXN_SCN is 0 76499643 LockdownSCN is 764996                                  41
Wed Jul 02 12:08:15 2014
Archived Log entry 14147 added for thread 1 sequence 8142 ID 0x65037b9c dest 1:
Wed Jul 02 12:08:15 2014
LNS: Standby redo logfile selected for thread 1 sequence 8143 for destination LO                                  G_ARCHIVE_DEST_2
Wed Jul 02 12:08:28 2014
ALTER SYSTEM ARCHIVE LOG
Wed Jul 02 12:08:28 2014
Thread 1 advanced to log sequence 8144 (LGWR switch)
  Current log# 3 seq# 8144 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_3.270.85                                  1857035
Wed Jul 02 12:08:33 2014
LNS: Standby redo logfile selected for thread 1 sequence 8144 for destination LO                                  G_ARCHIVE_DEST_2
Wed Jul 02 12:08:43 2014
Archived Log entry 14149 added for thread 1 sequence 8143 ID 0x65037b9c dest 1:
Wed Jul 02 12:08:43 2014
Logminer Bld: Done
LOGMINER: Dictionary Build: Waiting for txns in-flight at scn 0x0000.048f4ab9 [7                                  6499641] to complete
Wed Jul 02 12:11:23 2014
Thread 1 advanced to log sequence 8145 (LGWR switch)
  Current log# 9 seq# 8145 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_9.300.85                                  1856175
Wed Jul 02 12:11:25 2014
Archived Log entry 14151 added for thread 1 sequence 8144 ID 0x65037b9c dest 1:
Wed Jul 02 12:11:27 2014
LNS: Standby redo logfile selected for thread 1 sequence 8145 for destination LO                                  G_ARCHIVE_DEST_2
Wed Jul 02 12:14:16 2014
Thread 1 advanced to log sequence 8146 (LGWR switch)
  Current log# 1 seq# 8146 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_1.271.85                                  1856031
Wed Jul 02 12:14:18 2014
Archived Log entry 14153 added for thread 1 sequence 8145 ID 0x65037b9c dest 1:
Wed Jul 02 12:14:18 2014
LNS: Standby redo logfile selected for thread 1 sequence 8146 for destination LO                                  G_ARCHIVE_DEST_2
Wed Jul 02 12:16:40 2014
Thread 1 advanced to log sequence 8147 (LGWR switch)
  Current log# 8 seq# 8147 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_8.299.85                                  1855729
Wed Jul 02 12:16:43 2014
Archived Log entry 14155 added for thread 1 sequence 8146 ID 0x65037b9c dest 1:
Wed Jul 02 12:16:47 2014
LNS: Standby redo logfile selected for thread 1 sequence 8147 for destination LO                                  G_ARCHIVE_DEST_2
Wed Jul 02 12:18:43 2014
Thread 1 advanced to log sequence 8148 (LGWR switch)
  Current log# 2 seq# 8148 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_2.273.85                                  1857077
Wed Jul 02 12:18:45 2014
Archived Log entry 14157 added for thread 1 sequence 8147 ID 0x65037b9c dest 1:
Wed Jul 02 12:18:46 2014
LNS: Standby redo logfile selected for thread 1 sequence 8148 for destination LO                                  G_ARCHIVE_DEST_2
Wed Jul 02 12:20:49 2014
Thread 1 advanced to log sequence 8149 (LGWR switch)
  Current log# 3 seq# 8149 mem# 0: +OLTP_DATA1/trngoltp/onlinelog/group_3.270.851857035
Wed Jul 02 12:20:52 2014
Archived Log entry 14159 added for thread 1 sequence 8148 ID 0x65037b9c dest 1:
Wed Jul 02 12:20:53 2014


Alert log standby side-
TRNGODS Alert log:

alter database clear logfile group 1
Clearing online log 1 of thread 1 sequence number 8131
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_1.271.851                                  856031'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_1.2                                  71.851856031
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_1.271.851                                  856031'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_1.2                                  71.851856031
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_1.271.851856031
Completed: alter database clear logfile group 1
alter database clear logfile group 2
Clearing online log 2 of thread 1 sequence number 8128
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_2.273.851                                  857077'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_2.2                                  73.851857077
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_2.273.851                                  857077'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_2.2                                  73.851857077
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_2.273.851857077
Completed: alter database clear logfile group 2
alter database clear logfile group 3
Clearing online log 3 of thread 1 sequence number 8129
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_3.270.851                                  857035'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_3.2                                  70.851857035
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_3.270.851                                  857035'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_3.2                                  70.851857035
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_3.270.851857035
Completed: alter database clear logfile group 3
alter database clear logfile group 4
Clearing online log 4 of thread 0 sequence number 0
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_4.294.838                                  232361'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_4.2                                  94.838232361
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_4.294.838                                  232361'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_4.2                                  94.838232361
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_4.294.838232361
Completed: alter database clear logfile group 4
alter database clear logfile group 5
Clearing online log 5 of thread 0 sequence number 0
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_5.295.838                                  234971'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_5.2                                  95.838234971
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_5.295.838                                  234971'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_5.2                                  95.838234971
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_5.295.838234971
Completed: alter database clear logfile group 5
alter database clear logfile group 6
Clearing online log 6 of thread 0 sequence number 0
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_6.296.838                                  234973'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_6.2                                  96.838234973
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_6.296.838                                  234973'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_6.2                                  96.838234973
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_6.296.838234973
Completed: alter database clear logfile group 6
alter database clear logfile group 7
Clearing online log 7 of thread 0 sequence number 0
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_7.297.838                                  234973'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_7.2                                  97.838234973
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_7.297.838                                  234973'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_7.2                                  97.838234973
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_7.297.838234973
Completed: alter database clear logfile group 7
alter database clear logfile group 8
Clearing online log 8 of thread 1 sequence number 8127
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 8 of thread 1
ORA-00312: online log 8 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_8.299.851                                  855729'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_8.2                                  99.851855729
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 8 of thread 1
ORA-00312: online log 8 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_8.299.851                                  855729'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_8.2                                  99.851855729
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_8.299.851855729
Completed: alter database clear logfile group 8
alter database clear logfile group 9
Clearing online log 9 of thread 1 sequence number 8130
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 9 of thread 1
ORA-00312: online log 9 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_9.300.851                                  856175'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_9.3                                  00.851856175
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 9 of thread 1
ORA-00312: online log 9 thread 1: '+ODS_DATA1/trngoltp/onlinelog/group_9.300.851                                  856175'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_9.3                                  00.851856175
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_9.300.851856175
Completed: alter database clear logfile group 9
alter database clear logfile group 10
Clearing online log 10 of thread 0 sequence number 0
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 10 of thread 0
ORA-00312: online log 10 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_10.301.8                                  51857327'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_10.                                  301.851857327
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 10 of thread 0
ORA-00312: online log 10 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_10.301.8                                  51857327'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_10.                                  301.851857327
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_10.301.851857327
Wed Jul 02 11:55:48 2014
Completed: alter database clear logfile group 10
alter database clear logfile group 11
Clearing online log 11 of thread 0 sequence number 0
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 11 of thread 0
ORA-00312: online log 11 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_11.302.8                                  51857337'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_11.                                  302.851857337
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Errors in file /trngorabin/app/oracle/diag/rdbms/trngods/TRNGODS/trace/TRNGODS_o                                  ra_13001.trc:
ORA-00313: open failed for members of log group 11 of thread 0
ORA-00312: online log 11 thread 0: '+ODS_DATA1/trngoltp/onlinelog/group_11.302.8                                  51857337'
ORA-17503: ksfdopn:2 Failed to open file +ODS_DATA1/trngoltp/onlinelog/group_11.                                  302.851857337
ORA-15173: entry 'trngoltp' does not exist in directory '/'
Deleted Oracle managed file +ODS_DATA1/trngoltp/onlinelog/group_11.302.851857337
Completed: alter database clear logfile group 11
RFS connections are allowed
Wed Jul 02 11:58:28 2014
SUCCESS: diskgroup ODS_DATA2 was mounted
Wed Jul 02 11:58:28 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process 14598
RFS[1]: Opened log for thread 1 sequence 8133 dbid 1694747807 branch 833318050
Wed Jul 02 11:58:28 2014
RFS[2]: Assigned to RFS process 14618
RFS[2]: Opened log for thread 1 sequence 8134 dbid 1694747807 branch 833318050
Wed Jul 02 11:58:40 2014
RFS[3]: Assigned to RFS process 14615
RFS[3]: Selected log 10 for thread 1 sequence 8139 dbid 1694747807 branch 833318                                  050
Wed Jul 02 11:58:53 2014
RFS[4]: Assigned to RFS process 14603
RFS[4]: Opened log for thread 1 sequence 8132 dbid 1694747807 branch 833318050
Wed Jul 02 11:58:58 2014
NOTE: dependency between database TRNGODS and diskgroup resource ora.ODS_DATA2.d                                  g is established
Wed Jul 02 11:58:58 2014
RFS[5]: Assigned to RFS process 14624
RFS[5]: Selected log 11 for thread 1 sequence 8138 dbid 1694747807 branch 833318                                  050
Wed Jul 02 11:59:00 2014
RFS[6]: Assigned to RFS process 14620
RFS[6]: Opened log for thread 1 sequence 8136 dbid 1694747807 branch 833318050
Wed Jul 02 11:59:00 2014
Archived Log entry 1 added for thread 1 sequence 8133 rlc 833318050 ID 0x65037b9                                  c dest 2:
Wed Jul 02 11:59:01 2014
RFS[7]: Assigned to RFS process 14608
RFS[7]: Opened log for thread 1 sequence 8135 dbid 1694747807 branch 833318050
Wed Jul 02 11:59:01 2014
RFS[8]: Assigned to RFS process 14622
RFS[8]: Opened log for thread 1 sequence 8137 dbid 1694747807 branch 833318050
Wed Jul 02 11:59:01 2014
RFS[9]: Assigned to RFS process 14606
RFS[9]: Opened log for thread 1 sequence 8131 dbid 1694747807 branch 833318050
Wed Jul 02 11:59:02 2014
Archived Log entry 2 added for thread 1 sequence 8134 rlc 833318050 ID 0x65037b9                                  c dest 2:
Wed Jul 02 11:59:13 2014
Archived Log entry 3 added for thread 1 sequence 8132 rlc 833318050 ID 0x65037b9                                  c dest 2:
Wed Jul 02 11:59:17 2014
Archived Log entry 4 added for thread 1 sequence 8136 rlc 833318050 ID 0x65037b9                                  c dest 2:
Wed Jul 02 11:59:17 2014
Archived Log entry 5 added for thread 1 sequence 8137 rlc 833318050 ID 0x65037b9                                  c dest 2:
Wed Jul 02 11:59:21 2014
Archived Log entry 6 added for thread 1 sequence 8131 rlc 833318050 ID 0x65037b9                                  c dest 2:
Wed Jul 02 11:59:21 2014
Archived Log entry 7 added for thread 1 sequence 8135 rlc 833318050 ID 0x65037b9                                  c dest 2:
Wed Jul 02 11:59:25 2014
Archived Log entry 8 added for thread 1 sequence 8138 ID 0x65037b9c dest 1:
Archived Log entry 9 added for thread 1 sequence 8138 ID 0x65037b9c dest 3:
Wed Jul 02 12:00:36 2014
RFS[3]: Selected log 11 for thread 1 sequence 8140 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:00:43 2014
Archived Log entry 10 added for thread 1 sequence 8139 ID 0x65037b9c dest 1:
Archived Log entry 11 added for thread 1 sequence 8139 ID 0x65037b9c dest 3:
Wed Jul 02 12:02:09 2014
ALTER SYSTEM SET log_archive_dest_1='location=+ODS_DATA2/arc_ods/ VALID_FOR=(All                                  _LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=TRNGODS' SCOPE=BOTH;
Wed Jul 02 12:03:40 2014
ALTER SYSTEM SET log_archive_dest_2='SERVICE=TRNGOLTP LGWR ASYNC VALID_FOR=(ONLI                                  NE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TRNGOLTP' SCOPE=BOTH;
Wed Jul 02 12:03:53 2014
RFS[3]: Selected log 10 for thread 1 sequence 8141 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:04:04 2014
Archived Log entry 12 added for thread 1 sequence 8140 ID 0x65037b9c dest 1:
Archived Log entry 13 added for thread 1 sequence 8140 ID 0x65037b9c dest 3:
Wed Jul 02 12:06:31 2014
RFS[3]: Selected log 11 for thread 1 sequence 8142 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:06:41 2014
Archived Log entry 14 added for thread 1 sequence 8141 ID 0x65037b9c dest 1:
Archived Log entry 15 added for thread 1 sequence 8141 ID 0x65037b9c dest 3:
Wed Jul 02 12:06:51 2014
alter database add standby logfile group 12('+ODS_DATA1') size 200M
Completed: alter database add standby logfile group 12('+ODS_DATA1') size 200M
Wed Jul 02 12:08:15 2014
RFS[3]: Selected log 10 for thread 1 sequence 8143 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:08:22 2014
Archived Log entry 16 added for thread 1 sequence 8142 ID 0x65037b9c dest 1:
Archived Log entry 17 added for thread 1 sequence 8142 ID 0x65037b9c dest 3:
Wed Jul 02 12:08:33 2014
RFS[3]: Selected log 11 for thread 1 sequence 8144 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:08:43 2014
Archived Log entry 18 added for thread 1 sequence 8143 ID 0x65037b9c dest 1:
Archived Log entry 19 added for thread 1 sequence 8143 ID 0x65037b9c dest 3:
Wed Jul 02 12:11:27 2014
RFS[3]: Selected log 10 for thread 1 sequence 8145 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:11:34 2014
Archived Log entry 20 added for thread 1 sequence 8144 ID 0x65037b9c dest 1:
Archived Log entry 21 added for thread 1 sequence 8144 ID 0x65037b9c dest 3:
Wed Jul 02 12:14:18 2014
RFS[3]: Selected log 11 for thread 1 sequence 8146 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:14:26 2014
Archived Log entry 22 added for thread 1 sequence 8145 ID 0x65037b9c dest 1:
Archived Log entry 23 added for thread 1 sequence 8145 ID 0x65037b9c dest 3:
Wed Jul 02 12:16:47 2014
RFS[3]: Selected log 10 for thread 1 sequence 8147 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:16:59 2014
Archived Log entry 24 added for thread 1 sequence 8146 ID 0x65037b9c dest 1:
Archived Log entry 25 added for thread 1 sequence 8146 ID 0x65037b9c dest 3:
Wed Jul 02 12:18:46 2014
RFS[3]: Selected log 11 for thread 1 sequence 8148 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:18:55 2014
Archived Log entry 26 added for thread 1 sequence 8147 ID 0x65037b9c dest 1:
Archived Log entry 27 added for thread 1 sequence 8147 ID 0x65037b9c dest 3:
Wed Jul 02 12:20:53 2014
RFS[3]: Selected log 10 for thread 1 sequence 8149 dbid 1694747807 branch 833318                                  050
Wed Jul 02 12:20:59 2014
Archived Log entry 28 added for thread 1 sequence 8148 ID 0x65037b9c dest 1:
Archived Log entry 29 added for thread 1 sequence 8148 ID 0x65037b9c dest 3:


I cannot make down of OLTP database. eager to get assistance on this..

Regards,
Ashish Kumar Mahanta
Re: logstdby.build is taking time to execute [message #617619 is a reply to message #617609] Wed, 02 July 2014 05:02 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I m not sure what the problem is.
Is it that your logfiles that are undersized, as shown in your alert log? You are log switching every three minutes. So you need to add log file groups that are ten times big, and drop the little ones that you have now. You'll need to resize the standby logs, too.
Or is it that you have a problem with building a logical standby dictionary, as in the topic title?
Re: logstdby.build is taking time to execute [message #617887 is a reply to message #617619] Fri, 04 July 2014 04:22 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

Even after increasing the log file size, situation was same.

We had logged the scenario to MOS. They called it as bug after checking the alert logs and trace files.
We did the same process at noon time but unable to complete logstndby.build script at restricted mode(job_queue_processes=0). But when done at nite time, script got executed with in 5-6 min.

We even don't know the how it happened? What internally happened. We found count=0 from v$transaction.

This is the update, which i would like to share you all.

Regards,
Ashish Kumar Mahanta
Re: logstdby.build is taking time to execute [message #618053 is a reply to message #617887] Mon, 07 July 2014 06:08 Go to previous message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

Due to below message in alert log, we had restarted the server and executed the script(logstndby.build).Unable to complete it during the day time, even in restricted mode.

When we executed it during night time, when users were not presents. It executed with less time.

LOGMINER: Dictionary Build: Waiting for txns in-flight at scn 0x0000.048f4ab9 [76499641] to complete


May be possible cause would be the undo transaction which were recovered and completed then only logstndby.build script executed.

Regards,
Ashish Kumar Mahanta
Previous Topic: RFS LogMiner: Registered logfile to LogMiner session id
Next Topic: Temp objects stops log apply at standby
Goto Forum:
  


Current Time: Thu Mar 28 20:43:17 CDT 2024