Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

archivelog changes not applied on standby

Nitesh NathaniSep 22 2014 — edited Oct 6 2014

Hi, i have Data guard setup on Oracle 11204 on linux platform.

I have an issue of archivelogs not getting applied. Please advise;

Here are the output for the following queries.

SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;

DATABASE_ROLE INSTANCE OPEN_MODE

---------------- ------------------------------ --------------------

PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS

-------------------- -------------------- --------------------

PRIMARY TEST READ WRITE

MAXIMUM AVAILABILITY RESYNCHRONIZATION SESSIONS ACTIVE

SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;

PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

ARCH CLOSING 1 212 350208 258

ARCH CLOSING 1 213 350208 256

ARCH CLOSING 1 214 350208 259

ARCH CLOSING 1 215 221184 291

ARCH CLOSING 1 216 4096 1257

ARCH CLOSING 1 217 1 302

ARCH CLOSING 1 218 6144 609

ARCH CLOSING 1 219 4096 1121

ARCH CLOSING 1 220 1 53

ARCH CLOSING 1 221 1 5

ARCH CONNECTED 0 0 0 0

PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS

--------- ------------ ---------- ---------- ---------- ----------

ARCH CLOSING 1 222 1 4

RFS IDLE 0 0 0 0

RFS IDLE 1 223 7496 1

SQL> SELECT max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)

--------------

174

SQL> select SEQUENCE#,applied,DEST_ID,STANDBY_DEST,THREAD# from v$archived_log where SEQUENCE# >175;

SEQUENCE# APPLIED DEST_ID STA THREAD#

---------- --------- ---------- --- ----------

176 YES 1 NO 1

177 YES 1 NO 1

178 YES 1 NO 1

179 YES 1 NO 1

180 YES 1 NO 1

181 YES 1 NO 1

182 YES 1 NO 1

183 YES 1 NO 1

184 YES 1 NO 1

185 YES 1 NO 1

186 YES 1 NO 1

SEQUENCE# APPLIED DEST_ID STA THREAD#

---------- --------- ---------- --- ----------

187 YES 1 NO 1

188 YES 1 NO 1

189 YES 1 NO 1

190 YES 1 NO 1

191 YES 1 NO 1

192 YES 1 NO 1

193 YES 1 NO 1

194 YES 1 NO 1

195 YES 1 NO 1

196 YES 1 NO 1

197 YES 1 NO 1

SEQUENCE# APPLIED DEST_ID STA THREAD#

---------- --------- ---------- --- ----------

198 YES 1 NO 1

199 YES 1 NO 1

200 YES 1 NO 1

201 YES 1 NO 1

202 YES 1 NO 1

203 YES 1 NO 1

204 YES 1 NO 1

205 YES 1 NO 1

206 YES 1 NO 1

207 YES 1 NO 1

208 YES 1 NO 1

SEQUENCE# APPLIED DEST_ID STA THREAD#

---------- --------- ---------- --- ----------

209 YES 1 NO 1

210 YES 1 NO 1

211 YES 1 NO 1

212 YES 1 NO 1

213 YES 1 NO 1

214 YES 1 NO 1

215 YES 1 NO 1

216 YES 1 NO 1

217 YES 1 NO 1

218 YES 1 NO 1

219 YES 1 NO 1

SEQUENCE# APPLIED DEST_ID STA THREAD#

---------- --------- ---------- --- ----------

220 YES 1 NO 1

221 YES 1 NO 1

222 YES 1 NO 1

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2014

Added on Sep 22 2014

#data-guard, #performance-availability

34 comments

11,761 views