oracle11g的让rman备份恢复,Oracle11g备份与恢复使用RMAN创建备份集举例

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

logo.jpg

首页 → 数据库技术

背景:

阅读新闻

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 配置归档日志删除策略

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密

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

本文永久更新链接地址:

logo.gif

0

MySQL搭建带过滤的复制环境

Oracle数据泵远程导入文件到本地数据库

相关资讯

rman备份

图片资讯

14032109525508t.jpgRHEL5下RMAN的自动备

130326190637121t.jpgRMAN备份策略制定参考

本文评论

查看全部评论 (0)

评论声明

最新资讯

本周热门

Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们

本站(LinuxIDC)所刊载文章不代表同意其说法或描述,仅为提供更多信息,,也不构成任何建议。

Copyright © 2006-2014 Linux公社 All rights reserved 浙ICP备06018118号 本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源:php中文网

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值