Bo's Oracle Station

查看: 1403|回复: 0

Section3

[复制链接]

75

主题

115

帖子

2688

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
2688
发表于 2015-10-9 16:30:02 | 显示全部楼层 |阅读模式
我的输出:



----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section3 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
export ORACLE_SID=PROD
.bash_profile OK



# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
    . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATHHOME/bin

export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/jdk/binORACLE_HOME/binPATH
export LANG=en_US


******************** TOPIC 1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:20 2015

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

SQL> SQL> Connected.
SQL>
TABLESPACE_NAME             BYTES   MAXBYTES
------------------------------ ---------- ----------
RC_DATA             104857600       0

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101000=0.2


A: 0


******************** TOPIC 1.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:21 2015

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

SQL> SQL> Connected.
SQL>
EXTENT_MAN
----------
LOCAL

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101010=0.1


A: LOCAL


******************** TOPIC 1.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:21 2015

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

SQL> SQL> Connected.
SQL>
     BYTES
----------
104857600

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101020=0.3


A:  104857600


******************** TOPIC 1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:21 2015

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

SQL> SQL> Connected.
SQL>
USERNAME
------------------------------
RC_ADMIN

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R102000=0.2


A: RC_ADMIN


******************** TOPIC 1.2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:21 2015

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

SQL> SQL> Connected.
SQL>
DEFAULT_TABLESPACE
------------------------------
RC_DATA

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R102010=0.3


A: RC_DATA


******************** TOPIC 1.2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

SQL> SQL> Connected.
SQL>
GRANTED_ROLE
------------------------------
RECOVERY_CATALOG_OWNER
CONNECT

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R102020=0.2


A: RECOVERY_CATALOG_OWNER


******************** TOPIC 1.3 ********************


******************** TOPIC 1.3.1 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103010=0.1


A: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103010=.15


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103010=.20


C: 0


******************** TOPIC 1.3.2 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103020=0.04


A: 1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103020=.08


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103020=.12


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103020=.16


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:22 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    500      SYSTEM               YES     /u01/app/oracle/oradata/PROD/Disk1/system01.dbf
2    200      UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf
3    400      SYSAUX               NO      /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf
4    48       USERS                NO      /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
5    400      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/Disk1/example01.dbf
6    40       INDX                 NO      /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf
7    10       TOOLS                NO      /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf
8    48       OLTP                 NO      /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf
9    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/Disk5/temp01.dbf
2    20       TEMP1                20          /u01/app/oracle/oradata/PROD/Disk1/temp1.dbf
3    20       TEMP2                20          /u01/app/oracle/oradata/PROD/Disk1/temp2.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R103020=.20


E: 0


******************** TOPIC 2 ********************


******************** TOPIC 2.1 ********************


******************** TOPIC 2.1.1 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201010=0.04


A: CONFIGURE BACKUP OPTIMIZATION ON;

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201010=.08


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201010=.12


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201010=.16


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201010=.20


E: 0


******************** TOPIC 2.1.2 ********************
drwxr-xr-x 3 oracle oinstall 4096 Sep 12 20:14 /home/oracle/backup


R201021=0.1



Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201022=0.04


A: CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201022=.08


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201022=.12


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201022=.16


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201022=.20


E: 0


******************** TOPIC 2.1.3 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201031=0.06


A: CONFIGURE CONTROLFILE AUTOBACKUP ON;

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201031=.12


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201031=.18


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201031=.24


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201031=.30


E: 0
drwxr-xr-x 2 oracle oinstall 4096 Sep 12 20:14 /home/oracle/backup/control


R201032=0.3



Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201033=0.06


A: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201033=.12


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201033=.18


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201033=.24


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201033=.30


E: 0


******************** TOPIC 2.1.4 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201040=0.04


A: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201040=.08


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201040=.12


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201040=.16


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:25 2015

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

connected to target database: PROD (DBID=302057870)
connected to recovery catalog database

RMAN>
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
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;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R201040=.20


E: 0


******************** TOPIC 2.2 ********************


******************** TOPIC 2.2.1 ********************


******************** TOPIC 2.2.2 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:32 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/system01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:34 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk3/undotbs1.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:35 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:36 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    96.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195929
        Piece Name: /home/oracle/backup/06qh09t1_1_1
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 236133     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/users01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:38 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/example01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:39 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/indx01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:40 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/tools01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:41 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Incr 0  272.44M    DISK        00:00:05     12-SEP-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnnd0_1D_WHOLE_INCR0_bz7qvqo1_.bkp
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8    0  Incr 210357     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/oltp01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:42 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    96.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T194140
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_nnndf_TAG20150912T194140_bz83vntf_.bkp
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 235865     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    57.63M     DISK        00:00:18     12-SEP-15      
        BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0aqh0a8e_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 237783     12-SEP-15 /u01/app/oracle/oradata/PROD/Disk1/REGISTRATION01.dbf

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.
R202020=1.00


******************** TOPIC 2.2.3 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:43 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    80.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20150912T200719
        Piece Name: /home/oracle/backup/0eqh0abn_1_1
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  SPFILE Included: Modification time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202031=0.03


A:         BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20150912T200719

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:43 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    80.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20150912T200719
        Piece Name: /home/oracle/backup/0eqh0abn_1_1
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  SPFILE Included: Modification time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202031=.06


B:         Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:43 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    80.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20150912T200719
        Piece Name: /home/oracle/backup/0eqh0abn_1_1
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  SPFILE Included: Modification time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202031=.07


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:43 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    80.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20150912T200719
        Piece Name: /home/oracle/backup/0eqh0abn_1_1
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  SPFILE Included: Modification time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202031=.08


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:43 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    80.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20150912T200719
        Piece Name: /home/oracle/backup/0eqh0abn_1_1
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  SPFILE Included: Modification time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202031=.09


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:43 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    80.00K     DISK        00:00:00     12-SEP-15      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20150912T200719
        Piece Name: /home/oracle/backup/0eqh0abn_1_1
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  SPFILE Included: Modification time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  SPFILE Included: Modification time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202031=.10


F: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:46 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  Control File Included: Ckp SCN: 210360       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  Control File Included: Ckp SCN: 236076       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  Control File Included: Ckp SCN: 236142       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    1.03M      DISK        00:00:00     12-SEP-15      
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0bqh0a97_1_1
  Control File Included: Ckp SCN: 237791       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  Control File Included: Ckp SCN: 237813       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  Control File Included: Ckp SCN: 237883       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  Control File Included: Ckp SCN: 238508       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  Control File Included: Ckp SCN: 238657       Ckp time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202032=0.15


A:         BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:46 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  Control File Included: Ckp SCN: 210360       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  Control File Included: Ckp SCN: 236076       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  Control File Included: Ckp SCN: 236142       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    1.03M      DISK        00:00:00     12-SEP-15      
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0bqh0a97_1_1
  Control File Included: Ckp SCN: 237791       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  Control File Included: Ckp SCN: 237813       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  Control File Included: Ckp SCN: 237883       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  Control File Included: Ckp SCN: 238508       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  Control File Included: Ckp SCN: 238657       Ckp time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202032=.30


B:         Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:46 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  Control File Included: Ckp SCN: 210360       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  Control File Included: Ckp SCN: 236076       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  Control File Included: Ckp SCN: 236142       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    1.03M      DISK        00:00:00     12-SEP-15      
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0bqh0a97_1_1
  Control File Included: Ckp SCN: 237791       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  Control File Included: Ckp SCN: 237813       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  Control File Included: Ckp SCN: 237883       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  Control File Included: Ckp SCN: 238508       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  Control File Included: Ckp SCN: 238657       Ckp time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202032=.32


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:46 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  Control File Included: Ckp SCN: 210360       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  Control File Included: Ckp SCN: 236076       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  Control File Included: Ckp SCN: 236142       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    1.03M      DISK        00:00:00     12-SEP-15      
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0bqh0a97_1_1
  Control File Included: Ckp SCN: 237791       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  Control File Included: Ckp SCN: 237813       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  Control File Included: Ckp SCN: 237883       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  Control File Included: Ckp SCN: 238508       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  Control File Included: Ckp SCN: 238657       Ckp time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202032=.34


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:46 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  Control File Included: Ckp SCN: 210360       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  Control File Included: Ckp SCN: 236076       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  Control File Included: Ckp SCN: 236142       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    1.03M      DISK        00:00:00     12-SEP-15      
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0bqh0a97_1_1
  Control File Included: Ckp SCN: 237791       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  Control File Included: Ckp SCN: 237813       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  Control File Included: Ckp SCN: 237883       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  Control File Included: Ckp SCN: 238508       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  Control File Included: Ckp SCN: 238657       Ckp time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202032=.37


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:46 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_ncsn0_1D_WHOLE_INCR0_bz7qvyvr_.bkp
  Control File Included: Ckp SCN: 210360       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195901
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-01
  Control File Included: Ckp SCN: 236076       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T195931
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-02
  Control File Included: Ckp SCN: 236142       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    1.03M      DISK        00:00:00     12-SEP-15      
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0bqh0a97_1_1
  Control File Included: Ckp SCN: 237791       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200608
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-03
  Control File Included: Ckp SCN: 237813       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.58M      DISK        00:00:01     12-SEP-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T200721
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-04
  Control File Included: Ckp SCN: 237883       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201256
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-05
  Control File Included: Ckp SCN: 238508       Ckp time: 12-SEP-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    6.58M      DISK        00:00:00     12-SEP-15      
        BP Key: 19   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201435
        Piece Name: /home/oracle/backup/control/c-302057870-20150912-06
  Control File Included: Ckp SCN: 238657       Ckp time: 12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202032=.40


F: 0


******************** TOPIC 2.2.4 ********************

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:48 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       101.39M    DISK        00:00:03     12-SEP-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qvmtw_.bkp

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    5       158620     12-SEP-15 207525     12-SEP-15
  1    6       207525     12-SEP-15 210351     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       3.00K      DISK        00:00:00     12-SEP-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qw1ph_.bkp

  List of Archived Logs in backup set 3
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       210351     12-SEP-15 210363     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       13.66M     DISK        00:00:03     12-SEP-15      
        BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/08qh0a85_1_1

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       210363     12-SEP-15 234147     12-SEP-15
  1    9       234147     12-SEP-15 234149     12-SEP-15
  1    10      234149     12-SEP-15 234151     12-SEP-15
  1    11      234151     12-SEP-15 234153     12-SEP-15
  1    12      234153     12-SEP-15 234157     12-SEP-15
  1    13      234157     12-SEP-15 235914     12-SEP-15
  1    14      235914     12-SEP-15 235916     12-SEP-15
  1    15      235916     12-SEP-15 235918     12-SEP-15
  1    16      235918     12-SEP-15 235920     12-SEP-15
  1    17      235920     12-SEP-15 235923     12-SEP-15
  1    18      235923     12-SEP-15 235925     12-SEP-15
  1    19      235925     12-SEP-15 235928     12-SEP-15
  1    20      235928     12-SEP-15 235930     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      1.26M      DISK        00:00:01     12-SEP-15      
        BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/09qh0a8b_1_1

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       235931     12-SEP-15 237771     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      3.50K      DISK        00:00:01     12-SEP-15      
        BP Key: 13   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0cqh0a9d_1_1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       237771     12-SEP-15 237796     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18      1.76M      DISK        00:00:01     12-SEP-15      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201432
        Piece Name: /home/oracle/backup/0hqh0ap8_1_1

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       237796     12-SEP-15 238635     12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202041=0.15


A:         BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        BP Key: 13   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:48 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       101.39M    DISK        00:00:03     12-SEP-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qvmtw_.bkp

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    5       158620     12-SEP-15 207525     12-SEP-15
  1    6       207525     12-SEP-15 210351     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       3.00K      DISK        00:00:00     12-SEP-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qw1ph_.bkp

  List of Archived Logs in backup set 3
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       210351     12-SEP-15 210363     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       13.66M     DISK        00:00:03     12-SEP-15      
        BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/08qh0a85_1_1

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       210363     12-SEP-15 234147     12-SEP-15
  1    9       234147     12-SEP-15 234149     12-SEP-15
  1    10      234149     12-SEP-15 234151     12-SEP-15
  1    11      234151     12-SEP-15 234153     12-SEP-15
  1    12      234153     12-SEP-15 234157     12-SEP-15
  1    13      234157     12-SEP-15 235914     12-SEP-15
  1    14      235914     12-SEP-15 235916     12-SEP-15
  1    15      235916     12-SEP-15 235918     12-SEP-15
  1    16      235918     12-SEP-15 235920     12-SEP-15
  1    17      235920     12-SEP-15 235923     12-SEP-15
  1    18      235923     12-SEP-15 235925     12-SEP-15
  1    19      235925     12-SEP-15 235928     12-SEP-15
  1    20      235928     12-SEP-15 235930     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      1.26M      DISK        00:00:01     12-SEP-15      
        BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/09qh0a8b_1_1

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       235931     12-SEP-15 237771     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      3.50K      DISK        00:00:01     12-SEP-15      
        BP Key: 13   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0cqh0a9d_1_1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       237771     12-SEP-15 237796     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18      1.76M      DISK        00:00:01     12-SEP-15      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201432
        Piece Name: /home/oracle/backup/0hqh0ap8_1_1

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       237796     12-SEP-15 238635     12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202041=.30


B:         Piece Name: /home/oracle/backup/08qh0a85_1_1
        Piece Name: /home/oracle/backup/09qh0a8b_1_1
        Piece Name: /home/oracle/backup/0cqh0a9d_1_1
        Piece Name: /home/oracle/backup/0hqh0ap8_1_1

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:48 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       101.39M    DISK        00:00:03     12-SEP-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qvmtw_.bkp

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    5       158620     12-SEP-15 207525     12-SEP-15
  1    6       207525     12-SEP-15 210351     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       3.00K      DISK        00:00:00     12-SEP-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qw1ph_.bkp

  List of Archived Logs in backup set 3
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       210351     12-SEP-15 210363     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       13.66M     DISK        00:00:03     12-SEP-15      
        BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/08qh0a85_1_1

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       210363     12-SEP-15 234147     12-SEP-15
  1    9       234147     12-SEP-15 234149     12-SEP-15
  1    10      234149     12-SEP-15 234151     12-SEP-15
  1    11      234151     12-SEP-15 234153     12-SEP-15
  1    12      234153     12-SEP-15 234157     12-SEP-15
  1    13      234157     12-SEP-15 235914     12-SEP-15
  1    14      235914     12-SEP-15 235916     12-SEP-15
  1    15      235916     12-SEP-15 235918     12-SEP-15
  1    16      235918     12-SEP-15 235920     12-SEP-15
  1    17      235920     12-SEP-15 235923     12-SEP-15
  1    18      235923     12-SEP-15 235925     12-SEP-15
  1    19      235925     12-SEP-15 235928     12-SEP-15
  1    20      235928     12-SEP-15 235930     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      1.26M      DISK        00:00:01     12-SEP-15      
        BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/09qh0a8b_1_1

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       235931     12-SEP-15 237771     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      3.50K      DISK        00:00:01     12-SEP-15      
        BP Key: 13   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0cqh0a9d_1_1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       237771     12-SEP-15 237796     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18      1.76M      DISK        00:00:01     12-SEP-15      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201432
        Piece Name: /home/oracle/backup/0hqh0ap8_1_1

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       237796     12-SEP-15 238635     12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202041=.32


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:48 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       101.39M    DISK        00:00:03     12-SEP-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qvmtw_.bkp

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    5       158620     12-SEP-15 207525     12-SEP-15
  1    6       207525     12-SEP-15 210351     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       3.00K      DISK        00:00:00     12-SEP-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qw1ph_.bkp

  List of Archived Logs in backup set 3
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       210351     12-SEP-15 210363     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       13.66M     DISK        00:00:03     12-SEP-15      
        BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/08qh0a85_1_1

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       210363     12-SEP-15 234147     12-SEP-15
  1    9       234147     12-SEP-15 234149     12-SEP-15
  1    10      234149     12-SEP-15 234151     12-SEP-15
  1    11      234151     12-SEP-15 234153     12-SEP-15
  1    12      234153     12-SEP-15 234157     12-SEP-15
  1    13      234157     12-SEP-15 235914     12-SEP-15
  1    14      235914     12-SEP-15 235916     12-SEP-15
  1    15      235916     12-SEP-15 235918     12-SEP-15
  1    16      235918     12-SEP-15 235920     12-SEP-15
  1    17      235920     12-SEP-15 235923     12-SEP-15
  1    18      235923     12-SEP-15 235925     12-SEP-15
  1    19      235925     12-SEP-15 235928     12-SEP-15
  1    20      235928     12-SEP-15 235930     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      1.26M      DISK        00:00:01     12-SEP-15      
        BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/09qh0a8b_1_1

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       235931     12-SEP-15 237771     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      3.50K      DISK        00:00:01     12-SEP-15      
        BP Key: 13   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0cqh0a9d_1_1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       237771     12-SEP-15 237796     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18      1.76M      DISK        00:00:01     12-SEP-15      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201432
        Piece Name: /home/oracle/backup/0hqh0ap8_1_1

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       237796     12-SEP-15 238635     12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202041=.34


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:48 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       101.39M    DISK        00:00:03     12-SEP-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qvmtw_.bkp

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    5       158620     12-SEP-15 207525     12-SEP-15
  1    6       207525     12-SEP-15 210351     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       3.00K      DISK        00:00:00     12-SEP-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qw1ph_.bkp

  List of Archived Logs in backup set 3
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       210351     12-SEP-15 210363     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       13.66M     DISK        00:00:03     12-SEP-15      
        BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/08qh0a85_1_1

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       210363     12-SEP-15 234147     12-SEP-15
  1    9       234147     12-SEP-15 234149     12-SEP-15
  1    10      234149     12-SEP-15 234151     12-SEP-15
  1    11      234151     12-SEP-15 234153     12-SEP-15
  1    12      234153     12-SEP-15 234157     12-SEP-15
  1    13      234157     12-SEP-15 235914     12-SEP-15
  1    14      235914     12-SEP-15 235916     12-SEP-15
  1    15      235916     12-SEP-15 235918     12-SEP-15
  1    16      235918     12-SEP-15 235920     12-SEP-15
  1    17      235920     12-SEP-15 235923     12-SEP-15
  1    18      235923     12-SEP-15 235925     12-SEP-15
  1    19      235925     12-SEP-15 235928     12-SEP-15
  1    20      235928     12-SEP-15 235930     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      1.26M      DISK        00:00:01     12-SEP-15      
        BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/09qh0a8b_1_1

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       235931     12-SEP-15 237771     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      3.50K      DISK        00:00:01     12-SEP-15      
        BP Key: 13   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0cqh0a9d_1_1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       237771     12-SEP-15 237796     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18      1.76M      DISK        00:00:01     12-SEP-15      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201432
        Piece Name: /home/oracle/backup/0hqh0ap8_1_1

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       237796     12-SEP-15 238635     12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202041=.37


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:48 2015

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

connected to target database: PROD (DBID=302057870)

RMAN>
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1       101.39M    DISK        00:00:03     12-SEP-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qvmtw_.bkp

  List of Archived Logs in backup set 1
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    5       158620     12-SEP-15 207525     12-SEP-15
  1    6       207525     12-SEP-15 210351     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3       3.00K      DISK        00:00:00     12-SEP-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_INCR0
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_09_12/o1_mf_annnn_1D_WHOLE_INCR0_bz7qw1ph_.bkp

  List of Archived Logs in backup set 3
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       210351     12-SEP-15 210363     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       13.66M     DISK        00:00:03     12-SEP-15      
        BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/08qh0a85_1_1

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       210363     12-SEP-15 234147     12-SEP-15
  1    9       234147     12-SEP-15 234149     12-SEP-15
  1    10      234149     12-SEP-15 234151     12-SEP-15
  1    11      234151     12-SEP-15 234153     12-SEP-15
  1    12      234153     12-SEP-15 234157     12-SEP-15
  1    13      234157     12-SEP-15 235914     12-SEP-15
  1    14      235914     12-SEP-15 235916     12-SEP-15
  1    15      235916     12-SEP-15 235918     12-SEP-15
  1    16      235918     12-SEP-15 235920     12-SEP-15
  1    17      235920     12-SEP-15 235923     12-SEP-15
  1    18      235923     12-SEP-15 235925     12-SEP-15
  1    19      235925     12-SEP-15 235928     12-SEP-15
  1    20      235928     12-SEP-15 235930     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      1.26M      DISK        00:00:01     12-SEP-15      
        BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/09qh0a8b_1_1

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1       235931     12-SEP-15 237771     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      3.50K      DISK        00:00:01     12-SEP-15      
        BP Key: 13   Status: AVAILABLE  Compressed: YES  Tag: 2DC_WHOLE_FULL
        Piece Name: /home/oracle/backup/0cqh0a9d_1_1

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       237771     12-SEP-15 237796     12-SEP-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
18      1.76M      DISK        00:00:01     12-SEP-15      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20150912T201432
        Piece Name: /home/oracle/backup/0hqh0ap8_1_1

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       237796     12-SEP-15 238635     12-SEP-15

RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>

Recovery Manager complete.


R202041=.40


F: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:51 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL>   2    3  SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R202042=0.3


A: 0


******************** TOPIC 2.2.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:51 2015

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

SQL> Connected.
SQL> SQL>
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 1


R202051=0.05



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:52 2015

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

SQL> Connected.
SQL> SQL>
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 1


R202052=0.05




******************** TOPIC 2.2.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:52 2015

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

SQL> Connected.
SQL> SQL>
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3600

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 3600


R202061=0.15



SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:52 2015

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

SQL> Connected.
SQL> SQL>
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
3600

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 3600


R202062=0.15




******************** TOPIC 3 ********************


******************** TOPIC 3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:53 2015

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

SQL> Connected.
SQL> SQL>
FLASHBACK_ON
------------------
YES

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301000=0.4


A: YES


******************** TOPIC 3.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:53 2015

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

SQL> Connected.
SQL> SQL>
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4294967296

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 4294967296


R301010=0.1




******************** TOPIC 3.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:53 2015

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

SQL> Connected.
SQL> SQL>
VALUE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/flash_recovery_area

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301020=0.1


A: /u01/app/oracle/flash_recovery_area


******************** TOPIC 3.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:53 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database open mode here:
SQL> ****************************
SQL> SQL>
D
-
X
SQL>
OPEN_MODE
----------
READ WRITE
SQL>
     A
----------
2158310321
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R302001=0.01


A: READ WRITE

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 12 20:16:53 2015

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database open mode here:
SQL> ****************************
SQL> SQL>
D
-
X
SQL>
OPEN_MODE
----------
READ WRITE
SQL>
     A
----------
2158310321
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R302002=3.49


A: 2158310321
****************************************************************************************************


R101000: 0.2 full is 0.2 0.2
R101010: 0.1 full is 0.1 0.3
R101020: 0.3 full is 0.3 0.6
R102000: 0.2 full is 0.2 0.8
R102010: 0.3 full is 0.3 1.1
R102020: 0.2 full is 0.2 1.3
R103010: .20 full is 0.2 1.5
R103020: .20 full is 0.2 1.7
R201010: .20 full is 0.2 1.9
R201021: 0.1 full is 0.1 2.0
R201022: .20 full is 0.2 2.2
R201031: .30 full is 0.3 2.5
R201032: 0.3 full is 0.3 2.8
R201033: .30 full is 0.3 3.1
R201040: .20 full is 0.2 3.3
R202020: 1.00 full is 1 4.3
R202031: .10 full is 0.1 4.4
R202032: .40 full is 0.4 4.8
R202041: .40 full is 0.4 5.2
R202042: 0.3 full is 0.3 5.5
R202051: 0.05 full is 0.05 5.55
R202052: 0.05 full is 0.05 5.6
R202061: 0.15 full is 0.15 5.75
R202062: 0.15 full is 0.15 5.9
R301000: 0.4 full is 0.4 6.3
R301010: 0.1 full is 0.1 6.4
R301020: 0.1 full is 0.1 6.5
R302001: 0.01 full is 0.01 6.51
R302002: 3.49 full is 3.49 10
full of this section:
RESULT:
10.00


****************************************************************************************************


复制代码



Section3.zip

23.69 KB, 下载次数: 27

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 02:52 , Processed in 0.058228 second(s), 27 queries .

快速回复 返回顶部 返回列表