Over the weekend I saw our Flash Recovery Area nearing 100% and after reading following thread db_recovery_file_dest_size of 37580963840 bytes is 98.29% used and has 6442 I've decided I need to increase the size from 12TB to 14TB. I believe following command will work:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 14T SCOPE=BOTH;
My questions: Can this be done at anytime? Can the database be online? Do I have to do any special if we are using ASM?
FYI, I've already verified that ASM has enough space to support the 14TB.
Thanks,
Thomas