Oracle Tutorial: Rman detailed

1, set up concurrent to perform Rman backup

1) Manual Configuration

run{

Allocate channel C1 type disk;

Allocate channel C2 type disk;

Allocate channel C3 type disk;

Backup database format ' C:\rman\d_%U_%p.bak '

tag= ' Xifenfei ';

}

2) configuration in Parameters

Configure device type disk parallelism 3 backup type to backupset;

Backup database format ' c:\rman\d_%U.bak ' tag= ' Xifenfei ';

2. Set backup file size

run{Allocate channel C1 type disk maxpiecesize 100m;

Backup database format ' C:\rman\test_%U_%p.bak ' Filesperset 2 maxsetsize 500m;}

note:maxpiecesize– Single backup file size

filesperset– the number of datafile contained in a backset

The size of the Maxsetsize–backset

3. Backup control files

1) Configure automatic backup

Configure Controlfile autobackup on;

rman> CONFIGURE controlfile autobackup FORMAT for

DEVICE TYPE DISK to ' c:\rman\cl_%F.ctl ';

2) Backup by incidentally backup

Backup datafile 5 format ' C:\rman\d_%U.bak '

Include current controlfile;

4. Multiple copies of one backup (up to four copies)

1) Direct designation

Backup copies 2 datafile 5 format

' C:\rman\%U.bak ', ' C:\temp\%U.bak ';

2) specified in the configuration file

CONFIGURE datafile BACKUP copies for DEVICE TYPE DISK to 2;

Backup datafile 5 format ' C:\temp\t_%U.bak ', ' C:\rman\t_%U.bak ';

Oracle Video Tutorials Please focus on: http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/