Changing Fast Recovery Area destination
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
My database is running in archive log mode, but flashback is disabled because I do not need it.
The FRA is set to /flasharch mount point.
Now, I am going to change the FRA location to /flasharch01 mount point due to space limitation.
What to do with archivelog in the old location. Do I need to move the old files to new location?
Could you guys please guide me step by step?
RMAN uses control file instead of recovery catalog.
Should I create a recovery catalog? if yes.. please how? I need steps please.
As, I can't increase the FRA location. The only way to change the location is the solution. Could you please share the steps how to move the old files and how to catalog them? RMAN using control file instead of recovery catalog.
oracle rman archive-log
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
bumped to the homepage by Community♦ 3 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 |
My database is running in archive log mode, but flashback is disabled because I do not need it.
The FRA is set to /flasharch mount point.
Now, I am going to change the FRA location to /flasharch01 mount point due to space limitation.
What to do with archivelog in the old location. Do I need to move the old files to new location?
Could you guys please guide me step by step?
RMAN uses control file instead of recovery catalog.
Should I create a recovery catalog? if yes.. please how? I need steps please.
As, I can't increase the FRA location. The only way to change the location is the solution. Could you please share the steps how to move the old files and how to catalog them? RMAN using control file instead of recovery catalog.
oracle rman archive-log
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
bumped to the homepage by Community♦ 3 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What is consuming your FRA? What's your retention policy? Are there any obsolete files on it that you can clear up? Can you increase the size of/flasharchmount point? If you create new FRA you have to move old recovery files to the new location and catalog them you may also need to change initialization parameters.
– JSapkota
Jul 3 '17 at 6:52
2
Just symbolic link it, it's the easiest way
– Philᵀᴹ
Jul 3 '17 at 7:37
1
@JSapkota asked some important questions that you left unanswered. Perhaps you don't need a larger FRA, but siimply need to improve you use of the one you have. IF the only files using the FRA are archivelogs and/or backups, then you do NOT necessarily have to move the existing files. You could just leave them in place and let them get deleted in the normal course of backing up a deleting obsolete. And it is not a matter of rman " using control file instead of recovery catalog". RMAN always uses controlfile. Catalog is simply an optional enhancement.
– EdStevens
Jul 3 '17 at 18:59
add a comment |
My database is running in archive log mode, but flashback is disabled because I do not need it.
The FRA is set to /flasharch mount point.
Now, I am going to change the FRA location to /flasharch01 mount point due to space limitation.
What to do with archivelog in the old location. Do I need to move the old files to new location?
Could you guys please guide me step by step?
RMAN uses control file instead of recovery catalog.
Should I create a recovery catalog? if yes.. please how? I need steps please.
As, I can't increase the FRA location. The only way to change the location is the solution. Could you please share the steps how to move the old files and how to catalog them? RMAN using control file instead of recovery catalog.
oracle rman archive-log
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
My database is running in archive log mode, but flashback is disabled because I do not need it.
The FRA is set to /flasharch mount point.
Now, I am going to change the FRA location to /flasharch01 mount point due to space limitation.
What to do with archivelog in the old location. Do I need to move the old files to new location?
Could you guys please guide me step by step?
RMAN uses control file instead of recovery catalog.
Should I create a recovery catalog? if yes.. please how? I need steps please.
As, I can't increase the FRA location. The only way to change the location is the solution. Could you please share the steps how to move the old files and how to catalog them? RMAN using control file instead of recovery catalog.
oracle rman archive-log
oracle rman archive-log
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
edited Jul 4 '17 at 6:07
Paul White♦
54.2k14288461
54.2k14288461
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
asked Jul 3 '17 at 6:29
Rahman KhostRahman Khost
3419
3419
bumped to the homepage by Community♦ 3 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♦ 3 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
What is consuming your FRA? What's your retention policy? Are there any obsolete files on it that you can clear up? Can you increase the size of/flasharchmount point? If you create new FRA you have to move old recovery files to the new location and catalog them you may also need to change initialization parameters.
– JSapkota
Jul 3 '17 at 6:52
2
Just symbolic link it, it's the easiest way
– Philᵀᴹ
Jul 3 '17 at 7:37
1
@JSapkota asked some important questions that you left unanswered. Perhaps you don't need a larger FRA, but siimply need to improve you use of the one you have. IF the only files using the FRA are archivelogs and/or backups, then you do NOT necessarily have to move the existing files. You could just leave them in place and let them get deleted in the normal course of backing up a deleting obsolete. And it is not a matter of rman " using control file instead of recovery catalog". RMAN always uses controlfile. Catalog is simply an optional enhancement.
– EdStevens
Jul 3 '17 at 18:59
add a comment |
What is consuming your FRA? What's your retention policy? Are there any obsolete files on it that you can clear up? Can you increase the size of/flasharchmount point? If you create new FRA you have to move old recovery files to the new location and catalog them you may also need to change initialization parameters.
– JSapkota
Jul 3 '17 at 6:52
2
Just symbolic link it, it's the easiest way
– Philᵀᴹ
Jul 3 '17 at 7:37
1
@JSapkota asked some important questions that you left unanswered. Perhaps you don't need a larger FRA, but siimply need to improve you use of the one you have. IF the only files using the FRA are archivelogs and/or backups, then you do NOT necessarily have to move the existing files. You could just leave them in place and let them get deleted in the normal course of backing up a deleting obsolete. And it is not a matter of rman " using control file instead of recovery catalog". RMAN always uses controlfile. Catalog is simply an optional enhancement.
– EdStevens
Jul 3 '17 at 18:59
What is consuming your FRA? What's your retention policy? Are there any obsolete files on it that you can clear up? Can you increase the size of
/flasharch mount point? If you create new FRA you have to move old recovery files to the new location and catalog them you may also need to change initialization parameters.– JSapkota
Jul 3 '17 at 6:52
What is consuming your FRA? What's your retention policy? Are there any obsolete files on it that you can clear up? Can you increase the size of
/flasharch mount point? If you create new FRA you have to move old recovery files to the new location and catalog them you may also need to change initialization parameters.– JSapkota
Jul 3 '17 at 6:52
2
2
Just symbolic link it, it's the easiest way
– Philᵀᴹ
Jul 3 '17 at 7:37
Just symbolic link it, it's the easiest way
– Philᵀᴹ
Jul 3 '17 at 7:37
1
1
@JSapkota asked some important questions that you left unanswered. Perhaps you don't need a larger FRA, but siimply need to improve you use of the one you have. IF the only files using the FRA are archivelogs and/or backups, then you do NOT necessarily have to move the existing files. You could just leave them in place and let them get deleted in the normal course of backing up a deleting obsolete. And it is not a matter of rman " using control file instead of recovery catalog". RMAN always uses controlfile. Catalog is simply an optional enhancement.
– EdStevens
Jul 3 '17 at 18:59
@JSapkota asked some important questions that you left unanswered. Perhaps you don't need a larger FRA, but siimply need to improve you use of the one you have. IF the only files using the FRA are archivelogs and/or backups, then you do NOT necessarily have to move the existing files. You could just leave them in place and let them get deleted in the normal course of backing up a deleting obsolete. And it is not a matter of rman " using control file instead of recovery catalog". RMAN always uses controlfile. Catalog is simply an optional enhancement.
– EdStevens
Jul 3 '17 at 18:59
add a comment |
1 Answer
1
active
oldest
votes
My problem is solved. I have changed the FRA to new location.
alter system set db_recovery_file_dest='/flasharch01';
alter system set db_recovery_file_dest_size=750G;
Copy all archive log file which is generated in old and copy to new location.
using OS level copy commond.
RMAN> catalog db_recovery_file_dest;
Or
RMAN> catalog recovery area;
Or
RMAN> catalog start with 'New location Path';
RMAN> catalog start with 'New location Path';
create PFILE='/flasharch/file_raiddb.ora' from spfile;
RMAN> crosscheck copy;
RMAN> crosscheck backup;
RMAN> delete expired copy;
RMAN> delete expired backup;
alter system set log_archive_dest_1='location=/flasharch01';
create spfile from pfile=''/flasharch/file_raiddb.ora''
CREATE SPFILE='/flasharch/file_raiddb.ora'
FROM PFILE='/flasharch/file_raiddb.ora';
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
You should catalog your new fast recovery area after you moved the archivelogs. Maybe you also have to check if there is a controlfile copy in your FRA and change that parameter as well. Besides that you got it right :)
– ora-600
Jul 5 '17 at 16:06
Paul White thank you, yes you are right the catalog should be after moving archive log , so i have to edit the answer. For the control file copy could you please guide me how to check that control file copy is in FRA. Please also specify the parameter to change.
– Rahman Khost
Jul 6 '17 at 4:46
add a 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%2f177834%2fchanging-fast-recovery-area-destination%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
My problem is solved. I have changed the FRA to new location.
alter system set db_recovery_file_dest='/flasharch01';
alter system set db_recovery_file_dest_size=750G;
Copy all archive log file which is generated in old and copy to new location.
using OS level copy commond.
RMAN> catalog db_recovery_file_dest;
Or
RMAN> catalog recovery area;
Or
RMAN> catalog start with 'New location Path';
RMAN> catalog start with 'New location Path';
create PFILE='/flasharch/file_raiddb.ora' from spfile;
RMAN> crosscheck copy;
RMAN> crosscheck backup;
RMAN> delete expired copy;
RMAN> delete expired backup;
alter system set log_archive_dest_1='location=/flasharch01';
create spfile from pfile=''/flasharch/file_raiddb.ora''
CREATE SPFILE='/flasharch/file_raiddb.ora'
FROM PFILE='/flasharch/file_raiddb.ora';
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
You should catalog your new fast recovery area after you moved the archivelogs. Maybe you also have to check if there is a controlfile copy in your FRA and change that parameter as well. Besides that you got it right :)
– ora-600
Jul 5 '17 at 16:06
Paul White thank you, yes you are right the catalog should be after moving archive log , so i have to edit the answer. For the control file copy could you please guide me how to check that control file copy is in FRA. Please also specify the parameter to change.
– Rahman Khost
Jul 6 '17 at 4:46
add a comment |
My problem is solved. I have changed the FRA to new location.
alter system set db_recovery_file_dest='/flasharch01';
alter system set db_recovery_file_dest_size=750G;
Copy all archive log file which is generated in old and copy to new location.
using OS level copy commond.
RMAN> catalog db_recovery_file_dest;
Or
RMAN> catalog recovery area;
Or
RMAN> catalog start with 'New location Path';
RMAN> catalog start with 'New location Path';
create PFILE='/flasharch/file_raiddb.ora' from spfile;
RMAN> crosscheck copy;
RMAN> crosscheck backup;
RMAN> delete expired copy;
RMAN> delete expired backup;
alter system set log_archive_dest_1='location=/flasharch01';
create spfile from pfile=''/flasharch/file_raiddb.ora''
CREATE SPFILE='/flasharch/file_raiddb.ora'
FROM PFILE='/flasharch/file_raiddb.ora';
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
You should catalog your new fast recovery area after you moved the archivelogs. Maybe you also have to check if there is a controlfile copy in your FRA and change that parameter as well. Besides that you got it right :)
– ora-600
Jul 5 '17 at 16:06
Paul White thank you, yes you are right the catalog should be after moving archive log , so i have to edit the answer. For the control file copy could you please guide me how to check that control file copy is in FRA. Please also specify the parameter to change.
– Rahman Khost
Jul 6 '17 at 4:46
add a comment |
My problem is solved. I have changed the FRA to new location.
alter system set db_recovery_file_dest='/flasharch01';
alter system set db_recovery_file_dest_size=750G;
Copy all archive log file which is generated in old and copy to new location.
using OS level copy commond.
RMAN> catalog db_recovery_file_dest;
Or
RMAN> catalog recovery area;
Or
RMAN> catalog start with 'New location Path';
RMAN> catalog start with 'New location Path';
create PFILE='/flasharch/file_raiddb.ora' from spfile;
RMAN> crosscheck copy;
RMAN> crosscheck backup;
RMAN> delete expired copy;
RMAN> delete expired backup;
alter system set log_archive_dest_1='location=/flasharch01';
create spfile from pfile=''/flasharch/file_raiddb.ora''
CREATE SPFILE='/flasharch/file_raiddb.ora'
FROM PFILE='/flasharch/file_raiddb.ora';
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
My problem is solved. I have changed the FRA to new location.
alter system set db_recovery_file_dest='/flasharch01';
alter system set db_recovery_file_dest_size=750G;
Copy all archive log file which is generated in old and copy to new location.
using OS level copy commond.
RMAN> catalog db_recovery_file_dest;
Or
RMAN> catalog recovery area;
Or
RMAN> catalog start with 'New location Path';
RMAN> catalog start with 'New location Path';
create PFILE='/flasharch/file_raiddb.ora' from spfile;
RMAN> crosscheck copy;
RMAN> crosscheck backup;
RMAN> delete expired copy;
RMAN> delete expired backup;
alter system set log_archive_dest_1='location=/flasharch01';
create spfile from pfile=''/flasharch/file_raiddb.ora''
CREATE SPFILE='/flasharch/file_raiddb.ora'
FROM PFILE='/flasharch/file_raiddb.ora';
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
edited Jul 6 '17 at 4:48
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
answered Jul 4 '17 at 4:13
Rahman KhostRahman Khost
3419
3419
You should catalog your new fast recovery area after you moved the archivelogs. Maybe you also have to check if there is a controlfile copy in your FRA and change that parameter as well. Besides that you got it right :)
– ora-600
Jul 5 '17 at 16:06
Paul White thank you, yes you are right the catalog should be after moving archive log , so i have to edit the answer. For the control file copy could you please guide me how to check that control file copy is in FRA. Please also specify the parameter to change.
– Rahman Khost
Jul 6 '17 at 4:46
add a comment |
You should catalog your new fast recovery area after you moved the archivelogs. Maybe you also have to check if there is a controlfile copy in your FRA and change that parameter as well. Besides that you got it right :)
– ora-600
Jul 5 '17 at 16:06
Paul White thank you, yes you are right the catalog should be after moving archive log , so i have to edit the answer. For the control file copy could you please guide me how to check that control file copy is in FRA. Please also specify the parameter to change.
– Rahman Khost
Jul 6 '17 at 4:46
You should catalog your new fast recovery area after you moved the archivelogs. Maybe you also have to check if there is a controlfile copy in your FRA and change that parameter as well. Besides that you got it right :)
– ora-600
Jul 5 '17 at 16:06
You should catalog your new fast recovery area after you moved the archivelogs. Maybe you also have to check if there is a controlfile copy in your FRA and change that parameter as well. Besides that you got it right :)
– ora-600
Jul 5 '17 at 16:06
Paul White thank you, yes you are right the catalog should be after moving archive log , so i have to edit the answer. For the control file copy could you please guide me how to check that control file copy is in FRA. Please also specify the parameter to change.
– Rahman Khost
Jul 6 '17 at 4:46
Paul White thank you, yes you are right the catalog should be after moving archive log , so i have to edit the answer. For the control file copy could you please guide me how to check that control file copy is in FRA. Please also specify the parameter to change.
– Rahman Khost
Jul 6 '17 at 4:46
add a 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%2f177834%2fchanging-fast-recovery-area-destination%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
What is consuming your FRA? What's your retention policy? Are there any obsolete files on it that you can clear up? Can you increase the size of
/flasharchmount point? If you create new FRA you have to move old recovery files to the new location and catalog them you may also need to change initialization parameters.– JSapkota
Jul 3 '17 at 6:52
2
Just symbolic link it, it's the easiest way
– Philᵀᴹ
Jul 3 '17 at 7:37
1
@JSapkota asked some important questions that you left unanswered. Perhaps you don't need a larger FRA, but siimply need to improve you use of the one you have. IF the only files using the FRA are archivelogs and/or backups, then you do NOT necessarily have to move the existing files. You could just leave them in place and let them get deleted in the normal course of backing up a deleting obsolete. And it is not a matter of rman " using control file instead of recovery catalog". RMAN always uses controlfile. Catalog is simply an optional enhancement.
– EdStevens
Jul 3 '17 at 18:59