

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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=$PATH:$HOME/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 AGENT_HOME=/u01/app/agent10g
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$ORACLE_HOME/jdk/bin:$ORACLE_HOME/bin:$PATH
export LANG=en_US


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:17 2015

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

SQL> SQL> Connected.
SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
RC_DATA 			209715200 3.4360E+10

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 Sun Jan 11 17:13:17 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 Sun Jan 11 17:13:18 2015

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

SQL> SQL> Connected.
SQL> 
     BYTES
----------
 209715200

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


A: 0


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:18 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 Sun Jan 11 17:13:18 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 Sun Jan 11 17:13:19 2015

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

SQL> SQL> Connected.
SQL> 
GRANTED_ROLE
------------------------------
RESOURCE
RECOVERY_CATALOG_OWNER

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 Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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 Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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 Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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 Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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

Recovery Manager complete.


R103020=0.04


A: 1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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 Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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 Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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 Sun Jan 11 17:13:19 2015

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

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

RMAN> 
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    480      SYSTEM               YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf
2    25       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf
5    90       REGISTRATION         NO      /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/PROD/datafile/o1_mf_temp_bc28rp69_.tmp

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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Jan 11 16:52 /home/oracle/backup


R201021=0.1



Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201022=0


A: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201022=.04


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201022=.08


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201022=.12


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201022=.16


E: 0


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

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Jan 11 16:52 /home/oracle/backup/control


R201032=0.3



Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_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 Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201040=0


A: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201040=.04


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201040=.08


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201040=.12


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:24 2015

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO '/HOME/ORACLE/BACKUP';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO '%F'; # default
CONFIGURE DEVICE TYPE /HOME/ORACLE/BACKUP PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE /HOME/ORACLE/BACKUP TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

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

Recovery Manager complete.


R201040=.16


E: 0


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


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


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

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:35 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    508.12M    DISK        00:00:38     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/04psf92k_1_1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 483923     11-JAN-15 /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_bc28p5kn_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:37 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    508.12M    DISK        00:00:38     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/04psf92k_1_1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 483923     11-JAN-15 /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_bc28p5r7_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:39 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    508.12M    DISK        00:00:38     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/04psf92k_1_1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 483923     11-JAN-15 /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_bc28p5ky_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:40 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    508.12M    DISK        00:00:38     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/04psf92k_1_1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 483923     11-JAN-15 /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_bc28p5tt_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:41 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    508.12M    DISK        00:00:38     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/04psf92k_1_1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 483923     11-JAN-15 /u01/app/oracle/oradata/PROD/datafile/REGISTRATION.dbf

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

Recovery Manager complete.
R202020=0


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

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:43 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=0


A: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:43 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.03


B:         Piece Name: /home/oracle/backup/control/c-280493318-20150111-00

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:43 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.04


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:43 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.05


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:43 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.06


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:43 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  SPFILE Included: Modification time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.07


F: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:45 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  Control File Included: Ckp SCN: 483291       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  Control File Included: Ckp SCN: 483938       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  Control File Included: Ckp SCN: 485870       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=0


A: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:45 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  Control File Included: Ckp SCN: 483291       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  Control File Included: Ckp SCN: 483938       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  Control File Included: Ckp SCN: 485870       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.15


B:         Piece Name: /home/oracle/backup/control/c-280493318-20150111-00

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:45 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  Control File Included: Ckp SCN: 483291       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  Control File Included: Ckp SCN: 483938       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  Control File Included: Ckp SCN: 485870       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.17


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:45 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  Control File Included: Ckp SCN: 483291       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  Control File Included: Ckp SCN: 483938       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  Control File Included: Ckp SCN: 485870       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.19


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:45 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  Control File Included: Ckp SCN: 483291       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  Control File Included: Ckp SCN: 483938       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  Control File Included: Ckp SCN: 485870       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.22


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:45 2015

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

connected to target database: PROD (DBID=280493318)

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
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/02psf8tv_1_1
  Control File Included: Ckp SCN: 483291       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:02     11-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL01
        Piece Name: /home/oracle/05psf941_1_1
  Control File Included: Ckp SCN: 483938       Ckp time: 11-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    6.80M      DISK        00:00:01     11-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T161847
        Piece Name: /home/oracle/backup/control/c-280493318-20150111-00
  Control File Included: Ckp SCN: 485870       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.25


F: 0


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

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:47 2015

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

connected to target database: PROD (DBID=280493318)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       5.62M      DISK        00:00:02     11-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153545
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153545_bc49ylx1_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       480604     11-JAN-15 483916     11-JAN-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     11-JAN-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153636
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153636_bc4b05cn_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       483916     11-JAN-15 483942     11-JAN-15

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

Recovery Manager complete.


R202041=0


A: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:47 2015

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

connected to target database: PROD (DBID=280493318)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       5.62M      DISK        00:00:02     11-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153545
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153545_bc49ylx1_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       480604     11-JAN-15 483916     11-JAN-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     11-JAN-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153636
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153636_bc4b05cn_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       483916     11-JAN-15 483942     11-JAN-15

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

Recovery Manager complete.


R202041=0


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:47 2015

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

connected to target database: PROD (DBID=280493318)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       5.62M      DISK        00:00:02     11-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153545
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153545_bc49ylx1_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       480604     11-JAN-15 483916     11-JAN-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     11-JAN-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153636
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153636_bc4b05cn_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       483916     11-JAN-15 483942     11-JAN-15

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

Recovery Manager complete.


R202041=.02


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:47 2015

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

connected to target database: PROD (DBID=280493318)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       5.62M      DISK        00:00:02     11-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153545
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153545_bc49ylx1_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       480604     11-JAN-15 483916     11-JAN-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     11-JAN-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153636
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153636_bc4b05cn_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       483916     11-JAN-15 483942     11-JAN-15

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

Recovery Manager complete.


R202041=.04


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:47 2015

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

connected to target database: PROD (DBID=280493318)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       5.62M      DISK        00:00:02     11-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153545
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153545_bc49ylx1_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       480604     11-JAN-15 483916     11-JAN-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     11-JAN-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153636
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153636_bc4b05cn_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       483916     11-JAN-15 483942     11-JAN-15

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

Recovery Manager complete.


R202041=.07


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:47 2015

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

connected to target database: PROD (DBID=280493318)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       5.62M      DISK        00:00:02     11-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153545
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153545_bc49ylx1_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    7       480604     11-JAN-15 483916     11-JAN-15

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     11-JAN-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153636
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_annnn_TAG20150111T153636_bc4b05cn_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       483916     11-JAN-15 483942     11-JAN-15

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

Recovery Manager complete.


R202041=.10


F: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:49 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 Sun Jan 11 17:13:50 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 Sun Jan 11 17:13:50 2015

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

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


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: 0


R202052=0




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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:50 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0

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: 0


R202061=0



SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:50 2015

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

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


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: 0


R202062=0




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


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:50 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 Sun Jan 11 17:13:51 2015

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

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2147483648

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


R301010=0


A: 0


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

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Jan 11 17:13:51 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 Sun Jan 11 17:13:51 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 Sun Jan 11 17:13:51 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 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: .16 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: .16 full is 0.2 3.3
R202020: 0 full is 1 4.3
R202031: .07 full is 0.1 4.4
R202032: .25 full is 0.4 4.8
R202041: .10 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 full is 0.05 5.6
R202061: 0 full is 0.15 5.75
R202062: 0 full is 0.15 5.9
R301000: 0.4 full is 0.4 6.3
R301010: 0 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:
2.69


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