

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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_SID=PROD
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export OMS_HOME=$ORACLE_BASE/OracleHomes/oms10g
export AGENT_HOME=$ORACLE_BASE/OracleHomes/agent10g
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US
export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH


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

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

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 Sun Jan 11 17:12:57 2015

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

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

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


R101010=0.1


A: LOCAL


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

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

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

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

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


R101020=0.3


A:  104857600


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

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

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

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

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


R102000=0.2


A: RC_ADMIN


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

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

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

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

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


R102010=0.3


A: RC_DATA


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

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

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

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

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


R102020=0.2


A: RECOVERY_CATALOG_OWNER


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


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

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103010=0


A: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103010=0.2


B: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103010=0


C: 0


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

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103020=0


A: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103020=0.2


B: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103020=0


C: 0

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103020=.02


D: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

Recovery Manager: Release 10.2.0.2.0 - Production on Sun Jan 11 17:12:59 2015

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/11/2015 17:13:02
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R103020=.04


E: 0


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


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


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

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201010=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201010=0.2


B: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201010=0


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201010=.02


D: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201010=.04


E: 0


******************** TOPIC 2.1.2 ********************
ls: /home/oracle/backup: No such file or directory


R201021=0



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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201022=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201022=0.2


B: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201022=0


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201022=.02


D: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201022=.04


E: 0


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

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201031=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201031=0.2


B: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201031=0


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201031=.02


D: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201031=.04


E: 0
ls: /home/oracle/backup/control: No such file or directory


R201032=0



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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201033=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201033=0.2


B: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201033=0


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201033=.02


D: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201033=.04


E: 0


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

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201040=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201040=0.2


B: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201040=0


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201040=.02


D: RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

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

connected to target database: PROD (DBID=280476594, not open)
connected to recovery catalog database

RMAN> 
RMAN configuration parameters are:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 01/11/2015 17:13:06
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

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

Recovery Manager complete.


R201040=.04


E: 0


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


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


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

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

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

connected to target database: PROD (DBID=280476594, not open)

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
------- ---- -- ---------- ----------- ------------ ---------------
11      Incr 0  117.47M    DISK        00:00:00     10-JAN-15      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1znmnb_.bkp
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 203741     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Incr 0  119.79M    DISK        00:00:00     11-JAN-15      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rc2l_.bkp
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 253414     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/system01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

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
------- ---- -- ---------- ----------- ------------ ---------------
6       Incr 0  123.36M    DISK        00:00:00     10-JAN-15      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1znqjd_.bkp
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 203743     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Incr 0  14.21M     DISK        00:00:00     11-JAN-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rddp_.bkp
  List of Datafiles in backup set 16
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 253416     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk3/undotbs01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Incr 0  28.38M     DISK        00:00:00     10-JAN-15      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1znn7h_.bkp
  List of Datafiles in backup set 5
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 203742     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Incr 0  40.31M     DISK        00:00:00     11-JAN-15      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rdv1_.bkp
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 253415     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk2/sysaux01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Incr 0  96.00K     DISK        00:00:00     10-JAN-15      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1znp61_.bkp
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 203744     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Incr 0  168.00K    DISK        00:00:00     11-JAN-15      
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rddv_.bkp
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 253417     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/users01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

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
------- ---- -- ---------- ----------- ------------ ---------------
7       Incr 0  160.00K    DISK        00:00:00     10-JAN-15      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1znmn1_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 203740     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Incr 0  44.66M     DISK        00:00:00     11-JAN-15      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rb0n_.bkp
  List of Datafiles in backup set 14
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 253413     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/example01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

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
------- ---- -- ---------- ----------- ------------ ---------------
10      Incr 0  96.00K     DISK        00:00:00     10-JAN-15      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1znvt2_.bkp
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 203748     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/index_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Incr 0  119.79M    DISK        00:00:00     11-JAN-15      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rc2l_.bkp
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 253414     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/index_01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

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
------- ---- -- ---------- ----------- ------------ ---------------
8       Incr 0  96.00K     DISK        00:00:00     10-JAN-15      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1znxx7_.bkp
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 203750     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/tools_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Incr 0  40.31M     DISK        00:00:00     11-JAN-15      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rdv1_.bkp
  List of Datafiles in backup set 13
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 253415     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/tools_01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

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
------- ---- -- ---------- ----------- ------------ ---------------
9       Incr 0  96.00K     DISK        00:00:00     10-JAN-15      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182730
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_10/o1_mf_nnnd0_TAG20150110T182730_bc1zns05_.bkp
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8       Full 203747     10-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/oltp_01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Incr 0  14.21M     DISK        00:00:00     11-JAN-15      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rddp_.bkp
  List of Datafiles in backup set 16
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  8       Full 253416     11-JAN-15 /u01/app/oracle/oradata/PROD/Disk1/oltp_01.dbf

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

Recovery Manager complete.

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

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

connected to target database: PROD (DBID=280476594, not open)

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
------- ---- -- ---------- ----------- ------------ ---------------
15      Incr 0  168.00K    DISK        00:00:00     11-JAN-15      
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153225
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/backupset/2015_01_11/o1_mf_nnnd0_TAG20150111T153225_bc49rddv_.bkp
  List of Datafiles in backup set 15
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9       Full 253417     11-JAN-15 /u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00009

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

Recovery Manager complete.
R202020=0


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

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=0


B: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.01


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.02


D: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.03


E: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  SPFILE Included: Modification time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  SPFILE Included: Modification time: 11-JAN-15

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

Recovery Manager complete.


R202031=.04


F: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  Control File Included: Ckp SCN: 203755       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  Control File Included: Ckp SCN: 224075       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  Control File Included: Ckp SCN: 253428       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  Control File Included: Ckp SCN: 203755       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  Control File Included: Ckp SCN: 224075       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  Control File Included: Ckp SCN: 253428       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=0


B: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  Control File Included: Ckp SCN: 203755       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  Control File Included: Ckp SCN: 224075       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  Control File Included: Ckp SCN: 253428       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.02


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  Control File Included: Ckp SCN: 203755       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  Control File Included: Ckp SCN: 224075       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  Control File Included: Ckp SCN: 253428       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.04


D: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  Control File Included: Ckp SCN: 203755       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  Control File Included: Ckp SCN: 224075       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  Control File Included: Ckp SCN: 253428       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.07


E: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

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.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T182744
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868645664_bc1zo12o_.bkp
  Control File Included: Ckp SCN: 203755       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    6.58M      DISK        00:00:00     10-JAN-15      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20150110T220151
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_10/o1_mf_s_868658511_bc2d6hmk_.bkp
  Control File Included: Ckp SCN: 224075       Ckp time: 10-JAN-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    6.58M      DISK        00:00:00     11-JAN-15      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20150111T153246
        Piece Name: /u01/app/oracle/flash_recovery_area/PROD/autobackup/2015_01_11/o1_mf_s_868721566_bc49ryq4_.bkp
  Control File Included: Ckp SCN: 253428       Ckp time: 11-JAN-15

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

Recovery Manager complete.


R202032=.10


F: 0


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

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

Recovery Manager complete.


R202041=0


A: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

Recovery Manager complete.


R202041=0


B: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

Recovery Manager complete.


R202041=.02


C: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

Recovery Manager complete.


R202041=.04


D: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

Recovery Manager complete.


R202041=.07


E: 0

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

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

connected to target database: PROD (DBID=280476594, not open)

RMAN> 
using target database control file instead of recovery catalog

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

Recovery Manager complete.


R202041=.10


F: 0

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL>   2    3  from V_$BACKUP_ARCHIVELOG_DETAILS  ad, v_$archived_log	al where
                                       *
ERROR at line 2:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


A: 0


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

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

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

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

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


R202051=0.05



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

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

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


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


R202052=0




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

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

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

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

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


R202061=0



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

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

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


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


R202062=0




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


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

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

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

SQL> Connected.
SQL> SQL> 
FLASHBACK_ON
------------------
NO

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


A: 0


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

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

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

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

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


R301010=0.1


A: 4294967296


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

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

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

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

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


R301020=0.1


A: /u01/app/oracle/flash_recovery_area


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

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

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

SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> ****************************
SQL> The database open mode here:
SQL> ****************************
SQL> SQL> 
ADDR	       INDX    INST_ID D
-------- ---------- ---------- -
0C550094	  0	     1 X
SQL> 
OPEN_MODE
----------
MOUNTED
SQL> select	* from sys.t2968812593
                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


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


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: 0 full is 0.2 1.5
R103020: .04 full is 0.2 1.7
R201010: .04 full is 0.2 1.9
R201021: 0 full is 0.1 2.0
R201022: .04 full is 0.2 2.2
R201031: .04 full is 0.3 2.5
R201032: 0 full is 0.3 2.8
R201033: .04 full is 0.3 3.1
R201040: .04 full is 0.2 3.3
R202020: 0 full is 1 4.3
R202031: .04 full is 0.1 4.4
R202032: .10 full is 0.4 4.8
R202041: .10 full is 0.4 5.2
R202042: 0 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 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:
2.03


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