{"id":4507,"date":"2024-03-14T01:33:19","date_gmt":"2024-03-14T01:33:19","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/"},"modified":"2025-07-31T08:55:18","modified_gmt":"2025-07-31T08:55:18","slug":"what-is-the-method-for-scheduling-pl-sql-backups","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/","title":{"rendered":"Schedule PL\/SQL Backups with DBMS_SCHEDULER"},"content":{"rendered":"<p>There are many ways to implement scheduled backups in PL\/SQL, one commonly used method is to use the DBMS_SCHEDULER package to create and manage scheduled tasks. Below is an example code for creating a scheduled backup task.<\/p>\n<pre class=\"post-pre\"><code class=\"lang-sql\">-- \u521b\u5efa\u5b9a\u65f6\u4efb\u52a1\r\nBEGIN\r\n  DBMS_SCHEDULER.create_job (\r\n    job_name        =&gt; 'backup_job',\r\n    job_type        =&gt; 'PLSQL_BLOCK',\r\n    job_action      =&gt; 'BEGIN my_backup_procedure; END;',\r\n    start_date      =&gt; SYSTIMESTAMP,\r\n    repeat_interval =&gt; 'FREQ=DAILY; BYHOUR=0; BYMINUTE=0; BYSECOND=0',\r\n    enabled         =&gt; TRUE\r\n  );\r\nEND;\r\n\r\n-- \u5907\u4efd\u8fc7\u7a0b\r\nCREATE OR REPLACE PROCEDURE my_backup_procedure IS\r\nBEGIN\r\n  -- \u6267\u884c\u5907\u4efd\u64cd\u4f5c\uff0c\u4f8b\u5982\u4f7f\u7528RMAN\u547d\u4ee4\u5907\u4efd\u6570\u636e\u5e93\r\n  EXECUTE IMMEDIATE 'rman target \/ &lt;&lt;EOF\r\n    BACKUP DATABASE PLUS ARCHIVELOG;\r\n  EOF';\r\nEND;\r\n\/\r\n<\/code><\/pre>\n<p>In the example above, we first created a scheduled job named &#8220;backup_job&#8221; using the create_job procedure of the DBMS_SCHEDULER package. This job is scheduled to run at midnight every day and will call the my_backup_procedure to perform a backup operation. The backup operation will use the EXECUTE IMMEDIATE statement to execute RMAN commands for backing up the database.<\/p>\n<p>It is important to note that in order to successfully perform a backup operation, the database user needs to have the permission to execute RMAN commands. Additionally, the execution of scheduled tasks is also subject to whether the database scheduler service is enabled and functioning properly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are many ways to implement scheduled backups in PL\/SQL, one commonly used method is to use the DBMS_SCHEDULER package to create and manage scheduled tasks. Below is an example code for creating a scheduled backup task. &#8212; \u521b\u5efa\u5b9a\u65f6\u4efb\u52a1 BEGIN DBMS_SCHEDULER.create_job ( job_name =&gt; &#8216;backup_job&#8217;, job_type =&gt; &#8216;PLSQL_BLOCK&#8217;, job_action =&gt; &#8216;BEGIN my_backup_procedure; END;&#8217;, start_date =&gt; [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[4180,1878,2777,813,321],"class_list":["post-4507","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-automated-backup","tag-database-backup","tag-dbms_scheduler","tag-oracle-database","tag-pl-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Schedule PL\/SQL Backups with DBMS_SCHEDULER - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to schedule automated PL\/SQL backups using Oracle&#039;s DBMS_SCHEDULER package. Step-by-step guide with code examples for database administrators.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Schedule PL\/SQL Backups with DBMS_SCHEDULER\" \/>\n<meta property=\"og:description\" content=\"Learn how to schedule automated PL\/SQL backups using Oracle&#039;s DBMS_SCHEDULER package. Step-by-step guide with code examples for database administrators.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T01:33:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T08:55:18+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"Schedule PL\/SQL Backups with DBMS_SCHEDULER\",\"datePublished\":\"2024-03-14T01:33:19+00:00\",\"dateModified\":\"2025-07-31T08:55:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/\"},\"wordCount\":155,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Automated backup\",\"database backup\",\"DBMS_SCHEDULER\",\"Oracle database\",\"PL\/SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/\",\"name\":\"Schedule PL\/SQL Backups with DBMS_SCHEDULER - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T01:33:19+00:00\",\"dateModified\":\"2025-07-31T08:55:18+00:00\",\"description\":\"Learn how to schedule automated PL\/SQL backups using Oracle's DBMS_SCHEDULER package. Step-by-step guide with code examples for database administrators.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Schedule PL\/SQL Backups with DBMS_SCHEDULER\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Schedule PL\/SQL Backups with DBMS_SCHEDULER - Blog - Silicon Cloud","description":"Learn how to schedule automated PL\/SQL backups using Oracle's DBMS_SCHEDULER package. Step-by-step guide with code examples for database administrators.","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:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/","og_locale":"en_US","og_type":"article","og_title":"Schedule PL\/SQL Backups with DBMS_SCHEDULER","og_description":"Learn how to schedule automated PL\/SQL backups using Oracle's DBMS_SCHEDULER package. Step-by-step guide with code examples for database administrators.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T01:33:19+00:00","article_modified_time":"2025-07-31T08:55:18+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"Schedule PL\/SQL Backups with DBMS_SCHEDULER","datePublished":"2024-03-14T01:33:19+00:00","dateModified":"2025-07-31T08:55:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/"},"wordCount":155,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Automated backup","database backup","DBMS_SCHEDULER","Oracle database","PL\/SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/","name":"Schedule PL\/SQL Backups with DBMS_SCHEDULER - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T01:33:19+00:00","dateModified":"2025-07-31T08:55:18+00:00","description":"Learn how to schedule automated PL\/SQL backups using Oracle's DBMS_SCHEDULER package. Step-by-step guide with code examples for database administrators.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-scheduling-pl-sql-backups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Schedule PL\/SQL Backups with DBMS_SCHEDULER"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4507"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4507\/revisions"}],"predecessor-version":[{"id":149174,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4507\/revisions\/149174"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}