OraFAQ Forum: Backup & Recovery » How to change the path for db_recovery_file

Home » RDBMS Server » Backup & Recovery » How to change the path for db_recovery_file_dest? (Oracle 10g.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to change the path for db_recovery_file_dest? [message #379399]

Tue, 06 January 2009 05:45

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.

Report message to a moderator