All entries for Friday 25 February 2011
February 25, 2011
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.