Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRA's size

clliranJan 18 2011 — edited Jan 21 2011
Hi gurus,

I want to take backup with RMAN. I'm gonna use FRA. Now FRA size is 21 GB and i think and guess it's not enough. So want to change FRA's_dest and size coz another logical disk has much space then current. I have several questions:

1) i will change FRA destination does old FRA_dest_size leave space? or will continue use them on previouse logical disk?
2) How much will be backup set if i use compress. App database's datafiles size are 150Gb.
3) are these right commands for changing destination and size of FRA?
In open mode:
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH;
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/disk1/flash_recovery_area' SCOPE=BOTH;

4) i use differ location for archivelogs. i want to keep only backup sets in FRA.


Regards,
rustam_tj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2011
Added on Jan 18 2011
5 comments
1,774 views