DB2 Transaction Logs - can they be COPY-PASTE on another Disaster Recovery Server?Postgres synchronized...
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
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
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
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
asked Feb 23 '15 at 7:50
DejanDejan
30731126
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
db2 transaction-log logs snapshot disaster-recovery
asked Feb 23 '15 at 7:50
DejanDejan
30731126
asked Feb 23 '15 at 7:50
DejanDejan
30731126
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
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.
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 |
add a comment |
1 Answer
1
active
oldest
votes
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.
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
});
}
});
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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.
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.
answered Feb 23 '15 at 14:06
Chris AldrichChris Aldrich
3,94042451
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.
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
answered Feb 23 '15 at 14:06
Chris AldrichChris Aldrich
3,94042451
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
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
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
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
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
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
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
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
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
