Home » RDBMS Server » Backup & Recovery » use_db_recovery_file_dest (RHEL4/Win2k3,10.2.0.3)
use_db_recovery_file_dest [message #381733] Mon, 19 January 2009 09:32 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Hello,

I would like to know what may be the consequences of changing the default location of the flash recovery area (oracle_base/flash_recovery_area) to a customed one.

What I mean is, if I alter my spfile and change the default location of the parameter db_recovery_file_dest to another location on another hard disk, how will the use of use_db_recovery_flash_dest expression with some parameters such as log_archive_dest be affected?

Will the expression use_db_recovery_flash_dest still refer to the location of my recovery area? Will there be problems during archiving,backup and or recovery?

Thanks in advance.
Re: use_db_recovery_file_dest [message #381734 is a reply to message #381733] Mon, 19 January 2009 09:44 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
No worries changing the location. The USE_DB_RECOVERY_FLASH_DEST will point to the new location.
Re: use_db_recovery_file_dest [message #381751 is a reply to message #381734] Mon, 19 January 2009 11:20 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Thanks alot Ebrian.
Re: use_db_recovery_file_dest [message #381753 is a reply to message #381751] Mon, 19 January 2009 11:55 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Just feedback. It works. I issued a
alter system checkpoint
and the archive was created in the new location. I also performed a backup of my whole database using rman and all the backed up files where created in the destination I specified.

Thanks again.

[Updated on: Mon, 19 January 2009 11:57]

Report message to a moderator

Re: use_db_recovery_file_dest [message #381757 is a reply to message #381733] Mon, 19 January 2009 12:07 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
> I also performed a backup of my whole database using rman and all the backed up files where created in the destination I specified.
You would have gotten these results without posting to this forum.
So what prevented you from doing so?
Re: use_db_recovery_file_dest [message #381882 is a reply to message #381757] Tue, 20 January 2009 03:53 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

What prevented me from doing what? Posting to this forum or having the results I mentionned? Obviously, if I was absolutely sure I would get the results I mentionned earlier, I wouldn't have opened this topic in the first place.Anyway, I just wanted to give Ebrian a feedback of what he suggested me to do.

Thanks.
Re: use_db_recovery_file_dest [message #381884 is a reply to message #381757] Tue, 20 January 2009 03:54 Go to previous message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

What prevented me from doing what? Posting to this forum or having the results I mentionned? Obviously, if I was absolutely sure I would get the results I mentionned earlier, I wouldn't have opened this topic in the first place.Anyway, I just wanted to give Ebrian a feedback of what he suggested me to do.

Thanks.
Previous Topic: Unable to issue DELETE OBSOLETE....in RMAN
Next Topic: Restore Database Using RMAN on Different OS Version
Goto Forum:
  


Current Time: Tue Dec 06 12:00:25 CST 2016

Total time taken to generate the page: 0.13791 seconds