oracle 11g dataguard的备份

来源：互联网发布：橱柜效果图制作软件编辑：程序博客网时间：2024/05/04 17:37

提示：dataguard的备份需要时候recover catalog，因此需要另外一个数据库来专门作为catalog server，我使用的catalog server叫：normal，并且在主库和备库上都需要设置db_recovery_file_dest和db_recovery_file_dest_size初始化参数。

我的环境：VBox、oracle11R2、oracle linux、主库：dg1、备库：dg2、catalog 库：normal

主库VBox镜像文件：http://yunpan.cn/QCBPHgnWqQDVU 访问密码 0582

备库VBox镜像文件：http://yunpan.cn/QCBPSMwhp4cev 访问密码 5f5c

catalog 库VBox镜像文件：http://yunpan.cn/QCvsWbBg3pNV6 访问密码 1491

备份步骤：

1、创建rman管理用户（在normal库上）

SQL> create tablespace cattbs datafile '/u01/app/oracle/oradata/normal/cattbs01.dbf' size 300M;Tablespace created.SQL> CREATE USER rman IDENTIFIED BY oracle TEMPORARY TABLESPACE temp DEFAULT TABLESPACE cattbs QUOTA UNLIMITED ON cattbs;User created.grant connect, resource,  RECOVERY_CATALOG_OWNER TO rman;Grant succeeded.

2、创建recovery catalog

[oracle@normal ~]$ rman catalog rman/oracleRecovery Manager: Release 11.2.0.3.0 - Production on Sat Jul 26 15:38:45 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to recovery catalog databaseRMAN> create catalog tablespace cattbs;recovery catalog created

3、配置tnsname.ora

[oracle@normal admin]$ cat tnsnames.ora normal=(        DESCRIPTION =                (ADDRESS = (PROTOCOL = TCP)(HOST = normal.localdomain)(PORT = 1521))                (CONNECT_DATA =                        (SERVER = DEDICATED)                        (SERVICE_NAME = normal)                )) dg1=(        DESCRIPTION =                (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.91)(PORT = 1521))                (CONNECT_DATA =                        (SERVER = DEDICATED)                        (SERVICE_NAME = dg1)                ))dg2=(        DESCRIPTION =                (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.92)(PORT = 1521))                (CONNECT_DATA =                        (SERVER = DEDICATED)                        (SERVICE_NAME = dg2)                ))

4、使用catalog 连接 primary数据库（dg1）数据库

[oracle@normal admin]$ rman target sys/oracle@dg1 catalog rman/oracle@normalRecovery Manager: Release 11.2.0.3.0 - Production on Sat Jul 26 18:49:18 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: DG1 (DBID=1834430236)connected to recovery catalog database

5、注册 dg1 数据库

RMAN> REGISTER DATABASE;database registered in recovery catalogstarting full resync of recovery catalogfull resync completeRMAN> report schema;Report of database schema for database with db_unique_name DG1List of Permanent Datafiles===========================File Size(MB) Tablespace           RB segs Datafile Name---- -------- -------------------- ------- ------------------------1    325      SYSTEM               YES     /u01/app/oradata/dg1/system01.dbf2    325      SYSAUX               NO      /u01/app/oradata/dg1/sysaux01.dbf3    200      UNDOTBS1             YES     /u01/app/oradata/dg1/undotbs01.dbf4    500      USERS                NO      /u01/app/oradata/dg1/users01.dbf5    100      CHENHAO01            NO      /u01/app/oradata/dg1/chenhao01.dbf6    10       CHENHAO02            NO      /u01/app/oradata/dg1/chenhao02.dbfList of Temporary Files=======================File Size(MB) Tablespace           Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1    20       TEMPTS1              20          /u01/app/oradata/dg1/temp01.dbf

6、使用catalog 连接 standby数据库（dg2） (注意：在使用target连接dg2时catalog会自动注册dg2数据库)

[oracle@normal ~]$ rman target sys/oracle@dg2 catalog rman/oracle@normal Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jul 27 08:53:24 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: DG1 (DBID=1834430236, not open)connected to recovery catalog databaseRMAN> report schema;Report of database schema for database with db_unique_name DG2List of Permanent Datafiles===========================File Size(MB) Tablespace           RB segs Datafile Name---- -------- -------------------- ------- ------------------------1    325      SYSTEM               YES     /u01/app/oradata/dg2/system01.dbf2    325      SYSAUX               NO      /u01/app/oradata/dg2/sysaux01.dbf3    200      UNDOTBS1             YES     /u01/app/oradata/dg2/undotbs01.dbf4    500      USERS                NO      /u01/app/oradata/dg2/users01.dbf5    100      CHENHAO01            NO      /u01/app/oradata/dg2/chenhao01.dbf6    10       CHENHAO02            NO      /u01/app/oradata/dg2/chenhao02.dbfList of Temporary Files=======================File Size(MB) Tablespace           Maxsize(MB) Tempfile Name---- -------- -------------------- ----------- --------------------1    20       TEMPTS1              20          /u01/app/oradata/dg2/temp01.dbf

7、修改primary数据库（dg1）CONFIGURE参数（rman连接到dg1上，和前面连接的方法一样）

--配置保留策略RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;new RMAN configuration parameters:CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;new RMAN configuration parameters are successfully storedstarting full resync of recovery catalogfull resync complete--指定何时删除归档RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;new RMAN configuration parameters:CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;new RMAN configuration parameters are successfully storedstarting full resync of recovery catalogfull resync complete--为dataguard的每个库配置连接标识RMAN> CONFIGURE DB_UNIQUE_NAME dg1 CONNECT IDENTIFIER 'dg1';new RMAN configuration parameters:CONFIGURE DB_UNIQUE_NAME 'dg1' CONNECT IDENTIFIER  'dg1';new RMAN configuration parameters are successfully storedstarting full resync of recovery catalogfull resync completeRMAN> CONFIGURE DB_UNIQUE_NAME dg2 CONNECT IDENTIFIER 'dg2';new RMAN configuration parameters:CONFIGURE DB_UNIQUE_NAME 'dg2' CONNECT IDENTIFIER  'dg2';new RMAN configuration parameters are successfully storedstarting full resync of recovery catalogfull resync complete--展现dataguard环境数据库列表RMAN> list db_unique_name of database;List of DatabasesDB Key  DB Name  DB ID            Database Role    Db_unique_name------- ------- ----------------- ---------------  ------------------344     DG1      1834430236       PRIMARY          DG1                 344     DG1      1834430236       STANDBY          DG2

8、修改standby数据库（dg2）CONFIGURE参数（rman连接到dg2上，和前面连接的方法一样）

--启动自动备份control file和spfileRMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters:CONFIGURE CONTROLFILE AUTOBACKUP ON;new RMAN configuration parameters are successfully stored--跳过已经存在的有效备份文件RMAN> CONFIGURE BACKUP OPTIMIZATION ON;new RMAN configuration parameters:CONFIGURE BACKUP OPTIMIZATION ON;new RMAN configuration parameters are successfully stored--配置日志删除策略RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;old RMAN configuration parameters:CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;new RMAN configuration parameters:CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;new RMAN configuration parameters are successfully stored-- 注意：如果还有其他的物理备库设置日志删除策略请用以下命令-- CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

9、开始备份

--同步catalogRMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;resyncing from database with DB_UNIQUE_NAME DG1starting full resync of recovery catalogfull resync complete--做个0级备份RMAN> BACKUP AS BACKUPSET INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG;Starting backup at 2014-07-27 10:15:58using channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=1 RECID=3 STAMP=853087991input archived log thread=1 sequence=2 RECID=4 STAMP=853087991input archived log thread=1 sequence=3 RECID=5 STAMP=853087991input archived log thread=1 sequence=4 RECID=6 STAMP=853087991input archived log thread=1 sequence=5 RECID=7 STAMP=853087991input archived log thread=1 sequence=6 RECID=8 STAMP=853087991input archived log thread=1 sequence=7 RECID=9 STAMP=853087991input archived log thread=1 sequence=8 RECID=10 STAMP=853087991channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:16:01channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:16:36piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r717p_.bkp tag=TAG20140727T101558 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=9 RECID=11 STAMP=853087991input archived log thread=1 sequence=10 RECID=12 STAMP=853087991input archived log thread=1 sequence=11 RECID=13 STAMP=853087992input archived log thread=1 sequence=12 RECID=14 STAMP=853087992input archived log thread=1 sequence=13 RECID=15 STAMP=853087992input archived log thread=1 sequence=14 RECID=16 STAMP=853087992input archived log thread=1 sequence=15 RECID=17 STAMP=853087992input archived log thread=1 sequence=16 RECID=18 STAMP=853087992input archived log thread=1 sequence=17 RECID=19 STAMP=853087992input archived log thread=1 sequence=18 RECID=1 STAMP=853083803input archived log thread=1 sequence=19 RECID=2 STAMP=853083804input archived log thread=1 sequence=20 RECID=20 STAMP=853087992input archived log thread=1 sequence=21 RECID=21 STAMP=853087992input archived log thread=1 sequence=22 RECID=22 STAMP=853087992input archived log thread=1 sequence=23 RECID=23 STAMP=853087992input archived log thread=1 sequence=24 RECID=24 STAMP=853087993input archived log thread=1 sequence=25 RECID=25 STAMP=853090342input archived log thread=1 sequence=26 RECID=26 STAMP=853090342input archived log thread=1 sequence=27 RECID=27 STAMP=853090342input archived log thread=1 sequence=28 RECID=28 STAMP=853090342input archived log thread=1 sequence=29 RECID=29 STAMP=853090342input archived log thread=1 sequence=30 RECID=30 STAMP=853090342input archived log thread=1 sequence=31 RECID=31 STAMP=853090342input archived log thread=1 sequence=32 RECID=32 STAMP=853090343input archived log thread=1 sequence=33 RECID=33 STAMP=853090343input archived log thread=1 sequence=34 RECID=34 STAMP=853090343input archived log thread=1 sequence=35 RECID=35 STAMP=853090343input archived log thread=1 sequence=36 RECID=37 STAMP=853090343input archived log thread=1 sequence=37 RECID=36 STAMP=853090343input archived log thread=1 sequence=38 RECID=38 STAMP=853090344input archived log thread=1 sequence=39 RECID=39 STAMP=853090455input archived log thread=1 sequence=40 RECID=40 STAMP=853090522input archived log thread=1 sequence=41 RECID=41 STAMP=853090527input archived log thread=1 sequence=42 RECID=43 STAMP=853100803input archived log thread=1 sequence=43 RECID=42 STAMP=853100803input archived log thread=1 sequence=44 RECID=44 STAMP=853100804input archived log thread=1 sequence=45 RECID=45 STAMP=853103306input archived log thread=1 sequence=46 RECID=46 STAMP=853105046input archived log thread=1 sequence=47 RECID=47 STAMP=853105046input archived log thread=1 sequence=48 RECID=48 STAMP=853105516input archived log thread=1 sequence=49 RECID=49 STAMP=853105650input archived log thread=1 sequence=50 RECID=50 STAMP=853105675input archived log thread=1 sequence=51 RECID=51 STAMP=853105680input archived log thread=1 sequence=52 RECID=52 STAMP=853105686input archived log thread=1 sequence=53 RECID=53 STAMP=853105719input archived log thread=1 sequence=54 RECID=54 STAMP=853105719input archived log thread=1 sequence=55 RECID=55 STAMP=853105721input archived log thread=1 sequence=56 RECID=57 STAMP=853106186input archived log thread=1 sequence=57 RECID=56 STAMP=853106186input archived log thread=1 sequence=58 RECID=58 STAMP=853106300input archived log thread=1 sequence=59 RECID=59 STAMP=853106306input archived log thread=1 sequence=60 RECID=60 STAMP=853106309input archived log thread=1 sequence=61 RECID=63 STAMP=853106319input archived log thread=1 sequence=62 RECID=65 STAMP=853106348input archived log thread=1 sequence=63 RECID=68 STAMP=853106591input archived log thread=1 sequence=64 RECID=70 STAMP=853106745input archived log thread=1 sequence=65 RECID=71 STAMP=853106747input archived log thread=1 sequence=66 RECID=74 STAMP=853106763input archived log thread=1 sequence=67 RECID=73 STAMP=853106763input archived log thread=1 sequence=68 RECID=75 STAMP=853106765input archived log thread=1 sequence=69 RECID=76 STAMP=853106788input archived log thread=1 sequence=70 RECID=78 STAMP=853107920input archived log thread=1 sequence=71 RECID=77 STAMP=853107919input archived log thread=1 sequence=72 RECID=79 STAMP=853109035channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:16:36channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:17:11piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r84vy_.bkp tag=TAG20140727T101558 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=73 RECID=80 STAMP=853109036input archived log thread=1 sequence=74 RECID=81 STAMP=853109326input archived log thread=1 sequence=75 RECID=82 STAMP=853109372input archived log thread=1 sequence=76 RECID=83 STAMP=853109380input archived log thread=1 sequence=77 RECID=84 STAMP=853109623input archived log thread=1 sequence=78 RECID=85 STAMP=853109643input archived log thread=1 sequence=79 RECID=86 STAMP=853109950input archived log thread=1 sequence=80 RECID=89 STAMP=853110642channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:17:12channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:17:13piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r986v_.bkp tag=TAG20140727T101558 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=1 RECID=87 STAMP=853110635input archived log thread=1 sequence=2 RECID=88 STAMP=853110636input archived log thread=1 sequence=3 RECID=90 STAMP=853110747input archived log thread=1 sequence=4 RECID=91 STAMP=853110769input archived log thread=1 sequence=5 RECID=97 STAMP=853110799input archived log thread=1 sequence=6 RECID=99 STAMP=853110806input archived log thread=1 sequence=7 RECID=101 STAMP=853110901input archived log thread=1 sequence=8 RECID=104 STAMP=853110917input archived log thread=1 sequence=9 RECID=103 STAMP=853110917input archived log thread=1 sequence=10 RECID=105 STAMP=853110921input archived log thread=1 sequence=11 RECID=106 STAMP=853110940input archived log thread=1 sequence=12 RECID=107 STAMP=853929596input archived log thread=1 sequence=13 RECID=108 STAMP=853929596input archived log thread=1 sequence=14 RECID=109 STAMP=853959336input archived log thread=1 sequence=15 RECID=110 STAMP=854009410input archived log thread=1 sequence=16 RECID=111 STAMP=854009412channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:17:13channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:17:20piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r99lx_.bkp tag=TAG20140727T101558 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07Finished backup at 2014-07-27 10:17:20Starting backup at 2014-07-27 10:17:20using channel ORA_DISK_1channel ORA_DISK_1: starting incremental level 0 datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00004 name=/u01/app/oradata/dg2/users01.dbfinput datafile file number=00001 name=/u01/app/oradata/dg2/system01.dbfinput datafile file number=00002 name=/u01/app/oradata/dg2/sysaux01.dbfinput datafile file number=00003 name=/u01/app/oradata/dg2/undotbs01.dbfinput datafile file number=00005 name=/u01/app/oradata/dg2/chenhao01.dbfinput datafile file number=00006 name=/u01/app/oradata/dg2/chenhao02.dbfchannel ORA_DISK_1: starting piece 1 at 2014-07-27 10:17:23channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:18:08piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_nnnd0_TAG20140727T101720_9x8r9m7t_.bkp tag=TAG20140727T101720 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:45Finished backup at 2014-07-27 10:18:08Starting backup at 2014-07-27 10:18:08using channel ORA_DISK_1specification does not match any archived log in the repositorybackup cancelled because there are no files to backupFinished backup at 2014-07-27 10:18:11Starting Control File and SPFILE Autobackup at 2014-07-27 10:18:11piece handle=/u01/app/oracle/flash_recovery_area/DG2/autobackup/2014_07_27/o1_mf_s_854009404_9x8rc460_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 2014-07-27 10:18:14--如果归档日志不在fast recovery area中需要使用以下命令删除不需要的归档日志RMAN> DELETE ARCHIVELOG ALL;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=43 device type=DISKList of Archived Log Copies for database with db_unique_name DG2=====================================================================Key     Thrd Seq     S Low Time           ------- ---- ------- - -------------------664     1    1       A 2014-07-16 23:10:34        Name: /u01/archivelog/arch_853110634_1_1.arc665     1    2       A 2014-07-16 23:10:35        Name: /u01/archivelog/arch_853110634_1_2.arc667     1    3       A 2014-07-16 23:10:36        Name: /u01/archivelog/arch_853110634_1_3.arc668     1    4       A 2014-07-16 23:12:27        Name: /u01/archivelog/arch_853110634_1_4.arc669     1    5       A 2014-07-16 23:12:49        Name: /u01/archivelog/arch_853110634_1_5.arc670     1    6       A 2014-07-16 23:13:19        Name: /u01/archivelog/arch_853110634_1_6.arc671     1    7       A 2014-07-16 23:13:26        Name: /u01/archivelog/arch_853110634_1_7.arc673     1    8       A 2014-07-16 23:15:04        Name: /u01/archivelog/arch_853110634_1_8.arc672     1    9       A 2014-07-16 23:15:11        Name: /u01/archivelog/arch_853110634_1_9.arc674     1    10      A 2014-07-16 23:15:12        Name: /u01/archivelog/arch_853110634_1_10.arc675     1    11      A 2014-07-16 23:15:20        Name: /u01/archivelog/arch_853110634_1_11.arc676     1    12      A 2014-07-16 23:15:40        Name: /u01/archivelog/arch_853110634_1_12.arc677     1    13      A 2014-07-26 10:39:00        Name: /u01/archivelog/arch_853110634_1_13.arc678     1    14      A 2014-07-26 10:39:52        Name: /u01/archivelog/arch_853110634_1_14.arc689     1    15      A 2014-07-26 18:55:34        Name: /u01/archivelog/arch_853110634_1_15.arc690     1    16      A 2014-07-27 08:48:22        Name: /u01/archivelog/arch_853110634_1_16.arcDo you really want to delete the above objects (enter YES or NO)? yesdeleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_1.arc RECID=87 STAMP=853110635deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_2.arc RECID=88 STAMP=853110636deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_3.arc RECID=90 STAMP=853110747deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_4.arc RECID=91 STAMP=853110769deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_5.arc RECID=97 STAMP=853110799deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_6.arc RECID=99 STAMP=853110806deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_7.arc RECID=101 STAMP=853110901deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_8.arc RECID=104 STAMP=853110917deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_9.arc RECID=103 STAMP=853110917deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_10.arc RECID=105 STAMP=853110921deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_11.arc RECID=106 STAMP=853110940deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_12.arc RECID=107 STAMP=853929596deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_13.arc RECID=108 STAMP=853929596deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_14.arc RECID=109 STAMP=853959336deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_15.arc RECID=110 STAMP=854009410deleted archived logarchived log file name=/u01/archivelog/arch_853110634_1_16.arc RECID=111 STAMP=854009412Deleted 16 objects--列出备份信息RMAN> list backupset;List of Backup Sets===================BS Key  Size       Device Type Elapsed Time Completion Time    ------- ---------- ----------- ------------ -------------------799     60.55M     DISK        00:00:04     2014-07-27 10:17:17        BP Key: 803   Status: AVAILABLE  Compressed: NO  Tag: TAG20140727T101558        Piece Name: /u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r99lx_.bkp  List of Archived Logs in backup set 799  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time  ---- ------- ---------- ------------------- ---------- ---------  1    1       279463     2014-07-16 23:10:34 279466     2014-07-16 23:10:35  1    2       279466     2014-07-16 23:10:35 279527     2014-07-16 23:10:36  1    3       279527     2014-07-16 23:10:36 279712     2014-07-16 23:12:27  1    4       279712     2014-07-16 23:12:27 279730     2014-07-16 23:12:49  1    5       279730     2014-07-16 23:12:49 279766     2014-07-16 23:13:19  1    6       279766     2014-07-16 23:13:19 279778     2014-07-16 23:13:26  1    7       279778     2014-07-16 23:13:26 299883     2014-07-16 23:15:00  1    8       299883     2014-07-16 23:15:04 299886     2014-07-16 23:15:11  1    9       299886     2014-07-16 23:15:11 299966     2014-07-16 23:15:12  1    10      299966     2014-07-16 23:15:12 300011     2014-07-16 23:15:20  1    11      300011     2014-07-16 23:15:20 300035     2014-07-16 23:15:40  1    12      300035     2014-07-16 23:15:40 300353     2014-07-26 10:39:00  1    13      300353     2014-07-26 10:39:00 300589     2014-07-26 10:39:52  1    14      300589     2014-07-26 10:39:52 337060     2014-07-26 18:55:34  1    15      337060     2014-07-26 18:55:34 348524     2014-07-27 08:48:22  1    16      348524     2014-07-27 08:48:22 351942     2014-07-27 08:50:04BS Key  Type LV Size       Device Type Elapsed Time Completion Time    ------- ---- -- ---------- ----------- ------------ -------------------910     Incr 0  410.35M    DISK        00:00:36     2014-07-27 10:17:59        BP Key: 927   Status: AVAILABLE  Compressed: NO  Tag: TAG20140727T101720        Piece Name: /u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_nnnd0_TAG20140727T101720_9x8r9m7t_.bkp  List of Datafiles in backup set 910  File LV Type Ckp SCN    Ckp Time            Name  ---- -- ---- ---------- ------------------- ----  1    0  Incr 351942     2014-07-27 08:50:04 /u01/app/oradata/dg2/system01.dbf  2    0  Incr 351942     2014-07-27 08:50:04 /u01/app/oradata/dg2/sysaux01.dbf  3    0  Incr 351942     2014-07-27 08:50:04 /u01/app/oradata/dg2/undotbs01.dbf  4    0  Incr 351942     2014-07-27 08:50:04 /u01/app/oradata/dg2/users01.dbf  5    0  Incr 351942     2014-07-27 08:50:04 /u01/app/oradata/dg2/chenhao01.dbf  6    0  Incr 351942     2014-07-27 08:50:04 /u01/app/oradata/dg2/chenhao02.dbfBS Key  Type LV Size       Device Type Elapsed Time Completion Time    ------- ---- -- ---------- ----------- ------------ -------------------945     Full    9.42M      DISK        00:00:01     2014-07-27 10:18:12        BP Key: 952   Status: AVAILABLE  Compressed: NO  Tag: TAG20140727T101811        Piece Name: /u01/app/oracle/flash_recovery_area/DG2/autobackup/2014_07_27/o1_mf_s_854009404_9x8rc460_.bkp  SPFILE Included: Modification time: 2014-07-27 08:50:12  SPFILE db_unique_name: DG2  Standby Control File Included: Ckp SCN: 351942       Ckp time: 2014-07-27 08:50:04

0 0