ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 用RMAN创建Physical Standby Database(三)

用RMAN创建Physical Standby Database(三)

原创 Linux操作系统 作者:wwd_wang 时间:2009-01-16 15:17:17 0 删除 编辑

fb-db$rman target /

Recovery Manager: Release 9.2.0.7.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: RMA (DBID=1337371029)

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2048 M FORMAT   '/data/backup/%U';    

                                                                                                   

using target database controlfile instead of recovery catalog                                                         

new RMAN configuration parameters:                                                                        

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2048 M FORMAT   '/data/backup/%U';                

new RMAN configuration parameters are successfully stored                                                          

                                                                                                              

RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

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 ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2048 M FORMAT   '/data/backup/%U';

RMAN configuration has no stored or default parameters

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/product/oracle/dbs/snapcf_rma.f'; # default

RMAN> BACKUP DATABASE

2>   INCLUDE CURRENT CONTROLFILE FOR STANDBY

3>   PLUS ARCHIVELOG;

(如缺少歸檔,則在rman下执行如下语句:change archivelog all crosscheck ;一切搞定。)

RMAN> exit

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

请登录后发表评论 登录
全部评论

注册时间:2008-05-08

  • 博文量
    236
  • 访问量
    198054