--rman连接目标数据库
[oracle@S1011:/export/home/oracle]$ rman target/
Recovery Manager:Release11.2.0.3.0-ProductiononTue Aug1317:15:412013
Copyright(c)1982,2011,Oracleand/orits affiliates.Allrights reserved.
connectedtotarget database:TESTDB11(DBID=2578856066)
RMAN>
--执行实例管理命令
RMAN>shutdownimmediate;
usingtarget database controlfileinsteadofrecoverycatalog
database closed
database dismounted
Oracle instance shut down
RMAN>startup mount;
connectedtotarget database(notstarted)
Oracle instance started
database mounted
Total SystemGlobalArea855982080bytes
FixedSize2230792bytes
VariableSize641730040bytes
Database Buffers209715200bytes
Redo Buffers2306048bytes
RMAN>opendatabase;
database opened
--执行SQL语句
RMAN>sql'alter system switch logfile';
sqlstatement:altersystem switch logfile
--查看channel的配置
RMAN>show channel;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
RMAN configuration hasnostoredordefaultparameters
--配置2个rman通道
RMAN>configure channel1devicetypediskformat'/pooldisk02/backup03/%U';
newRMAN configurationparameters:
CONFIGURE CHANNEL1DEVICETYPEDISKFORMAT'/pooldisk02/backup03/%U';
newRMAN configurationparametersaresuccessfully
stored
RMAN>configure channel2devicetypediskformat'/pooldisk02/backup04/%U';
usingtarget database controlfileinsteadofrecoverycatalog
newRMAN configurationparameters:
CONFIGURE CHANNEL2DEVICETYPEDISKFORMAT'/pooldisk02/backup04/%U';
newRMAN configurationparametersaresuccessfully
stored
--查看配置的通道
RMAN>show channel;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE CHANNEL1DEVICETYPEDISKFORMAT'/pooldisk02/backup03/%U';
CONFIGURE CHANNEL2DEVICETYPEDISKFORMAT'/pooldisk02/backup04/%U';
--对users表空间进行备份
RMAN>backup tablespace users;
Starting backupat13-AUG-13
configurationforDISK channel2isignored
allocated channel:ORA_DISK_1
channel ORA_DISK_1:SID=41devicetype=DISK
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00004name=/oradata/users01.dbf
channel ORA_DISK_1:starting piece1at13-AUG-13
channel ORA_DISK_1:finished piece1at13-AUG-13
piece handle=/pooldisk02/backup03/03oh77tu_1_1 tag=TAG20130813T174742comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01
Finished backupat13-AUG-13
--为什么只使用一个channel，这与当前的配置有关
RMAN>showall;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE RETENTION POLICYTOREDUNDANCY1;#default
CONFIGURE BACKUP OPTIMIZATIONOFF;#default
CONFIGUREDEFAULTDEVICETYPETODISK;#default
CONFIGURE CONTROLFILE AUTOBACKUPOFF;#default
CONFIGURE CONTROLFILE AUTOBACKUPFORMATFORDEVICETYPEDISKTO'%F';#default
CONFIGURE
DEVICETYPEDISK PARALLELISM1BACKUPTYPETOBACKUPSET;#default
CONFIGURE DATAFILE BACKUP COPIESFORDEVICETYPEDISKTO1;#default
CONFIGURE ARCHIVELOG BACKUP COPIESFORDEVICETYPEDISKTO1;#default
CONFIGURE CHANNEL1DEVICETYPEDISKFORMAT'/pooldisk02/backup03/%U';
CONFIGURE CHANNEL2DEVICETYPEDISKFORMAT'/pooldisk02/backup04/%U';
CONFIGURE MAXSETSIZETOUNLIMITED;#default
CONFIGURE ENCRYPTIONFORDATABASEOFF;#default
CONFIGURE ENCRYPTION ALGORITHM'AES128';#default
CONFIGURE COMPRESSION ALGORITHM'BASIC'ASOFRELEASE'DEFAULT'OPTIMIZEFORLOADTRUE;#default
CONFIGURE ARCHIVELOG DELETION POLICYTONONE;#default
CONFIGURE SNAPSHOT CONTROLFILE NAMETO'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_TestDB11.f';#default
--重新配置磁盘设备的备份并行度
RMAN>CONFIGURE DEVICETYPEDISK PARALLELISM2BACKUPTYPETOBACKUPSET;
newRMAN configurationparameters:
CONFIGURE DEVICETYPEDISK PARALLELISM2BACKUPTYPETOBACKUPSET;
newRMAN configurationparametersaresuccessfully
stored
released channel:ORA_DISK_1
--再次对users表空间进行备份
RMAN>backup tablespace users;
Starting backupat13-AUG-13
allocated channel:ORA_DISK_1
channel ORA_DISK_1:SID=41devicetype=DISK
allocated channel:ORA_DISK_2
channel ORA_DISK_2:SID=42devicetype=DISK
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00004name=/oradata/users01.dbf
channel ORA_DISK_1:starting piece1at13-AUG-13
channel ORA_DISK_1:finished piece1at13-AUG-13
piece handle=/pooldisk02/backup03/04oh7891_1_1 tag=TAG20130813T175336comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01
Finished backupat13-AUG-13
--手工分配channel
RMAN>run{
2>backup datafile2channel ORA_DISK_2;
3>backup datafile4channel ORA_DISK_1;
4>}
Starting backupat13-AUG-13
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_2:starting full datafile backupset
channel ORA_DISK_2:specifying datafile(s)inbackupset
inputdatafilefilenumber=00002name=/oradata/sysaux01.dbf
channel ORA_DISK_2:starting piece1at13-AUG-13
channel ORA_DISK_2:finished piece1at13-AUG-13
piece handle=/pooldisk02/backup04/05oh78g9_1_1 tag=TAG20130813T175729comment=NONE
channel ORA_DISK_2:backupsetcomplete,elapsedtime:00:00:45
Finished backupat13-AUG-13
Starting backupat13-AUG-13
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00004name=/oradata/users01.dbf
channel ORA_DISK_1:starting piece1at13-AUG-13
channel ORA_DISK_1:finished piece1at13-AUG-13
piece handle=/pooldisk02/backup03/06oh78hm_1_1 tag=TAG20130813T175814comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01
Finished backupat13-AUG-13
--临时分配一个channel
RMAN>run
2>{allocatechannel c1 devicetypediskformat'/pooldisk02/backup05/%U';
3>allocatechannel c2 devicetypediskformat'/pooldisk02/backup06/%U';
4>backup datafile3channel c1;
5>backup tablespace users channel
c2;
6>releasechannel c1;
7>releasechannel c2;
8>}
released channel:ORA_DISK_1
released channel:ORA_DISK_2
allocated channel:c1
channel c1:SID=41devicetype=DISK
allocated channel:c2
channel c2:SID=42devicetype=DISK
Starting backupat13-AUG-13
channel c1:starting full datafile backupset
channel c1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00003name=/oradata/undotbs01.dbf
channel c1:starting piece1at13-AUG-13
channel c1:finished piece1at13-AUG-13
piece handle=/pooldisk02/backup05/07oh792c_1_1 tag=TAG20130813T180708comment=NONE
channel c1:backupsetcomplete,elapsedtime:00:00:07
Finished backupat13-AUG-13
Starting backupat13-AUG-13
channel c2:starting full datafile backupset
channel c2:specifying datafile(s)inbackupset
inputdatafilefilenumber=00004name=/oradata/users01.dbf
channel c2:starting piece1at13-AUG-13
channel c2:finished piece1at13-AUG-13
piece handle=/pooldisk02/backup06/08oh792j_1_1 tag=TAG20130813T180715comment=NONE
channel c2:backupsetcomplete,elapsedtime:00:00:01
Finished backupat13-AUG-13
released channel:c1
released channel:c2
--查看表空间users的备份情况
RMAN>list backupoftablespace users;
ListofBackupSets
===================
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ ---------------
1Full4.23MDISK00:00:0113-AUG-13
BPKey:1Status:AVAILABLECompressed:NOTag:TAG20130813T174742
Piece Name:/pooldisk02/backup03/03oh77tu_1_1
ListofDatafilesinbackupset1
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- --------- ----
4Full259608413-AUG-13/oradata/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ ---------------
2Full4.23MDISK00:00:0013-AUG-13
BPKey:2Status:AVAILABLECompressed:NOTag:TAG20130813T175336
Piece Name:/pooldisk02/backup03/04oh7891_1_1
ListofDatafilesinbackupset2
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- --------- ----
4Full259644213-AUG-13/oradata/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ ---------------
4Full4.23MDISK00:00:0013-AUG-13
BPKey:4Status:AVAILABLECompressed:NOTag:TAG20130813T175814
Piece Name:/pooldisk02/backup03/06oh78hm_1_1
ListofDatafilesinbackupset4
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- --------- ----
4Full259665113-AUG-13/oradata/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ ---------------
6Full4.23MDISK00:00:0013-AUG-13
BPKey:6Status:AVAILABLECompressed:NOTag:TAG20130813T180715
Piece Name:/pooldisk02/backup06/08oh792j_1_1
ListofDatafilesinbackupset6
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- --------- ----
4Full259721213-AUG-13/oradata/users01.dbf
--修改时间的显示格式
[oracle@S1011:/export/home/oracle]$ export NLS_DATE_FORMAT='yyyy-mm-dd
hh24:mi:ss'
RMAN>list backupoftablespace users;
usingtarget database controlfileinsteadofrecoverycatalog
ListofBackupSets
===================
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ -------------------
1Full4.23MDISK00:00:012013-08-1317:47:43
BPKey:1Status:AVAILABLECompressed:NOTag:TAG20130813T174742
Piece Name:/pooldisk02/backup03/03oh77tu_1_1
ListofDatafilesinbackupset1
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- ------------------- ----
4Full25960842013-08-1317:47:43/oradata/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ -------------------
2Full4.23MDISK00:00:002013-08-1317:53:37
BPKey:2Status:AVAILABLECompressed:NOTag:TAG20130813T175336
Piece Name:/pooldisk02/backup03/04oh7891_1_1
ListofDatafilesinbackupset2
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- ------------------- ----
4Full25964422013-08-1317:53:37/oradata/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ -------------------
4Full4.23MDISK00:00:002013-08-1317:58:14
BPKey:4Status:AVAILABLECompressed:NOTag:TAG20130813T175814
Piece Name:/pooldisk02/backup03/06oh78hm_1_1
ListofDatafilesinbackupset4
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- ------------------- ----
4Full25966512013-08-1317:58:14/oradata/users01.dbf
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ -------------------
6Full4.23MDISK00:00:002013-08-1318:07:15
BPKey:6Status:AVAILABLECompressed:NOTag:TAG20130813T180715
Piece Name:/pooldisk02/backup06/08oh792j_1_1
ListofDatafilesinbackupset6
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- ------------------- ----
4Full25972122013-08-1318:07:15/oradata/users01.dbf
--查看参数配置
RMAN>showall;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE RETENTION POLICYTOREDUNDANCY1;#default
CONFIGURE BACKUP OPTIMIZATIONOFF;#default
CONFIGUREDEFAULTDEVICETYPETODISK;#default
CONFIGURE CONTROLFILE AUTOBACKUPOFF;#default
CONFIGURE CONTROLFILE AUTOBACKUPFORMATFORDEVICETYPEDISKTO'%F';#default
CONFIGURE DEVICETYPEDISK PARALLELISM2BACKUPTYPETOBACKUPSET;
CONFIGURE DATAFILE BACKUP COPIESFORDEVICETYPEDISKTO1;#default
CONFIGURE ARCHIVELOG BACKUP COPIESFORDEVICETYPEDISKTO1;#default
CONFIGURE CHANNEL1DEVICETYPEDISKFORMAT'/pooldisk02/backup03/%U';
CONFIGURE CHANNEL2DEVICETYPEDISKFORMAT'/pooldisk02/backup04/%U';
CONFIGURE MAXSETSIZETOUNLIMITED;#default
CONFIGURE ENCRYPTIONFORDATABASEOFF;#default
CONFIGURE ENCRYPTION ALGORITHM'AES128';#default
CONFIGURE COMPRESSION ALGORITHM'BASIC'ASOFRELEASE'DEFAULT'OPTIMIZEFORLOADTRUE;#default
CONFIGURE ARCHIVELOG DELETION POLICYTONONE;#default
CONFIGURE SNAPSHOT CONTROLFILE NAMETO'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_TestDB11.f';#default
--保留策略1，冗余度(redundancy)
RMAN>show retention policy;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE RETENTION POLICYTOREDUNDANCY1;#default
--查看需要的备份
RMAN>report need backup;
RMAN retention policy will be appliedtothe command
RMAN retention policyissettoredundancy1
Reportoffileswithlessthan1redundant backups
File#bkps Name
---- ----- -----------------------------------------------------
10/oradata/system01.dbf
50/oradata/example01.dbf
60/oradata/newts01.dbf
70/oradata/fbtbs01.dbf
RMAN>backup datafile7;
Starting backupat2013-08-1401:38:21
allocated channel:ORA_DISK_1
channel ORA_DISK_1:SID=47devicetype=DISK
allocated channel:ORA_DISK_2
channel ORA_DISK_2:SID=52devicetype=DISK
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00007name=/oradata/fbtbs01.dbf
channel ORA_DISK_1:starting piece1at2013-08-1401:38:21
channel ORA_DISK_1:finished piece1at2013-08-1401:38:23
piece handle=/pooldisk02/backup03/09oh83gd_1_1 tag=TAG20130814T013821comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:02
Finished backupat2013-08-1401:38:23
RMAN>report need backup;
RMAN retention policy will be appliedtothe command
RMAN retention policyissettoredundancy1
Reportoffileswithlessthan1redundant backups
File#bkps Name
---- ----- -----------------------------------------------------
10/oradata/system01.dbf
50/oradata/example01.dbf
60/oradata/newts01.dbf
--调整保留策略
RMAN>CONFIGURE RETENTION POLICYTOREDUNDANCY2;
newRMAN configurationparameters:
CONFIGURE RETENTION POLICYTOREDUNDANCY2;
newRMAN configurationparametersaresuccessfully
stored
RMAN>report need backup;
RMAN retention policy will be appliedtothe command
RMAN retention policyissettoredundancy2
Reportoffileswithlessthan2redundant backups
File#bkps Name
---- ----- -----------------------------------------------------
10/oradata/system01.dbf
21/oradata/sysaux01.dbf
31/oradata/undotbs01.dbf
50/oradata/example01.dbf
60/oradata/newts01.dbf
71/oradata/fbtbs01.dbf
--把文件7再备份一次
RMAN>backup datafile7;
Starting backupat2013-08-1401:41:06
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00007name=/oradata/fbtbs01.dbf
channel ORA_DISK_1:starting piece1at2013-08-1401:41:06
channel ORA_DISK_1:finished piece1at2013-08-1401:41:07
piece handle=/pooldisk02/backup03/0aoh83li_1_1 tag=TAG20130814T014106comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01
Finished backupat2013-08-1401:41:07
RMAN>report need backup;
RMAN retention policy will be appliedtothe command
RMAN retention policyissettoredundancy2
Reportoffileswithlessthan2redundant backups
File#bkps Name
---- ----- -----------------------------------------------------
10/oradata/system01.dbf
21/oradata/sysaux01.dbf
31/oradata/undotbs01.dbf
50/oradata/example01.dbf
60/oradata/newts01.dbf
--查看过期的备份(根据备份策略来决定是否过期)
RMAN>report obsolete;
RMAN retention policy will be appliedtothe command
RMAN retention policyissettoredundancy2
Reportofobsolete backupsandcopies
TypeKeyCompletionTimeFilename/Handle
-------------------- ------ ------------------ --------------------
BackupSet12013-08-1317:47:43
Backup Piece12013-08-1317:47:43/pooldisk02/backup03/03oh77tu_1_1
BackupSet22013-08-1317:53:37
Backup Piece22013-08-1317:53:37/pooldisk02/backup03/04oh7891_1_1
--修改回原来的保留策略
RMAN>CONFIGURE RETENTION POLICYTOREDUNDANCY1;
oldRMAN configurationparameters:
CONFIGURE RETENTION POLICYTOREDUNDANCY2;
newRMAN configurationparameters:
CONFIGURE RETENTION POLICYTOREDUNDANCY1;
newRMAN configurationparametersaresuccessfully
stored
RMAN>report obsolete;
RMAN retention policy will be appliedtothe command
RMAN retention policyissettoredundancy1
Reportofobsolete backupsandcopies
TypeKeyCompletionTimeFilename/Handle
-------------------- ------ ------------------ --------------------
BackupSet12013-08-1317:47:43
Backup Piece12013-08-1317:47:43/pooldisk02/backup03/03oh77tu_1_1
BackupSet22013-08-1317:53:37
Backup Piece22013-08-1317:53:37/pooldisk02/backup03/04oh7891_1_1
BackupSet42013-08-1317:58:14
Backup Piece42013-08-1317:58:14/pooldisk02/backup03/06oh78hm_1_1
BackupSet72013-08-1401:38:22
Backup Piece72013-08-1401:38:22/pooldisk02/backup03/09oh83gd_1_1
--保留策略2，恢复窗口，设置恢复窗口为7天
RMAN>CONFIGURE RETENTION POLICYTOrecovery windowof7days;
oldRMAN configurationparameters:
CONFIGURE RETENTION POLICYTOREDUNDANCY1;
newRMAN configurationparameters:
CONFIGURE RETENTION POLICYTORECOVERY WINDOWOF7DAYS;
newRMAN configurationparametersaresuccessfully
stored
--清除现有参数的设置,使用默认值
RMAN>CONFIGURE RETENTION POLICY clear;
oldRMAN configurationparameters:
CONFIGURE RETENTION POLICYTORECOVERY WINDOWOF7DAYS;
RMAN configurationparametersaresuccessfully resettodefaultvalue
--查看当前设置
RMAN>show RETENTION POLICY;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE RETENTION POLICYTOREDUNDANCY1;#default
--查看当前的备份优化的设置,是指数据文件、归档日志、备份集如果存在相同的就不会再备份
RMAN>show backup optimization;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE BACKUP OPTIMIZATIONOFF;#default
--控制文件自动备份,如果设置为off，则不会单独地自动备份控制文件和初始化参数文件。
--但当备份集中包含1号数据文件时，会在同一备份集中包含控制文件和初始化参数文件
RMAN>show CONTROLFILE AUTOBACKUP;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE CONTROLFILE AUTOBACKUPOFF;#default
--备份4号数据文件，没有备份控制文件
RMAN>backup datafile4;
Starting backupat2013-08-1402:07:27
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00004name=/oradata/users01.dbf
channel ORA_DISK_1:starting piece1at2013-08-1402:07:28
channel ORA_DISK_1:finished piece1at2013-08-1402:07:29
piece handle=/pooldisk02/backup03/0boh856v_1_1 tag=TAG20130814T020727comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:02
Finished backupat2013-08-1402:07:29
--备份1号文件,包含控制文件和初始化参数文件
RMAN>backup datafile1;
Starting backupat2013-08-1402:08:10
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00001name=/oradata/system01.dbf
channel ORA_DISK_1:starting piece1at2013-08-1402:08:10
channel ORA_DISK_2:starting full datafile backupset
channel ORA_DISK_2:specifying datafile(s)inbackupset
channel ORA_DISK_1:finished piece1at2013-08-1402:08:56
piece handle=/pooldisk02/backup03/0coh858a_1_1 tag=TAG20130814T020810comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:46
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
includingcurrentSPFILEinbackupset
channel ORA_DISK_1:starting piece1at2013-08-1402:08:56
includingcurrentcontrolfileinbackupset
channel ORA_DISK_2:starting piece1at2013-08-1402:08:56
channel ORA_DISK_1:finished piece1at2013-08-1402:08:57
piece handle=/pooldisk02/backup03/0eoh859o_1_1 tag=TAG20130814T020810comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01
channel ORA_DISK_2:finished piece1at2013-08-1402:08:57
piece handle=/pooldisk02/backup04/0doh858b_1_1 tag=TAG20130814T020810comment=NONE
channel ORA_DISK_2:backupsetcomplete,elapsedtime:00:00:01
Finished backupat2013-08-1402:08:57
--清除备份
RMAN>deletebackup;
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
ListofBackup Pieces
BPKeyBSKeyPc#
Cp# StatusDeviceTypePiece Name
------- ------- --- --- ----------- ----------- ----------
1111AVAILABLEDISK/pooldisk02/backup03/03oh77tu_1_1
2211AVAILABLEDISK/pooldisk02/backup03/04oh7891_1_1
3311AVAILABLEDISK/pooldisk02/backup04/05oh78g9_1_1
4411AVAILABLEDISK/pooldisk02/backup03/06oh78hm_1_1
5511AVAILABLEDISK/pooldisk02/backup05/07oh792c_1_1
6611AVAILABLEDISK/pooldisk02/backup06/08oh792j_1_1
7711AVAILABLEDISK/pooldisk02/backup03/09oh83gd_1_1
8811AVAILABLEDISK/pooldisk02/backup03/0aoh83li_1_1
9911AVAILABLEDISK/pooldisk02/backup03/0boh856v_1_1
101011AVAILABLEDISK/pooldisk02/backup03/0coh858a_1_1
111111AVAILABLEDISK/pooldisk02/backup03/0eoh859o_1_1
121211AVAILABLEDISK/pooldisk02/backup04/0doh858b_1_1
--打开控制文件自动备份,会在单独的备份集中创建控制文件和初始化参数文件的备份
RMAN>CONFIGURE CONTROLFILE AUTOBACKUPon;
newRMAN configurationparameters:
CONFIGURE CONTROLFILE AUTOBACKUPON;
newRMAN configurationparametersaresuccessfully
stored
RMAN>backup datafile4;
Starting backupat2013-08-1402:12:00
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00004name=/oradata/users01.dbf
channel ORA_DISK_1:starting piece1at2013-08-1402:12:00
channel ORA_DISK_1:finished piece1at2013-08-1402:12:01
piece handle=/pooldisk02/backup03/0foh85fg_1_1 tag=TAG20130814T021200comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01
Finished backupat2013-08-1402:12:01
Starting ControlFileandSPFILE Autobackupat2013-08-1402:12:01
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823399921_90pcg1ng_.bkpcomment=NONE
Finished ControlFileandSPFILE Autobackupat2013-08-1402:12:02
--查看备份的控制文件的信息
RMAN>list backupofcontrolfile;
ListofBackupSets
===================
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ -------------------
14Full9.67MDISK00:00:012013-08-1402:12:02
BPKey:14Status:AVAILABLECompressed:NOTag:TAG20130814T021201
Piece Name:/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823399921_90pcg1ng_.bkp
ControlFileIncluded:Ckp SCN:2633674Ckptime:2013-08-1402:12:01
--自动备份的控制文件的格式
RMAN>show CONTROLFILE AUTOBACKUPFORMAT;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE CONTROLFILE AUTOBACKUPFORMATFORDEVICETYPEDISKTO'%F';#default
--查看rman所有配置参数，一一加以解释
RMAN>showall;
RMAN configurationparametersfordatabasewithdb_unique_name TESTDB11are:
CONFIGURE RETENTION POLICYTOREDUNDANCY1;#default
CONFIGURE BACKUP OPTIMIZATIONOFF;#default
CONFIGUREDEFAULTDEVICETYPETODISK;#default
CONFIGURE CONTROLFILE AUTOBACKUPON;
CONFIGURE CONTROLFILE AUTOBACKUPFORMATFORDEVICETYPEDISKTO'%F';#default
CONFIGURE DEVICETYPEDISK PARALLELISM2BACKUPTYPETOBACKUPSET;
CONFIGURE DATAFILE BACKUP COPIESFORDEVICETYPEDISKTO1;#default
CONFIGURE ARCHIVELOG BACKUP COPIESFORDEVICETYPEDISKTO1;#default
CONFIGURE CHANNEL1DEVICETYPEDISKFORMAT'/pooldisk02/backup03/%U';
CONFIGURE CHANNEL2DEVICETYPEDISKFORMAT'/pooldisk02/backup04/%U';
CONFIGURE MAXSETSIZETOUNLIMITED;#default
CONFIGURE ENCRYPTIONFORDATABASEOFF;#default
CONFIGURE ENCRYPTION ALGORITHM'AES128';#default
CONFIGURE COMPRESSION ALGORITHM'BASIC'ASOFRELEASE'DEFAULT'OPTIMIZEFORLOADTRUE;#default
CONFIGURE ARCHIVELOG DELETION POLICYTONONE;#default
CONFIGURE SNAPSHOT CONTROLFILE NAMETO'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_TestDB11.f';#default
--rman备份可以分为镜像拷贝和备份集2种
--1.备份拷贝
RMAN>backupascopy datafile4;
Starting backupat2013-08-1402:35:19
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_1:starting datafile copy
inputdatafilefilenumber=00004name=/oradata/users01.dbf
outputfilename=/pooldisk02/backup03/data_D-TESTDB11_I-2578856066_TS-USERS_FNO-4_0hoh86r8 tag=TAG20130814T023519
RECID=3STAMP=823401320
channel ORA_DISK_1:datafile copy complete,elapsedtime:00:00:01
Finished backupat2013-08-1402:35:21
Starting ControlFileandSPFILE Autobackupat2013-08-1402:35:21
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823401321_90pdssjc_.bkpcomment=NONE
Finished ControlFileandSPFILE Autobackupat2013-08-1402:35:22
--查看已经产生的镜像拷贝
RMAN>list copyofdatafile4;
ListofDatafile Copies
=======================
KeyFileSCompletionTimeCkp SCNCkpTime
------- ---- - ------------------- ---------- -------------------
34A2013-08-1402:35:2026347782013-08-1402:35:20
Name:/pooldisk02/backup03/data_D-TESTDB11_I-2578856066_TS-USERS_FNO-4_0hoh86r8
Tag:TAG20130814T023519
--镜像拷贝保持原大小
[root@S1011:/pooldisk02]# ls-lh/oradata/users01.dbf
-rw-r-----1 oracleoinstall6.3M Aug 14 02:35
/oradata/users01.dbf
[root@S1011:/pooldisk02]# ls-lh ls-lh/pooldisk02/backup03/data_D-TESTDB11_I-2578856066_TS-USERS_FNO-4_0hoh86r8
ls:Nosuchfileordirectory
-lh:Nosuchfileordirectory
-rw-r-----1 oracleoinstall6.3M Aug 14 02:35
/pooldisk02/backup03/data_D-TESTDB11_I-2578856066_TS-USERS_FNO-4_0hoh86r8
--镜像拷贝也可以自己指定产生的位置和名称
RMAN>copy datafile4to'/pooldisk02/backup01/user01.bak';
Starting backupat2013-08-1402:44:44
usingchannel ORA_DISK_1
usingchannel ORA_DISK_2
channel ORA_DISK_1:starting datafile copy
inputdatafilefilenumber=00004name=/oradata/users01.dbf
outputfilename=/pooldisk02/backup01/user01.bak tag=TAG20130814T024444
RECID=4STAMP=823401885
channel ORA_DISK_1:datafile copy complete,elapsedtime:00:00:01
Finished backupat2013-08-1402:44:46
Starting ControlFileandSPFILE Autobackupat2013-08-1402:44:46
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823401886_90pfcgf0_.bkpcomment=NONE
Finished ControlFileandSPFILE Autobackupat2013-08-1402:44:47
--重新将备份并行度设置为1
RMAN>CONFIGURE DEVICETYPEDISK PARALLELISM1BACKUPTYPETOBACKUPSET;
usingtarget database controlfileinsteadofrecoverycatalog
oldRMAN configurationparameters:
CONFIGURE DEVICETYPEDISK PARALLELISM1BACKUPTYPETOBACKUPSET;
newRMAN configurationparameters:
CONFIGURE DEVICETYPEDISK PARALLELISM1BACKUPTYPETOBACKUPSET;
newRMAN configurationparametersaresuccessfully
stored
--2.给表空间users添加一个数据文件
sys@TESTDB11>altertablespace usersadddatafile'/oradata/users02.dbf'size50m;
Tablespace altered.
--生成备份集
RMAN>backup tablespace users;
Starting backupat2013-08-1402:52:12
usingchannel ORA_DISK_1
channel ORA_DISK_1:starting full datafile backupset
channel ORA_DISK_1:specifying datafile(s)inbackupset
inputdatafilefilenumber=00008name=/oradata/users02.dbf
inputdatafilefilenumber=00004name=/oradata/users01.dbf
channel ORA_DISK_1:starting piece1at2013-08-1402:52:12
channel ORA_DISK_1:finished piece1at2013-08-1402:52:13
piece handle=/pooldisk02/backup03/0noh87qs_1_1 tag=TAG20130814T025212comment=NONE
channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01
Finished backupat2013-08-1402:52:13
Starting ControlFileandSPFILE Autobackupat2013-08-1402:52:14
piece handle=/u01/app/oracle/fast_recovery_area/TESTDB11/autobackup/2013_08_14/o1_mf_s_823402334_90pfsgb4_.bkpcomment=NONE
Finished ControlFileandSPFILE Autobackupat2013-08-1402:52:15
RMAN>list backupoftablespace users;
ListofBackupSets
===================
BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime
------- ---- -- ---------- ----------- ------------ -------------------
19Full5.23MDISK00:00:012013-08-1402:52:13
BPKey:19Status:AVAILABLECompressed:NOTag:TAG20130814T025212
Piece Name:/pooldisk02/backup03/0noh87qs_1_1
ListofDatafilesinbackupset19
FileLVTypeCkp SCNCkpTimeName
---- -- ---- ---------- ------------------- ----
4Full26359012013-08-1402:52:12/oradata/users01.dbf
8Full26359012013-08-1402:52:12/oradata/users02.dbf
--查看生成的备份集的大小,比原来数据文件小多了
[root@S1011:/pooldisk02]# ls-lh/pooldisk02/backup03/0noh87qs_1_1
-rw-r-----1 oracleoinstall5.2M Aug 14 02:52
/pooldisk02/backup03/0noh87qs_1_1