Oracle 11g 备份与恢复 使用RMAN创建备份集举例

2014-11-24 17:15:11 · 作者: · 浏览: 1

--%d: Specifies the name of the database


--%s: Specifies the backup set number. This number is a counter in the control file that is incremented for each backup set.


-- The counter value starts at 1 and is unique for the lifetime of the control file.


-- If you restore a backup control file, then duplicate values can result.


-- Also, CREATE CONTROLFILE initializes the counter back to 1


--%p: Specifies the piece number within the backup set.


-- This value starts at 1 for each backup set and is incremented by 1 as each backup piece is created.



RMAN> backup as backupset format '/backup01/df_%d_%s_%p.bus' tablespace users;



Starting backup at 09-AUG-14


using channel ORA_DISK_1


channel ORA_DISK_1: starting full datafile backup set


channel ORA_DISK_1: specifying datafile(s) in backup set


input datafile file number=00004 name=+DISKGROUP01/testdb11/users01.dbf


channel ORA_DISK_1: starting piece 1 at 09-AUG-14


channel ORA_DISK_1: finished piece 1 at 09-AUG-14


piece handle=/backup01/df_TESTDB11_31_1.bus tag=TAG20140809T104346 comment=NONE


channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01


Finished backup at 09-AUG-14



--查看产生的备份文件


[oracle@OL54.cuug.net:/backup01]$ ls -l


total 18248


-rw-r----- 1 oracle dba 9830400 Aug 9 07:31 02pfgdr4_1_1


-rw-r----- 1 oracle dba 5251072 Aug 9 09:13 data_D-TESTDB11_I-2620210741_TS-USERS_FNO-4_0mpfgjqi


-rw-r----- 1 oracle dba 3571712 Aug 9 10:43 df_TESTDB11_31_1.bus



--删除所有备份


RMAN> delete backup;



using channel ORA_DISK_1



List of Backup Pieces


BP Key BS Key Pc# Cp# Status Device Type Piece Name


------- ------- --- --- ----------- ----------- ----------


575 574 1 1 AVAILABLE DISK /backup01/df_TESTDB11_31_1.bus



Do you really want to delete the above objects (enter YES or NO) yes


deleted backup piece


backup piece handle=/backup01/df_TESTDB11_31_1.bus RECID=26 STAMP=855139427


Deleted 1 objects


--------------------------------------推荐阅读 --------------------------------------


--------------------------------------分割线 --------------------------------------