Oracle 10g RAC RMAN backup Example

最新推荐文章于 2022-11-30 18:00:34 发布
最新推荐文章于 2022-11-30 18:00:34 发布
阅读量1.4k 收藏 2
点赞数
分类专栏： Oracle Oracle RAC 文章标签： oracle Oracle ORACLE oracle rac Oracle RAC
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/staricqxyz/article/details/8433312
版权

Database Version: 10.2.0.5 3nodes


Verify the databases are in archivelog mode and archive destination

racnode1

[oracle@racnode1 arch]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:31:03 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /u01/app/oracle/arch
Oldest online log sequence     17
Next log sequence to archive   18
Current log sequence	       18

racnode2 

[oracle@racnode2 arch]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:32:17 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /u01/app/oracle/arch
Oldest online log sequence     9
Next log sequence to archive   10
Current log sequence	       10

racnode3 

[oracle@racnode3 arch]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:32:43 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> archive log list
Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       /u01/app/oracle/arch
Oldest online log sequence     2
Next log sequence to archive   3
Current log sequence	       3



Verify connectivity to the target nodes and catalog if used 

[oracle@racnode3 arch]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 25 14:34:59 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> conn sys/oracle@racdb1 as sysdba
Connected.
SQL> conn sys/oracle@racdb2 as sysdba
Connected.
SQL> conn sys/oracle@racdb3 as sysdba
Connected.
SQL> conn sys/oracle@racdb as sysdba
Connected.
SQL>


Connect using RMAN to verify and set the controlfile persistent configuration

[oracle@racnode1 backup]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Dec 25 14:40:45 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: RACDB (DBID=800157471)

RMAN> show all;

using target database control file instead of recovery catalog
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; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
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 '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_racdb1.f'; # default

RMAN>


In this example, using PARALLELISM 3 as 3 nodes are used.The PARALLELISM will than automaticly start 3 channels and will use the related CONFIGURE CHANNEL for additional clauses. 
RMAN> configure retention policy to redundancy 3;


new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
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> configure controlfile autobackup format for device type disk to '/u01/app/oracle/backup/%F';


new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';
new RMAN configuration parameters are successfully stored


RMAN> configure device type disk parallelism 3;


new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored


RMAN> configure channel 1 device type disk connect sys/oracle@racdb1;


new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored


RMAN> configure channel 2 device type disk connect sys/oracle@racdb2;


new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored


RMAN> configure channel 3 device type disk connect 'sys/oracle@racdb3';


new RMAN configuration parameters:
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored


RMAN> 

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
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 '/u01/app/oracle/backup/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';
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 '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_racdb1.f'; # default

RMAN>


backup incremental level 0 

[oracle@racnode1 backup]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Dec 25 15:09:42 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: RACDB (DBID=800157471)

RMAN> run{
2> configure retention policy to redundancy 3;
3> configure controlfile autobackup on;
4> configure controlfile autobackup format for device type disk to '/u01/app/oracle/backup/%F';
5> configure device type disk parallelism 3;
6> configure channel 1 device type disk connect sys/oracle@racdb1;
7> configure channel 2 device type disk connect sys/oracle@racdb2;
8> configure channel 3 device type disk connect sys/oracle@racdb3;
9> configure maxsetsize to unlimited;
10> backup incremental level 0
11> format '/u01/app/oracle/backup/%d_LVL0_%T_%u_s%s_p%p' tag 'DB_INC0'
12> database;
13> backup archivelog all format '/u01/app/oracle/backup/%d_ARCH_%T_%u_s%s_p%p' tag 'ARCH_INC0'
14> delete input;
15> }

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters are successfully stored

Starting backup at 25-DEC-2012 15:12:32
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=845 instance=racdb1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=855 instance=racdb2 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=848 instance=racdb3 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATADG/racdb/datafile/system.256.802540615
channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:12:35
channel ORA_DISK_2: starting incremental level 0 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=+DATADG/racdb/datafile/sysaux.257.802540615
input datafile fno=00006 name=+DATADG/racdb/datafile/undotbs2.265.802540981
input datafile fno=00004 name=+DATADG/racdb/datafile/users.259.802540615
channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:12:35
channel ORA_DISK_3: starting incremental level 0 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00005 name=+DATADG/racdb/datafile/example.264.802540751
input datafile fno=00002 name=+DATADG/racdb/datafile/undotbs1.258.802540615
input datafile fno=00007 name=+DATADG/racdb/datafile/undotbs3.269.802888323
channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:12:36
channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:13:01
piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1 tag=DB_INC0 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:26
channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:13:46
piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1 tag=DB_INC0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:11
channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:13:47
piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1 tag=DB_INC0 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:12
Finished backup at 25-DEC-2012 15:13:46

Starting backup at 25-DEC-2012 15:13:50
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_3: starting archive log backupset
channel ORA_DISK_3: specifying archive log(s) in backup set
input archive log thread=3 sequence=3 recid=29 stamp=802970034
channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:13:56
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=15 recid=22 stamp=802967112
channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:13:56
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=2 sequence=10 recid=28 stamp=802970033
channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:13:57
channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:13:57
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1 tag=ARCH_INC0 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_3: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/3_3_802540708.dbf recid=29 stamp=802970034
channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:13:58
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1 tag=ARCH_INC0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/1_15_802540708.dbf recid=22 stamp=802967112
channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:13:59
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1 tag=ARCH_INC0 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_2: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/2_10_802540708.dbf recid=28 stamp=802970033
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=18 recid=27 stamp=802970031
channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:13:58
channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:13:59
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1 tag=ARCH_INC0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/1_18_802540708.dbf recid=27 stamp=802970031
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=16 recid=24 stamp=802967124
input archive log thread=1 sequence=17 recid=25 stamp=802967126
channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:14:01
channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:14:02
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1 tag=ARCH_INC0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/1_16_802540708.dbf recid=24 stamp=802967124
archive log filename=/u01/app/oracle/arch/1_17_802540708.dbf recid=25 stamp=802967126
Finished backup at 25-DEC-2012 15:14:02

Starting Control File and SPFILE Autobackup at 25-DEC-2012 15:14:02
piece handle=/u01/app/oracle/backup/c-800157471-20121225-00 comment=NONE
Finished Control File and SPFILE Autobackup at 25-DEC-2012 15:14:09

RMAN>

backup incremental level 1 

RMAN> run{
2> configure retention policy to redundancy 3;
3> configure controlfile autobackup on;
4> configure controlfile autobackup format for device type disk to '/u01/app/oracle/backup/%F';
5> configure device type disk parallelism 3;
6> configure channel 1 device type disk connect sys/oracle@racdb1;
7> configure channel 2 device type disk connect sys/oracle@racdb2;
8> configure channel 3 device type disk connect sys/oracle@racdb3;
9> configure maxsetsize to unlimited;
10> backup incremental level 1
11> format '/u01/app/oracle/backup/%d_LVL1_%T_%u_s%s_p%p' tag 'DB_INC1'
12> database;
13> backup archivelog all format '/u01/app/oracle/backup/%d_ARCH_%T_%u_s%s_p%p' tag 'ARCH_INC1'
14> delete input;
15> crosscheck backupset;
16> delete noprompt expired backup;
17> delete noprompt obsolete;
18> }

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters:
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CONNECT '*';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters:
CONFIGURE MAXSETSIZE TO UNLIMITED;
new RMAN configuration parameters are successfully stored

Starting backup at 25-DEC-2012 15:24:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=845 instance=racdb1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=855 instance=racdb2 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=848 instance=racdb3 devtype=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATADG/racdb/datafile/system.256.802540615
channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:24:53
channel ORA_DISK_2: starting incremental level 1 datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00003 name=+DATADG/racdb/datafile/sysaux.257.802540615
input datafile fno=00006 name=+DATADG/racdb/datafile/undotbs2.265.802540981
input datafile fno=00004 name=+DATADG/racdb/datafile/users.259.802540615
channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:24:53
channel ORA_DISK_3: starting incremental level 1 datafile backupset
channel ORA_DISK_3: specifying datafile(s) in backupset
input datafile fno=00005 name=+DATADG/racdb/datafile/example.264.802540751
input datafile fno=00002 name=+DATADG/racdb/datafile/undotbs1.258.802540615
input datafile fno=00007 name=+DATADG/racdb/datafile/undotbs3.269.802888323
channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:25:02
channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:25:05
piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1 tag=DB_INC1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12
channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:25:20
piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1 tag=DB_INC1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:27
channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:25:20
piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1 tag=DB_INC1 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:27
Finished backup at 25-DEC-2012 15:25:20

Starting backup at 25-DEC-2012 15:25:24
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=19 recid=30 stamp=802970726
channel ORA_DISK_1: starting piece 1 at 25-DEC-2012 15:25:33
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=2 sequence=11 recid=31 stamp=802970726
channel ORA_DISK_2: starting piece 1 at 25-DEC-2012 15:25:33
channel ORA_DISK_3: starting archive log backupset
channel ORA_DISK_3: specifying archive log(s) in backup set
input archive log thread=3 sequence=4 recid=32 stamp=802970727
channel ORA_DISK_3: starting piece 1 at 25-DEC-2012 15:25:34
channel ORA_DISK_1: finished piece 1 at 25-DEC-2012 15:25:34
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1 tag=ARCH_INC1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/1_19_802540708.dbf recid=30 stamp=802970726
channel ORA_DISK_2: finished piece 1 at 25-DEC-2012 15:25:34
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1 tag=ARCH_INC1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/2_11_802540708.dbf recid=31 stamp=802970726
channel ORA_DISK_3: finished piece 1 at 25-DEC-2012 15:25:34
piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1 tag=ARCH_INC1 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_3: deleting archive log(s)
archive log filename=/u01/app/oracle/arch/3_4_802540708.dbf recid=32 stamp=802970727
Finished backup at 25-DEC-2012 15:25:34

Starting Control File and SPFILE Autobackup at 25-DEC-2012 15:25:34
piece handle=/u01/app/oracle/backup/c-800157471-20121225-01 comment=NONE
Finished Control File and SPFILE Autobackup at 25-DEC-2012 15:25:41

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1 recid=3 stamp=802969955
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1 recid=5 stamp=802970036
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1 recid=7 stamp=802970038
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1 recid=8 stamp=802970041
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/c-800157471-20121225-00 recid=9 stamp=802970045
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1 recid=10 stamp=802970693
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1 recid=13 stamp=802970733
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/c-800157471-20121225-01 recid=16 stamp=802970736
Crosschecked 8 objects

crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1 recid=2 stamp=802969956
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1 recid=6 stamp=802970037
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1 recid=12 stamp=802970702
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1 recid=14 stamp=802970733
Crosschecked 4 objects

crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1 recid=1 stamp=802969965
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1 recid=4 stamp=802970036
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1 recid=11 stamp=802970706
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1 recid=15 stamp=802970734
Crosschecked 4 objects


using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 3
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
no obsolete backups found

RMAN>

summary 

RMAN> list backupset;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
1       Incr 0  66.25M     DISK        00:00:24     25-DEC-2012 15:12:59
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: DB_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  2    0  Incr 930970     25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs1.258.802540615
  5    0  Incr 930970     25-DEC-2012 15:12:42 +DATADG/racdb/datafile/example.264.802540751
  7    0  Incr 930970     25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs3.269.802888323

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
2       Incr 0  263.96M    DISK        00:01:05     25-DEC-2012 15:13:40
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: DB_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3    0  Incr 930964     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/sysaux.257.802540615
  4    0  Incr 930964     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/users.259.802540615
  6    0  Incr 930964     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/undotbs2.265.802540981

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
3       Incr 0  370.38M    DISK        00:01:07     25-DEC-2012 15:13:42
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: DB_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1    0  Incr 930959     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/system.256.802540615

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
4       693.00K    DISK        00:00:01     25-DEC-2012 15:13:57
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1

  List of Archived Logs in backup set 4
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  3    3       926740     25-DEC-2012 14:25:27 931028     25-DEC-2012 15:13:53

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
5       3.30M      DISK        00:00:01     25-DEC-2012 15:13:57
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    15      892350     25-DEC-2012 11:24:17 926723     25-DEC-2012 14:25:11

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
6       791.50K    DISK        00:00:02     25-DEC-2012 15:13:58
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  2    10      926728     25-DEC-2012 14:25:14 931026     25-DEC-2012 15:13:52

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
7       1.43M      DISK        00:00:01     25-DEC-2012 15:13:59
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1

  List of Archived Logs in backup set 7
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    18      926737     25-DEC-2012 14:25:26 931023     25-DEC-2012 15:13:51

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
8       3.50K      DISK        00:00:01     25-DEC-2012 15:14:01
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1

  List of Archived Logs in backup set 8
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    16      926723     25-DEC-2012 14:25:11 926734     25-DEC-2012 14:25:23
  1    17      926734     25-DEC-2012 14:25:23 926737     25-DEC-2012 14:25:26

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
9       Full    14.67M     DISK        00:00:04     25-DEC-2012 15:14:06
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20121225T151402
        Piece Name: /u01/app/oracle/backup/c-800157471-20121225-00
  Control File Included: Ckp SCN: 931040       Ckp time: 25-DEC-2012 15:14:02
  SPFILE Included: Modification time: 25-DEC-2012 14:23:24

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
10      Incr 1  128.00K    DISK        00:00:09     25-DEC-2012 15:25:02
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: DB_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1    1  Incr 931568     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/system.256.802540615

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
11      Incr 1  232.00K    DISK        00:00:21     25-DEC-2012 15:25:14
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: DB_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  2    1  Incr 931576     25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs1.258.802540615
  5    1  Incr 931576     25-DEC-2012 15:25:03 +DATADG/racdb/datafile/example.264.802540751
  7    1  Incr 931576     25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs3.269.802888323

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
12      Incr 1  208.00K    DISK        00:00:21     25-DEC-2012 15:25:14
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: DB_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3    1  Incr 931570     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/sysaux.257.802540615
  4    1  Incr 931570     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/users.259.802540615
  6    1  Incr 931570     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/undotbs2.265.802540981

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
13      38.00K     DISK        00:00:02     25-DEC-2012 15:25:34
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    19      931023     25-DEC-2012 15:13:51 931599     25-DEC-2012 15:25:25

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
14      58.00K     DISK        00:00:02     25-DEC-2012 15:25:34
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  2    11      931026     25-DEC-2012 15:13:52 931601     25-DEC-2012 15:25:26

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
15      5.00K      DISK        00:00:02     25-DEC-2012 15:25:34
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1

  List of Archived Logs in backup set 15
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  3    4       931028     25-DEC-2012 15:13:53 931604     25-DEC-2012 15:25:26

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
16      Full    14.67M     DISK        00:00:04     25-DEC-2012 15:25:38
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20121225T152534
        Piece Name: /u01/app/oracle/backup/c-800157471-20121225-01
  Control File Included: Ckp SCN: 931613       Ckp time: 25-DEC-2012 15:25:34
  SPFILE Included: Modification time: 25-DEC-2012 14:23:24

RMAN> 
RMAN> list backupset summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
1       B  0  A DISK        25-DEC-2012 15:12:59 1       1       NO         DB_INC0
2       B  0  A DISK        25-DEC-2012 15:13:40 1       1       NO         DB_INC0
3       B  0  A DISK        25-DEC-2012 15:13:42 1       1       NO         DB_INC0
4       B  A  A DISK        25-DEC-2012 15:13:57 1       1       NO         ARCH_INC0
5       B  A  A DISK        25-DEC-2012 15:13:57 1       1       NO         ARCH_INC0
6       B  A  A DISK        25-DEC-2012 15:13:58 1       1       NO         ARCH_INC0
7       B  A  A DISK        25-DEC-2012 15:13:59 1       1       NO         ARCH_INC0
8       B  A  A DISK        25-DEC-2012 15:14:01 1       1       NO         ARCH_INC0
9       B  F  A DISK        25-DEC-2012 15:14:06 1       1       NO         TAG20121225T151402
10      B  1  A DISK        25-DEC-2012 15:25:02 1       1       NO         DB_INC1
11      B  1  A DISK        25-DEC-2012 15:25:14 1       1       NO         DB_INC1
12      B  1  A DISK        25-DEC-2012 15:25:14 1       1       NO         DB_INC1
13      B  A  A DISK        25-DEC-2012 15:25:34 1       1       NO         ARCH_INC1
14      B  A  A DISK        25-DEC-2012 15:25:34 1       1       NO         ARCH_INC1
15      B  A  A DISK        25-DEC-2012 15:25:34 1       1       NO         ARCH_INC1
16      B  F  A DISK        25-DEC-2012 15:25:38 1       1       NO         TAG20121225T152534

RMAN> 
RMAN> list backup by file;


List of Datafile Backups
========================

File Key     TY LV S Ckp SCN    Ckp Time             #Pieces #Copies Compressed Tag
---- ------- -  -- - ---------- -------------------- ------- ------- ---------- ---
1    10      B  1  A 931568     25-DEC-2012 15:24:53 1       1       NO         DB_INC1
     3       B  0  A 930959     25-DEC-2012 15:12:35 1       1       NO         DB_INC0
2    11      B  1  A 931576     25-DEC-2012 15:25:03 1       1       NO         DB_INC1
     1       B  0  A 930970     25-DEC-2012 15:12:42 1       1       NO         DB_INC0
3    12      B  1  A 931570     25-DEC-2012 15:24:53 1       1       NO         DB_INC1
     2       B  0  A 930964     25-DEC-2012 15:12:35 1       1       NO         DB_INC0
4    12      B  1  A 931570     25-DEC-2012 15:24:53 1       1       NO         DB_INC1
     2       B  0  A 930964     25-DEC-2012 15:12:35 1       1       NO         DB_INC0
5    11      B  1  A 931576     25-DEC-2012 15:25:03 1       1       NO         DB_INC1
     1       B  0  A 930970     25-DEC-2012 15:12:42 1       1       NO         DB_INC0
6    12      B  1  A 931570     25-DEC-2012 15:24:53 1       1       NO         DB_INC1
     2       B  0  A 930964     25-DEC-2012 15:12:35 1       1       NO         DB_INC0
7    11      B  1  A 931576     25-DEC-2012 15:25:03 1       1       NO         DB_INC1
     1       B  0  A 930970     25-DEC-2012 15:12:42 1       1       NO         DB_INC0

List of Archived Log Backups
============================

Thrd Seq     Low SCN    Low Time             BS Key  S #Pieces #Copies Compressed Tag
---- ------- ---------- -------------------- ------- - ------- ------- ---------- ---
1    15      892350     25-DEC-2012 11:24:17 5       A 1       1       NO         ARCH_INC0
1    16      926723     25-DEC-2012 14:25:11 8       A 1       1       NO         ARCH_INC0
1    17      926734     25-DEC-2012 14:25:23 8       A 1       1       NO         ARCH_INC0
1    18      926737     25-DEC-2012 14:25:26 7       A 1       1       NO         ARCH_INC0
1    19      931023     25-DEC-2012 15:13:51 13      A 1       1       NO         ARCH_INC1
2    10      926728     25-DEC-2012 14:25:14 6       A 1       1       NO         ARCH_INC0
2    11      931026     25-DEC-2012 15:13:52 14      A 1       1       NO         ARCH_INC1
3    3       926740     25-DEC-2012 14:25:27 4       A 1       1       NO         ARCH_INC0
3    4       931028     25-DEC-2012 15:13:53 15      A 1       1       NO         ARCH_INC1

List of Control File Backups
============================

CF Ckp SCN Ckp Time             BS Key  S #Pieces #Copies Compressed Tag
---------- -------------------- ------- - ------- ------- ---------- ---
931613     25-DEC-2012 15:25:34 16      A 1       1       NO         TAG20121225T152534
931040     25-DEC-2012 15:14:02 9       A 1       1       NO         TAG20121225T151402
List of SPFILE Backups
======================

Modification Time    BS Key  S #Pieces #Copies Compressed Tag
-------------------- ------- - ------- ------- ---------- ---
25-DEC-2012 14:23:24 16      A 1       1       NO         TAG20121225T152534
25-DEC-2012 14:23:24 9       A 1       1       NO         TAG20121225T151402

RMAN> 
RMAN> list backup of database;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
1       Incr 0  66.25M     DISK        00:00:24     25-DEC-2012 15:12:59
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: DB_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_03ntomb3_s3_p1
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  2    0  Incr 930970     25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs1.258.802540615
  5    0  Incr 930970     25-DEC-2012 15:12:42 +DATADG/racdb/datafile/example.264.802540751
  7    0  Incr 930970     25-DEC-2012 15:12:42 +DATADG/racdb/datafile/undotbs3.269.802888323

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
2       Incr 0  263.96M    DISK        00:01:05     25-DEC-2012 15:13:40
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: DB_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_02ntomb3_s2_p1
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3    0  Incr 930964     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/sysaux.257.802540615
  4    0  Incr 930964     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/users.259.802540615
  6    0  Incr 930964     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/undotbs2.265.802540981

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
3       Incr 0  370.38M    DISK        00:01:07     25-DEC-2012 15:13:42
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: DB_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_LVL0_20121225_01ntomb3_s1_p1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1    0  Incr 930959     25-DEC-2012 15:12:35 +DATADG/racdb/datafile/system.256.802540615

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
10      Incr 1  128.00K    DISK        00:00:09     25-DEC-2012 15:25:02
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: DB_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0anton25_s10_p1
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1    1  Incr 931568     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/system.256.802540615

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
11      Incr 1  232.00K    DISK        00:00:21     25-DEC-2012 15:25:14
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: DB_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0cnton25_s12_p1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  2    1  Incr 931576     25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs1.258.802540615
  5    1  Incr 931576     25-DEC-2012 15:25:03 +DATADG/racdb/datafile/example.264.802540751
  7    1  Incr 931576     25-DEC-2012 15:25:03 +DATADG/racdb/datafile/undotbs3.269.802888323

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
12      Incr 1  208.00K    DISK        00:00:21     25-DEC-2012 15:25:14
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: DB_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_LVL1_20121225_0bnton25_s11_p1
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3    1  Incr 931570     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/sysaux.257.802540615
  4    1  Incr 931570     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/users.259.802540615
  6    1  Incr 931570     25-DEC-2012 15:24:53 +DATADG/racdb/datafile/undotbs2.265.802540981

RMAN> 
RMAN> list backup of archivelog all;


List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
4       693.00K    DISK        00:00:01     25-DEC-2012 15:13:57
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_06ntomdk_s6_p1

  List of Archived Logs in backup set 4
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  3    3       926740     25-DEC-2012 14:25:27 931028     25-DEC-2012 15:13:53

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
5       3.30M      DISK        00:00:01     25-DEC-2012 15:13:57
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_04ntomdk_s4_p1

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    15      892350     25-DEC-2012 11:24:17 926723     25-DEC-2012 14:25:11

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
6       791.50K    DISK        00:00:02     25-DEC-2012 15:13:58
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_05ntomdk_s5_p1

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  2    10      926728     25-DEC-2012 14:25:14 931026     25-DEC-2012 15:13:52

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
7       1.43M      DISK        00:00:01     25-DEC-2012 15:13:59
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_07ntomdm_s7_p1

  List of Archived Logs in backup set 7
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    18      926737     25-DEC-2012 14:25:26 931023     25-DEC-2012 15:13:51

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
8       3.50K      DISK        00:00:01     25-DEC-2012 15:14:01
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC0
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_08ntomdo_s8_p1

  List of Archived Logs in backup set 8
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    16      926723     25-DEC-2012 14:25:11 926734     25-DEC-2012 14:25:23
  1    17      926734     25-DEC-2012 14:25:23 926737     25-DEC-2012 14:25:26

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
13      38.00K     DISK        00:00:02     25-DEC-2012 15:25:34
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0dnton3c_s13_p1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    19      931023     25-DEC-2012 15:13:51 931599     25-DEC-2012 15:25:25

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
14      58.00K     DISK        00:00:02     25-DEC-2012 15:25:34
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0enton3c_s14_p1

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  2    11      931026     25-DEC-2012 15:13:52 931601     25-DEC-2012 15:25:26

BS Key  Size       Device Type Elapsed Time Completion Time     
------- ---------- ----------- ------------ --------------------
15      5.00K      DISK        00:00:02     25-DEC-2012 15:25:34
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: ARCH_INC1
        Piece Name: /u01/app/oracle/backup/RACDB_ARCH_20121225_0fnton3c_s15_p1

  List of Archived Logs in backup set 15
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  3    4       931028     25-DEC-2012 15:13:53 931604     25-DEC-2012 15:25:26

RMAN> 
RMAN> list backup of controlfile;


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
9       Full    14.67M     DISK        00:00:04     25-DEC-2012 15:14:06
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20121225T151402
        Piece Name: /u01/app/oracle/backup/c-800157471-20121225-00
  Control File Included: Ckp SCN: 931040       Ckp time: 25-DEC-2012 15:14:02

BS Key  Type LV Size       Device Type Elapsed Time Completion Time     
------- ---- -- ---------- ----------- ------------ --------------------
16      Full    14.67M     DISK        00:00:04     25-DEC-2012 15:25:38
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20121225T152534
        Piece Name: /u01/app/oracle/backup/c-800157471-20121225-01
  Control File Included: Ckp SCN: 931613       Ckp time: 25-DEC-2012 15:25:34

RMAN>









ZhongWeicheng
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle10gRAC安装过程视频讲解
07-23
教程名称：Oracle 10g RAC安装过程视频讲解课程目录：【】Oracle10g RAC_1【】Oracle10g RAC_2【】Oracle10g RAC_3【】Oracle10g RAC_4【】Oracle10g RAC_5 资源太大，传百度网盘了，链接在附件中，有需要的同学自取...
Oracle 10g RAC RMAN recovery Example
Zhong Weicheng Study Notes
12-25 1397
Oracle 10g RAC RMAN backup Example  Closed database and delete datafile [oracle@racnode1 backup]$ srvctl stop database -d racdb [oracle@racnode1 backup]$ asmcmd ASMCMD> ls DATADG/ FLASHDG/ A
Oracle 11g RAC 原地升级到 19c
JiekeXu的博客
11-30 3781
作者 | JiekeXu来源 |公众号 JiekeXu DBA之路（ID: JiekeXu_IT）如需转载请联系授权 |(个人微信 ID：JiekeXu_DBA)大家好，我是 JiekeXu,很高兴又和大家见面了,今天和大家一起来看看 Oracle 11g RAC 原地升级到 19c，欢迎点击上方蓝字“JiekeXu DBA之路”关注我的公众号，标星或置顶，更多干货第一时间到达！记得去年初的一段...
oracle 10g rac 单实例恢复至ORACLE10G RAC RMAN
cqsg68568的博客
12-07 111
在前两节中，分别介绍了使用expdp/impdp迁移单实例数据库到rac环境的方法，其中包括使用表空间传输的方式，但如果在用户数量多，或者表空间数量多，又或者函数，过程，包等代码对象多的条件下，使用前两种方式迁移未免麻烦且...
关于centos6.8下Oracle11gRAC 设置本地归档目录，并配置nfs共享目录rman备份
king_harry的专栏
12-15 1660
1、修改目录 将两个节点的归档修改到本地文件系统下 节点1归档到/arch1 节点2归档到/arch2 2、创建本地目录 节点1： #mkdir -p /arch1 #chown -R oracle:oinstall /arch1 #chown -R 775 /arch1 节点2： #mkdir -p /arch2 #chown -R oracle:oinstall /arch2 #chown -R 775 /arch2 3、修改归档（任一节点操作） SQL>alter system se
Oracle10gRAC安装配置.ppt
11-21
Oracle10gRAC安装配置.ppt
Oracle 11g RAC+DG安装配置
08-09
基于Vmware 15 + CentOS 7.6 + Oracle 11g RAC+DG安装配置
oracle10g rac asm for linux
03-05
oracle10g rac asm for linux oracle10g rac asm for linux
oracle 10gRAC实施
05-16
oracle 10g RAC实施手册，讲解实施过程中的问题和步骤
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一)
热门推荐
Zhong Weicheng Study Notes
12-28 1万+
有关于Oracle Linux 6的安装可以参考Oracle Linux 6 Installation。安装两台OL6分配两个网卡内存均为3G,hostname分别为node1和node2。 OS版本你也可以选择CentOS6或者是RHEL6,建议初次安装选择CentOS6/RHEL6。选择Oracle Linux6可以使用OL6提供的oracle-rdbms-server-11gR2-prei
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (四)
Zhong Weicheng Study Notes
12-29 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三) 将安装介质上传到node1,解压准备安装grid infrast
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三)
Zhong Weicheng Study Notes
12-28 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 配置共享磁盘,本次实验环境是基于VMware ESXi 5搭建。 和vbox配置差不多,具体过程略,关闭node1,node2,说明一下需要注意的地方 SCSI
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二)
Zhong Weicheng Study Notes
12-28 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 在所有node上创建oracle,grid用户,创建相关目录 [root@node2 ~]# groupadd -g 1000 oinstall [root@node2 ~]# groupadd -g 1200 asmadmin [root@node2 ~]# groupadd
Add a Node to Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6
Zhong Weicheng Study Notes
01-05 1万+
Delete a Node from Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6 This guide shows how to add a node to an existing 11gR2(11.2.0.3) Oracle RAC cluster. It is assumed that the node in question is
Delete a Node from Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6
Zhong Weicheng Study Notes
01-05 1万+
Add a Node to Oracle RAC 11gR2(11.2.0.3) on Oracle Linux 6 This guide shows how to remove a node from an existing 11gR2 Oracle RAC cluster. It is assumed that the node in question is available an
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (五)
Zhong Weicheng Study Notes
12-29 8974
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三) 使用UDEV在Oracle Linux 6上安装Oracle 11g R
查询Oracle RAC Cache Fusion通信的私有网络
Zhong Weicheng Study Notes
01-22 6847
[oracle@zhongwc1 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.7 (Tikanga) [oracle@zhongwc1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 22 15:1
Installation Oracle11gR2 RAC on SuSE Linux Enterprise Server 11
Zhong Weicheng Study Notes
12-30 6728
SLES11安装参考博文 Installation SUSE Linux Enterprise Server 11 vzwc1:~ # cat /etc/issue Welcome to SUSE Linux Enterprise Server 11 SP3 (x86_64) - Kernel \r (\l). vzwc1:~ # 配置/etc/hosts文件 192.1
安装Oracle11g rac
最新发布
09-16
安装Oracle 11g RAC需要按照特定的步骤进行配置。具体安装过程可以参考引用和引用中提供的文档。一般来说，安装Oracle 11g RAC的过程包括以下几个步骤： 1. 下载并解压Oracle 11g RAC安装文件，可以使用命令unzip...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值