I have a primary server and backup server located in different physical
sites.
The primary server is live and ship logs to backup site every 5
minutes.
The primary server is being full online backed up every sunday locally.
Those logs are being applied to backup server every five minutes.
For example,
Primary site has power outage on tuesday, the last log was shipped was
S0001000.LOG. Backup server was brought to live, the first active log
was S0001001.LOG when started. Same time, the log was shipped back to
primary site. The backup site runs until sunday, the log till
S0002001.LOG was shipped to primary site.
Sunday, I need to stop the backup server and switch the primary server
up.
I think I can use the backup image on primary site of last sunday, and
apply all the log (from S0001001.LOG to S0002001.LOG)in clude those
generated by backup site, then bring it up.
Somebody has the similar experience?
5  2417 
I have a primary server and backup server located in different physical
sites, all running DB2 V8.1.5 on windows.
The primary server is live and ship logs to backup site every 5
minutes.
The primary server is being full online backed up every sunday locally.
Those logs are being applied to backup server every five minutes.
For example,
Primary site has power outage on tuesday, the last log was shipped was
S0001000.LOG. Backup server was brought to live, the first active log
was S0001001.LOG when started. Same time, the log was shipped back to
primary site. The backup site runs until sunday, the log till
S0002001.LOG was shipped to primary site.
Sunday, I need to stop the backup server and switch the primary server
up.
I think I can use the backup image on primary site of last sunday, and
apply all the log (from S0001001.LOG to S0002001.LOG)in clude those
generated by backup site, then bring it up.
Somebody has the similar experience?
I have a primary server and backup server located in different physical
sites, all running DB2 V8.1.5 on windows.
The primary server is live and ship logs to backup site every 5
minutes.
The primary server is being full online backed up every sunday locally.
Those logs are being applied to backup server every five minutes.
For example,
Primary site has power outage on tuesday, the last log was shipped was
S0001000.LOG. Backup server was brought to live, the first active log
was S0001001.LOG when started. Same time, the log was shipped back to
primary site. The backup site runs until sunday, the log till
S0002001.LOG was shipped to primary site.
Sunday, I need to stop the backup server and switch the primary server
up.
I think I can use the backup image on primary site of last sunday, and
apply all the log since then, there will be 2 parts
(from S0000800.LOG to S0001000.LOG on the primary site)
(from S0001001.LOG to S0002001.LOG on the backup site)
then bring it up.
Somebody has the similar experience?
Your proposed solution should NOT work. You ship logs every 5 minutes
which could accumulate up to five minutes of updates on the primary
server that are not shipped before it initially fails. Restoring logs
from the backup server, after it picked up the workload, could cause
difficulties.
The quickest way to move back to the primary server may be to stop
activity on the backup server, make an offline backup and restore it to
the primary server. You should use the quickest procedure; making a
backup and restoring or using yesterday's backup and logs. Yesterday's
backup with logs shipped to the backup (through S0001000) and logs
S0001001 through S0002001 should bring the primary server to the same
state as the backup server.
Phil Sherman sh*******@gmail .com wrote: I have a primary server and backup server located in different physical
sites.
The primary server is live and ship logs to backup site every 5
minutes.
The primary server is being full online backed up every sunday locally.
Those logs are being applied to backup server every five minutes.
For example,
Primary site has power outage on tuesday, the last log was shipped was
S0001000.LOG. Backup server was brought to live, the first active log
was S0001001.LOG when started. Same time, the log was shipped back to
primary site. The backup site runs until sunday, the log till
S0002001.LOG was shipped to primary site.
Sunday, I need to stop the backup server and switch the primary server
up.
I think I can use the backup image on primary site of last sunday, and
apply all the log (from S0001001.LOG to S0002001.LOG)in clude those
generated by backup site, then bring it up.
Somebody has the similar experience?
For the backup site is remote, it takes long time to bring the ***GB
backup image to primary site.
So I am wondering if I can use the image has been taken on primary site
of sunday, and apply the logs from both site. From primary site, I use
log flie since last backup till S0001000.LOG, but ignore all the rest
(for it crash), plus those generated on seconday site (from
S0001001.LOG to end)
I think there could be some loss because of some log was not shipped to
backup site (after S0001000.LOG), but it is acceptable here. I dont the
structure of logs, and hope they are consistent.
You may still run into a problem. When you terminated forward recovery
on the backup system at log S00001000, you would have lost any logged
updates that were not committed. (The commits would have been done
during the last <5 min of operation before the primary server crashed.)
When you try to restore on the primary server; you will have a
discontinuity in the logs where you start the new log from the backup
server.
I'd backup the database on the backup server immediately after
terminating rollforward and ship that backup to the primary server
immediately. It will be available to restore on the primary server and
you can start rollforward recovery on the primary server until you make
a clean shutdown on the backup server and ship the last log tape back to
the primary server. This way, the outage to return to the primary server
would be transmit and process of a single 5 min log.
Phil Sherman sh*******@gmail .com wrote: For the backup site is remote, it takes long time to bring the ***GB
backup image to primary site.
So I am wondering if I can use the image has been taken on primary site
of sunday, and apply the logs from both site. From primary site, I use
log flie since last backup till S0001000.LOG, but ignore all the rest
(for it crash), plus those generated on seconday site (from
S0001001.LOG to end)
I think there could be some loss because of some log was not shipped to
backup site (after S0001000.LOG), but it is acceptable here. I dont the
structure of logs, and hope they are consistent. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ^CrAsH^ |
last post by:
Hi to all,
i've a "problem" with log shipping in sql server 2000 sp3.
My log shipping works fine, but the task does not update
log_shipping_primaries table on secondary server, and so log shipping
monitor report always out of sync backup, even if all works fine.
I've set log shipping using a sql server user created on both servers with
same password and sysadmin rights, and sql server agent run as a local admin
user created identically...
|
by: Tim Groulx |
last post by:
Hello,
I am setting up log shipping between two SQL servers. Everything in the
setup seems to work fine. The problem I am having is that the "Log
Shipping Alert Job - Backup" job is failing, event though the tlog
backup copy & restore process is working fine. When I look at the
histories of both the backup and copy/restore jobs, they are successful
all the way through, I can make changes to the primary db, and see them
get shipped to...
|
by: smyers1972 |
last post by:
I am attempting to set up log shipping from my primary dell clustered 2
node sql server to a backup quad xeon server in case of a failure. When I
follow the information given from Microsoft regarding this and I get to
the point where I am at "Add Destination Database" I am being prompted
for my server name, which shows the primary one ONLY. I dont seem to find
any documentation on where I add in the secondary server name...
Searching...
|
by: InProcess |
last post by:
We have successfully implemented Log Shipping between two MS SQL Server
2000 servers (bothe SP3). The problem we are having is two fold:
1) The tran log on the primary server is not being truncated even
though the tran logs are being shipped and applied to the standby
database on the backup server.
2) The log shipping monitor, when drilling down into the "View
Copy/Restore History" reporting selection, is showing a copy failure for...
|
by: nek |
last post by:
Greetings,
I tried to implement log shipping using PULL method as described in
'The Basics of DB2 Log Shipping' by Dale McInnis, but found the
subsequent "rollforward" did not go beyond the first log.
Here is what I did:
2 machines: Primary and standby servers both W2K SP4 running DB2 8.2.
Both have logretain (YES) and USEREXIT (ON) set.
| | |
by: theSpinel |
last post by:
Is it possible to failover a single or a selected number of databases
onto a standby server? We're currently log shipping about 12 databases
to a standby and I was wondering if it was possible to randomly
failover onto selected dbs.
My understanding of log shipping is that when the primary server goes
down, the standby takes over. But, does that mean that all of the db's
on the standby server now become the primary? Or, can failover...
|
by: Julie Graham |
last post by:
I'm having issues setting up log shipping on a remote server. We have a very large production database that needs to be migrated offsite. The db is 9 GB backed up. It takes about 4 hours to copy the file to the remote server when it is archived. During the log shipping process the file takes a lot more time than that to arrive at the remote server. I decided to use log shipping for this migration, because we can't have our production box...
|
by: Axlin |
last post by:
Hi.
Could someone tell me what did i miss out in my steps when i configured our production database to our development database?
I tried on 2 separate servers and also between 2 separate instances on our development server, but it didn't work.No error after configuring Log shipping though.
Between the 2 servers - the transaction logs was backup every 1min on the pri server but log files just didnt transfer to secondary database.
...
|
by: Jason Huang |
last post by:
Hi,
I've established the log shipping between my Primary database server and the
Stand by database server.
In the Stand by server, the database is gray, and in the BACKUP folder,
there're MyDB_init.bak and many .TRN files.
1.How do I make the MyDB's color not gray in that Stand by server? I wanna
test the SELECT and see if the record between the Primary and Stand by
server are consistant.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
