Shulou(Shulou.com)05/31 Report--

This article mainly explains "whether RMAN chooses to set backup properties". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "whether RMAN chooses to set backup properties".

For backup sets or backup fragments, RMAN can set their properties, including the file name, backup set size, and backup set label of the backup fragment.

1. File name of the backup fragment

By default, the BACKUP command does not need to specify a name for the backup fragment, and RMAN automatically generates a unique name for each backup fragment. The use of the FORMAT parameter is very flexible and can be specified when assigning a channel or when a backup command is executed.

(1) specify a file name when assigning a channel

RMAN > run {

ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT'/ backup/%U'

BACKUP TABLESPACE USERS

}

(2) specify a file name when performing a backup

RMAN > BACKUP TABLESPACE USERS FORMAT'/ backup/%U'

two。 Set backup set label

When backing up, you can directly assign a label to the backup set, which RMAN calls TAG. By default, you don't have to set it, and RMAN randomly assigns a TAG tag according to its own rules (default format: TAGyyyymmddThhmmss).

Of course, DBA can manually set a TAG tag.

RMAN > BACKUP TABLESPACE USERS TAG TBS_USERS

3. Set backup set size

By default, a type of file is saved as a backup fragment in the backup set, but considering that if the file is large, the resulting backup fragment may be larger or even exceed the operating system limit.

RMAN has a parameter called MAXSETSIZE when allocating channels, which is used to specify the maximum limit for backup fragments.

RMAN > BACKUP TABLESAPCE USERS MAXSETSIZE=10m

Thank you for your reading, the above is the content of "whether RMAN chooses to set backup properties". After the study of this article, I believe you have a deeper understanding of whether RMAN chooses to set backup properties, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.