Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1066112
  • 博文数量: 239
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 3618
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-12 13:17
文章分类

全部博文(239)

文章存档

2021年(1)

2016年(1)

2015年(30)

2014年(91)

2013年(116)

分类: LINUX

2013-09-11 10:52:38

1.备份控制文件
RMAN> backup current controlfile;


Starting backup at 10-SEP-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
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncnnf_TAG20130910T194255_92zp5k2q_.bkp tag=TAG20130910T194255 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-SEP-13


2.备份数据库的同时备份控制文件
RMAN> backup database include current controlfile;


Starting backup at 10-SEP-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=00001 name=/opt/oracle/oradata/portaldb/system01.dbf
input datafile file number=00002 name=/opt/oracle/oradata/portaldb/sysaux01.dbf
input datafile file number=00003 name=/opt/oracle/oradata/portaldb/undotbs01.dbf
input datafile file number=00005 name=/oradata/portaldb_ICMLFQ32_01.dbf
input datafile file number=00006 name=/oradata/portaldb_ICMLNF32_01.dbf
input datafile file number=00007 name=/oradata/portaldb_ICMSFQ04_01.dbf
input datafile file number=00008 name=/oradata/portaldb_ICMVFQ04_01.dbf
input datafile file number=00009 name=/oradata/portaldb_ICMLSNDX_01.dbf
input datafile file number=00004 name=/opt/oracle/oradata/portaldb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T194428_92zp8dmn_.bkp tag=TAG20130910T194428 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
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 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194428_92zpc2pk_.bkp tag=TAG20130910T194428 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-SEP-13

3.备份第一个数据文件
RMAN> backup datafile 1;


Starting backup at 10-SEP-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=00001 name=/opt/oracle/oradata/portaldb/system01.dbf
channel ORA_DISK_1: starting piece 1 at 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T194942_92zpl6l4_.bkp tag=TAG20130910T194942 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
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 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194942_92zpmynf_.bkp tag=TAG20130910T194942 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-SEP-13

4.查看备份过的控制文件
RMAN> list backup of controlfile;




List of Backup Sets
===================




BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    9.36M      DISK        00:00:02     10-SEP-13      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T181210
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T181210_92zjvd24_.bkp
  Control File Included: Ckp SCN: 1131454      Ckp time: 10-SEP-13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    9.36M      DISK        00:00:01     10-SEP-13      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T182338
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T182338_92zkjvfb_.bkp
  Control File Included: Ckp SCN: 1132378      Ckp time: 10-SEP-13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    9.36M      DISK        00:00:02     10-SEP-13      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T182444
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T182444_92zklxrc_.bkp
  Control File Included: Ckp SCN: 1132421      Ckp time: 10-SEP-13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    9.36M      DISK        00:00:01     10-SEP-13      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T183137
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T183137_92zl2t44_.bkp
  Control File Included: Ckp SCN: 1133095      Ckp time: 10-SEP-13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    9.36M      DISK        00:00:01     10-SEP-13      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T183832
        Piece Name: /oradata/backup/bak_0bojh5ft_1_1
  Control File Included: Ckp SCN: 1133289      Ckp time: 10-SEP-13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Full    9.33M      DISK        00:00:01     10-SEP-13      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T194255
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncnnf_TAG20130910T194255_92zp5k2q_.bkp
  Control File Included: Ckp SCN: 1136446      Ckp time: 10-SEP-13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    9.36M      DISK        00:00:02     10-SEP-13      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T194428
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194428_92zpc2pk_.bkp
  Control File Included: Ckp SCN: 1136576      Ckp time: 10-SEP-13


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    9.36M      DISK        00:00:02     10-SEP-13      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T194942
        Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194942_92zpmynf_.bkp
  Control File Included: Ckp SCN: 1136736      Ckp time: 10-SEP-13





阅读(1204) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~