{"id":49848,"date":"2022-06-07T10:43:05","date_gmt":"2022-06-07T10:43:05","guid":{"rendered":"https:\/\/dbtut.com\/?p=49848"},"modified":"2022-06-07T10:44:14","modified_gmt":"2022-06-07T10:44:14","slug":"setting-the-log-archive-trace-parameter","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/","title":{"rendered":"Setting The Log Archive Trace Parameter"},"content":{"rendered":"

In today’s article we will learn to Setting The Log Archive Trace Parameter.<\/p>\n

Although the LOG_ARCHIVE_TRACE parameter is an optional parameter, we use it for troubleshotting.<\/p>\n

This parameter shows in detail the process of sending archives sent to the Standby party.<\/p>\n

Trace files are written to the ADR (Automatic Diagnostic Repository) location. This location is as follows.<\/p>\n

[Primary] SQL> show parameter diagnostic\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndiagnostic_dest                      string      \/u01\/app\/oracle\r\n<\/pre>\n
\tADR_HOME=<diagnostic_dest>diag\/rdbms\/<db_name>\/<instance_name>\/trace\r\n<\/pre>\n
Although its default value is 0, it can take the following values. If we want more than one feature to be turned on then we add these values.<\/p>\n
\"\"<\/p>\n
LET’S TEST<\/h4>\n
1. We list the files in the ADR_HOME directory according to the processing time, according to the old.<\/p>\n
[oracle@primary trace]$ ls -alt | more\r\ntotal 2332\r\n-rw-r-----  1 oracle oinstall 579867 Feb 10 09:05 drcprimary.log\r\n-rw-r-----  1 oracle oinstall  63006 Feb 10 09:05 primary_mmon_27780.trc\r\n-rw-r-----  1 oracle oinstall   6211 Feb 10 09:05 primary_mmon_27780.trm\r\n-rw-r-----  1 oracle oinstall  63515 Feb 10 09:04 primary_lgwr_27748.trc\r\n-rw-r-----  1 oracle oinstall   6929 Feb 10 09:04 primary_lgwr_27748.trm\r\n-rw-r-----  1 oracle oinstall 143012 Feb 10 08:59 alert_primary.log\r\n-rw-r-----  1 oracle oinstall   2434 Feb 10 08:59 primary_arc3_27861.trc\r\n-rw-r-----  1 oracle oinstall    250 Feb 10 08:59 primary_arc3_27861.trm\r\n-rw-r-----  1 oracle oinstall   2135 Feb 10 08:41 primary_nsv4_9940.trc\r\n-rw-r-----  1 oracle oinstall    142 Feb 10 08:41 primary_nsv4_9940.trm\r\n-rw-r-----  1 oracle oinstall   2516 Feb 10 08:41 primary_rsm0_9983.trc\r\n-rw-r-----  1 oracle oinstall    253 Feb 10 08:41 primary_rsm0_9983.trm\r\n-rw-r-----  1 oracle oinstall   1710 Feb 10 08:41 primary_nsv1_9842.trc\r\n-rw-r-----  1 oracle oinstall    118 Feb 10 08:41 primary_nsv1_9842.trm\r\n-rw-r-----  1 oracle oinstall   2144 Feb 10 08:41 primary_arc2_27853.trc\r\n-rw-r-----  1 oracle oinstall    254 Feb 10 08:41 primary_arc2_27853.trm\r\n<\/pre>\n
2. We set the LOG_ARCHIVE_TRACE parameter to a value.<\/p>\n
DGMGRL> sql \"alter system set log_archive_trace=16 scope=both\";\r\nSucceeded.\r\nDGMGRL> exit\r\n<\/pre>\n
[oracle@primary trace]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.1.0.2.0 Production on Fri Feb 10 09:07:39 2017\r\n\r\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\r\n\r\n[Primary] SQL> show parameter log_archive_trace\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nlog_archive_trace                    integer     16\r\n<\/pre>\n
3. We list the files in the ADR_HOME directory again according to the processing time.<\/p>\n
[oracle@primary trace]$ ls -alt | more\r\ntotal 2492\r\n-rw-r-----  1 oracle oinstall 186176 Feb 10 09:08 primary_lgwr_27748.trc\r\n-rw-r-----  1 oracle oinstall   9070 Feb 10 09:08 primary_lgwr_27748.trm\r\n-rw-r-----  1 oracle oinstall  33647 Feb 10 09:08 primary_nss2_10361.trc\r\n-rw-r-----  1 oracle oinstall    952 Feb 10 09:08 primary_nss2_10361.trm\r\n-rw-r-----  1 oracle oinstall 581863 Feb 10 09:08 drcprimary.log\r\n-rw-r-----  1 oracle oinstall  10666 Feb 10 09:07 primary_arc1_27849.trc\r\n-rw-r-----  1 oracle oinstall    457 Feb 10 09:07 primary_arc1_27849.trm\r\n-rw-r-----  1 oracle oinstall 143087 Feb 10 09:07 alert_primary.log\r\n-rw-r-----  1 oracle oinstall  63006 Feb 10 09:05 primary_mmon_27780.trc\r\n-rw-r-----  1 oracle oinstall   6211 Feb 10 09:05 primary_mmon_27780.trm\r\n-rw-r-----  1 oracle oinstall   2434 Feb 10 08:59 primary_arc3_27861.trc\r\n-rw-r-----  1 oracle oinstall    250 Feb 10 08:59 primary_arc3_27861.trm\r\n-rw-r-----  1 oracle oinstall   2135 Feb 10 08:41 primary_nsv4_9940.trc\r\n-rw-r-----  1 oracle oinstall    142 Feb 10 08:41 primary_nsv4_9940.trm\r\n-rw-r-----  1 oracle oinstall   2516 Feb 10 08:41 primary_rsm0_9983.trc\r\n-rw-r-----  1 oracle oinstall    253 Feb 10 08:41 primary_rsm0_9983.trm\r\n-rw-r-----  1 oracle oinstall   1710 Feb 10 08:41 primary_nsv1_9842.trc\r\n-rw-r-----  1 oracle oinstall    118 Feb 10 08:41 primary_nsv1_9842.trm\r\n-rw-r-----  1 oracle oinstall   2144 Feb 10 08:41 primary_arc2_27853.trc\r\n-rw-r-----  1 oracle oinstall    254 Feb 10 08:41 primary_arc2_27853.trm\r\n<\/pre>\n
New files that arrive after the parameter is set are marked in blue above.<\/p>\n
4. When the log files are very large, we can search by word if we want.<\/p>\n
[oracle@primary trace]$ grep Error primary_arc1_27849.trc\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nError 1034 received logging on to the standby\r\nError 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nkrsi_verify_network: Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nError 1034 received logging on to the standby\r\nError 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nkrsi_verify_network: Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nError 1034 received logging on to the standby\r\nError 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nkrsi_verify_network: Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nError 1034 received logging on to the standby\r\nError 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nkrsi_verify_network: Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nOCISessionBegin failed. Error -1\r\nLinux-x86_64 Error: 2: No such file or directory\r\nError 1034 received logging on to the standby\r\nError 1034 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nkrsi_verify_network: Error 1034 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'prmyFS'\r\nError 3113 detaching RFS from standby instance at host 'logical'\r\nError 12537 received logging on to the standby\r\nError 12537 connecting to destination LOG_ARCHIVE_DEST_4 standby host 'logical'\r\nkrsi_verify_network: Error 12537 attaching to destination LOG_ARCHIVE_DEST_4 standby host 'logical'\r\n<\/pre>\n
5. We turn off the trace.<\/p>\n
DGMGRL> sql \"alter system set log_archive_trace=0 scope=both\";\r\nSucceeded.\r\n<\/pre>\n
[Primary] SQL> show parameter log_archive_trace\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nlog_archive_trace                    integer     0\r\n<\/pre>\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article we will learn to Setting The Log Archive Trace Parameter. Although the LOG_ARCHIVE_TRACE parameter is an optional parameter, we use it for troubleshotting. This parameter shows in detail the process of sending archives sent to the Standby party. Trace files are written to the ADR (Automatic Diagnostic Repository) location. This location is …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":49851,"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":[],"class_list":["post-49848","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nSetting The Log Archive Trace Parameter - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article we will learn to Setting The Log Archive Trace Parameter. Although the LOG_ARCHIVE_TRACE parameter is an optional parameter\" \/>\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\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting The Log Archive Trace Parameter - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article we will learn to Setting The Log Archive Trace Parameter. Although the LOG_ARCHIVE_TRACE parameter is an optional parameter\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-07T10:43:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-07T10:44:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png\" \/>\n\t<meta property=\"og:image:width\" content=\"761\" \/>\n\t<meta property=\"og:image:height\" content=\"346\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Setting The Log Archive Trace Parameter\",\"datePublished\":\"2022-06-07T10:43:05+00:00\",\"dateModified\":\"2022-06-07T10:44:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/\"},\"wordCount\":172,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/\",\"name\":\"Setting The Log Archive Trace Parameter - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png\",\"datePublished\":\"2022-06-07T10:43:05+00:00\",\"dateModified\":\"2022-06-07T10:44:14+00:00\",\"description\":\"In today's article we will learn to Setting The Log Archive Trace Parameter. Although the LOG_ARCHIVE_TRACE parameter is an optional parameter\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png\",\"width\":761,\"height\":346},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting The Log Archive Trace Parameter\"}]},{\"@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":"Setting The Log Archive Trace Parameter - Database Tutorials","description":"In today's article we will learn to Setting The Log Archive Trace Parameter. Although the LOG_ARCHIVE_TRACE parameter is an optional parameter","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\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/","og_locale":"en_US","og_type":"article","og_title":"Setting The Log Archive Trace Parameter - Database Tutorials","og_description":"In today's article we will learn to Setting The Log Archive Trace Parameter. Although the LOG_ARCHIVE_TRACE parameter is an optional parameter","og_url":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/","og_site_name":"Database Tutorials","article_published_time":"2022-06-07T10:43:05+00:00","article_modified_time":"2022-06-07T10:44:14+00:00","og_image":[{"width":761,"height":346,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Setting The Log Archive Trace Parameter","datePublished":"2022-06-07T10:43:05+00:00","dateModified":"2022-06-07T10:44:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/"},"wordCount":172,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/","url":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/","name":"Setting The Log Archive Trace Parameter - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png","datePublished":"2022-06-07T10:43:05+00:00","dateModified":"2022-06-07T10:44:14+00:00","description":"In today's article we will learn to Setting The Log Archive Trace Parameter. Although the LOG_ARCHIVE_TRACE parameter is an optional parameter","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/06\/Ekran-goruntusu-2022-06-07-134154.png","width":761,"height":346},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/06\/07\/setting-the-log-archive-trace-parameter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Setting The Log Archive Trace Parameter"}]},{"@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\/49848","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=49848"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/49848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/49851"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=49848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=49848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=49848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}