Ygthkb

How to politely refuse in-office gym instructor for steroids and protein

How to write cases in LaTeX?

How do you get out of your own psychology to write characters?

What does an unprocessed RAW file look like?

Why did Luke use his left hand to shoot?

Why is it that Bernie Sanders is always called a "socialist"?

Icon at Subject-line scrlttr2

Writing dialogues for characters whose first language is not English

Possible issue with my W4 and tax return

Reading Mishnayos without understanding

Why does 0.-5 evaluate to -5?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

Website seeing my Facebook data?

Sitecore 9.1 Installation - Skip to particular step

Why is Shelob considered evil?

Minimum Viable Product for RTS game?

Renting a 2CV in France

What species should be used for storage of human minds?

Is it possible to detect 100% of SQLi with a simple regex?

Equivalent of "illegal" for violating civil law

Boss asked me to sign a resignation paper without a date on it along with my new contract

Does it take energy to move something in a circle?

Other than edits for international editions, did Harry Potter and the Philosopher's Stone receive errata?

What does からか mean?

DB2 Transaction Logs - can they be COPY-PASTE on another Disaster Recovery Server?

Postgres synchronized backup - what's with the archive?IBM DB2 9.7, possible to temporarily disable transaction logs?Disaster Recovery Options for Sql ServerDB2 ARCHIVE mode - Can all archive logs be deleted after doing the FULL OFFLINE backup?DB2 - Why new multiple C000000x subfolders are created in Archive Log folder?MS SQL Server 2008 Transaction log file back up failureHow to know what are the necessary log files for a backup in DB2?Backing up & restoring 10-20 SQL Server databases to a ~synchronous state?Transaction log uses (not backups of transaction logs)Need help with SQL Server 2014 and disaster recovery

0

We have Server1 with Online Backup1, Archive Logs 1,2,3 for example and Transaction Logs from 1 to 10.
We are interested in next scenario:
If Server1 fails completely and we want to move everything on second server I suppose it is not the problem to move and restore Backup1 and Archive logs 1,2,3 on Server2.
But can Transaction Logs (their snapshot in some specific time) be also copied to the Server2? Because Transaction Logs are probably the most problematic part for this Disaster Recovery Scenario. Can there be some problem with the fact that transaction logs are written and populated all the time?

ADDITION: DISK option is used when configuring Archive Mode

db2 transaction-log logs snapshot disaster-recovery

share|improve this question

edited Feb 23 '15 at 14:57

Dejan

asked Feb 23 '15 at 7:50

DejanDejan

30731126

bumped to the homepage by Community♦ 2 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

We have Server1 with Online Backup1, Archive Logs 1,2,3 for example and Transaction Logs from 1 to 10.
We are interested in next scenario:
If Server1 fails completely and we want to move everything on second server I suppose it is not the problem to move and restore Backup1 and Archive logs 1,2,3 on Server2.
But can Transaction Logs (their snapshot in some specific time) be also copied to the Server2? Because Transaction Logs are probably the most problematic part for this Disaster Recovery Scenario. Can there be some problem with the fact that transaction logs are written and populated all the time?

ADDITION: DISK option is used when configuring Archive Mode

db2 transaction-log logs snapshot disaster-recovery

share|improve this question

edited Feb 23 '15 at 14:57

Dejan

asked Feb 23 '15 at 7:50

DejanDejan

30731126

bumped to the homepage by Community♦ 2 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

We have Server1 with Online Backup1, Archive Logs 1,2,3 for example and Transaction Logs from 1 to 10.
We are interested in next scenario:
If Server1 fails completely and we want to move everything on second server I suppose it is not the problem to move and restore Backup1 and Archive logs 1,2,3 on Server2.
But can Transaction Logs (their snapshot in some specific time) be also copied to the Server2? Because Transaction Logs are probably the most problematic part for this Disaster Recovery Scenario. Can there be some problem with the fact that transaction logs are written and populated all the time?

ADDITION: DISK option is used when configuring Archive Mode

db2 transaction-log logs snapshot disaster-recovery

share|improve this question

edited Feb 23 '15 at 14:57

Dejan

asked Feb 23 '15 at 7:50

DejanDejan

30731126

share|improve this question

edited Feb 23 '15 at 14:57

Dejan

asked Feb 23 '15 at 7:50

DejanDejan

30731126

share|improve this question

edited Feb 23 '15 at 14:57

Dejan

asked Feb 23 '15 at 7:50

DejanDejan

30731126

asked Feb 23 '15 at 7:50

DejanDejan

30731126

asked Feb 23 '15 at 7:50

DejanDejan

30731126

1 Answer
1

active

oldest

votes

0

Perhaps you wish to look into HADR on DB2. It actually does log shipping to the standby, so if there is a fail over you can either manually take over on the standby, or if you install TSA (Tivoli Systems Automation), then you can have it detect a failure and automatically fail over to the standby.

share|improve this answer

answered Feb 23 '15 at 14:06

Chris AldrichChris Aldrich

3,94042451

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Chris, no we are interested when Archive Mode is set with DISK option (unfortunately must be DISK because that is the requirement from the Customer). Please tell me if this is something which is possible or not? I am also confused little with the question from the customer but that is what they are asking us (I am aware that transaction logs are "active", database is populating them actively ) but please tell me if this is feasible or not? So we would copy ALL (online backup+archive logs+transaction logs) on another Disaster Recovery Server
  
  – Dejan
  Feb 23 '15 at 14:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Chris please tell us if this is feasible without HADR feature and TSA (I am familiar with that we implemented it for other customer but this customer does not want this option)
  
  – Dejan
  Feb 23 '15 at 14:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I know of TSA, but have not implemented HADR with it. Read up on Ember Crooks blog (db2commerce.com) for information on that.
  
  – Chris Aldrich
  Feb 23 '15 at 16:56
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you dont' want HADR, then yes, you could copy logs. Or even use the alternate/mirror log/archive parameters to get DB2 to copy the logs (possibly to a shared mount).
  
  – Chris Aldrich
  Feb 23 '15 at 16:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Chris, OK so you think this is OK. I am just concerned if database will know in which of those copied transaction logs it should write data into for the next transactions.
  
  – Dejan
  Feb 24 '15 at 7:21
  

  
  
  
  

 | 
show 1 more comment

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f93536%2fdb2-transaction-logs-can-they-be-copy-paste-on-another-disaster-recovery-serve%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Perhaps you wish to look into HADR on DB2. It actually does log shipping to the standby, so if there is a fail over you can either manually take over on the standby, or if you install TSA (Tivoli Systems Automation), then you can have it detect a failure and automatically fail over to the standby.

share|improve this answer

answered Feb 23 '15 at 14:06

Chris AldrichChris Aldrich

3,94042451

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Chris, no we are interested when Archive Mode is set with DISK option (unfortunately must be DISK because that is the requirement from the Customer). Please tell me if this is something which is possible or not? I am also confused little with the question from the customer but that is what they are asking us (I am aware that transaction logs are "active", database is populating them actively ) but please tell me if this is feasible or not? So we would copy ALL (online backup+archive logs+transaction logs) on another Disaster Recovery Server
  
  – Dejan
  Feb 23 '15 at 14:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Chris please tell us if this is feasible without HADR feature and TSA (I am familiar with that we implemented it for other customer but this customer does not want this option)
  
  – Dejan
  Feb 23 '15 at 14:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I know of TSA, but have not implemented HADR with it. Read up on Ember Crooks blog (db2commerce.com) for information on that.
  
  – Chris Aldrich
  Feb 23 '15 at 16:56
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you dont' want HADR, then yes, you could copy logs. Or even use the alternate/mirror log/archive parameters to get DB2 to copy the logs (possibly to a shared mount).
  
  – Chris Aldrich
  Feb 23 '15 at 16:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Chris, OK so you think this is OK. I am just concerned if database will know in which of those copied transaction logs it should write data into for the next transactions.
  
  – Dejan
  Feb 24 '15 at 7:21
  

  
  
  
  

 | 
show 1 more comment

0

Perhaps you wish to look into HADR on DB2. It actually does log shipping to the standby, so if there is a fail over you can either manually take over on the standby, or if you install TSA (Tivoli Systems Automation), then you can have it detect a failure and automatically fail over to the standby.

share|improve this answer

answered Feb 23 '15 at 14:06

Chris AldrichChris Aldrich

3,94042451

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Chris, no we are interested when Archive Mode is set with DISK option (unfortunately must be DISK because that is the requirement from the Customer). Please tell me if this is something which is possible or not? I am also confused little with the question from the customer but that is what they are asking us (I am aware that transaction logs are "active", database is populating them actively ) but please tell me if this is feasible or not? So we would copy ALL (online backup+archive logs+transaction logs) on another Disaster Recovery Server
  
  – Dejan
  Feb 23 '15 at 14:52
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Chris please tell us if this is feasible without HADR feature and TSA (I am familiar with that we implemented it for other customer but this customer does not want this option)
  
  – Dejan
  Feb 23 '15 at 14:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I know of TSA, but have not implemented HADR with it. Read up on Ember Crooks blog (db2commerce.com) for information on that.
  
  – Chris Aldrich
  Feb 23 '15 at 16:56
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you dont' want HADR, then yes, you could copy logs. Or even use the alternate/mirror log/archive parameters to get DB2 to copy the logs (possibly to a shared mount).
  
  – Chris Aldrich
  Feb 23 '15 at 16:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Chris, OK so you think this is OK. I am just concerned if database will know in which of those copied transaction logs it should write data into for the next transactions.
  
  – Dejan
  Feb 24 '15 at 7:21
  

  
  
  
  

 | 
show 1 more comment

Perhaps you wish to look into HADR on DB2. It actually does log shipping to the standby, so if there is a fail over you can either manually take over on the standby, or if you install TSA (Tivoli Systems Automation), then you can have it detect a failure and automatically fail over to the standby.

share|improve this answer

answered Feb 23 '15 at 14:06

Chris AldrichChris Aldrich

3,94042451

share|improve this answer

answered Feb 23 '15 at 14:06

Chris AldrichChris Aldrich

3,94042451

answered Feb 23 '15 at 14:06

Chris AldrichChris Aldrich

3,94042451

answered Feb 23 '15 at 14:06

Chris AldrichChris Aldrich

3,94042451