oracle rman本地备份,Oracle 11g RMAN备份-基本操作

雨点打透心脏的1/2处 2023-01-18 04:28 171阅读 0赞

\--rman连接目标数据库

\[oracle@S1011:/export/home/oracle\]$ rman target/

Recovery Manager:Release11.2.0.3.0-ProductiononTue Aug1317:15:412013

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

oracle rman本地备份,Oracle 11g RMAN备份-基本操作

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Oracle 11g EXPDP、RMAN自动备份SHELL脚本

相关 Oracle 11g RMAN恢复时报错"RMAN-06100"、"RMAN-06026"、"RMAN-03002"

相关 Oracle 11g RMAN multiplexing 备份脚本

相关 oracle rman本地备份,Oracle 11g RMAN备份-基本操作

相关 Oracle RMAN 增量备份

相关 Oracle rman 自动备份脚本

相关 oracle 11g 64位rman备份集迁移到32位

相关 RMAN Oracle数据库备份

相关 Oracle RMAN 备份（五）--增量备份

相关备份有困难？Oracle DBA详述RMAN备份