暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

12C RMAN pluggable databases

原创 章芋文 2013-09-05
420
支持同时备份恢复多个CDB和PDB,下面是针对PDB的测试
备份整个pdb:
[code][oracle@ora12c ~]$ rman target sys/oracle

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jul 25 19:37:40 2013

Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL12C (DBID=649692732)

RMAN> backup pluggable database pdborcl12c;

Starting backup at 25-JUL-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 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=00009 name=/oracle/12c/oradata/orcl12c/pdborcl12c/sysaux01.dbf
input datafile file number=00011 name=/oracle/12c/oradata/orcl12c/pdborcl12c/example01.dbf
input datafile file number=00008 name=/oracle/12c/oradata/orcl12c/pdborcl12c/system01.dbf
input datafile file number=00010 name=/oracle/12c/oradata/orcl12c/pdborcl12c/SAMPLE_SCHEMA_users01.dbf
channel ORA_DISK_1: starting piece 1 at 25-JUL-13
channel ORA_DISK_1: finished piece 1 at 25-JUL-13
piece handle=/oracle/12c/fast_recovery_area/ORCL12C/E01C4456BFAB4C98E0430100007F1796/backupset/2013_07_25/o1_mf_nnndf_TAG20130725T193823_8z23kj5r_.bkp tag=TAG20130725T193823 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
Finished backup at 25-JUL-13

Starting Control File and SPFILE Autobackup at 25-JUL-13
piece handle=/oracle/12c/fast_recovery_area/ORCL12C/autobackup/2013_07_25/o1_mf_s_821734789_8z23n788_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 25-JUL-13[/code]
查看备份
[code]RMAN> list backup summary;


List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
26 B F A DISK 25-JUL-13 1 1 NO TAG20130725T193823
27 B F A DISK 25-JUL-13 1 1 NO TAG20130725T193949
RMAN> select ts#,name from v$tablespace;

TS# NAME
---------- ------------------------------
0 SYSTEM
1 SYSAUX
2 UNDOTBS1
4 USERS
3 TEMP
0 SYSTEM
1 SYSAUX
2 TEMP
0 SYSTEM
1 SYSAUX
2 TEMP
3 USERS
4 EXAMPLE

13 rows selected[/code]
备份pdb的EXAMPLE表空间:
[code]RMAN> backup tablespace pdborcl12c:EXAMPLE;

Starting backup at 25-JUL-13
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=00011 name=/oracle/12c/oradata/orcl12c/pdborcl12c/example01.dbf
channel ORA_DISK_1: starting piece 1 at 25-JUL-13
channel ORA_DISK_1: finished piece 1 at 25-JUL-13
piece handle=/oracle/12c/fast_recovery_area/ORCL12C/E01C4456BFAB4C98E0430100007F1796/backupset/2013_07_25/o1_mf_nnndf_TAG20130725T194749_8z2435qm_.bkp tag=TAG20130725T194749 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 25-JUL-13

Starting Control File and SPFILE Autobackup at 25-JUL-13
piece handle=/oracle/12c/fast_recovery_area/ORCL12C/autobackup/2013_07_25/o1_mf_s_821735295_8z2440ox_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 25-JUL-13[/code]
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论