首页 / 数据库 / MySQL / Oracle 11g 备份与恢复 使用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> backup as backupset format "/backup01/df_%d_%s_%p.bus" tablespace users; Starting backup at 09-AUG-14using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile（s） in backup setinput datafile file number=00004 name=+DISKGROUP01/testdb11/users01.dbfchannel ORA_DISK_1: starting piece 1 at 09-AUG-14channel ORA_DISK_1: finished piece 1 at 09-AUG-14piece handle=/backup01/df_TESTDB11_31_1.bus tag=TAG20140809T104346 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 09-AUG-14 --查看产生的备份文件[oracle@OL54.cuug.net:/backup01]$ ls -ltotal 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 PiecesBP 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）？ yesdeleted backup piecebackup piece handle=/backup01/df_TESTDB11_31_1.bus RECID=26 STAMP=855139427Deleted 1 objects--------------------------------------推荐阅读 --------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址