Welcome 微信登录

首页 / 数据库 / MySQL / Oracle使用RMAN对SYSTEM表空间进行介质恢复

注意：数据库应该支持在归档模式。1.对SYSTEMG表空间做一个备份
[Oracle@bys001 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Sep 17 10:42:18 2013
Copyright （c） 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: BYS1 （DBID=3957527513）
RMAN> list backup;
using target database control file instead of recovery catalog
specification does not match any backup in the repositoryRMAN> backup tablespace system;
Starting backup at 17-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=45 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile（s） in backup set
input datafile file number=00001 name=/u01/oradata/bys1/system01.dbf
channel ORA_DISK_1: starting piece 1 at 17-SEP-13
channel ORA_DISK_1: finished piece 1 at 17-SEP-13
piece handle=/u01/flash_recovery_area/BYS1/backupset/2013_09_17/o1_mf_nnndf_TAG20130917T104438_93hjjqph_.bkp tag=TAG20130917T104438 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:26
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile（s） in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 17-SEP-13
channel ORA_DISK_1: finished piece 1 at 17-SEP-13
piece handle=/u01/flash_recovery_area/BYS1/backupset/2013_09_17/o1_mf_ncsnf_TAG20130917T104438_93hjok2q_.bkp tag=TAG20130917T104438 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-SEP-13
RMAN> exit推荐阅读：Oracle基础教程之通过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
  • 1
  • 2
  • 3
  • 4
  • 5
  • 下一页
RMAN 相应概念介绍普通表与临时表DML操作会产生REDO/UNDO对比与分析相关资讯      RMAN 
  • RMAN故障一例（归档的备份，从不  （今 20:42）
  • RMAN的FORMATA格式说明  （03月10日）
  • Oracle 11g RMAN复制数据库的测试  （01月19日）
  • RMAN数据库迁移  （05月22日）
  • 使用RMAN复制恢复开发库环境  （02月17日）
  • Oracle 11g RMAN跨平台传输表空间  （01月19日）
本文评论 查看全部评论 （0）
表情： 姓名： 字数