Home » Server Options » Data Guard » ORACLE Instance esprdgdr - Archival Error
ORACLE Instance esprdgdr - Archival Error [message #250391] Mon, 09 July 2007 21:59 Go to next message
andrewlee2000
Messages: 7
Registered: July 2007
Junior Member
I have a primary database esprdgpr and standby database esprdgdr.
When i issue a switch logfile at esprdgpr, i can see logfiles being generated and applied at esprdgdr. At esprdgdr i'm using real time apply. I can even perform a switchover from esprdgpr to esprdgdr.

Problem arises when i esprdgdr becomes primary. Whenever i perform switch logfile, the logfiles are not generated at esprdgpr and the following error occurred "ORACLE Instance esprdgdr - Archival Error".
Here is my config for both sites;
ESPRDGDR:
standby_archive_dest =/archlog/data
log_archive_dest_state_2=enable
log_archive_dest_2 ='service=esprdgpr valid_for=(online_logfile,primary_role) db_unique_name=esprdgpr lgwr sync affirm mandatory reopen=300'
log_archive_dest_1=LOCATION=/archlog/data
log_archive_config=dg_config=(esprdgdr,esprdgpr)

ESPRDGPR:
standby_archive_dest =/archlog/data
log_archive_dest_state_2=enable
log_archive_dest_2 ='service=esprdgdr valid_for=(online_logfile,primary_role) db_unique_name=esprdgdr lgwr sync affirm mandatory reopen=300'
log_archive_dest_1=LOCATION=/archlog/data
log_archive_config=dg_config=(esprdgdr,esprdgpr)

I believer there is some network issue, but i cannot prove it. Any ideas would be appreciated. FYI, i can tnsping esprdgpr and esprdgdr from both sides.

thanks
Re: ORACLE Instance esprdgdr - Archival Error [message #250396 is a reply to message #250391] Mon, 09 July 2007 22:14 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
POST THE OUTPUT OF THIS QUERRY?And unable to open the file post last 100 lines here.
•	SQL> Select Status, Error 
from v$Archive_dest 
where dest_id=2;


Quote:


I believer there is some network issue, but i cannot prove it. Any ideas would be appreciated. FYI, i can tnsping esprdgpr and esprdgdr from both sides.


did you manually switch any log before?
Re: ORACLE Instance esprdgdr - Archival Error [message #250401 is a reply to message #250396] Mon, 09 July 2007 22:27 Go to previous messageGo to next message
andrewlee2000
Messages: 7
Registered: July 2007
Junior Member
The output shows valid and no error. I have perform some logswitch before
Re: ORACLE Instance esprdgdr - Archival Error [message #250402 is a reply to message #250401] Mon, 09 July 2007 22:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
It could be network problem then.
Remove the mandatory clause from archival destination,because every 300 sec it would write error log.
Re: ORACLE Instance esprdgdr - Archival Error [message #250403 is a reply to message #250391] Mon, 09 July 2007 22:50 Go to previous messageGo to next message
andrewlee2000
Messages: 7
Registered: July 2007
Junior Member
Remove already, but how can i show it's network related issue. Is there any tool that i can check the network? Just to double confirm that DG uses ONLY port 1521 as specified in tnsnames.ora rite?

thanks
Re: ORACLE Instance esprdgdr - Archival Error [message #250587 is a reply to message #250403] Tue, 10 July 2007 10:19 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
but how can i show it's network related issue. Is there any tool that i can check the network?


Try SCP or FTP to confirm..

Quote:
Just to double confirm that DG uses ONLY port 1521 as specified in tnsnames.ora rite?


Its not a deal if it would then it would throw the Listener doesnot know the connect descriptor or something like that but your configuration doesnt throws that error.
Re: ORACLE Instance esprdgdr - Archival Error [message #250784 is a reply to message #250587] Wed, 11 July 2007 06:00 Go to previous messageGo to next message
andrewlee2000
Messages: 7
Registered: July 2007
Junior Member
Hi, we are only using port 1521, all connect descriptor is connect as i can sqlplus to all sites. However there is one fully thing, if i do a ftp from primary to dr site, i put a hash into the ftp, i can see that i hangs. But if i use sftp it goes thru.

But is ftp related to DG log transferring process?

regards;
Re: ORACLE Instance esprdgdr - Archival Error [message #250854 is a reply to message #250784] Wed, 11 July 2007 10:54 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
But is ftp related to DG log transferring process?



No
Re: ORACLE Instance esprdgdr - Archival Error [message #250858 is a reply to message #250854] Wed, 11 July 2007 11:04 Go to previous messageGo to next message
andrewlee2000
Messages: 7
Registered: July 2007
Junior Member
After some investigation, I found out that the checksum on the archivelog transfer from primary to dataguard is not the same. Is this normal, or is there some network related issue?
Re: ORACLE Instance esprdgdr - Archival Error [message #250860 is a reply to message #250858] Wed, 11 July 2007 11:21 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Its not normal Size should be same on both primary and standby.
heres output from mine dataguard archivelogs

STANDBY
=======

-rw-r-----   1 oracle   dba          29M Jul 11 05:58 arch_1_1723_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 06:51 arch_1_1724_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 07:45 arch_1_1725_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 08:43 arch_1_1726_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 09:40 arch_1_1727_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 10:34 arch_1_1728_622573174.arc
-rw-r-----   1 oracle   dba         2.0M Jul 11 10:38 arch_1_1729_622573174.arc
-rw-r-----   1 oracle   dba         5.5M Jul 11 10:47 arch_1_1730_622573174.arc
-rw-r-----   1 oracle   dba          31K Jul 11 10:47 arch_1_1731_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 11:28 arch_1_1732_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 11:59 arch_1_1733_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 12:26 arch_1_1734_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 12:51 arch_1_1735_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 13:14 arch_1_1736_622573174.arc


PRIMARY
=======
-rw-r-----   1 oracle   dba          29M Jul 11 05:51 arch_1_1723_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 06:43 arch_1_1724_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 07:37 arch_1_1725_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 08:35 arch_1_1726_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 09:33 arch_1_1727_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 10:26 arch_1_1728_622573174.arc
-rw-r-----   1 oracle   dba         2.0M Jul 11 10:30 arch_1_1729_622573174.arc
-rw-r-----   1 oracle   dba         5.5M Jul 11 10:39 arch_1_1730_622573174.arc
-rw-r-----   1 oracle   dba          31K Jul 11 10:39 arch_1_1731_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 11:20 arch_1_1732_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 11:51 arch_1_1733_622573174.arc
-rw-r-----   1 oracle   dba          29M Jul 11 12:18 arch_1_1734_622573174.arc
Re: ORACLE Instance esprdgdr - Archival Error [message #250932 is a reply to message #250860] Wed, 11 July 2007 21:17 Go to previous messageGo to next message
andrewlee2000
Messages: 7
Registered: July 2007
Junior Member
Hi;
Size is the same, i mean the checksum value is different. Is there something wrong?
Re: ORACLE Instance esprdgdr - Archival Error [message #251212 is a reply to message #250932] Thu, 12 July 2007 13:01 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
andrewlee2000 wrote on Wed, 11 July 2007 20:17
Hi;
Size is the same, i mean the checksum value is different. Is there something wrong?

No its ok then.
What do you mean by checksum values?
Re: ORACLE Instance esprdgdr - Archival Error [message #251316 is a reply to message #251212] Thu, 12 July 2007 20:29 Go to previous messageGo to next message
andrewlee2000
Messages: 7
Registered: July 2007
Junior Member
For example when i do a $cksum 1_172_627430911.dbf on node 1, i will have the following result;
bash-3.00$ cksum /archlog/data/1_172_627430911.dbf
4266787365 1024 /archlog/data/1_172_627430911.dbf

When i do the same at node 2, i will have the following result;
bash-3.00$ cksum /archlog/data/1_172_627430911.dbf
1145965913 1024 /archlog/data/1_172_627430911.dbf

As you can see here the cksum value is not the same. This is not correct right?

regards
Re: ORACLE Instance esprdgdr - Archival Error [message #251461 is a reply to message #251316] Fri, 13 July 2007 12:30 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
As you can see here the cksum value is not the same. This is not correct right?


Yes there could be a problem.
Previous Topic: How to configure Data Guard in Oracle (8i)
Next Topic: Data Gurad in NOLOGGING Environment
Goto Forum:
  


Current Time: Fri Mar 29 08:43:20 CDT 2024