rman multisection backup试验之一

multisection backup是Oracle11g(确切的说是从11.1.0.6开始)的新特性,见mos文章

MultiSection Backups (文档 ID 406295.1)

下面来做实验:

[oracle@rhel63single ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 – Production on Thu Feb 19 01:07:28 2015Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: TEST (DBID=2106028980)RMAN> report schema;using target database control file instead of recovery catalogReport of database schema for database with db_unique_name TESTList of Permanent Datafiles===========================File Size(MB) TablespaceRB segs Datafile Name—- ——– ——————– ——- ————————1 800SYSTEM***/u01/app/oracle/oradata/test/system01.dbf2 3310SYSAUX***/u01/app/oracle/oradata/test/sysaux01.dbf3 240UNDOTBS1***/u01/app/oracle/oradata/test/undotbs01.dbf4 7USERS***/u01/app/oracle/oradata/test/users01.dbf5 50TENTBS***/u01/app/oracle/oradata/test/ten01.dbf6 5TB_TEST***/u01/app/oracle/oradata/test/tb_test_01.dbf7 500TS1***/u01/app/oracle/oradata/test/ts1.dbf8 500TS2***/u01/app/oracle/oradata/test/ts2.dbf9 50TEST***/u01/app/oracle/oradata/test/test01.dbf10 50TEST_UNI_SZ_2M***/u01/app/oracle/oradata/test/test_uni_sz_2m_01.dbf11 200TEST_UNI_SZ_1M***/u01/app/oracle/oradata/test/test_uni_sz_1m_01.dbfList of Temporary Files=======================File Size(MB) TablespaceMaxsize(MB) Tempfile Name—- ——– ——————– ———– ——————–1 157TEMP32767/u01/app/oracle/oradata/test/temp01.dbfRMAN> show all;RMAN configuration parameters for database with db_unique_name TEST are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_test.f'; # defaultRMAN> backup section size 300m datafile 1 format '/u02/%U';Starting backup at 19-FEB-15allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=133 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf —->system01.dbfbacking up blocks 1 through 38400—————————————————>注意此处channel ORA_DISK_1: starting piece 1 at 19-FEB-15channel ORA_DISK_1: finished piece 1 at 19-FEB-15piece handle=/u02/06pvkh2l_1_1 tag=TAG20150219T011148 comment=NONE——————>生成的backuppiecechannel ORA_DISK_1: backup set complete, elapsed time: 00:00:28channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf —->system01.dbfbacking up blocks 38401 through 76800———————————————–>注意此处channel ORA_DISK_1: starting piece 2 at 19-FEB-15channel ORA_DISK_1: finished piece 2 at 19-FEB-15piece handle=/u02/06pvkh2l_2_1 tag=TAG20150219T011148 comment=NONE——————>生成的backuppiecechannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/test/system01.dbf —->system01.dbfbacking up blocks 76801 through 102400———————————————->注意此处channel ORA_DISK_1: starting piece 3 at 19-FEB-15channel ORA_DISK_1: finished piece 3 at 19-FEB-15piece handle=/u02/06pvkh2l_3_1 tag=TAG20150219T011148 comment=NON——————>生成的backuppiecechannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setincluding current control file in backup setincluding current SPFILE in backup setchannel ORA_DISK_1: starting piece 1 at 19-FEB-15channel ORA_DISK_1: finished piece 1 at 19-FEB-15piece handle=/u02/09pvkh4o_1_1 tag=TAG20150219T011148 comment=NONE —>这个backuppiece是控制文件的自动备份,因为datafile1的备份会自动触发控制文件的备份。channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 19-FEB-15RMAN> 停止每日在车水马龙的市井里忙碌的穿梭,

rman multisection backup试验之一

相关文章:

你感兴趣的文章:

标签云: