Home » Server Options » Data Guard » Standby Configuration
Standby Configuration [message #233647] Fri, 27 April 2007 01:43 Go to next message
raj_t_menon
Messages: 8
Registered: November 2006
Location: Ahmedabad
Junior Member
Hi all,

We are planning to develop a Standby Database (In Maximum Performance - Managed recovery Mode)- But due to low speed of network we must copy the archive to standby archive location and then it should be recover from there.Is that possible for me in Managed Recovery Mode? because as per managed recovery concepts i think we need to configure log_archive_dest_2 parameter and when ever log switch occures...primary ll try to send archive to tht destination too..if it MANDATORY ..and if its OPTIONAL we dont need that..i think.But what will happen if we copy the archives to that location? will it recover automatically?..i am a little bit doubtful on this requirement, i think i have to configure it in Manual mode and do the roll forward manually-
So can any body please share information regarding this issue.

Thanks and Regards,
Raj
Re: Standby Configuration [message #233799 is a reply to message #233647] Fri, 27 April 2007 09:00 Go to previous messageGo to next message
raj_t_menon
Messages: 8
Registered: November 2006
Location: Ahmedabad
Junior Member
Guyz,
Here iam explaining my requirement-

We need to to configure a Standby( Physical-MAXIMUM PERFORMANCE
mode) in a place, which is 600 KM away from our primary destination.
Currently our LAN network traffic rate is 100 Mbps. but this traffic is
virtually reduced to 1Mbps out side our LAN.
Our Production Database is 24X7 and Its generating 17 GB Archive files every
day.
Since the net work traffic is slow i think, it will create some log gaps,and
also we couldn't do a point in time recovery.
We are configuring a Standby, here inside our LAN in Managed Recovery Mode
for recovery purpose and will keep a Standby there in remote place for
Reports.
and it will be recover it in every morning.If iam following this procedure,
my
log_archive_dest_2 ='service=stby ARCH NOAFFIRM' ( which is the standby here
inside our LAN and should be in MANAGED RECOVERY mode)
and i need to configure the parameters for standby in my remote location.So
my doubt is-
Shall i need to configure "log_archive_dest_n" in the parameterlist of my
Primary for that remote Standby ?
I think for manual recovery we can aviod that.But we need to eonnect it
thrrough Oracle Net
Can you please tell me the essential PRIMARY parameter list entries for this
kind of remote standby , recovering in a manual mode ?
i think the following parameter should be there -

FAL_SERVER
FAL_CLIENT
DB_FILE_NAME_CONVERT
LOG_FILE_NAME_CONVERT
STANDBY_FILE_MANAGEMENT=AUTO
STANDBY_ARCHIVE_DEST

Thanks and Regards,
Raj
Re: Standby Configuration [message #234963 is a reply to message #233799] Thu, 03 May 2007 09:58 Go to previous message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
That's perfect and you have to also add up tnsentries on both the sides for both mahcines for proper FAILBACK situation.

Previous Topic: Failed to request gap sequence. Thread #: 1
Next Topic: urgent:dataguard unable to apply logs
Goto Forum:
  


Current Time: Thu Mar 28 08:22:03 CDT 2024