Sfrgttk

Closed form of recurrent arithmetic series summation

How would a mousetrap for use in space work?

For a new assistant professor in CS, how to build/manage a publication pipeline

Is the Standard Deduction better than Itemized when both are the same amount?

Do jazz musicians improvise on the parent scale in addition to the chord-scales?

What does "lightly crushed" mean for cardamon pods?

Fundamental Solution of the Pell Equation

Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?

Is grep documentation wrong?

Fantasy story; one type of magic grows in power with use, but the more powerful they are, they more they are drawn to travel to their source

2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?

How to compare two different files line by line in unix?

How to react to hostile behavior from a senior developer?

Is it cost-effective to upgrade an old-ish Giant Escape R3 commuter bike with entry-level branded parts (wheels, drivetrain)?

old style "caution" boxes

How to Make a Beautiful Stacked 3D Plot

Crossing US/Canada Border for less than 24 hours

Around usage results

Irreducible of finite Krull dimension implies quasi-compact?

Dating a Former Employee

How to answer "Have you ever been terminated?"

When a candle burns, why does the top of wick glow if bottom of flame is hottest?

Is there any way for the UK Prime Minister to make a motion directly dependent on Government confidence?

How to tell that you are a giant?

Changing Fast Recovery Area destination

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

1

1

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

share|improve this question

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♦ 5 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 /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
  

  
  
  
  
  
  

  
  
  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 | 

1

1

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

share|improve this question

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♦ 5 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 /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
  

  
  
  
  
  
  

  
  
  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

share|improve this question

edited Jul 4 '17 at 6:07

Paul White♦

54.2k14288461

asked Jul 3 '17 at 6:29

Rahman KhostRahman Khost

3419

share|improve this question

edited Jul 4 '17 at 6:07

Paul White♦

54.2k14288461

asked Jul 3 '17 at 6:29

Rahman KhostRahman Khost

3419

share|improve this question

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

asked Jul 3 '17 at 6:29

Rahman KhostRahman Khost

3419

asked Jul 3 '17 at 6:29

Rahman KhostRahman Khost

3419

1 Answer
1

active

oldest

votes

0

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';

share|improve this answer

edited Jul 6 '17 at 4:48

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
});


}
});

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%2f177834%2fchanging-fast-recovery-area-destination%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

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';

share|improve this answer

edited Jul 6 '17 at 4:48

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 | 

0

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';

share|improve this answer

edited Jul 6 '17 at 4:48

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';

share|improve this answer

edited Jul 6 '17 at 4:48

answered Jul 4 '17 at 4:13

Rahman KhostRahman Khost

3419

alter system set db_recovery_file_dest='/flasharch01';

alter system set db_recovery_file_dest_size=750G;

RMAN> catalog db_recovery_file_dest; 

RMAN> catalog recovery area; 

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';

share|improve this answer

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