{"id":875,"date":"2013-10-05T20:08:32","date_gmt":"2013-10-05T17:08:32","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=875"},"modified":"2013-10-05T20:36:13","modified_gmt":"2013-10-05T17:36:13","slug":"oracle-rman-backup-format-string-clause","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-rman-backup-format-string-clause\/","title":{"rendered":"Oracle Rman Backup Format String Clause"},"content":{"rendered":"

Rman Configure<\/strong><\/p>\n

RMAN> configure channel device type disk format ‘\/backup\/backup_%d_s%s_p%p_%T’;<\/p><\/blockquote>\n

%c<\/strong> The copy number of the backup piece within a set of duplexed backup pieces. If you did not duplex a backup, then this variable is 1 for backup sets and 0 for proxy copies. If one of these commands is enabled, then the variable shows the copy number. The maximum value for %c is 256.<\/p>\n

%d<\/strong> The name of the database.<\/p>\n

%D<\/strong> The current day of the month (in format DD)<\/p>\n

%F<\/strong> Combination of DBID, day, month, year, and sequence into a unique and repeatable generated name.<\/p>\n

%M<\/strong> The month (format MM)<\/p>\n

%n The name of the database, padded on the right with x characters to a total length of eight characters. (AKA: Porn star alias name) For example, if the scott is the database name, %n= scottxxx.<\/p>\n

%p<\/strong> The piece number within the backup set. This value starts at 1 for each backup set and is incremented by 1 as each backup piece is created. Note: If you specify PROXY, then the %p variable must be included in the FORMAT string either explicitly or implicitly within %U.<\/p>\n

%s<\/strong> The backup set number. This number is a counter in the control file that is incremented for each backup set. The counter value starts at 1 and is unique for the lifetime of the control file. If you restore a backup control file, then duplicate values can result. Also, CREATE CONTROLFILE initializes the counter back to 1.<\/p>\n

%t<\/strong> The backup set time stamp, which is a 4-byte value derived as the number of seconds elapsed since a fixed reference time. The combination of %s and %t can be used to form a unique name for the backup set.<\/p>\n

%T<\/strong> The year, month, and day (YYYYMMDD)<\/p>\n

%u<\/strong> An 8-character name constituted by compressed representations of the backup set number and the time the backup set was created.<\/p>\n

%U<\/strong> A convenient shorthand for %u_%p_%c that guarantees uniqueness in generated backup filenames. If you do not specify a format, RMAN uses %U by default.<\/p>\n

%Y<\/strong> The year (YYYY)<\/p>\n","protected":false},"excerpt":{"rendered":"

Rman Configure RMAN> configure channel device type disk format ‘\/backup\/backup_%d_s%s_p%p_%T’; %c The copy number of the backup piece within a set of duplexed backup pieces. If you did not duplex a backup, then this variable is 1 for backup sets and 0 for proxy copies. If one of these commands is enabled, then the variable…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"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":[20],"tags":[90,32,48],"class_list":["post-875","post","type-post","status-publish","format-standard","hentry","category-oracle-backup-and-recovery","tag-oracle","tag-oracle-administration","tag-oracle-rman-backup"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-e7","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=875"}],"version-history":[{"count":4,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/875\/revisions"}],"predecessor-version":[{"id":879,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/875\/revisions\/879"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=875"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}