

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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 PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US
export ORACLE_SID=PROD
export TNS_ADMIN=$ORACLE_HOME/network/admin


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

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:38 2003

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

SQL> SQL> Connected.
SQL> 
TABLESPACE_NAME 		    BYTES   MAXBYTES
------------------------------ ---------- ----------
RC_DATA 			104857600 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 Fri Jan 3 06:28:39 2003

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 Fri Jan 3 06:28:39 2003

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

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

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


R101020=0.3


A:  104857600


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

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:39 2003

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 Fri Jan 3 06:28:40 2003

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 Fri Jan 3 06:28:40 2003

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

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

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


R102020=0.2


A: RECOVERY_CATALOG_OWNER


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


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

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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 Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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 Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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 Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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_z199osls_.dbf

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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 Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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 Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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 Fri Jan 3 06:28:41 2003

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

connected to target database: PROD (DBID=4189108092)
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_z199osls_.dbf
2    30       UNDOTBS1             YES     /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf
3    250      SYSAUX               NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.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_z199rf4n_.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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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  3 06:08 /home/oracle/backup


R201021=0.1



Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201022=0.04


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

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201022=.08


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201022=.12


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201022=.16


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201022=.20


E: 0


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

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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  3 06:08 /home/oracle/backup/control


R201032=0.3



Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

RMAN> 
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 3;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '/home/oracle/backup/%U.back';
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 Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201040=0.04


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

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201040=.08


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201040=.12


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201040=.16


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:45 2003

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

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

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

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

Recovery Manager complete.


R201040=.20


E: 0


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


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


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

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:52 2003

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

connected to target database: PROD (DBID=4189108092)

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    597.70M    DISK        00:00:34     03-JAN-03      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19b9znx_.bkp
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 475832     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_z199osls_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    597.70M    DISK        00:00:32     03-JAN-03      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19bld7g_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 475968     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_z199osls_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    597.70M    DISK        00:00:37     03-JAN-03      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_2_DISK_FULL_WHOLE_z19bn86y_.bkp
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 476024     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_z199osls_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    597.85M    DISK        00:00:28     03-JAN-03      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T052821
        Piece Name: /home/oracle/backup/0febuofl_1_1.back
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 477474     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_z199osls_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    110.22M    DISK        00:00:43     03-JAN-03      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0iebuon3_1_1.back
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 477601     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_z199osls_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    110.28M    DISK        00:00:40     03-JAN-03      
        BP Key: 21   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0nebup95_1_1.back
  List of Datafiles in backup set 19
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 478013     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_system_z199osls_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:53 2003

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

connected to target database: PROD (DBID=4189108092)

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    597.70M    DISK        00:00:34     03-JAN-03      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19b9znx_.bkp
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 475832     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    597.70M    DISK        00:00:32     03-JAN-03      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19bld7g_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 475968     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    597.70M    DISK        00:00:37     03-JAN-03      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_2_DISK_FULL_WHOLE_z19bn86y_.bkp
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 476024     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    597.85M    DISK        00:00:28     03-JAN-03      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T052821
        Piece Name: /home/oracle/backup/0febuofl_1_1.back
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 477474     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    110.22M    DISK        00:00:43     03-JAN-03      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0iebuon3_1_1.back
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 477601     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    110.28M    DISK        00:00:40     03-JAN-03      
        BP Key: 21   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0nebup95_1_1.back
  List of Datafiles in backup set 19
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 478013     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_z199oss0_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:55 2003

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

connected to target database: PROD (DBID=4189108092)

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    597.70M    DISK        00:00:34     03-JAN-03      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19b9znx_.bkp
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 475832     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    597.70M    DISK        00:00:32     03-JAN-03      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19bld7g_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 475968     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    597.70M    DISK        00:00:37     03-JAN-03      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_2_DISK_FULL_WHOLE_z19bn86y_.bkp
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 476024     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    597.85M    DISK        00:00:28     03-JAN-03      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T052821
        Piece Name: /home/oracle/backup/0febuofl_1_1.back
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 477474     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    110.22M    DISK        00:00:43     03-JAN-03      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0iebuon3_1_1.back
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 477601     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    110.28M    DISK        00:00:40     03-JAN-03      
        BP Key: 21   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0nebup95_1_1.back
  List of Datafiles in backup set 19
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 478013     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_z199osm3_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:56 2003

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

connected to target database: PROD (DBID=4189108092)

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    597.70M    DISK        00:00:34     03-JAN-03      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19b9znx_.bkp
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 475832     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    597.70M    DISK        00:00:32     03-JAN-03      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19bld7g_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 475968     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    597.70M    DISK        00:00:37     03-JAN-03      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_2_DISK_FULL_WHOLE_z19bn86y_.bkp
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 476024     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    597.85M    DISK        00:00:28     03-JAN-03      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T052821
        Piece Name: /home/oracle/backup/0febuofl_1_1.back
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 477474     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    110.22M    DISK        00:00:43     03-JAN-03      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0iebuon3_1_1.back
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 477601     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    110.28M    DISK        00:00:40     03-JAN-03      
        BP Key: 21   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0nebup95_1_1.back
  List of Datafiles in backup set 19
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 478013     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_users_z199ostb_.dbf

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

Recovery Manager complete.

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:58 2003

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

connected to target database: PROD (DBID=4189108092)

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    597.70M    DISK        00:00:34     03-JAN-03      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19b9znx_.bkp
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 475832     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    597.70M    DISK        00:00:32     03-JAN-03      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_1_DISK_FULL_WHOLE_z19bld7g_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 475968     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    597.70M    DISK        00:00:37     03-JAN-03      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_nnndf_2_DISK_FULL_WHOLE_z19bn86y_.bkp
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 476024     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    597.85M    DISK        00:00:28     03-JAN-03      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T052821
        Piece Name: /home/oracle/backup/0febuofl_1_1.back
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 477474     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    110.22M    DISK        00:00:43     03-JAN-03      
        BP Key: 15   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0iebuon3_1_1.back
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 477601     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19      Full    110.28M    DISK        00:00:40     03-JAN-03      
        BP Key: 21   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0nebup95_1_1.back
  List of Datafiles in backup set 19
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 478013     03-JAN-03 /u01/app/oracle/oradata/PROD/datafile/o1_mf_example_z199rjhz_.dbf

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

Recovery Manager complete.
R202020=1.00


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

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:59 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  SPFILE Included: Modification time: 03-JAN-03

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 Fri Jan 3 06:28:59 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  SPFILE Included: Modification time: 03-JAN-03

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

Recovery Manager complete.


R202031=.03


B:         Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:28:59 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  SPFILE Included: Modification time: 03-JAN-03

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 Fri Jan 3 06:28:59 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  SPFILE Included: Modification time: 03-JAN-03

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 Fri Jan 3 06:28:59 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  SPFILE Included: Modification time: 03-JAN-03

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 Fri Jan 3 06:28:59 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  SPFILE Included: Modification time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  SPFILE Included: Modification time: 03-JAN-03

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 Fri Jan 3 06:29:01 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  Control File Included: Ckp SCN: 475242       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  Control File Included: Ckp SCN: 475843       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  Control File Included: Ckp SCN: 475980       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  Control File Included: Ckp SCN: 476039       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    1.03M      DISK        00:00:01     03-JAN-03      
        BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0jebuoog_1_1.back
  Control File Included: Ckp SCN: 477616       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    1.03M      DISK        00:00:00     03-JAN-03      
        BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0oebupai_1_1.back
  Control File Included: Ckp SCN: 478028       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  Control File Included: Ckp SCN: 478037       Ckp time: 03-JAN-03

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

Recovery Manager complete.


R202032=0.15


A:         BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:01 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  Control File Included: Ckp SCN: 475242       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  Control File Included: Ckp SCN: 475843       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  Control File Included: Ckp SCN: 475980       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  Control File Included: Ckp SCN: 476039       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    1.03M      DISK        00:00:01     03-JAN-03      
        BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0jebuoog_1_1.back
  Control File Included: Ckp SCN: 477616       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    1.03M      DISK        00:00:00     03-JAN-03      
        BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0oebupai_1_1.back
  Control File Included: Ckp SCN: 478028       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  Control File Included: Ckp SCN: 478037       Ckp time: 03-JAN-03

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

Recovery Manager complete.


R202032=.30


B:         Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:01 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  Control File Included: Ckp SCN: 475242       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  Control File Included: Ckp SCN: 475843       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  Control File Included: Ckp SCN: 475980       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  Control File Included: Ckp SCN: 476039       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    1.03M      DISK        00:00:01     03-JAN-03      
        BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0jebuoog_1_1.back
  Control File Included: Ckp SCN: 477616       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    1.03M      DISK        00:00:00     03-JAN-03      
        BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0oebupai_1_1.back
  Control File Included: Ckp SCN: 478028       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  Control File Included: Ckp SCN: 478037       Ckp time: 03-JAN-03

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

Recovery Manager complete.


R202032=.32


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:01 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  Control File Included: Ckp SCN: 475242       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  Control File Included: Ckp SCN: 475843       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  Control File Included: Ckp SCN: 475980       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  Control File Included: Ckp SCN: 476039       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    1.03M      DISK        00:00:01     03-JAN-03      
        BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0jebuoog_1_1.back
  Control File Included: Ckp SCN: 477616       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    1.03M      DISK        00:00:00     03-JAN-03      
        BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0oebupai_1_1.back
  Control File Included: Ckp SCN: 478028       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  Control File Included: Ckp SCN: 478037       Ckp time: 03-JAN-03

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

Recovery Manager complete.


R202032=.34


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:01 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  Control File Included: Ckp SCN: 475242       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  Control File Included: Ckp SCN: 475843       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  Control File Included: Ckp SCN: 475980       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  Control File Included: Ckp SCN: 476039       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    1.03M      DISK        00:00:01     03-JAN-03      
        BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0jebuoog_1_1.back
  Control File Included: Ckp SCN: 477616       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    1.03M      DISK        00:00:00     03-JAN-03      
        BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0oebupai_1_1.back
  Control File Included: Ckp SCN: 478028       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  Control File Included: Ckp SCN: 478037       Ckp time: 03-JAN-03

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

Recovery Manager complete.


R202032=.37


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:01 2003

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

connected to target database: PROD (DBID=4189108092)

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     03-JAN-03      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z199xw6j_.bkp
  Control File Included: Ckp SCN: 475242       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bc1hb_.bkp
  Control File Included: Ckp SCN: 475843       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_1_DISK_FULL_WHOLE_z19bmjoq_.bkp
  Control File Included: Ckp SCN: 475980       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    6.80M      DISK        00:00:01     03-JAN-03      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_ncsnf_2_DISK_FULL_WHOLE_z19booov_.bkp
  Control File Included: Ckp SCN: 476039       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    1.03M      DISK        00:00:01     03-JAN-03      
        BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053219
        Piece Name: /home/oracle/backup/0jebuoog_1_1.back
  Control File Included: Ckp SCN: 477616       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
20      Full    1.03M      DISK        00:00:00     03-JAN-03      
        BP Key: 22   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T054156
        Piece Name: /home/oracle/backup/0oebupai_1_1.back
  Control File Included: Ckp SCN: 478028       Ckp time: 03-JAN-03

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
22      Full    6.80M      DISK        00:00:00     03-JAN-03      
        BP Key: 26   Status: AVAILABLE  Compressed: NO  Tag: TAG20030103T054246
        Piece Name: /home/oracle/backup/control/c-4189108092-20030103-02
  Control File Included: Ckp SCN: 478037       Ckp time: 03-JAN-03

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

Recovery Manager complete.


R202032=.40


F: 0


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

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:04 2003

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

connected to target database: PROD (DBID=4189108092)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19b9wdq_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bc3ws_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       475825     03-JAN-03 475846     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19blbml_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bmncz_.bkp

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6       475956     03-JAN-03 475984     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_2_DISK_FULL_WHOLE_z19bn6sg_.bkp

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03
  1    6       475956     03-JAN-03 475984     03-JAN-03
  1    7       475984     03-JAN-03 476014     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14      658.00K    DISK        00:00:01     03-JAN-03      
        BP Key: 14   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053216
        Piece Name: /home/oracle/backup/0hebuon0_1_1.back

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       476014     03-JAN-03 476043     03-JAN-03
  1    9       476043     03-JAN-03 477594     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17      2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053305
        Piece Name: /home/oracle/backup/0kebuooi_1_1.back

  List of Archived Logs in backup set 17
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    10      477594     03-JAN-03 477619     03-JAN-03

BS Key  Size
------- ----------
18      180.50K

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    11      477619     03-JAN-03 478005     03-JAN-03

  Backup Set Copy #1 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    18      1   AVAILABLE   /home/oracle/backup/0mebup92_1_1.back

  Backup Set Copy #2 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19      1   AVAILABLE   /home/oracle/backup/0mebup92_1_2.back

  Backup Set Copy #3 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    20      1   AVAILABLE   /home/oracle/backup/0mebup92_1_3.back

BS Key  Size
------- ----------
21      7.00K

  List of Archived Logs in backup set 21
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    12      478005     03-JAN-03 478031     03-JAN-03

  Backup Set Copy #1 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    23      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_1.back

  Backup Set Copy #2 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    24      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_2.back

  Backup Set Copy #3 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    25      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_3.back

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

Recovery Manager complete.


R202041=0.15


A:         BP Key: 14   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053216
        BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053305

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:04 2003

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

connected to target database: PROD (DBID=4189108092)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19b9wdq_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bc3ws_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       475825     03-JAN-03 475846     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19blbml_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bmncz_.bkp

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6       475956     03-JAN-03 475984     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_2_DISK_FULL_WHOLE_z19bn6sg_.bkp

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03
  1    6       475956     03-JAN-03 475984     03-JAN-03
  1    7       475984     03-JAN-03 476014     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14      658.00K    DISK        00:00:01     03-JAN-03      
        BP Key: 14   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053216
        Piece Name: /home/oracle/backup/0hebuon0_1_1.back

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       476014     03-JAN-03 476043     03-JAN-03
  1    9       476043     03-JAN-03 477594     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17      2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053305
        Piece Name: /home/oracle/backup/0kebuooi_1_1.back

  List of Archived Logs in backup set 17
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    10      477594     03-JAN-03 477619     03-JAN-03

BS Key  Size
------- ----------
18      180.50K

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    11      477619     03-JAN-03 478005     03-JAN-03

  Backup Set Copy #1 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    18      1   AVAILABLE   /home/oracle/backup/0mebup92_1_1.back

  Backup Set Copy #2 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19      1   AVAILABLE   /home/oracle/backup/0mebup92_1_2.back

  Backup Set Copy #3 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    20      1   AVAILABLE   /home/oracle/backup/0mebup92_1_3.back

BS Key  Size
------- ----------
21      7.00K

  List of Archived Logs in backup set 21
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    12      478005     03-JAN-03 478031     03-JAN-03

  Backup Set Copy #1 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    23      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_1.back

  Backup Set Copy #2 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    24      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_2.back

  Backup Set Copy #3 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    25      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_3.back

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

Recovery Manager complete.


R202041=.30


B:         Piece Name: /home/oracle/backup/0hebuon0_1_1.back
        Piece Name: /home/oracle/backup/0kebuooi_1_1.back
    18      1   AVAILABLE   /home/oracle/backup/0mebup92_1_1.back
    19      1   AVAILABLE   /home/oracle/backup/0mebup92_1_2.back
    20      1   AVAILABLE   /home/oracle/backup/0mebup92_1_3.back
    23      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_1.back
    24      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_2.back
    25      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_3.back

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:04 2003

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

connected to target database: PROD (DBID=4189108092)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19b9wdq_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bc3ws_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       475825     03-JAN-03 475846     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19blbml_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bmncz_.bkp

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6       475956     03-JAN-03 475984     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_2_DISK_FULL_WHOLE_z19bn6sg_.bkp

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03
  1    6       475956     03-JAN-03 475984     03-JAN-03
  1    7       475984     03-JAN-03 476014     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14      658.00K    DISK        00:00:01     03-JAN-03      
        BP Key: 14   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053216
        Piece Name: /home/oracle/backup/0hebuon0_1_1.back

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       476014     03-JAN-03 476043     03-JAN-03
  1    9       476043     03-JAN-03 477594     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17      2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053305
        Piece Name: /home/oracle/backup/0kebuooi_1_1.back

  List of Archived Logs in backup set 17
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    10      477594     03-JAN-03 477619     03-JAN-03

BS Key  Size
------- ----------
18      180.50K

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    11      477619     03-JAN-03 478005     03-JAN-03

  Backup Set Copy #1 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    18      1   AVAILABLE   /home/oracle/backup/0mebup92_1_1.back

  Backup Set Copy #2 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19      1   AVAILABLE   /home/oracle/backup/0mebup92_1_2.back

  Backup Set Copy #3 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    20      1   AVAILABLE   /home/oracle/backup/0mebup92_1_3.back

BS Key  Size
------- ----------
21      7.00K

  List of Archived Logs in backup set 21
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    12      478005     03-JAN-03 478031     03-JAN-03

  Backup Set Copy #1 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    23      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_1.back

  Backup Set Copy #2 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    24      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_2.back

  Backup Set Copy #3 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    25      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_3.back

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

Recovery Manager complete.


R202041=.32


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:04 2003

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

connected to target database: PROD (DBID=4189108092)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19b9wdq_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bc3ws_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       475825     03-JAN-03 475846     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19blbml_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bmncz_.bkp

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6       475956     03-JAN-03 475984     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_2_DISK_FULL_WHOLE_z19bn6sg_.bkp

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03
  1    6       475956     03-JAN-03 475984     03-JAN-03
  1    7       475984     03-JAN-03 476014     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14      658.00K    DISK        00:00:01     03-JAN-03      
        BP Key: 14   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053216
        Piece Name: /home/oracle/backup/0hebuon0_1_1.back

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       476014     03-JAN-03 476043     03-JAN-03
  1    9       476043     03-JAN-03 477594     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17      2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053305
        Piece Name: /home/oracle/backup/0kebuooi_1_1.back

  List of Archived Logs in backup set 17
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    10      477594     03-JAN-03 477619     03-JAN-03

BS Key  Size
------- ----------
18      180.50K

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    11      477619     03-JAN-03 478005     03-JAN-03

  Backup Set Copy #1 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    18      1   AVAILABLE   /home/oracle/backup/0mebup92_1_1.back

  Backup Set Copy #2 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19      1   AVAILABLE   /home/oracle/backup/0mebup92_1_2.back

  Backup Set Copy #3 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    20      1   AVAILABLE   /home/oracle/backup/0mebup92_1_3.back

BS Key  Size
------- ----------
21      7.00K

  List of Archived Logs in backup set 21
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    12      478005     03-JAN-03 478031     03-JAN-03

  Backup Set Copy #1 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    23      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_1.back

  Backup Set Copy #2 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    24      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_2.back

  Backup Set Copy #3 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    25      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_3.back

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

Recovery Manager complete.


R202041=.34


D: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:04 2003

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

connected to target database: PROD (DBID=4189108092)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19b9wdq_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bc3ws_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       475825     03-JAN-03 475846     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19blbml_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bmncz_.bkp

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6       475956     03-JAN-03 475984     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_2_DISK_FULL_WHOLE_z19bn6sg_.bkp

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03
  1    6       475956     03-JAN-03 475984     03-JAN-03
  1    7       475984     03-JAN-03 476014     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14      658.00K    DISK        00:00:01     03-JAN-03      
        BP Key: 14   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053216
        Piece Name: /home/oracle/backup/0hebuon0_1_1.back

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       476014     03-JAN-03 476043     03-JAN-03
  1    9       476043     03-JAN-03 477594     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17      2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053305
        Piece Name: /home/oracle/backup/0kebuooi_1_1.back

  List of Archived Logs in backup set 17
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    10      477594     03-JAN-03 477619     03-JAN-03

BS Key  Size
------- ----------
18      180.50K

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    11      477619     03-JAN-03 478005     03-JAN-03

  Backup Set Copy #1 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    18      1   AVAILABLE   /home/oracle/backup/0mebup92_1_1.back

  Backup Set Copy #2 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19      1   AVAILABLE   /home/oracle/backup/0mebup92_1_2.back

  Backup Set Copy #3 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    20      1   AVAILABLE   /home/oracle/backup/0mebup92_1_3.back

BS Key  Size
------- ----------
21      7.00K

  List of Archived Logs in backup set 21
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    12      478005     03-JAN-03 478031     03-JAN-03

  Backup Set Copy #1 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    23      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_1.back

  Backup Set Copy #2 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    24      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_2.back

  Backup Set Copy #3 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    25      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_3.back

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

Recovery Manager complete.


R202041=.37


E: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:04 2003

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

connected to target database: PROD (DBID=4189108092)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
2       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19b9wdq_.bkp

  List of Archived Logs in backup set 2
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5       3.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bc3ws_.bkp

  List of Archived Logs in backup set 5
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    4       475825     03-JAN-03 475846     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19blbml_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: 1_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_1_DISK_FULL_WHOLE_z19bmncz_.bkp

  List of Archived Logs in backup set 9
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    6       475956     03-JAN-03 475984     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      2.30M      DISK        00:00:01     03-JAN-03      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: 2_DISK_FULL_WHOLE
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2003_01_03/o1_mf_annnn_2_DISK_FULL_WHOLE_z19bn6sg_.bkp

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    3       473023     03-JAN-03 475825     03-JAN-03
  1    4       475825     03-JAN-03 475846     03-JAN-03
  1    5       475846     03-JAN-03 475956     03-JAN-03
  1    6       475956     03-JAN-03 475984     03-JAN-03
  1    7       475984     03-JAN-03 476014     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14      658.00K    DISK        00:00:01     03-JAN-03      
        BP Key: 14   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053216
        Piece Name: /home/oracle/backup/0hebuon0_1_1.back

  List of Archived Logs in backup set 14
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    8       476014     03-JAN-03 476043     03-JAN-03
  1    9       476043     03-JAN-03 477594     03-JAN-03

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17      2.00K      DISK        00:00:01     03-JAN-03      
        BP Key: 17   Status: AVAILABLE  Compressed: YES  Tag: TAG20030103T053305
        Piece Name: /home/oracle/backup/0kebuooi_1_1.back

  List of Archived Logs in backup set 17
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    10      477594     03-JAN-03 477619     03-JAN-03

BS Key  Size
------- ----------
18      180.50K

  List of Archived Logs in backup set 18
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    11      477619     03-JAN-03 478005     03-JAN-03

  Backup Set Copy #1 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    18      1   AVAILABLE   /home/oracle/backup/0mebup92_1_1.back

  Backup Set Copy #2 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19      1   AVAILABLE   /home/oracle/backup/0mebup92_1_2.back

  Backup Set Copy #3 of backup set 18
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     03-JAN-03       YES        TAG20030103T054154

    List of Backup Pieces for backup set 18 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    20      1   AVAILABLE   /home/oracle/backup/0mebup92_1_3.back

BS Key  Size
------- ----------
21      7.00K

  List of Archived Logs in backup set 21
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    12      478005     03-JAN-03 478031     03-JAN-03

  Backup Set Copy #1 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    23      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_1.back

  Backup Set Copy #2 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    24      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_2.back

  Backup Set Copy #3 of backup set 21
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     03-JAN-03       YES        TAG20030103T054243

    List of Backup Pieces for backup set 21 Copy #3
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    25      1   AVAILABLE   /home/oracle/backup/0pebupaj_1_3.back

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

Recovery Manager complete.


R202041=.40


F: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:06 2003

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 Fri Jan 3 06:29:06 2003

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 Fri Jan 3 06:29:06 2003

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 Fri Jan 3 06:29:07 2003

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 Fri Jan 3 06:29:07 2003

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 Fri Jan 3 06:29:07 2003

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 Fri Jan 3 06:29:07 2003

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

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

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


R301010=0.1


A: 4294967296


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

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jan 3 06:29:07 2003

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 Fri Jan 3 06:29:08 2003

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> select	* from sys.t2968812593
                   *
ERROR at line 1:
ORA-00942: table or view does not exist


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


A: READ WRITE


R302002=0


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


R101000: 0.2 full is 0.2 0.2
R101010: 0.1 full is 0.1 0.3
R101020: 0.3 full is 0.3 0.6
R102000: 0.2 full is 0.2 0.8
R102010: 0.3 full is 0.3 1.1
R102020: 0.2 full is 0.2 1.3
R103010: .20 full is 0.2 1.5
R103020: .20 full is 0.2 1.7
R201010: .20 full is 0.2 1.9
R201021: 0.1 full is 0.1 2.0
R201022: .20 full is 0.2 2.2
R201031: .30 full is 0.3 2.5
R201032: 0.3 full is 0.3 2.8
R201033: .30 full is 0.3 3.1
R201040: .20 full is 0.2 3.3
R202020: 1.00 full is 1 4.3
R202031: .07 full is 0.1 4.4
R202032: .40 full is 0.4 4.8
R202041: .40 full is 0.4 5.2
R202042: 0.3 full is 0.3 5.5
R202051: 0.05 full is 0.05 5.55
R202052: 0 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.1 full is 0.1 6.4
R301020: 0.1 full is 0.1 6.5
R302001: 0 full is 0.01 6.51
R302002: 0 full is 3.49 10
full of this section:
RESULT:
1.12


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