oracle 安全备份与rman_Oracle 11G 备份与恢复 使用RMAN创建备份集举例

--%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>backupasbackupsetformat'/backup01/df_%d_%s_%p.bus'tablespace users;

Starting backupat09-AUG-14

usingchannel ORA_DISK_1

channel ORA_DISK_1:starting full datafile backupset

channel ORA_DISK_1:specifying datafile(s)inbackupset

inputdatafilefilenumber=00004name=+DISKGROUP01/testdb11/users01.dbf

channel ORA_DISK_1:starting piece1at09-AUG-14

channel ORA_DISK_1:finished piece1at09-AUG-14

piece handle=/backup01/df_TESTDB11_31_1.bus tag=TAG20140809T104346comment=NONE

channel ORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01

Finished backupat09-AUG-14

--查看产生的备份文件

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

total18248

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

-rw-r----- 1 oracle dba 5251072 Aug9 09:13

data_D-TESTDB11_I-2620210741_TS-USERS_FNO-4_0mpfgjqi

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

--删除所有备份

RMAN>deletebackup;

usingchannel ORA_DISK_1

ListofBackup Pieces

BPKeyBSKeyPc# Cp# StatusDeviceTypePiece Name

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

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

57557411AVAILABLEDISK/backup01/df_TESTDB11_31_1.bus

Doyou really wanttodeletethe above objects(enter YESorNO)?yes

deleted backup piece

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

Deleted1objects