OraFAQ Forum: Data Guard » ORACLE Instance esprdgdr

Home » Server Options » Data Guard » ORACLE Instance esprdgdr - Archival Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE Instance esprdgdr - Archival Error [message #250391]

Mon, 09 July 2007 21:59

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

Attachment: alert_esprdgdr.log.tar.Z
(Size: 832.07KB, Downloaded 2094 times)

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250396 is a reply to message #250391]

Mon, 09 July 2007 22:14

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.

Code: [Select all] [Show/ hide]

•	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?

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250401 is a reply to message #250396]

Mon, 09 July 2007 22:27

andrewlee2000
Messages: 7
Registered: July 2007

Junior Member

The output shows valid and no error. I have perform some logswitch before

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250402 is a reply to message #250401]

Mon, 09 July 2007 22:38

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.

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250403 is a reply to message #250391]

Mon, 09 July 2007 22:50

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

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250587 is a reply to message #250403]

Tue, 10 July 2007 10:19

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.

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250784 is a reply to message #250587]

Wed, 11 July 2007 06:00

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;

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250854 is a reply to message #250784]

Wed, 11 July 2007 10:54

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

But is ftp related to DG log transferring process?

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250858 is a reply to message #250854]

Wed, 11 July 2007 11:04

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?

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250860 is a reply to message #250858]

Wed, 11 July 2007 11:21

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
=======

Code: [Select all] [Show/ hide]

-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
=======

Code: [Select all] [Show/ hide]

-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

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #250932 is a reply to message #250860]

Wed, 11 July 2007 21:17

andrewlee2000
Messages: 7
Registered: July 2007

Junior Member

Hi;
Size is the same, i mean the checksum value is different. Is there something wrong?

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #251212 is a reply to message #250932]

Thu, 12 July 2007 13:01

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?

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #251316 is a reply to message #251212]

Thu, 12 July 2007 20:29

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

Report message to a moderator

Re: ORACLE Instance esprdgdr - Archival Error [message #251461 is a reply to message #251316]

Fri, 13 July 2007 12:30

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.

Report message to a moderator

Previous Topic:	How to configure Data Guard in Oracle (8i)
Next Topic:	Data Gurad in NOLOGGING Environment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 09:13:57 CDT 2025