Home » RDBMS Server » Backup & Recovery » How to change the path for db_recovery_file_dest? (Oracle 10g.)
How to change the path for db_recovery_file_dest? [message #379399] Tue, 06 January 2009 05:45 Go to next message
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
Senior Member
Dear All,
I need a help regarding how to change the path for the the parameter db_recovery_file_dest.When I use the below query it shows me the path and size.But in my c drive i have space for about 638MB so here in this sceneraio i need to change the path to another location which has more space.Waiting fo your kind suggestions.


SQL> CONN SYS/oracle@ORCL AS SYSDBA
Connected.
SQL> show parameter db_recovery_file;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      C:\RECOVERY
db_recovery_file_dest_size           big integer 1G
SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      C:\RECOVERY
db_recovery_file_dest_size           big integer 1G
SQL>




Thanks & Regards,
Hammer.
Re: How to change the path for db_recovery_file_dest? [message #379402 is a reply to message #379399] Tue, 06 January 2009 05:52 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Alter system.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup005.htm
Previous Topic: Location of Backup
Next Topic: How to restore backup from a patricular set directly from TAPE using RMAN
Goto Forum:
  


Current Time: Fri Dec 02 16:35:38 CST 2016

Total time taken to generate the page: 0.10368 seconds