Oracle database migration from on premise to AWS with zero downtime and only AWS services
0
I wanted to know if we can migrate an oracle database from on premise to AWS, using aws/open source tools/services only with zero downtime. The preference is just AWS services. since this is a 1 time requirement we are not interested in purchasing third party tool licenses. The important requirement for this POC is that there shouldn't be any downtime.
Kindly let me know if you can provide me any inputs for the same.
Thanks
oracle amazon-web-services migration database-migration aws-dms
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
add a comment |
0
I wanted to know if we can migrate an oracle database from on premise to AWS, using aws/open source tools/services only with zero downtime. The preference is just AWS services. since this is a 1 time requirement we are not interested in purchasing third party tool licenses. The important requirement for this POC is that there shouldn't be any downtime.
Kindly let me know if you can provide me any inputs for the same.
Thanks
oracle amazon-web-services migration database-migration aws-dms
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
You plan to use ORACLE RDS or Oracle on EC2 instance?.
– Dmitry Demin
Nov 22 '18 at 10:28
Oracle on Ec2 instance... the size of the data to be transferred can be considered to be about 10GB.
– kavya sudeep
Nov 22 '18 at 11:13
add a comment |
0
0
0
I wanted to know if we can migrate an oracle database from on premise to AWS, using aws/open source tools/services only with zero downtime. The preference is just AWS services. since this is a 1 time requirement we are not interested in purchasing third party tool licenses. The important requirement for this POC is that there shouldn't be any downtime.
Kindly let me know if you can provide me any inputs for the same.
Thanks
oracle amazon-web-services migration database-migration aws-dms
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
I wanted to know if we can migrate an oracle database from on premise to AWS, using aws/open source tools/services only with zero downtime. The preference is just AWS services. since this is a 1 time requirement we are not interested in purchasing third party tool licenses. The important requirement for this POC is that there shouldn't be any downtime.
Kindly let me know if you can provide me any inputs for the same.
Thanks
oracle amazon-web-services migration database-migration aws-dms
oracle amazon-web-services migration database-migration aws-dms
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
asked Nov 22 '18 at 9:09
kavya sudeepkavya sudeep
6
6
You plan to use ORACLE RDS or Oracle on EC2 instance?.
– Dmitry Demin
Nov 22 '18 at 10:28
Oracle on Ec2 instance... the size of the data to be transferred can be considered to be about 10GB.
– kavya sudeep
Nov 22 '18 at 11:13
add a comment |
You plan to use ORACLE RDS or Oracle on EC2 instance?.
– Dmitry Demin
Nov 22 '18 at 10:28
Oracle on Ec2 instance... the size of the data to be transferred can be considered to be about 10GB.
– kavya sudeep
Nov 22 '18 at 11:13
You plan to use ORACLE RDS or Oracle on EC2 instance?.
– Dmitry Demin
Nov 22 '18 at 10:28
You plan to use ORACLE RDS or Oracle on EC2 instance?.
– Dmitry Demin
Nov 22 '18 at 10:28
Oracle on Ec2 instance... the size of the data to be transferred can be considered to be about 10GB.
– kavya sudeep
Nov 22 '18 at 11:13
Oracle on Ec2 instance... the size of the data to be transferred can be considered to be about 10GB.
– kavya sudeep
Nov 22 '18 at 11:13
add a comment |
1 Answer
1
active
oldest
votes
0
To reduce database downtime, use standby technology.
- Install Oracle software only(same version on premise server) on the new server AWS EC2.
- Perform a hot backup on the premise server.
- Restore the hot backup to the new server AWS EC2.
- Configure the standby between the premise Oracle servers
and new AWS EC2. - Make switchover role primary to standby AWS EC2.
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
Why 11g? An extended support contract with Oracle will be required for support from Jan 2019. I would recommend going with the latest release.
– Jeffrey Kemp
Nov 27 '18 at 3:35
There is no version in the question. 11g- this is just an example, so many companies use 11g.
– Dmitry Demin
Nov 27 '18 at 3:50
Exactly. This answer does not read like an "example", it says, explicitly, "Install Oracle software only 11g" as if that's the best (or only) option.
– Jeffrey Kemp
Nov 27 '18 at 4:47
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427316%2foracle-database-migration-from-on-premise-to-aws-with-zero-downtime-and-only-aws%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
0
To reduce database downtime, use standby technology.
- Install Oracle software only(same version on premise server) on the new server AWS EC2.
- Perform a hot backup on the premise server.
- Restore the hot backup to the new server AWS EC2.
- Configure the standby between the premise Oracle servers
and new AWS EC2. - Make switchover role primary to standby AWS EC2.
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
Why 11g? An extended support contract with Oracle will be required for support from Jan 2019. I would recommend going with the latest release.
– Jeffrey Kemp
Nov 27 '18 at 3:35
There is no version in the question. 11g- this is just an example, so many companies use 11g.
– Dmitry Demin
Nov 27 '18 at 3:50
Exactly. This answer does not read like an "example", it says, explicitly, "Install Oracle software only 11g" as if that's the best (or only) option.
– Jeffrey Kemp
Nov 27 '18 at 4:47
add a comment |
0
To reduce database downtime, use standby technology.
- Install Oracle software only(same version on premise server) on the new server AWS EC2.
- Perform a hot backup on the premise server.
- Restore the hot backup to the new server AWS EC2.
- Configure the standby between the premise Oracle servers
and new AWS EC2. - Make switchover role primary to standby AWS EC2.
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
Why 11g? An extended support contract with Oracle will be required for support from Jan 2019. I would recommend going with the latest release.
– Jeffrey Kemp
Nov 27 '18 at 3:35
There is no version in the question. 11g- this is just an example, so many companies use 11g.
– Dmitry Demin
Nov 27 '18 at 3:50
Exactly. This answer does not read like an "example", it says, explicitly, "Install Oracle software only 11g" as if that's the best (or only) option.
– Jeffrey Kemp
Nov 27 '18 at 4:47
add a comment |
0
0
0
To reduce database downtime, use standby technology.
- Install Oracle software only(same version on premise server) on the new server AWS EC2.
- Perform a hot backup on the premise server.
- Restore the hot backup to the new server AWS EC2.
- Configure the standby between the premise Oracle servers
and new AWS EC2. - Make switchover role primary to standby AWS EC2.
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
To reduce database downtime, use standby technology.
- Install Oracle software only(same version on premise server) on the new server AWS EC2.
- Perform a hot backup on the premise server.
- Restore the hot backup to the new server AWS EC2.
- Configure the standby between the premise Oracle servers
and new AWS EC2. - Make switchover role primary to standby AWS EC2.
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
edited Nov 27 '18 at 4:58
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
answered Nov 22 '18 at 11:34
Dmitry DeminDmitry Demin
899149
899149
Why 11g? An extended support contract with Oracle will be required for support from Jan 2019. I would recommend going with the latest release.
– Jeffrey Kemp
Nov 27 '18 at 3:35
There is no version in the question. 11g- this is just an example, so many companies use 11g.
– Dmitry Demin
Nov 27 '18 at 3:50
Exactly. This answer does not read like an "example", it says, explicitly, "Install Oracle software only 11g" as if that's the best (or only) option.
– Jeffrey Kemp
Nov 27 '18 at 4:47
add a comment |
Why 11g? An extended support contract with Oracle will be required for support from Jan 2019. I would recommend going with the latest release.
– Jeffrey Kemp
Nov 27 '18 at 3:35
There is no version in the question. 11g- this is just an example, so many companies use 11g.
– Dmitry Demin
Nov 27 '18 at 3:50
Exactly. This answer does not read like an "example", it says, explicitly, "Install Oracle software only 11g" as if that's the best (or only) option.
– Jeffrey Kemp
Nov 27 '18 at 4:47
Why 11g? An extended support contract with Oracle will be required for support from Jan 2019. I would recommend going with the latest release.
– Jeffrey Kemp
Nov 27 '18 at 3:35
Why 11g? An extended support contract with Oracle will be required for support from Jan 2019. I would recommend going with the latest release.
– Jeffrey Kemp
Nov 27 '18 at 3:35
There is no version in the question. 11g- this is just an example, so many companies use 11g.
– Dmitry Demin
Nov 27 '18 at 3:50
There is no version in the question. 11g- this is just an example, so many companies use 11g.
– Dmitry Demin
Nov 27 '18 at 3:50
Exactly. This answer does not read like an "example", it says, explicitly, "Install Oracle software only 11g" as if that's the best (or only) option.
– Jeffrey Kemp
Nov 27 '18 at 4:47
Exactly. This answer does not read like an "example", it says, explicitly, "Install Oracle software only 11g" as if that's the best (or only) option.
– Jeffrey Kemp
Nov 27 '18 at 4:47
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53427316%2foracle-database-migration-from-on-premise-to-aws-with-zero-downtime-and-only-aws%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
You plan to use ORACLE RDS or Oracle on EC2 instance?.
– Dmitry Demin
Nov 22 '18 at 10:28
Oracle on Ec2 instance... the size of the data to be transferred can be considered to be about 10GB.
– kavya sudeep
Nov 22 '18 at 11:13