提示: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/oracle
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jul 26 15:38:45 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> 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@normal
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jul 26 18:49:18 2014
Copyright (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 catalog
starting full resync of recovery catalog
full resync complete
RMAN> report schema;
Report of database schema for database with db_unique_name DG1
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 325 SYSTEM YES /u01/app/oradata/dg1/system01.dbf
2 325 SYSAUX NO /u01/app/oradata/dg1/sysaux01.dbf
3 200 UNDOTBS1 YES /u01/app/oradata/dg1/undotbs01.dbf
4 500 USERS NO /u01/app/oradata/dg1/users01.dbf
5 100 CHENHAO01 NO /u01/app/oradata/dg1/chenhao01.dbf
6 10 CHENHAO02 NO /u01/app/oradata/dg1/chenhao02.dbf
List 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 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DG1 (DBID=1834430236, not open)
connected to recovery catalog database
RMAN> report schema;
Report of database schema for database with db_unique_name DG2
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 325 SYSTEM YES /u01/app/oradata/dg2/system01.dbf
2 325 SYSAUX NO /u01/app/oradata/dg2/sysaux01.dbf
3 200 UNDOTBS1 YES /u01/app/oradata/dg2/undotbs01.dbf
4 500 USERS NO /u01/app/oradata/dg2/users01.dbf
5 100 CHENHAO01 NO /u01/app/oradata/dg2/chenhao01.dbf
6 10 CHENHAO02 NO /u01/app/oradata/dg2/chenhao02.dbf
List 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 stored
starting full resync of recovery catalog
full 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 stored
starting full resync of recovery catalog
full 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 stored
starting full resync of recovery catalog
full resync complete
RMAN> 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 stored
starting full resync of recovery catalog
full resync complete
--展现dataguard环境数据库列表
RMAN> list db_unique_name of database;
List of Databases
DB 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和spfile
RMAN> 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、开始备份
--同步catalog
RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
resyncing from database with DB_UNIQUE_NAME DG1
starting full resync of recovery catalog
full resync complete
--做个0级备份
RMAN> BACKUP AS BACKUPSET INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG;
Starting backup at 2014-07-27 10:15:58
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=3 STAMP=853087991
input archived log thread=1 sequence=2 RECID=4 STAMP=853087991
input archived log thread=1 sequence=3 RECID=5 STAMP=853087991
input archived log thread=1 sequence=4 RECID=6 STAMP=853087991
input archived log thread=1 sequence=5 RECID=7 STAMP=853087991
input archived log thread=1 sequence=6 RECID=8 STAMP=853087991
input archived log thread=1 sequence=7 RECID=9 STAMP=853087991
input archived log thread=1 sequence=8 RECID=10 STAMP=853087991
channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:16:01
channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:16:36
piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r717p_.bkp tag=TAG20140727T101558 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=11 STAMP=853087991
input archived log thread=1 sequence=10 RECID=12 STAMP=853087991
input archived log thread=1 sequence=11 RECID=13 STAMP=853087992
input archived log thread=1 sequence=12 RECID=14 STAMP=853087992
input archived log thread=1 sequence=13 RECID=15 STAMP=853087992
input archived log thread=1 sequence=14 RECID=16 STAMP=853087992
input archived log thread=1 sequence=15 RECID=17 STAMP=853087992
input archived log thread=1 sequence=16 RECID=18 STAMP=853087992
input archived log thread=1 sequence=17 RECID=19 STAMP=853087992
input archived log thread=1 sequence=18 RECID=1 STAMP=853083803
input archived log thread=1 sequence=19 RECID=2 STAMP=853083804
input archived log thread=1 sequence=20 RECID=20 STAMP=853087992
input archived log thread=1 sequence=21 RECID=21 STAMP=853087992
input archived log thread=1 sequence=22 RECID=22 STAMP=853087992
input archived log thread=1 sequence=23 RECID=23 STAMP=853087992
input archived log thread=1 sequence=24 RECID=24 STAMP=853087993
input archived log thread=1 sequence=25 RECID=25 STAMP=853090342
input archived log thread=1 sequence=26 RECID=26 STAMP=853090342
input archived log thread=1 sequence=27 RECID=27 STAMP=853090342
input archived log thread=1 sequence=28 RECID=28 STAMP=853090342
input archived log thread=1 sequence=29 RECID=29 STAMP=853090342
input archived log thread=1 sequence=30 RECID=30 STAMP=853090342
input archived log thread=1 sequence=31 RECID=31 STAMP=853090342
input archived log thread=1 sequence=32 RECID=32 STAMP=853090343
input archived log thread=1 sequence=33 RECID=33 STAMP=853090343
input archived log thread=1 sequence=34 RECID=34 STAMP=853090343
input archived log thread=1 sequence=35 RECID=35 STAMP=853090343
input archived log thread=1 sequence=36 RECID=37 STAMP=853090343
input archived log thread=1 sequence=37 RECID=36 STAMP=853090343
input archived log thread=1 sequence=38 RECID=38 STAMP=853090344
input archived log thread=1 sequence=39 RECID=39 STAMP=853090455
input archived log thread=1 sequence=40 RECID=40 STAMP=853090522
input archived log thread=1 sequence=41 RECID=41 STAMP=853090527
input archived log thread=1 sequence=42 RECID=43 STAMP=853100803
input archived log thread=1 sequence=43 RECID=42 STAMP=853100803
input archived log thread=1 sequence=44 RECID=44 STAMP=853100804
input archived log thread=1 sequence=45 RECID=45 STAMP=853103306
input archived log thread=1 sequence=46 RECID=46 STAMP=853105046
input archived log thread=1 sequence=47 RECID=47 STAMP=853105046
input archived log thread=1 sequence=48 RECID=48 STAMP=853105516
input archived log thread=1 sequence=49 RECID=49 STAMP=853105650
input archived log thread=1 sequence=50 RECID=50 STAMP=853105675
input archived log thread=1 sequence=51 RECID=51 STAMP=853105680
input archived log thread=1 sequence=52 RECID=52 STAMP=853105686
input archived log thread=1 sequence=53 RECID=53 STAMP=853105719
input archived log thread=1 sequence=54 RECID=54 STAMP=853105719
input archived log thread=1 sequence=55 RECID=55 STAMP=853105721
input archived log thread=1 sequence=56 RECID=57 STAMP=853106186
input archived log thread=1 sequence=57 RECID=56 STAMP=853106186
input archived log thread=1 sequence=58 RECID=58 STAMP=853106300
input archived log thread=1 sequence=59 RECID=59 STAMP=853106306
input archived log thread=1 sequence=60 RECID=60 STAMP=853106309
input archived log thread=1 sequence=61 RECID=63 STAMP=853106319
input archived log thread=1 sequence=62 RECID=65 STAMP=853106348
input archived log thread=1 sequence=63 RECID=68 STAMP=853106591
input archived log thread=1 sequence=64 RECID=70 STAMP=853106745
input archived log thread=1 sequence=65 RECID=71 STAMP=853106747
input archived log thread=1 sequence=66 RECID=74 STAMP=853106763
input archived log thread=1 sequence=67 RECID=73 STAMP=853106763
input archived log thread=1 sequence=68 RECID=75 STAMP=853106765
input archived log thread=1 sequence=69 RECID=76 STAMP=853106788
input archived log thread=1 sequence=70 RECID=78 STAMP=853107920
input archived log thread=1 sequence=71 RECID=77 STAMP=853107919
input archived log thread=1 sequence=72 RECID=79 STAMP=853109035
channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:16:36
channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:17:11
piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r84vy_.bkp tag=TAG20140727T101558 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=73 RECID=80 STAMP=853109036
input archived log thread=1 sequence=74 RECID=81 STAMP=853109326
input archived log thread=1 sequence=75 RECID=82 STAMP=853109372
input archived log thread=1 sequence=76 RECID=83 STAMP=853109380
input archived log thread=1 sequence=77 RECID=84 STAMP=853109623
input archived log thread=1 sequence=78 RECID=85 STAMP=853109643
input archived log thread=1 sequence=79 RECID=86 STAMP=853109950
input archived log thread=1 sequence=80 RECID=89 STAMP=853110642
channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:17:12
channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:17:13
piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r986v_.bkp tag=TAG20140727T101558 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=87 STAMP=853110635
input archived log thread=1 sequence=2 RECID=88 STAMP=853110636
input archived log thread=1 sequence=3 RECID=90 STAMP=853110747
input archived log thread=1 sequence=4 RECID=91 STAMP=853110769
input archived log thread=1 sequence=5 RECID=97 STAMP=853110799
input archived log thread=1 sequence=6 RECID=99 STAMP=853110806
input archived log thread=1 sequence=7 RECID=101 STAMP=853110901
input archived log thread=1 sequence=8 RECID=104 STAMP=853110917
input archived log thread=1 sequence=9 RECID=103 STAMP=853110917
input archived log thread=1 sequence=10 RECID=105 STAMP=853110921
input archived log thread=1 sequence=11 RECID=106 STAMP=853110940
input archived log thread=1 sequence=12 RECID=107 STAMP=853929596
input archived log thread=1 sequence=13 RECID=108 STAMP=853929596
input archived log thread=1 sequence=14 RECID=109 STAMP=853959336
input archived log thread=1 sequence=15 RECID=110 STAMP=854009410
input archived log thread=1 sequence=16 RECID=111 STAMP=854009412
channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:17:13
channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:17:20
piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_annnn_TAG20140727T101558_9x8r99lx_.bkp tag=TAG20140727T101558 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 2014-07-27 10:17:20
Starting backup at 2014-07-27 10:17:20
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oradata/dg2/users01.dbf
input datafile file number=00001 name=/u01/app/oradata/dg2/system01.dbf
input datafile file number=00002 name=/u01/app/oradata/dg2/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oradata/dg2/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oradata/dg2/chenhao01.dbf
input datafile file number=00006 name=/u01/app/oradata/dg2/chenhao02.dbf
channel ORA_DISK_1: starting piece 1 at 2014-07-27 10:17:23
channel ORA_DISK_1: finished piece 1 at 2014-07-27 10:18:08
piece handle=/u01/app/oracle/flash_recovery_area/DG2/backupset/2014_07_27/o1_mf_nnnd0_TAG20140727T101720_9x8r9m7t_.bkp tag=TAG20140727T101720 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 2014-07-27 10:18:08
Starting backup at 2014-07-27 10:18:08
using channel ORA_DISK_1
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 2014-07-27 10:18:11
Starting Control File and SPFILE Autobackup at 2014-07-27 10:18:11
piece handle=/u01/app/oracle/flash_recovery_area/DG2/autobackup/2014_07_27/o1_mf_s_854009404_9x8rc460_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2014-07-27 10:18:14
--如果归档日志不在fast recovery area中需要使用以下命令删除不需要的归档日志
RMAN> DELETE ARCHIVELOG ALL;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
List 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.arc
665 1 2 A 2014-07-16 23:10:35
Name: /u01/archivelog/arch_853110634_1_2.arc
667 1 3 A 2014-07-16 23:10:36
Name: /u01/archivelog/arch_853110634_1_3.arc
668 1 4 A 2014-07-16 23:12:27
Name: /u01/archivelog/arch_853110634_1_4.arc
669 1 5 A 2014-07-16 23:12:49
Name: /u01/archivelog/arch_853110634_1_5.arc
670 1 6 A 2014-07-16 23:13:19
Name: /u01/archivelog/arch_853110634_1_6.arc
671 1 7 A 2014-07-16 23:13:26
Name: /u01/archivelog/arch_853110634_1_7.arc
673 1 8 A 2014-07-16 23:15:04
Name: /u01/archivelog/arch_853110634_1_8.arc
672 1 9 A 2014-07-16 23:15:11
Name: /u01/archivelog/arch_853110634_1_9.arc
674 1 10 A 2014-07-16 23:15:12
Name: /u01/archivelog/arch_853110634_1_10.arc
675 1 11 A 2014-07-16 23:15:20
Name: /u01/archivelog/arch_853110634_1_11.arc
676 1 12 A 2014-07-16 23:15:40
Name: /u01/archivelog/arch_853110634_1_12.arc
677 1 13 A 2014-07-26 10:39:00
Name: /u01/archivelog/arch_853110634_1_13.arc
678 1 14 A 2014-07-26 10:39:52
Name: /u01/archivelog/arch_853110634_1_14.arc
689 1 15 A 2014-07-26 18:55:34
Name: /u01/archivelog/arch_853110634_1_15.arc
690 1 16 A 2014-07-27 08:48:22
Name: /u01/archivelog/arch_853110634_1_16.arc
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_1.arc RECID=87 STAMP=853110635
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_2.arc RECID=88 STAMP=853110636
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_3.arc RECID=90 STAMP=853110747
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_4.arc RECID=91 STAMP=853110769
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_5.arc RECID=97 STAMP=853110799
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_6.arc RECID=99 STAMP=853110806
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_7.arc RECID=101 STAMP=853110901
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_8.arc RECID=104 STAMP=853110917
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_9.arc RECID=103 STAMP=853110917
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_10.arc RECID=105 STAMP=853110921
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_11.arc RECID=106 STAMP=853110940
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_12.arc RECID=107 STAMP=853929596
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_13.arc RECID=108 STAMP=853929596
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_14.arc RECID=109 STAMP=853959336
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_15.arc RECID=110 STAMP=854009410
deleted archived log
archived log file name=/u01/archivelog/arch_853110634_1_16.arc RECID=111 STAMP=854009412
Deleted 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:04
BS 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.dbf
BS 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