oracle默认数据不起作用,backup中指定了filesperset 选项为什么不起作用?

RMAN> report schema;

using target database control file instead of recovery catalog

Report of database schema for database with db_unique_name HUATENG

List of Permanent Datafiles

===========================

File Size(MB) Tablespace           RB segs Datafile Name

---- -------- -------------------- ------- ------------------------

1    680      SYSTEM               ***     /u01/app/oracle/oradata/huateng/system01.dbf

2    480      SYSAUX               ***     /u01/app/oracle/oradata/huateng/sysaux01.dbf

3    85       UNDOTBS1             ***     /u01/app/oracle/oradata/huateng/undotbs01.dbf

4    5        USERS                ***     /u01/app/oracle/oradata/huateng/users01.dbf

5    100      EXAMPLE              ***     /u01/app/oracle/oradata/huateng/example01.dbf

6    57       HTYANSP              ***     /u01/app/oracle/oradata/huateng/htyansp01.dbf

List of Temporary Files

=======================

File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

---- -------- -------------------- ----------- --------------------

1    29       TEMP                 32767       /u01/app/oracle/oradata/huateng/temp01.dbf

RMAN> backup database filesperset 3 format '/dbbackup/%U.bak';

Starting backup at 2012-08-09 15:31:44

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=17 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/app/oracle/oradata/huateng/system01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/huateng/users01.dbf

input datafile file number=00006 name=/u01/app/oracle/oradata/huateng/htyansp01.dbf

channel ORA_DISK_1: starting piece 1 at 2012-08-09 15:31:45

channel ORA_DISK_1: finished piece 1 at 2012-08-09 15:32:30

piece handle=/dbbackup/05ni7iv1_1_1.bak tag=TAG20120809T153145 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/app/oracle/oradata/huateng/sysaux01.dbf

input datafile file number=00005 name=/u01/app/oracle/oradata/huateng/example01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/huateng/undotbs01.dbf

channel ORA_DISK_1: starting piece 1 at 2012-08-09 15:32:31

channel ORA_DISK_1: finished piece 1 at 2012-08-09 15:33:06

piece handle=/dbbackup/06ni7j0f_1_1.bak tag=TAG20120809T153145 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35

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 2012-08-09 15:33:09

channel ORA_DISK_1: finished piece 1 at 2012-08-09 15:33:12

piece handle=/dbbackup/07ni7j1i_1_1.bak tag=TAG20120809T153145 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 2012-08-09 15:33:13

RMAN> list backupset;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

3       Full    591.58M    DISK        00:00:37     2012-08-09 15:32:22

BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20120809T153145

Piece Name: /dbbackup/05ni7iv1_1_1.bak

List of Datafiles in backup set 3

File LV Type Ckp SCN    Ckp Time            Name

---- -- ---- ---------- ------------------- ----

1       Full 2078954    2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/system01.dbf

4       Full 2078954    2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/users01.dbf

6       Full 2078954    2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/htyansp01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

4       Full    435.73M    DISK        00:00:32     2012-08-09 15:33:03

BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20120809T153145

Piece Name: /dbbackup/06ni7j0f_1_1.bak

List of Datafiles in backup set 4

File LV Type Ckp SCN    Ckp Time            Name

---- -- ---- ---------- ------------------- ----

2       Full 2078954    2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/sysaux01.dbf

3       Full 2078954    2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/undotbs01.dbf

5       Full 2078954    2012-08-07 23:51:26 /u01/app/oracle/oradata/huateng/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

5       Full    9.36M      DISK        00:00:05     2012-08-09 15:33:11

BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20120809T153145

Piece Name: /dbbackup/07ni7j1i_1_1.bak

SPFILE Included: Modification time: 2012-08-09 15:30:17

SPFILE db_unique_name: HUATENG

Control File Included: Ckp SCN: 2078954      Ckp time: 2012-08-07 23:51:26

RMAN> list backupset of controlfile;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------

5       Full    9.36M      DISK        00:00:05     2012-08-09 15:33:11

BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20120809T153145

Piece Name: /dbbackup/07ni7j1i_1_1.bak

Control File Included: Ckp SCN: 2078954      Ckp time: 2012-08-07 23:51:26

RMAN>

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

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值