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:
1 2 3 4 5 6 7 8 9 | SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 1G SCOPE=BOTH;System altered.SQL> show parameters DB_RECOVERY_FILE_DEST_SIZENAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest_size big integer 1G |
- Configuração do DB_RECOVERY_FILE_DEST:
1 2 3 4 5 6 7 8 9 10 | SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fra' SCOPE=BOTH ;System altered.SQL> show parameters DB_RECOVERY_FILE_DESTNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest string /u01/app/oracle/fradb_recovery_file_dest_size big integer 1G |
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)