FRA Usage<\/strong><\/li>\n<\/ol>\n1) Locating Archive Log Files(LOG_ARCHIVE_DEST_N)<\/h3>\n We can set the location of archive log files with LOG_ARCHIVE_DEST_N parameter.<\/p>\n
SQL> alter system set log_archive_dest_1 = 'location=\/\u2026\u2026 ' scope = both;<\/pre>\nWe also need to set the format of the archive logs. By default, Archive Logs are saved with a .dbf extension, but this makes it difficult to differentiate archive logs from data files. Therefore, we can define the desired format with LOG_ARCHIVE_FORMAT parameter.<\/p>\n
SQL> alter system set log_archive_format='SINGLEDB_%t_%s_%r.arc' scope=both;<\/pre>\nThe meaning of the characters used to determine the format of the archive log files;<\/p>\n
%s\u00a0 ->\u00a0 log sequence number<\/p>\n
%S\u00a0 ->\u00a0 log sequence number, zero filled<\/p>\n
%t\u00a0 ->\u00a0 thread number<\/p>\n
%T ->\u00a0 thread number, zero filled<\/p>\n
%a\u00a0 ->\u00a0 activation ID<\/p>\n
%d\u00a0 ->\u00a0 Database ID<\/p>\n
%r\u00a0 ->\u00a0 Resetlod ID<\/p>\n
Oracle default format;<\/strong> %t_%s_%r.dbf<\/div>\n\n
SQL> show parameter db_recovery\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest string\ndb_recovery_file_dest_size big integer 0\n\t\nSQL> archive log list\nDatabase log mode No Archive Mode\nAutomatic archival Disabled\nArchive destination \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/arch\nOldest online log sequence 14\nCurrent log sequence 16\n<\/pre>\n2) FRA(Fast Recovery Area) Usage<\/h3>\n<\/div>\nWhat is Fast Recovery Area?<\/h4>\n FRA is an area where the following files are stored;<\/p>\n
\nArchive log files,<\/li>\n RMAN backup files,<\/li>\n Flashback log files,<\/li>\n Online Redo Log files,<\/li>\n Control File<\/li>\n<\/ul>\nUse of the FRA area can be enabled by setting two parameters in the database. These parameters are; DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE.<\/p>\n
DB_RECOVERY_FILE_DEST<\/strong> determines the directory to use as the FRA area.<\/p>\nDB_RECOVERY_FILE_DEST_SIZE<\/strong> determines the maximum space for files in the FRA area.<\/p>\nBefore Enabling Fast Recovery Area<\/h4>\nSQL> show parameter db_recovery\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest string\ndb_recovery_file_dest_size big integer 0\n\n\nSQL> archive log list\nDatabase log mode No Archive Mode\nAutomatic archival Disabled\nArchive destination \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/arch\nOldest online log sequence 14\nCurrent log sequence 16<\/pre>\nEnable Fast Recovery Area<\/h4>\n The following operations are performed consequentively. If the order changes, you receive an error.<\/p>\n
SQL> alter system set db_recovery_file_dest_size=20000M;\n\nSystem altered.\n\nSQL> alter system set db_recovery_file_dest='+FRA';\n\nSystem altered.<\/pre>\nNow, check the db_recovery parameter again;<\/p>\n
SQL> show parameter db_recovery\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest string +FRA\ndb_recovery_file_dest_size big integer 10000M\n\n\nSQL> archive log list\nDatabase log mode No Archive Mode\nAutomatic archival Disabled\nArchive destination USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence 14\nCurrent log sequence 16<\/pre>\nDB_RECOVERY_FILE_DEST\u00a0 vs LOG_ARCHIVE_DEST<\/h4>\n If the parameter LOG_ARCHIVE_DEST_N is set together with the FRA area in the PARAMETER file in the database, the archive log files are saved to the directory set in the LOG_ARCHIVE_DEST_N parameter, not the FRA area. These situations can be queried as follows.<\/p>\n
SQL> show parameter log_archive_dest_1\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_1 string\n\nSQL> show parameter db_recovery\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest string +FRA\ndb_recovery_file_dest_size big integer 10000M\n\nSQL> show parameter log_archive_format\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_format string %t_%s_%r.dbf<\/pre>\nWhen the first file is created in the FRA area, Oracle creates a set of logical directories on the file location specified by the db_recovery_file_dest parameter. Its structure is as follows;
According to the above directory structure, a new directory is created every day and archive files are saved to these locations.<\/p>\n
Oracle recommends the use of FRA space for RMAN backup files and Archive Log Files. FRA area management is performed by Oracle. Backup files and archive files are stored on the same disk.<\/p>\n
When a very high level of REDO occurs, if there is no space in the FRA area; If a new REDO Log Switch operation occurs, the database will become unresponsive as there will be no more disk space.<\/p>\n
Therefore, FRA is not a preferred area of \u200b\u200buse in production databases. Instead, it is necessary to specify a space by setting LOG_ARCHIVE_DEST_N and keep it under control with SCRIPT.<\/p>\n
Find Archivelog Location<\/h4>\n You can check the Archivelog file location as follows;<\/p>\n
SQL> archive log list; (If FRA Used)\nDatabase log mode No Archive Mode\nAutomatic archival Disabled\nArchive destination USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence 19\nCurrent log sequence 21\n\n\n\nSQL> archive log list; (If FRA Not Used)\nDatabase log mode No Archive Mode\nAutomatic archival Disabled\nArchive destination \/oracle\/ora11g\/dbs\/arch\nOldest online log sequence 7247\nCurrent log sequence 7249<\/pre>\nCheck Archivelog Size<\/h4>\nSQL> show parameter db_recovery_file_dest;\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest string +FRA\ndb_recovery_file_dest_size big integer 10G<\/pre>\nCheck Archivelog Parameters<\/h4>\nSQL> show parameter log\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\naudit_syslog_level string\ncommit_logging string\ndb_create_online_log_dest_1 string\ndb_create_online_log_dest_2 string\ndb_create_online_log_dest_3 string\ndb_create_online_log_dest_4 string\ndb_create_online_log_dest_5 string\nenable_ddl_logging boolean FALSE\nlog_archive_config string\nlog_archive_dest string\nlog_archive_dest_1 string\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_10 string\nlog_archive_dest_11 string\nlog_archive_dest_12 string\nlog_archive_dest_13 string\nlog_archive_dest_14 string\nlog_archive_dest_15 string\nlog_archive_dest_16 string\nlog_archive_dest_17 string\nlog_archive_dest_18 string\nlog_archive_dest_19 string\nlog_archive_dest_2 string\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_20 string\nlog_archive_dest_21 string\nlog_archive_dest_22 string\nlog_archive_dest_23 string\nlog_archive_dest_24 string\nlog_archive_dest_25 string\nlog_archive_dest_26 string\nlog_archive_dest_27 string\nlog_archive_dest_28 string\nlog_archive_dest_29 string\nlog_archive_dest_3 string\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_30 string\nlog_archive_dest_31 string\nlog_archive_dest_4 string\nlog_archive_dest_5 string\nlog_archive_dest_6 string\nlog_archive_dest_7 string\nlog_archive_dest_8 string\nlog_archive_dest_9 string\nlog_archive_dest_state_1 string enable\nlog_archive_dest_state_10 string enable\nlog_archive_dest_state_11 string enable\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_state_12 string enable\nlog_archive_dest_state_13 string enable\nlog_archive_dest_state_14 string enable\nlog_archive_dest_state_15 string enable\nlog_archive_dest_state_16 string enable\nlog_archive_dest_state_17 string enable\nlog_archive_dest_state_18 string enable\nlog_archive_dest_state_19 string enable\nlog_archive_dest_state_2 string enable\nlog_archive_dest_state_20 string enable\nlog_archive_dest_state_21 string enable\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_state_22 string enable\nlog_archive_dest_state_23 string enable\nlog_archive_dest_state_24 string enable\nlog_archive_dest_state_25 string enable\nlog_archive_dest_state_26 string enable\nlog_archive_dest_state_27 string enable\nlog_archive_dest_state_28 string enable\nlog_archive_dest_state_29 string enable\nlog_archive_dest_state_3 string enable\nlog_archive_dest_state_30 string enable\nlog_archive_dest_state_31 string enable\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_state_4 string enable\nlog_archive_dest_state_5 string enable\nlog_archive_dest_state_6 string enable\nlog_archive_dest_state_7 string enable\nlog_archive_dest_state_8 string enable\nlog_archive_dest_state_9 string enable\nlog_archive_duplex_dest string\nlog_archive_format string RMANASM_%t_%s_%r.arc\nlog_archive_local_first boolean TRUE\nlog_archive_max_processes integer 4\nlog_archive_min_succeed_dest integer 1\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_start boolean FALSE\nlog_archive_trace integer 0\nlog_buffer integer 6815744\nlog_checkpoint_interval integer 0\nlog_checkpoint_timeout integer 1800\nlog_checkpoints_to_alert boolean FALSE\nlog_file_name_convert string\n<\/pre>\nCheck Archivelog Format<\/h4>\nSQL> show parameter log_archive_format\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_format string RMANASM_%t_%s_%r.arc<\/pre>\nHow To Enable Archivelog Mode in Oracle?<\/h2>\nDetermine where the database archive log files will be stored(for FRA);<\/h4>\nSQL> alter system set db_recovery_file_dest_size=10G scope=both;\nSQL> alter system set db_recovery_file_dest='+FRA' scope=both;<\/pre>\nDetermine where the database archive log files will be stored(File System Location);<\/h4>\nSQL> alter system set log_archive_dest_1 = 'location=\/\u2026\u2026 ' scope = both;<\/pre>\nIf you set both of above parameters, the archive log files are saved to the directory set in the LOG_ARCHIVE_DEST_N parameter, not the FRA area. You can find the detail informartion above.<\/p>\n
Set Archive Log Files Format;<\/h4>\nSQL> alter system set log_archive_format='singledb_%t_%s_%r.arc' scope=spfile;\nSystem altered.\n\nSQL> shutdown immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n\n\nSQL> startup;\nORACLE instance started.\n\nTotal System Global Area 3323752448 bytes\nFixed Size 2217912 bytes\nVariable Size 1811941448 bytes\nDatabase Buffers 1493172224 bytes\nRedo Buffers 16420864 bytes\nDatabase mounted.\nDatabase opened.\n\n\nSQL> show parameter log_archive_format\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_format string singledb_%t_%s_%r.arc<\/pre>\nCheck Archivelog File Location;<\/h4>\nSQL> archive log list; (FRA alan\u0131 kullan\u0131lm\u0131\u015fsa)\nDatabase log mode No Archive Mode\nAutomatic archival Disabled\nArchive destination USE_DB_RECOVERY_FILE_DEST\nOldest online log sequence 19\nCurrent log sequence 21\n\n\n\nSQL> archive log list; (FRA alan\u0131 kullan\u0131lmam\u0131\u015fsa)\nDatabase log mode No Archive Mode\nAutomatic archival Disabled\nArchive destination \/oracle\/ora11g\/dbs\/arch\nOldest online log sequence 7247\nCurrent log sequence 7249\n\n\n\nSQL> show parameter db_recovery_file_dest;\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest string +FRA\ndb_recovery_file_dest_size big integer 10G<\/pre>\nEnable Archivelog Mode<\/h4>\nSQL> shutdown immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n\nSQL> startup mount;\nORACLE instance started.\n\nTotal System Global Area 1653518336 bytes\nFixed Size 2213896 bytes\nVariable Size 1006635000 bytes\nDatabase Buffers 637534208 bytes\nRedo Buffers 7135232 bytes\nDatabase mounted.\n\nSQL> alter database archivelog;\n\nDatabase altered.\n\n\nSQL> alter database open;\n\nDatabase altered.\nSQL> select log_mode from v$database;\n\nLOG_MODE\n------------\nARCHIVELOG\n\nSQL><\/pre>\nDisabling Archivelog Mode<\/h4>\nSQL> shutdown immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n\nSQL> startup mount;\nORACLE instance started.\n\nTotal System Global Area 1653518336 bytes\nFixed Size 2213896 bytes\nVariable Size 1006635000 bytes\nDatabase Buffers 637534208 bytes\nRedo Buffers 7135232 bytes\nDatabase mounted.\n\nSQL> alter database noarchivelog;\n\nDatabase altered.\n\n\nSQL> alter database open;\n\nDatabase altered.\n\n\nSQL> select log_mode from v$database;\n\nLOG_MODE\n------------\nNOARCHIVELOG\n\nSQL><\/pre>\n<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"excerpt":{"rendered":"
What is Archivelog Mode in Oracle? The following operations cannot be performed until archive log mode is enabled. RMAN Online Backup Flashback Database User Managed Hot Backup ARCHIVE LOG MODE must be enabled to perform the above operations. There are some situations in the database that must be considered before enabling archivelog mode. These are …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"author":484,"featured_media":14562,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[7292,5546,7303,7289,7304,7315,7314,7301,7228,2282,7286,7279,7276,7287,7266,7230,7285,7278,7319,7311,7310,7291,7290,7277,7263,7265,7264,7296,7299,5555,7295,7297,7298,7308,7309,7307,7318,7316,7313,7306,7268,7267,7321,7305,7300,7302,7294,7293,7317,7288,7284,7229,7312,7273,7280,7269,7272,7281,7274,7283,7275,7270,7282,7271],"class_list":["post-14556","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-archive-log-size","tag-archive-log-size-script","tag-archivelog-format","tag-archivelog-location","tag-archivelog-parameters","tag-change-archivelog-mode","tag-changing-the-database-archiving-mode","tag-check-archivelog-format","tag-checking-archivelog-mode-status","tag-db_recovery_file_dest","tag-db_recovery_file_dest-vs-log_archive_dest","tag-db_recovery_file_dest-and-db_recovery_file_dest_size","tag-db_recovery_file_dest_size","tag-difference-between-db_recovery_file_dest-and-log_archive_dest","tag-disabling-archivelog","tag-disabling-archivelog-mode","tag-enable-fast-recovery-area","tag-enable-fra","tag-enable-disable-archive-log-mode","tag-enabling-and-disabling-archivelog-mode","tag-enabling-archivelog-mode","tag-find-archive-log-location","tag-find-archivelog-location","tag-fra-parameters","tag-how-do-i-enable-archivelog-mode","tag-how-do-i-turn-off-archivelog-mode","tag-how-do-i-view-archivelog-mode","tag-how-to-check-archive-log-destination-size-in-oracle","tag-how-to-check-archive-log-file-size","tag-how-to-check-archive-log-file-size-in-oracle","tag-how-to-check-archive-log-size","tag-how-to-check-size-of-archive-logs","tag-how-to-check-the-size-of-archive-logs-in-oracle","tag-how-to-disable-archivelog-mode-in-oracle","tag-how-to-enable-and-disable-archivelog-mode-in-oracle","tag-how-to-enable-archivelog-mode-in-oracle","tag-how-to-enable-disable-archive-log-mode-in-oracle","tag-how-to-put-oracle-database-in-archive-log-mode","tag-is-oracle-in-archivelog-mode","tag-log_archive_dest-parameters","tag-log_archive_dest_n","tag-log_archive_format","tag-oracle-archive-log-mode","tag-oracle-archive-log-parameters","tag-oracle-archive-log-size-per-hour","tag-oracle-archivelog-format","tag-oracle-check-archive-log-size","tag-oracle-log-archive-size","tag-put-oracle-database-in-archive-log-mode","tag-query-archivelog-location","tag-set-db_recovery_file_dest_size","tag-what-is-archivelog-mode-in-oracle","tag-what-is-archivelog-mode","tag-what-is-db_recovery_file_dest_size","tag-what-is-db_recovery_file_dest","tag-what-is-fast-recovery-area","tag-what-is-flash-recovery-area-in-oracle-11g","tag-what-is-flash-recovery-area-in-oracle","tag-what-is-fra-in-oracle","tag-what-is-fra-in-oracle-12c","tag-what-is-fra-in-oracle-database","tag-what-is-frafast-recovery-area","tag-what-is-oracle-fra-used-for","tag-what-is-the-use-of-fra-in-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":2331,"today_views":0},"yoast_head":"\n
What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode - Database Tutorials<\/title>\n<meta name=\"description\" content=\"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-03T06:25:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-03T06:25:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png\" \/>\n\t<meta property=\"og:image:width\" content=\"528\" \/>\n\t<meta property=\"og:image:height\" content=\"313\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode\",\"datePublished\":\"2020-01-03T06:25:54+00:00\",\"dateModified\":\"2020-01-03T06:25:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/\"},\"wordCount\":769,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png\",\"keywords\":[\"archive log size\",\"archive log size script\",\"archivelog format\",\"Archivelog Location\",\"archivelog parameters\",\"Change Archivelog Mode\",\"Changing the Database Archiving Mode\",\"Check Archivelog Format\",\"Checking ARCHIVELOG mode status\",\"db_recovery_file_dest\",\"DB_RECOVERY_FILE_DEST\u00a0 vs LOG_ARCHIVE_DEST\",\"DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE\",\"DB_RECOVERY_FILE_DEST_SIZE\",\"difference between DB_RECOVERY_FILE_DEST\u00a0 and LOG_ARCHIVE_DEST\",\"Disabling ARCHIVELOG\",\"Disabling ARCHIVELOG mode\",\"Enable Fast Recovery Area\",\"Enable FRA\",\"Enable\/Disable Archive Log Mode\",\"enabling and disabling archivelog mode\",\"enabling archivelog mode\",\"find archive log location\",\"Find Archivelog Location\",\"FRA parameters\",\"How do I enable Archivelog mode?\",\"How do I turn off Archivelog mode?\",\"How do I view Archivelog mode?\",\"how to check archive log destination size in oracle\",\"how to check archive log file size\",\"how to check archive log file size in oracle\",\"how to check archive log size\",\"how to check size of archive logs\",\"how to check the size of archive logs in oracle\",\"How To Disable Archivelog Mode in Oracle?\",\"How To Enable and Disable Archivelog Mode in Oracle?\",\"How To Enable Archivelog Mode in Oracle\",\"How to enable\/disable archive log mode in oracle\",\"How to put Oracle Database in ARCHIVE LOG mode?\",\"Is Oracle in Archivelog mode?\",\"log_archive_dest parameters\",\"LOG_ARCHIVE_DEST_N\",\"LOG_ARCHIVE_FORMAT\",\"Oracle Archive Log Mode\",\"oracle archive log parameters\",\"oracle archive log size per hour\",\"oracle archivelog format\",\"oracle check archive log size\",\"oracle log archive size\",\"put Oracle Database in ARCHIVE LOG mode?\",\"Query Archivelog Location\",\"set db_recovery_file_dest_size\",\"What is Archivelog mode in Oracle?\",\"What is Archivelog mode?\",\"What is Db_recovery_file_dest_size?\",\"What is Db_recovery_file_dest?\",\"What is fast recovery area?\",\"What is flash recovery area in Oracle 11g?\",\"What is flash recovery area in Oracle?\",\"What is FRA in oracle\",\"What is Fra in Oracle 12c?\",\"What is FRA in oracle database\",\"What is FRA(Fast Recovery Area)?\",\"What is Oracle FRA used for?\",\"What is the use of FRA in Oracle?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/\",\"name\":\"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png\",\"datePublished\":\"2020-01-03T06:25:54+00:00\",\"dateModified\":\"2020-01-03T06:25:56+00:00\",\"description\":\"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png\",\"width\":528,\"height\":313},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode - Database Tutorials","description":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/","og_locale":"en_US","og_type":"article","og_title":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode - Database Tutorials","og_description":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-03T06:25:54+00:00","article_modified_time":"2020-01-03T06:25:56+00:00","og_image":[{"width":528,"height":313,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode","datePublished":"2020-01-03T06:25:54+00:00","dateModified":"2020-01-03T06:25:56+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/"},"wordCount":769,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png","keywords":["archive log size","archive log size script","archivelog format","Archivelog Location","archivelog parameters","Change Archivelog Mode","Changing the Database Archiving Mode","Check Archivelog Format","Checking ARCHIVELOG mode status","db_recovery_file_dest","DB_RECOVERY_FILE_DEST\u00a0 vs LOG_ARCHIVE_DEST","DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE","DB_RECOVERY_FILE_DEST_SIZE","difference between DB_RECOVERY_FILE_DEST\u00a0 and LOG_ARCHIVE_DEST","Disabling ARCHIVELOG","Disabling ARCHIVELOG mode","Enable Fast Recovery Area","Enable FRA","Enable\/Disable Archive Log Mode","enabling and disabling archivelog mode","enabling archivelog mode","find archive log location","Find Archivelog Location","FRA parameters","How do I enable Archivelog mode?","How do I turn off Archivelog mode?","How do I view Archivelog mode?","how to check archive log destination size in oracle","how to check archive log file size","how to check archive log file size in oracle","how to check archive log size","how to check size of archive logs","how to check the size of archive logs in oracle","How To Disable Archivelog Mode in Oracle?","How To Enable and Disable Archivelog Mode in Oracle?","How To Enable Archivelog Mode in Oracle","How to enable\/disable archive log mode in oracle","How to put Oracle Database in ARCHIVE LOG mode?","Is Oracle in Archivelog mode?","log_archive_dest parameters","LOG_ARCHIVE_DEST_N","LOG_ARCHIVE_FORMAT","Oracle Archive Log Mode","oracle archive log parameters","oracle archive log size per hour","oracle archivelog format","oracle check archive log size","oracle log archive size","put Oracle Database in ARCHIVE LOG mode?","Query Archivelog Location","set db_recovery_file_dest_size","What is Archivelog mode in Oracle?","What is Archivelog mode?","What is Db_recovery_file_dest_size?","What is Db_recovery_file_dest?","What is fast recovery area?","What is flash recovery area in Oracle 11g?","What is flash recovery area in Oracle?","What is FRA in oracle","What is Fra in Oracle 12c?","What is FRA in oracle database","What is FRA(Fast Recovery Area)?","What is Oracle FRA used for?","What is the use of FRA in Oracle?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/","name":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png","datePublished":"2020-01-03T06:25:54+00:00","dateModified":"2020-01-03T06:25:56+00:00","description":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z.png","width":528,"height":313},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/03\/what-is-archivelog-mode-in-oracle-and-how-do-i-enable-and-disable-archivelog-mode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14556"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14556\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14562"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}