OraFAQ Forum: Server Administration » Changing the FLASH_RECOVERY

Home » RDBMS Server » Server Administration » Changing the FLASH_RECOVERY_AREA location

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

Changing the FLASH_RECOVERY_AREA location [message #124205]

Thu, 16 June 2005 18:25

kavaworld
Messages: 2
Registered: June 2005
Location: NRC

Junior Member

We are using Oracle 10.1.0.4 and would like to change the location of flash_recovery_area/ from its current location to another. We moved this direcory with all its subdir to a new location exited the configuration file but when we start the DB Oracle didn't recognize the new location. So we restored this directory. Soon we will run out of space on this directory because summer time we are holding flash recovery for 7 days. Could a symbolic link will work? (we currently delete files older than 3 days) Or something else. Pls help if you know how!

Thanks,
Serguey

Report message to a moderator

Re: Changing the FLASH_RECOVERY_AREA location [message #124226 is a reply to message #124205]

Thu, 16 June 2005 22:40

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

As you are using Oracle 10g First find by which file your database is started
SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /usr/app/oracle/product/10.1.0/db_1/dbs/spfileOradb.ora

----------------------------------------------------
For Understanding....
In spfileOradb.ora
Oradb<-- is my SID (Database name)so you must be having your own database name or SID attached to your spfile.
----------------------------------------------------

I.e by Pfile or Spfile.

Now if your database is using Spfile then take backup of Spfile..(Do this as it is a precautionary measure)

Now change Spfile into pfile
Note :- Spfile is binary file and pfile is text file.

Now Open pfile (ie init.ora)

Change the path specify for parameter
db_recovery_file_dest='/var/oracle/flash_recovery_area'
db_recovery_file_dest_size=2147483648

Save the change.

Now Create Spfile from Pfile.

NoW shutdown the database and then Start it again.
Oracle will look for SPfile and as per the path specified in parameter db_recovery_file_dest location of flash_recovery_area is decided

-----------------------------------------------------------------
If Oracle is using Pfile to start database and you dont want to use Spfile then just make changes in pfile

i.e. Change the path specify for parameter
db_recovery_file_dest='/var/oracle/flash_recovery_area'
db_recovery_file_dest_size=2147483648

save the change...in pfile (init.ora)

Sql>Shutdown immediate

SQL>Startup

Note:- [1]Spfile concept is newly introduced from Oracle 9i
[2] Once Spfile is made oracle looks for Spfile whenever startup command is issued to start the database

I hope now you must be able to change the location of flash_recovery_area

From:- Sunilkumar

Report message to a moderator

Re: Changing the FLASH_RECOVERY_AREA location [message #124326 is a reply to message #124226]

Fri, 17 June 2005 09:31

kavaworld
Messages: 2
Registered: June 2005
Location: NRC

Junior Member

Thank you for your replay. We issue following from SQL*Plus which changed the destination in init and spfile.
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/srv/oradata/flash_recovery_area' SCOPE=BOTH SID='*';

The tree structure of this directory, which we want to change is like:

../flash_recovery_area/sid_name/autobackup
../flash_recovery_area/sid_name/backupset
../flash_recovery_area/sid_name/datafile
../flash_recovery_area/sid_name/flashback

After changing the location with the above statement
we have only
/srv/oradata/flash_recovery_area/sid_name/backupset
and the database didn't create /srv/oradata/flash_recovery_area/sid_name/flashback
and didn't record any .flb files

Thanks,
Serguey

Report message to a moderator

Previous Topic:	ORA-1113 Can not open database
Next Topic:	What is recommended size of SGA (Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:15:48 CDT 2024