ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Multiple Copies of RMAN Backups

Multiple Copies of RMAN Backups

原创 Linux操作系统 作者:v_fantasy 时间:2011-05-31 15:23:17 0 删除 编辑
1、 it is not possible to duplex backup sets to the flash recovery area
用FRA区域存放bankupset的时候无法采用多路技术
RMAN> delete noprompt backupset;
using channel ORA_DISK_1
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/10.2.0/db_1/dbs/snapcf_dg.f'; # default
RMAN> backup datafile 6;
Starting backup at 31-MAY-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/oracle/oradata/dg/users03.dbf
channel ORA_DISK_1: starting piece 1 at 31-MAY-11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/31/2011 15:29:53
ORA-19806: cannot make duplex backups in recovery area
RMAN> list backupset;

RMAN>
RMAN> BACKUP DEVICE TYPE DISK copies 2 DATAFILE  6 FORMAT '/oracle/b1/%U', '/oracle/b2/%U';
Starting backup at 31-MAY-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/oracle/oradata/dg/users03.dbf
channel ORA_DISK_1: starting piece 1 at 31-MAY-11
channel ORA_DISK_1: finished piece 1 at 31-MAY-11 with 2 copies and tag TAG20110531T153155
piece handle=/oracle/b1/16mdngrb_1_1 comment=NONE
piece handle=/oracle/b2/16mdngrb_1_2 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 31-MAY-11
RMAN> list backupset;

List of Backup Sets
===================
BS Key  Type LV Size
------- ---- -- ----------
23      Full    19.09M
  List of Datafiles in backup set 23
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 766014     31-MAY-11 /oracle/oradata/dg/users03.dbf
  Backup Set Copy #1 of backup set 23
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:03     31-MAY-11       NO         TAG20110531T153155
    List of Backup Pieces for backup set 23 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    27      1   AVAILABLE   /oracle/b1/16mdngrb_1_1
  Backup Set Copy #2 of backup set 23
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:03     31-MAY-11       NO         TAG20110531T153155
    List of Backup Pieces for backup set 23 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    28      1   AVAILABLE   /oracle/b2/16mdngrb_1_2
RMAN>
 
2、 duplexing only applies to backup sets, not image copies, It is an error to specify the BACKUP... COPIES when creating image copy backups, and the CONFIGURE... BACKUP COPIES setting is ignored for image copy backups.
 
多路技术只适用于backupset而不适用于image copy
RMAN> backup as copy DEVICE TYPE DISK copies 2 DATAFILE  6 FORMAT '/oracle/b1/%U', '/oracle/b2/%U';
Starting backup at 31-MAY-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/31/2011 15:36:12
RMAN-06580: the copies option cannot be used with AS COPY
 
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/b1/%U', '/oracle/b2/%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oracle/b1/%U',   '/oracle/b2/%U';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oracle/b1/%U',   '/oracle/b2/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/10.2.0/db_1/dbs/snapcf_dg.f'; # default
RMAN>
RMAN> backup as copy datafile 6;
Starting backup at 31-MAY-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00006 name=/oracle/oradata/dg/users03.dbf
output filename=/oracle/b1/data_D-DG_I-1664183733_TS-USERS_FNO-6_19mdnh4m tag=TAG20110531T153654 recid=17 stamp=752600215
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 31-MAY-11
RMAN> list copy;
specification does not match any archive log in the recovery catalog
List of Datafile Copies
Key     File S Completion Time Ckp SCN    Ckp Time        Name
------- ---- - --------------- ---------- --------------- ----
17      6    A 31-MAY-11       766182     31-MAY-11       /oracle/b1/data_D-DG_I-1664183733_TS-USERS_FNO-6_19mdnh4m
RMAN>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16158219/viewspace-696778/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 关于flashback log
请登录后发表评论 登录
全部评论

注册时间:2008-10-07

  • 博文量
    98
  • 访问量
    179538