Sunday, May 20, 2012

11gR1 Data Guard: Logs apply on standby is stoped due to currept or incomplete log

Check the logs apply status
Login to standby database (Open read only if not already opened)

SQL> select max(al.sequence#) "Last Seq Recieved", max(lh.sequence#) "Last Seq Applied" from v$archived_log al, v$log_history lh;


Last Seq RecievedLast Seq Applied
64246400

Check the alert_<SID>.log and note that the apply process is stuck while trying to apply log seq. 6441.

Copy log seq. 6441 from primary database to standby and manually try to register the log.

SQL> alter database register physical logfile '<fullpath/filename>';

OR

SQL> alter database register or replace physical logfile '<fullpath/filename>';

If this does not resolve the issue then do the following:

SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount standby database;
SQL> alter database recover automatic standby database;

Check the alert_<SID>.log and note that the logs apply has been started.
Wait for the recovery to finish and then cancel.

SQL> shutdown immediate
SQL> startup
SQL> alter database recover managed standby database using current logfile disconnect from session;

3 comments:

Unknown said...

canada goose canadian goose canada goose jacket canada goose sale canada goose outlet canada goose jackets Canada Goose Bib Canada Goose Parka Canada Goose Pant Canada Goose Snow Bunting Canada Goose Burnett Jacket Canada Goose Hybridge Hoody Canada Goose Langford Parka Canada Goose Ontario Parka Canada Goose Summit Jacket Canada Goose Tundra Down Cargo Pant Canada Goose Camrose Parka Canada Goose Freestyle Vest Canada Goose Livigno Parka Canada Goose Solaris Parka

Unknown said...

oakley asian fit oakley pit boss oakley ek signature Ray Ban 2140 Ray Ban 4171 Ray Ban 8304 Ray Ban Clubmaster Ray Ban Aviator Ray Ban Metal Cheap Ray Bans Cheap Ray-Ban Where Can i Buy Ray Ban Sunglasses Cheap www.ray-bansunglassesstoresale.com Ray Ban Sunglasses Ray Bans Sunglasses Ray Ban Sale Ray Ban Eyewear Where To Get Ray Bans

Anonymous said...

louis vuitton outlet, nike air max, polo ralph lauren outlet, ray ban sunglasses, louis vuitton outlet, cheap oakley sunglasses, prada handbags, ugg boots, louis vuitton, chanel handbags, air max, oakley sunglasses, tiffany jewelry, air jordan pas cher, uggs on sale, oakley sunglasses, louis vuitton, jordan shoes, tory burch outlet, sac longchamp, kate spade outlet, louboutin shoes, louboutin pas cher, burberry, longchamp outlet, replica watches, louis vuitton, ray ban sunglasses, nike outlet, michael kors, ray ban sunglasses, nike free, longchamp pas cher, nike roshe run, oakley sunglasses, louboutin outlet, nike air max, longchamp, tiffany and co, christian louboutin outlet, nike free, louboutin, prada outlet, ugg boots, gucci outlet, oakley sunglasses, replica watches, ralph lauren pas cher, polo ralph lauren outlet, longchamp outlet