手机版
你好,游客 登录 注册
背景:
阅读新闻

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

[日期:2014-08-28] 来源:Linux社区  作者:LuiseDalian [字体: ]

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-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

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

RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htm

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

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

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址http://www.linuxidc.com/Linux/2014-08/105904.htm

linux
相关资讯       rman备份 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款