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
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)