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

Xiaobian to share with you how to allocate channels, I believe most people do not know how, so share this article for everyone's reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

RMAN supports two backup devices: SBT (tape) and DISK (disk). The relationship between channels and equipment is close, and the allocation of channels is based on equipment.

Channels can be assigned manually or automatically in RMAN.

1. Manual channel assignment

Manual channel allocation has a special command: ALLOCATE CHANNEL, which can only appear in the RUN block. When executing backup/restore and other commands that require disk I/O operations, you can put them and ALLOCATE CHANNEL commands in a RUN block and allocate channels for them by ALLOCATE CHANNEL.

After manually assigning channels, you need to release these channels before the end of the RUN block. You can release channels by using the RELEASE CHANNEL command.

2. automatic channel assignment

If there is no channel ALLOCATE CHANNEL command to manually allocate channels, then when an I/O command such as BACKUP is executed, RMAN automatically allocates channels using the settings in the predefined configuration.

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

3. Do you need to assign channels

An RMAN channel is essentially a stream of data to the storage device, and whether to configure a channel and how many channels to configure can be determined based on the time of backup. Configuring channels is a great way to configure backups when they take longer than expected.

4. example

run

{

allocate channel c1 type disk;

allocate channel c2 type disk;

backup database ;

release channel c1;

release channel c2;

}

The above is all the content of this article,"How to allocate channels by RMAN." Thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

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.