Configurar a Fast Recovery Area é uma tarefa que envolve dois parâmetros: DB_RECOVERY_FILE_DEST_SIZE e DB_RECOVERY_FILE_DEST. O primeiro basicamente determina o tamanho da Fast Recovery Area e o segundo o diretório onde os arquivos serão gerados. Sendo isso, neste post irei mostrar a configuração desta área em um ambiente Single instance. Uma vez que, a configuração em um ambiente com Oracle Real Application Clusters (RAC) deve ser a mesma em todas as instâncias do ambiente, além de especificar a cláusula SID=’*’ .
- Configuração do DB_RECOVERY_FILE_DEST_SIZE:
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 1G SCOPE=BOTH; System altered. SQL> show parameters DB_RECOVERY_FILE_DEST_SIZE NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest_size big integer 1G
- Configuração do DB_RECOVERY_FILE_DEST:
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fra' SCOPE=BOTH ; System altered. SQL> show parameters DB_RECOVERY_FILE_DEST NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u01/app/oracle/fra db_recovery_file_dest_size big integer 1G
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.