| Monu |
Posted: Apr 09, 2008 11:38:34 PM |
Total Post: 21
Joined: Jan, 2008
|
OS- Red Hat Enterprise Linux AS release 3 (Taroon Update 2)
Oracle info: 9.2.0.1.0
while applying archive logs to standby database manually i am getting the error.
commands which i use to apply archive log are:-
scp to copy archive logs from primary to standby database.
alter database register logfile '/...../';
shutdown immediate
startup nomount
alter database mount standby database;
alter database recover standby database through sequence 7590;
In alert log file we are getting the following error:
ORA-04031: unable to allocate bytes of shared memory ("","","","").
Thu Apr 10 04:03:55 2008
Failed to request gap sequence. Thread #: 1, gap sequence: 7576-7576
All FAL server has been attempted.
i've checked the gap sequence as well but no such gap sequence is there.
select * from v$archive_gap;
no rows selected
I even tried to change the shared pool size but that didn't work either. Help me out plz.
|
|
|
 Murtuja |
| Posted: Apr 10, 2008 12:47:11 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
http://www.idevelopment.info/data/Oracle/DBA_tips/Data_Guard_9i/DG_75.shtml
http://www.orafaq.com/forum/t/52037/0/
HTH
|
|
|
|
|
| Gitesh |
| Posted: Apr 11, 2008 11:45:18 PM | |
|
Total Post: 322
Joined: May, 2005
|
Did you check which last archive sequence applied? If said sequence didn't applied then register same sequence manually and apply.
|
|
|
|
|
| Monu |
| Posted: Apr 12, 2008 12:04:26 AM | |
|
Total Post: 21
Joined: Jan, 2008
|
yes dear, i've that as well.
|
|
|
|
|
| Gitesh |
| Posted: May 16, 2008 05:16:12 AM | |
|
Total Post: 322
Joined: May, 2005
|
Let us know physical memory and paging/swaping size.
|
|
|
|
|
| Monu |
| Posted: May 16, 2008 11:55:56 AM | |
|
Total Post: 21
Joined: Jan, 2008
|
grep MemTotal /proc/meminfo
MemTotal: 4055640 kB
grep SwapTotal /proc/meminfo
SwapTotal: 4194216 kB
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
