{"id":2220,"date":"2021-02-27T09:22:05","date_gmt":"2021-02-27T09:22:05","guid":{"rendered":"https:\/\/swiv.com.br\/configuring-the-oracle-fast-recovery-area-fra\/"},"modified":"2026-05-27T20:02:52","modified_gmt":"2026-05-27T19:02:52","slug":"configuring-the-oracle-fast-recovery-area-fra","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/02\/27\/configuring-the-oracle-fast-recovery-area-fra\/","title":{"rendered":"Configuring the Oracle Fast Recovery Area (FRA)"},"content":{"rendered":"\n<p>A Fast Recovery Area nos permite abrigar em diret\u00f3rio de FS ou ASM arquivos permanentes (c\u00f3pias multiplexadas de control file ou online redo logs) ou arquivos transientes (archived redo logs, c\u00f3pias de datafiles ou control files, control file autobackps, backup pieces, etc). Esta \u00e1rea \u00e9 administrada de forma autom\u00e1tica pelo Oracle, que permite a sua defini\u00e7\u00e3o e tamanho no momento da instala\u00e7\u00e3o do banco, ou posteriormente, sem causar downtime.<\/p>\n\n\n\n<p>No meu caso, eu j\u00e1 tenho a FRA configurada:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SELECT INSTANCE_NAME,STATUS FROM GV$INSTANCE;\n \nINSTANCE_NAME    STATUS\n---------------- ------------\nRMANDB           OPEN\n \nSQL&gt; SHO PARAMETER DB_RECOVERY_FILE_DEST\n \nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest                string      \/oracle\/fra\ndb_recovery_file_dest_size           big integer 700M\n<\/pre><\/div>\n\n\n<p>Em caso de necessidade de altera\u00e7\u00e3o, o par\u00e2metro DB_RECOVERY_FILE_DEST_SIZE deve ser definido primeiro (ajustando o tamanho dessa \u00e1rea), e posteriormente o par\u00e2metro DB_RECOVERY_FILE_DEST (que define a sua localiza\u00e7\u00e3o):<\/p>\n\n\n\n<p>Validando o diret\u00f3rio atual:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 ~]$ cd \/oracle\/fra\n&#x5B;oracle@oel8 fra]$ ll\ntotal 0\ndrwxr-x---. 5 oracle oinstall 60 May  2  2020 RMANDB\n&#x5B;oracle@oel8 fra]$ cd RMANDB\/\n&#x5B;oracle@oel8 RMANDB]$ ll\ntotal 0\ndrwxr-x---. 3 oracle oinstall 24 May  2  2020 autobackup\ndrwxr-x---. 2 oracle oinstall 33 Apr  5  2020 controlfile\ndrwxr-x---. 2 oracle oinstall 93 Apr  5  2020 onlinelog\n&#x5B;oracle@oel8 RMANDB]$ cd ..\n&#x5B;oracle@oel8 fra]$ du -hs *\n171M    RMANDB\n<\/pre><\/div>\n\n\n<p>Criando novo diret\u00f3rio:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 oracle]$ mkdir fra2\n&#x5B;oracle@oel8 oracle]$ chmod 775 fra2\n&#x5B;oracle@oel8 oracle]$ pwd\n\/oracle\n&#x5B;oracle@oel8 oracle]$ ll\ntotal 0\ndrwxrwxr-x. 5 oracle oinstall  53 Mar 30  2020 18.0.0\ndrwxrwxr-x. 2 oracle oinstall 222 Feb 27 05:58 archives\ndrwxrwxr-x. 3 oracle oinstall  20 Apr  5  2020 dados\ndrwxrwxr-x. 3 oracle oinstall  20 Apr  5  2020 fra\ndrwxrwxr-x. 2 oracle oinstall   6 Feb 27 06:15 fra2\n&#x5B;oracle@oel8 oracle]$\n<\/pre><\/div>\n\n\n<p>Alterando os par\u00e2metros do banco:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 oracle]$ rman target \/\n \nRecovery Manager: Release 18.0.0.0.0 - Production on Sat Feb 27 06:18:07 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\n \nconnected to target database: RMANDB (DBID=3825250984)\n \nRMAN&gt; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=500M;\n \nusing target database control file instead of recovery catalog\nStatement processed\n \nRMAN&gt; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=&#039;\/oracle\/fra2&#039;;\n \nStatement processed\n \nRMAN&gt;\n<\/pre><\/div>\n\n\n<p>Fonte: https:\/\/docs.oracle.com\/database\/121\/ADMQS\/GUID-D6A541BF-A878-4B45-AFAC-1E921554731E.htm<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Fast Recovery Area nos permite abrigar em diret\u00f3rio de FS ou ASM arquivos permanentes (c\u00f3pias multiplexadas de control file ou online redo logs) ou arquivos transientes (archived redo logs, c\u00f3pias de datafiles ou control files, control file autobackps, backup pieces, etc). Esta \u00e1rea \u00e9 administrada de forma autom\u00e1tica pelo Oracle, que permite a sua [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[],"class_list":["post-2220","post","type-post","status-publish","format-standard","hentry","category-administration","category-backup-recovery"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2220"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2220\/revisions"}],"predecessor-version":[{"id":9254,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2220\/revisions\/9254"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}