Si vous souhaitez activer le mode archive log dans votre base de donn\u00e9es Oracle parce que vous voulez sauvegarder votre base de donn\u00e9es pendant qu'elle est ouverte, vous devez suivre ces \u00e9tapes simples.<\/p>\n\n\n\n
Sachez que vous devrez red\u00e9marrer votre base de donn\u00e9es.<\/p>\n\n\n\n
Nous y voil\u00e0.<\/p>\n\n\n\n\n\n\n\n
Vous devez d'abord vous connecter en tant que sysdba et effectuer quelques v\u00e9rifications.<\/p>\n\n\n
\nsqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 10 12:09:10 2021\nVersion 19.8.0.0.0\n\nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.8.0.0.0\n\nSQL> SELECT LOG_MODE FROM V$DATABASE;\n\nLOG_MODE\n------------\nNOARCHIVELOG\n\nSQL> show parameter LOG_ARCHIVE_DEST_1\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_1 string\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\n\nSQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both;\n\nSystem altered.\n<\/pre><\/div>\n\n\nVous devez maintenant arr\u00eater la base de donn\u00e9es Oracle et la monter.<\/p>\n\n\n
\nSQL> SHUTDOWN IMMEDIATE\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n\nSQL> STARTUP MOUNT\nORACLE instance started.\n\nTotal System Global Area 1073738888 bytes\nFixed Size 9143432 bytes\nVariable Size 532676608 bytes\nDatabase Buffers 524288000 bytes\nRedo Buffers 7630848 bytes\nDatabase mounted.\n\nSQL> ALTER DATABASE ARCHIVELOG;\n\nDatabase altered.\n\nSQL> ALTER DATABASE OPEN;\n\nDatabase altered.\n\nSQL> ALTER SYSTEM SWITCH LOGFILE;\n\nSystem altered.\n<\/pre><\/div>\n\n\nVous pouvez maintenant v\u00e9rifier que le mode d'archivage est activ\u00e9 dans votre base de donn\u00e9es Oracle.<\/p>\n\n\n
\nSQL> SELECT NAME FROM V$ARCHIVED_LOG;\n\nNAME\n--------------------------------------------------------------------------------\n\/u01\/app\/oracle\/fra\/ORADB\/archivelog\/2021_04_10\/o1_mf_1_19_j72qftrw_.arc\n\nSQL> SELECT LOG_MODE FROM V$DATABASE;\n\nLOG_MODE\n------------\nARCHIVELOG\n\nSQL> show parameter LOG_ARCHIVE_DEST_1\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_\n DEST\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\n<\/pre><\/div>\n\n\nJ'esp\u00e8re que cela vous a \u00e9t\u00e9 utile.<\/p>","protected":false},"excerpt":{"rendered":"
Si vous souhaitez activer le mode archive log dans votre base de donn\u00e9es Oracle parce que vous voulez sauvegarder votre base de donn\u00e9es pendant qu'elle est ouverte, vous devez suivre ces \u00e9tapes simples. Sachez que vous devrez red\u00e9marrer votre base de donn\u00e9es. Nous y voil\u00e0.<\/p>","protected":false},"author":1,"featured_media":2927,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"enable archive log mode in oracle 19c","rank_math_title":"","rank_math_description":"Enable archive log mode in Oracle 19c effortlessly. Follow this step-by-step tutorial to activate archive log mode in Oracle 19c.","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[77,78],"class_list":["post-1618","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-archive","tag-backup"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-688660.jpeg?fit=1733%2C1300&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1618","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=1618"}],"version-history":[{"count":8,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1618\/revisions"}],"predecessor-version":[{"id":1626,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1618\/revisions\/1626"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2927"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=1618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=1618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=1618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}