Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these multiple channels. As far as you’re using Enterprise Edition because Standard Edition is stuck to a single channel.<\/p>\n
Disk space is very often limited and you’ll probably have to find another solution to keep backups longuer if you want to. You can think about tapes or you can connect RMAN to a global backup tool, but it requires additional libraries that are not free, and it definitely adds complexity.<\/p>\n
The other solution is to have dual disk destination for the backups. The first one will be the main destination for your daily backups, the other one will be dedicated to long-term backups, maybe on slower disks but with more free space available. This second destination can eventualy be backed up with another tool without using any library.<\/p>\n
For the demonstration, assume you have 2 filesystems, \/backup is dedicated to latest daily backups and \/lt_backup is for long-term backups.<\/p>\n
du -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n4.0K backup\nls: cannot access backup\/*: No such file or directory\n\n4.0K lt_backup\nls: cannot access lt_backup\/*: No such file or directory<\/pre>\n<\/p>\n
First of all, take a backup on the first destination:<\/p>\n
RMAN> backup as compressed backupset database format '\/oracle\/backup\/%U';<\/pre>\n<\/p>\n
This is a small database and backup is done with the default single channel, so there is only two backupsets, one for the datafiles and the other for the controlfile and the spfile:<\/p>\n
du -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n162M backup\n-rw-r-----. 1 oracle oinstall 168067072 Aug 15 01:27 backup\/2btaj0mt_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:27 backup\/2ctaj0nm_1_1\n\n4.0K lt_backup\nls: cannot access lt_backup\/*: No such file or directory<\/pre>\n<\/p>\n
It’s quite easy to move the backup to the long term destination with RMAN:<\/p>\n
RMAN> backup backupset all format '\/oracle\/lt_backup\/%U' delete input;<\/pre>\n<\/p>\n
BACKUP BACKUPSET with DELETE INPUT is basically the same as a system mv or move. But it does not require to recatalog the backup files as RMAN is doing this automatically.<\/p>\n
Now our backup is located in the second destination:<\/p>\n
du -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n4.0K backup\nls: cannot access backup\/*: No such file or directory\n\n162M lt_backup\n-rw-r-----. 1 oracle oinstall 168067072 Aug 15 01:28 lt_backup\/2btaj0mt_1_2\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:28 lt_backup\/2ctaj0nm_1_2<\/pre>\n<\/p>\n
You can see here that backup filename has changed: last number increased. Oracle knows that this is the second copy of these backupsets (even the first ones don’t exist anymore).<\/p>\n
Like a mv command you can put again your backup in previous destination:<\/p>\n
RMAN> backup backupset all format '\/oracle\/backup\/%U' delete input;\n\n162M backup\n-rw-r-----. 1 oracle oinstall 168067072 Aug 15 01:29 backup\/2btaj0mt_1_3\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:29 backup\/2ctaj0nm_1_3\n\n4.0K lt_backup\nls: cannot access lt_backup\/*: No such file or directory<\/pre>\n<\/p>\n
All the backupsets are now back to the first destination only, and you can see another increase on the filename. And RMAN catalog is up-to-date.<\/p>\n
Now let’s make the first folder the default destination for the backups, and go for compressed backupset as a default behavior:<\/p>\n
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET ;\nRMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\/oracle\/backup\/%U';<\/pre>\n<\/p>\n
Now you only need a 2-word command to backup the database:<\/p>\n
RMAN> backup database;<\/pre>\n<\/p>\n
New backup is in first destination as expected:<\/p>\n
du -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n323M backup\n-rw-r-----. 1 oracle oinstall 168067072 Aug 15 01:29 backup\/2btaj0mt_1_3\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:29 backup\/2ctaj0nm_1_3\n-rw-r-----. 1 oracle oinstall 168050688 Aug 15 01:35 backup\/2dtaj15o_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:35 backup\/2etaj16h_1_1\n\n4.0K lt_backup\nls: cannot access lt_backup\/*: No such file or directory<\/pre>\n<\/p>\n
Suppose you want to move the oldest backups, those done before 1.30AM:<\/p>\n
RMAN> backup backupset completed before 'TRUNC(SYSDATE)+1.5\/24' format '\/oracle\/lt_backup\/%U' delete input;<\/pre>\n<\/p>\n
Everything is working as expected, latest backup is still in the first destination, and the oldest one is in the lt_backup filesystem. With another increase of the number ending the filename:<\/p>\n
du -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n162M backup\n-rw-r-----. 1 oracle oinstall 168050688 Aug 15 01:35 backup\/2dtaj15o_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:35 backup\/2etaj16h_1_1\n\n162M lt_backup\n-rw-r-----. 1 oracle oinstall 168067072 Aug 15 01:38 lt_backup\/2btaj0mt_1_4\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:38 lt_backup\/2ctaj0nm_1_4<\/pre>\n<\/p>\n
Now that the tests are OK, let’s simulate a real world example. First, tidy up all the backups:<\/p>\n
RMAN> delete noprompt backupset;<\/pre>\n<\/p>\n
Let’s take a new backup.<\/p>\n
RMAN> backup database;<\/pre>\n<\/p>\n
Backup is in default destination:<\/p>\n
du -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n162M backup\n-rw-r-----. 1 oracle oinstall 168050688 Aug 15 01:43 backup\/2ftaj1lv_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:43 backup\/2gtaj1mo_1_1\n\n4.0K lt_backup\nls: cannot access lt_backup\/*: No such file or directory<\/pre>\n<\/p>\n
Let’s take another backup later:<\/p>\n
RMAN> backup database;\n\ndu -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n323M backup\n-rw-r-----. 1 oracle oinstall 168050688 Aug 15 01:43 backup\/2ftaj1lv_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 01:43 backup\/2gtaj1mo_1_1\n-rw-r-----. 1 oracle oinstall 168181760 Aug 15 02:00 backup\/2htaj2m4_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 02:01 backup\/2itaj2mt_1_1\n\n4.0K lt_backup\nls: cannot access lt_backup\/*: No such file or directory<\/pre>\n<\/p>\n
Now let’s move the oldest backup to the other folder:<\/p>\n
RMAN> backup backupset completed before 'TRUNC(SYSDATE)+2\/24' format '\/oracle\/lt_backup\/%U' delete input;\n\ndu -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n162M backup\n-rw-r-----. 1 oracle oinstall 168181760 Aug 15 02:00 backup\/2htaj2m4_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 02:01 backup\/2itaj2mt_1_1\n\n162M lt_backup\n-rw-r-----. 1 oracle oinstall 168050688 Aug 15 02:02 lt_backup\/2ftaj1lv_1_2\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 02:02 lt_backup\/2gtaj1mo_1_2<\/pre>\n<\/p>\n
Storing only the oldest backups in the long-term destination is not so clever, imagine you loose your first backup destination? It could be great to have the latest backup in both destinations. You can do that with a BACKUP BACKUPSET COMPLETED AFTER and no DELETE INPUT for basically the same as a cp or copy command:<\/p>\n
RMAN> backup backupset completed after 'TRUNC(SYSDATE)+2\/24' format '\/oracle\/lt_backup\/%U';\n\ndu -hs backup; ls -lrt backup\/* | tail -n 8 ; echo ;du -hs lt_backup; ls -lrt lt_backup\/* | tail -n 8\n\n162M backup\n-rw-r-----. 1 oracle oinstall 168181760 Aug 15 02:00 backup\/2htaj2m4_1_1\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 02:01 backup\/2itaj2mt_1_1\n\n323M lt_backup\n-rw-r-----. 1 oracle oinstall 168050688 Aug 15 02:02 lt_backup\/2ftaj1lv_1_2\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 02:02 lt_backup\/2gtaj1mo_1_2\n-rw-r-----. 1 oracle oinstall 168181760 Aug 15 02:03 lt_backup\/2htaj2m4_1_2\n-rw-r-----. 1 oracle oinstall 1130496 Aug 15 02:03 lt_backup\/2itaj2mt_1_2<\/pre>\n<\/p>\n
That’s it, you now have a first destination for newest backups, and a second one for all the backups. And you just have to schedule these 2 BACKUP BACKUPSET after your daily backup of your database.<\/p>\n
Note that backups will stay in both destinations until they reach the retention limit you defined for your database. The DELETE OBSOLETE will purge the backupsets wherever they are and delete all the known copies.<\/p>\n","protected":false},"excerpt":{"rendered":"
Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these multiple channels. As far as you’re using Enterprise Edition because Standard Edition is stuck to […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,59],"tags":[1433,60,61,1434,1435,1436,96,270],"type_dbi":[],"class_list":["post-11574","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-11g","tag-12c","tag-18c","tag-backup-backupset","tag-dual-destination","tag-multiple-destination","tag-oracle","tag-rman"],"acf":[],"yoast_head":"\n
Easily manage dual backup destination with RMAN - dbi Blog<\/title>\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.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Easily manage dual backup destination with RMAN\" \/>\n<meta property=\"og:description\" content=\"Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these multiple channels. As far as you’re using Enterprise Edition because Standard Edition is stuck to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-15T13:40:35+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"Easily manage dual backup destination with RMAN\",\"datePublished\":\"2018-08-15T13:40:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/\"},\"wordCount\":641,\"commentCount\":2,\"keywords\":[\"11g\",\"12c\",\"18c\",\"backup backupset\",\"dual destination\",\"multiple destination\",\"Oracle\",\"RMAN\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/\",\"name\":\"Easily manage dual backup destination with RMAN - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2018-08-15T13:40:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/easily-manage-dual-backup-destination-with-rman\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Easily manage dual backup destination with RMAN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0fb4bbf128b4cda2f96d662dec2baedd\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\\\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/jerome-dubar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Easily manage dual backup destination with RMAN - dbi Blog","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.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/","og_locale":"en_US","og_type":"article","og_title":"Easily manage dual backup destination with RMAN","og_description":"Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these multiple channels. As far as you’re using Enterprise Edition because Standard Edition is stuck to […]","og_url":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/","og_site_name":"dbi Blog","article_published_time":"2018-08-15T13:40:35+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"Easily manage dual backup destination with RMAN","datePublished":"2018-08-15T13:40:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/"},"wordCount":641,"commentCount":2,"keywords":["11g","12c","18c","backup backupset","dual destination","multiple destination","Oracle","RMAN"],"articleSection":["Database Administration & Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/","url":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/","name":"Easily manage dual backup destination with RMAN - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-08-15T13:40:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/easily-manage-dual-backup-destination-with-rman\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Easily manage dual backup destination with RMAN"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11574","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11574"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11574\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11574"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}