===============================
backupset의 병렬화
===============================
RMAN> create script parall_backup {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
backup
incremental level = 0
format '/BACKUP/df_%d_%s_%p.bak'
(datafile 1 channel c1)
(datafile 2 channel c2)
(datafile 3,4,5,6 channel c3);
sql 'alter system archive log current';
release channel c1;
release channel c2;
release channel c3;
}
created script parall_backup
RMAN> run {execute script parall_backup;}
executing script: parall_backup
allocated channel: c1
channel c1: SID=27 device type=DISK
allocated channel: c2
channel c2: SID=150 device type=DISK
allocated channel: c3
channel c3: SID=28 device type=DISK
Starting backup at 2015-10-13:15:22:40
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
channel c1: starting piece 1 at 2015-10-13:15:22:40
channel c2: starting incremental level 0 datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
channel c2: starting piece 1 at 2015-10-13:15:22:40
channel c3: starting incremental level 0 datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/rman_tbs.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel c3: starting piece 1 at 2015-10-13:15:22:40
channel c1: finished piece 1 at 2015-10-13:15:23:05
piece handle=/BACKUP/df_ORCL_87_1.bak tag=TAG20151013T152240 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:25
channel c2: finished piece 1 at 2015-10-13:15:23:05
piece handle=/BACKUP/df_ORCL_88_1.bak tag=TAG20151013T152240 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:25
channel c3: finished piece 1 at 2015-10-13:15:23:05
piece handle=/BACKUP/df_ORCL_89_1.bak tag=TAG20151013T152240 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:25
Finished backup at 2015-10-13:15:23:05
Starting Control File and SPFILE Autobackup at 2015-10-13:15:23:05
piece handle=/BACKUP/rman_con/c-1420439357-20151013-08 comment=NONE
Finished Control File and SPFILE Autobackup at 2015-10-13:15:23:07
sql statement: alter system archive log current
released channel: c1
released channel: c2
released channel: c3
[oracle@lnx04 ~]$ rtc debug trace rmantrace.trc
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Oct 13 15:53:57 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: ORCL (DBID=1420439357)
RMAN-06008: connected to recovery catalog database
RMAN> show all;
RMAN-06607: RMAN configuration parameters for database with db_unique_name ORCL are:
RMAN-01005: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
RMAN-01005: CONFIGURE BACKUP OPTIMIZATION ON;
RMAN-01005: CONFIGURE DEFAULT DEVICE TYPE TO DISK;
RMAN-01005: CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN-01005: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/BACKUP/rman_con/%F';
RMAN-01005: CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
RMAN-01005: CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN-01005: CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN-01005: CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 100 M FORMAT '/BACKUP/rman/%d_%s_%p';
RMAN-01005: CONFIGURE MAXSETSIZE TO 2 G;
RMAN-01005: CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
RMAN-01005: CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
RMAN-01005: CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
RMAN-01005: CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
RMAN-01005: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f'; # default
RMAN> exit
Recovery Manager complete.
'스터디북' 카테고리의 다른 글
| [10/13] admin 기본 연습 (0) | 2015.10.13 |
|---|---|
| [10/13] 실습 - 4 Flashback query, versions query, transaction query (0) | 2015.10.13 |
| [10/13] 실습 - 2 RMAN을 이용한 Duplicate 복제 DB 생성 (0) | 2015.10.13 |
| [10/13] 실습 - 1 RMAN - current redolog file (0) | 2015.10.13 |
| [10/13] 정리 (0) | 2015.10.13 |