cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DRS archive log

Go to solution
Former Member

on ‎08-18-2009 3:53 AM

0 Kudos

Hi,

I have currently set two places to store my offline archive log. The configuration in oracle as below:

LOG_ARCHIVE_DEST_1 LOCATION=U:\oracle\SID\oraarch\SIDarch

LOG_ARCHIVE_DEST_2 SERVICE=SID_DR

LOG_ARCHIVE_DEST_2 is pointing to our DRS server connected thru network.

My questions:

1- If there is a problem/failure on the network, what will happen for LOG_ARCHIVE_DEST_2? Will my primary database hangs due to this kind of configuration?

2- What will happen if destination 2, the filesystem is full? Will I get the archive stuck problem?

3- Is there any other setback configuring this way?

Thanks in advance

Best Regards.

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎08-18-2009 6:11 AM
0 Kudos

Hello Eida,

1> Set the parameter log_archive_min_succeed=1, meaning one of the destinations should be successful. You can also make the first destination mandatory.

LOG_ARCHIVE_DEST_1="LOCATION=U:\oracle\SID\oraarch\SIDarch mandatory"

2> Making the first destination mandatory i think should ensure that there is no archive struck situation if the second destination failes. Also you can use the following option in second destination so that it can retry every 5 mins after a failure.

LOG_ARCHIVE_DEST_2="SERVICE=SID_DR reopen=300"

Regards

Anil Verma B

Show replies
Show replies
Former Member
‎08-24-2009 2:47 PM
0 Kudos

Hi,

Looking at the wait event, here is the statistics:

Type Client Sessions Busy wait Total wait Busy wait

time (ms) time (ms) time (%)

USER User 77 736,919,660 13,038,584,670 5.65

BACK ARC0 1 57,057,620 354,642,500 16.09

BACK ARC1 1 7,936,520 363,972,440 2.18

The busy wait time for the archive is at 16%. Is this becuase of the current setup on the log_archive_destination?

Answers (1)

Answers (1)

Former Member
‎08-18-2009 9:41 AM
0 Kudos

Hi,

No problem, you can do this configuration. If you want to more security, you have to monitor all properly.

If any one happenes like full disk or network failure then This backup will not performed. thats it.

You will get warning, check those warnings and resolve. Nothing will stuck in this case when second network backup not happened.

Regards,

Gokul Chandola

Show replies
Show replies
Former Member
‎08-18-2009 9:45 AM
0 Kudos

Hi,

Thanks for the feedback.

The reason why I'm asking this because we had an incident, twice after activating those parameter.

There is a lot of WP hangs. I was wondering, if this could be the reason.

Also, at the moment the line between primary and standby database is 2MB lease line. I wonder if this enough.

Former Member
‎08-21-2009 7:10 AM
0 Kudos

I'm getting this kind of error in my oracle trace file. Also, all the WP are hanging and nothing is being process. What is the cause of this? Is this something to LOG_ARCHIVE_DEST_2?

Line: -

Dump file r:\oracle\epf\saptrace\background\epf_arc0_5660.trc

Sun Aug 09 07:18:28 2009

ORACLE V9.2.0.8.0 - Production vsnsta=0

vsnsql=12 vsnxtr=3

Windows 2000 Version 5.2 Service Pack 2, CPU type 586

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.8.0 - Production

Windows 2000 Version 5.2 Service Pack 2, CPU type 586

Instance name: epf

Redo thread mounted by this instance: 0 <none>

Oracle process number: 8

Windows thread id: 5660, image: ORACLE.EXE

      • SESSION ID:(7.1) 2009-08-09 07:18:28.140

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

.

.

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

.

Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode

      • 2009-08-09 08:00:00.021

RFS network connection lost at host 'EPF_DR'

Error 3114 writing standby archive log file at host 'EPF_DR'

      • 2009-08-09 08:00:00.021 51426 kcrr.c

ARC0: I/O error 3114 archiving log 2 to 'EPF_DR'

      • 2009-08-09 08:00:00.037

kcrrfail: dest:2 err:3114 force:0

Local destination LOG_ARCHIVE_DEST_1 is still active

ORA-03114: not connected to ORACLE

      • 2009-08-09 08:05:12.347

Error 12537 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'EPF_DR'

Error 12537 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'EPF_DR'

      • 2009-08-09 08:05:12.347 51426 kcrr.c

ARC0: Error 12537 Creating archive log file to 'EPF_DR'

      • 2009-08-09 08:05:12.347

kcrrfail: dest:2 err:12537 force:0

ORA-12537: TNS:connection closed

Error 16058 attaching RFS server to standby instance at host 'EPF_DR'

Error 16058 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'EPF_DR'

      • 2009-08-09 08:26:40.411 51426 kcrr.c

ARC0: Error 16058 Creating archive log file to 'EPF_DR'

      • 2009-08-09 08:26:40.411

kcrrfail: dest:2 err:16058 force:0

ORA-16058: standby database instance is not mounted

Standby database restarted; old mount ID 0xe69bf2de now 0xe6e833df

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode

Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode

Edited by: Eida Hanafiah on Aug 21, 2009 8:12 AM

Edited by: Eida Hanafiah on Aug 21, 2009 8:14 AM

Ask a Question