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
|
|
|
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.
• 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 #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.
|
|
|
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;
|
|
|
|
|
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
=======
-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 #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
|
|
|
|