All entries for Friday 25 February 2011

Two unexpected thing happened when creating logical standby

1. When run the command
alter database recover to logical standby pewsos

It just hung there and the log reported “Media Recovery Waiting for thread 1 sequence xxx”

alter system set log_archive_dest_2=’service=pewsos LGWR ASYNC valid_for=(online_logfiles,primary_role) db_unique_name=pewsos’;

I have to manual copy the log file over and completed the command.

It hung again. I get rid of ” LGWR ASYNC” and work properly

2. It failed to restart , reporting:
ORA-16181: SGA specified for Logical Standby is too large Cause: MAX_SGA is larger than the larger of initialization parameters

It turned out to be the “MAX_SGA” parameter in logical standby settings is too big.

Hongfeng Sun : 25 Feb 2011 16:42 |  Tags: Oracle-Availability |  Comments (0) |  Close comments |  Report a problem