{"id":1114,"date":"2015-09-21T15:01:27","date_gmt":"2015-09-21T13:01:27","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=1114"},"modified":"2019-07-02T15:51:03","modified_gmt":"2019-07-02T13:51:03","slug":"archivlog-noarchivlog","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/09\/21\/archivlog-noarchivlog\/","title":{"rendered":"RMAN archivlog \/ noarchivlog"},"content":{"rendered":"<h2>Rman<\/h2>\n<h3>archive log mode<\/h3>\n<pre>[oracle@wctsrv0058 ~]$ . oraenv\r\nORACLE_SID = [TSH1] ? BRIDGE\r\n[oracle@wctsrv0058 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 2 13:12:04 2019\r\n\r\nCopyright (c) 1982, 2007, Oracle.  All Rights Reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 10g Release 10.2.0.4.0 - 64bit Production\r\n\r\nSQL&gt; archive log list;\r\nDatabase log mode              No Archive Mode\r\nAutomatic archival             Disabled\r\nArchive destination            \/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/arch\r\nOldest online log sequence     68\r\nCurrent log sequence           70\r\nSQL&gt; shutdown immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt; startup mount;\r\nORACLE instance started.\r\n\r\nTotal System Global Area  285212672 bytes\r\nFixed Size                  2083368 bytes\r\nVariable Size             188745176 bytes\r\nDatabase Buffers           88080384 bytes\r\nRedo Buffers                6303744 bytes\r\nDatabase mounted.\r\nSQL&gt; alter database archivelog;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database open;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; archive log list;\r\nDatabase log mode              Archive Mode\r\nAutomatic archival             Enabled\r\nArchive destination            \/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/arch\r\nOldest online log sequence     68\r\nNext log sequence to archive   70\r\nCurrent log sequence           70\r\nSQL&gt;<code><\/code><\/pre>\n<pre>alter database noarchivelog;<\/pre>\n<pre>alter database open; \r\narchive log list;\r\nalter system switch logfile;<\/pre>\n<h3>Configuration ControlFile<\/h3>\n<p>$ rman<\/p>\n<pre>connect target \/ ;\r\nshow all;\r\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\r\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\/data\/backups\/hot\/%T_%d_%F';\r\nCONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\/data\/backups\/hot\/%T_%d_%U';\r\n<\/pre>\n<p>ou<\/p>\n<pre>connect target \/ ;\r\nshow all;\r\nCONFIGURE CONTROLFILE AUTOBACKUP ON;\r\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\/backups\/%d\/hot\/%T_%d_%F';\r\nCONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\/backups\/%d\/hot\/%T_%d_%U';<\/pre>\n<h3>rman backup<\/h3>\n<h6>manual<\/h6>\n<pre>crosscheck backup;\r\ncrosscheck archivelog all;\r\ndelete noprompt expired backup;\r\ndelete noprompt expired archivelog all;\r\ndelete noprompt obsolete;\r\n\r\nbackup incremental level 0 tag 'database level 0' database plus archivelog tag 'archives level 0';\r\ndelete noprompt obsolete;\r\n\r\nreport need backup;\r\nlist backup summary;\r\n<\/pre>\n<div class=\"contextual\" title=\"Modifier cette section\"><\/div>\n<h6>script<\/h6>\n<p><strong>Cold<\/strong><\/p>\n<pre> .\/stop_database.sh BIPRD\r\n .\/backup_cold_BIPRD.sh\r\n .\/start_database.sh BIPRD\r\n<\/pre>\n<p><strong>Hot<\/strong><\/p>\n<pre> sauve_hot.sh BIPRD<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Rman archive log mode [oracle@wctsrv0058 ~]$ . oraenv ORACLE_SID = [TSH1] ? BRIDGE [oracle@wctsrv0058 ~]$ sqlplus \/ as sysdba SQL*Plus: Release 10.2.0.4.0 &#8211; Production on Tue Jul 2 13:12:04 2019 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Release 10.2.0.4.0 &#8211; 64bit Production SQL&gt; archive log list; Database log mode &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/09\/21\/archivlog-noarchivlog\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;RMAN archivlog \/ noarchivlog&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30,37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1114"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1114"}],"version-history":[{"count":7,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1114\/revisions"}],"predecessor-version":[{"id":2220,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1114\/revisions\/2220"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1114"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}