recover oracle database exclude tablespace

db_file_name_convert=('/oradata3/PRODPV/','/oradata3/PRODQA/','/oratemp1/PRODPV/','/oratemp1/PRODQA/')
log_file_name_convert=('/oralog1/PRODPV/','/oralog1/PRODQA/','/oralog2/PRODPV/','/oralog2/PRODQA/')


[oracle@usnode dbs]$ cat CRQ000000123456.cmd
run
{
set until time "to_date('mar 03 2016 11:59:00','Mon DD YYYY HH24:MI:SS')";
allocate channel t1 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
allocate channel t3 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-INCR)';
allocate channel t5 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-ARCH)';
allocate auxiliary channel a1 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-INCR)';
allocate auxiliary channel a3 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-ARCH)';
allocate auxiliary channel a6 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
DUPLICATE  TARGET DATABASE TO 'PRODQA';
}
[oracle@usnode dbs]$ chmod 775 CRQ000000123456.cmd
[oracle@usnode dbs]$ echo $ORACLE_SID
PRODQA
[oracle@usnode dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 07:01:25 2016

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


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

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile=initPRODQA.ora
ORACLE instance started.

Total System Global Area 2.1379E+10 bytes
Fixed Size                  2213136 bytes
Variable Size            1.6911E+10 bytes
Database Buffers         4294967296 bytes
Redo Buffers              170340352 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@usnode dbs]$  orapwd file=orapw$ORACLE_SID entries=15 password=passwd
[oracle@usnode dbs]$ nohup rman target sys/passwd@PRODPV auxiliary sys/passwd@PRODQA cmdfile=CRQ000000123456.cmd log=CRQ000000123456.log &
[1] 620
[oracle@usnode dbs]$ nohup: appending output to `nohup.out'

[oracle@usnode dbs]$ tail -f CRQ000000123456.log
channel t5: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: a1
channel a1: SID=421 device type=SBT_TAPE
channel a1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: a3
channel a3: SID=436 device type=SBT_TAPE
channel a3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: a6
channel a6: SID=451 device type=SBT_TAPE
channel a6: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

Starting Duplicate Db at 05-MAR-16

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area   21378957312 bytes

Fixed Size                     2213136 bytes
Variable Size              16911436528 bytes
Database Buffers            4294967296 bytes
Redo Buffers                 170340352 bytes
allocated channel: a1
channel a1: SID=421 device type=SBT_TAPE
channel a1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a3
channel a3: SID=436 device type=SBT_TAPE
channel a3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a6
channel a6: SID=451 device type=SBT_TAPE
channel a6: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

contents of Memory Script:
{
   set until scn  14462050921984;
   sql clone "alter system set  db_name =
 ''PRODPV'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''PRODQA'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile;
   alter clone database mount;
}
executing Memory Script

executing command: SET until clause

sql statement: alter system set  db_name =  ''PRODPV'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''PRODQA'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area   21378957312 bytes

Fixed Size                     2213136 bytes
Variable Size              16911436528 bytes
Database Buffers            4294967296 bytes
Redo Buffers                 170340352 bytes
allocated channel: a1
channel a1: SID=421 device type=SBT_TAPE
channel a1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a3
channel a3: SID=436 device type=SBT_TAPE
channel a3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a6
channel a6: SID=451 device type=SBT_TAPE
channel a6: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

Starting restore at 05-MAR-16

channel a1: starting datafile backup set restore
channel a1: restoring control file
channel a1: reading from backup piece c-575815501-20160303-03
channel a1: piece handle=c-575815501-20160303-03 tag=TAG20160303T112853
channel a1: restored backup piece 1
channel a1: restore complete, elapsed time: 00:01:35
output file name=/oradata1/PRODQA/control01.ctl
output file name=/oradata2/PRODQA/control02.ctl
output file name=/oradata3/PRODQA/control03.ctl
Finished restore at 05-MAR-16

database mounted

contents of Memory Script:
{
   set until scn  14462050921984;
   set newname for datafile  1 to
 "/oradata3/PRODQA/system01.dbf";
   set newname for datafile  2 to
 "/oradata3/PRODQA/sysaux01.dbf";
   set newname for datafile  3 to
 "/oradata3/PRODQA/undotbs01.dbf";
   set newname for datafile  4 to
 "/oradata3/PRODQA/users01.dbf";
   set newname for datafile  5 to
 "/oradata3/PRODQA/pvwd01.dbf";
   set newname for datafile  6 to
 "/oradata3/PRODQA/pvwx01.dbf";
   set newname for datafile  7 to
 "/oradata3/PRODQA/pvwdocs01.dbf";
   set newname for datafile  8 to
 "/oradata3/PRODQA/pvwd02.dbf";
   set newname for datafile  9 to
 "/oradata3/PRODQA/pvwx02.dbf";
   set newname for datafile  10 to
 "/oradata3/PRODQA/undotbs02.dbf";
   set newname for datafile  11 to
 "/oradata3/PRODQA/pvwdocs02.dbf";
   set newname for datafile  12 to
 "/oradata3/PRODQA/pvwdocs03.dbf";
   set newname for datafile  13 to
 "/oradata3/PRODQA/pvwd03.dbf";
   set newname for datafile  14 to
 "/oradata3/PRODQA/ignited01.dbf";
   set newname for datafile  15 to
 "/oradata3/PRODQA/pvwdocs04.dbf";
   set newname for datafile  16 to
 "/oradata3/PRODQA/pvwdocs05.dbf";
   set newname for datafile  17 to
 "/oradata3/PRODQA/pvwx03.dbf";
   set newname for datafile  18 to
 "/oradata3/PRODQA/pvwdocs06.dbf";
   set newname for datafile  19 to
 "/oradata3/PRODQA/pvwd04.dbf";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 05-MAR-16

channel a1: starting datafile backup set restore
channel a1: specifying datafile(s) to restore from backup set
channel a1: restoring datafile 00004 to /oradata3/PRODQA/users01.dbf
channel a1: restoring datafile 00005 to /oradata3/PRODQA/pvwd01.dbf
channel a1: restoring datafile 00012 to /oradata3/PRODQA/pvwdocs03.dbf
channel a1: restoring datafile 00019 to /oradata3/PRODQA/pvwd04.dbf
channel a1: reading from backup piece dblevel0_PRODPV.17563_1_905509882
channel a3: starting datafile backup set restore
channel a3: specifying datafile(s) to restore from backup set
channel a3: restoring datafile 00002 to /oradata3/PRODQA/sysaux01.dbf
channel a3: restoring datafile 00003 to /oradata3/PRODQA/undotbs01.dbf
channel a3: restoring datafile 00008 to /oradata3/PRODQA/pvwd02.dbf
channel a3: restoring datafile 00010 to /oradata3/PRODQA/undotbs02.dbf
channel a3: reading from backup piece dblevel0_PRODPV.17562_1_905509882
channel a6: starting datafile backup set restore
channel a6: specifying datafile(s) to restore from backup set
channel a6: restoring datafile 00001 to /oradata3/PRODQA/system01.dbf
channel a6: restoring datafile 00009 to /oradata3/PRODQA/pvwx02.dbf
channel a6: restoring datafile 00011 to /oradata3/PRODQA/pvwdocs02.dbf
channel a6: reading from backup piece dblevel0_PRODPV.17561_1_905509882
channel a6: piece handle=dblevel0_PRODPV.17561_1_905509882 tag=DB_HOT_FULL_20160303103009
channel a6: restored backup piece 1
channel a6: restore complete, elapsed time: 00:07:05
channel a6: starting datafile backup set restore
channel a6: specifying datafile(s) to restore from backup set
channel a6: restoring datafile 00006 to /oradata3/PRODQA/pvwx01.dbf
channel a6: restoring datafile 00015 to /oradata3/PRODQA/pvwdocs04.dbf
channel a6: restoring datafile 00017 to /oradata3/PRODQA/pvwx03.dbf
channel a6: restoring datafile 00018 to /oradata3/PRODQA/pvwdocs06.dbf
channel a6: reading from backup piece dblevel0_PRODPV.17559_1_905509882
channel a1: piece handle=dblevel0_PRODPV.17563_1_905509882 tag=DB_HOT_FULL_20160303103009
channel a1: restored backup piece 1
channel a1: restore complete, elapsed time: 00:07:50
channel a1: starting datafile backup set restore
channel a1: specifying datafile(s) to restore from backup set
channel a1: restoring datafile 00007 to /oradata3/PRODQA/pvwdocs01.dbf
channel a1: restoring datafile 00013 to /oradata3/PRODQA/pvwd03.dbf
channel a1: restoring datafile 00014 to /oradata3/PRODQA/ignited01.dbf
channel a1: restoring datafile 00016 to /oradata3/PRODQA/pvwdocs05.dbf
channel a1: reading from backup piece dblevel0_PRODPV.17560_1_905509882
channel a3: piece handle=dblevel0_PRODPV.17562_1_905509882 tag=DB_HOT_FULL_20160303103009
channel a3: restored backup piece 1
channel a3: restore complete, elapsed time: 00:07:57
channel a6: piece handle=dblevel0_PRODPV.17559_1_905509882 tag=DB_HOT_FULL_20160303103009
channel a6: restored backup piece 1
channel a6: restore complete, elapsed time: 00:11:21
channel a1: piece handle=dblevel0_PRODPV.17560_1_905509882 tag=DB_HOT_FULL_20160303103009
channel a1: restored backup piece 1
channel a1: restore complete, elapsed time: 00:10:56
Finished restore at 05-MAR-16

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=96 STAMP=905671754 file name=/oradata3/PRODQA/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=97 STAMP=905671754 file name=/oradata3/PRODQA/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=98 STAMP=905671754 file name=/oradata3/PRODQA/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=99 STAMP=905671754 file name=/oradata3/PRODQA/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=100 STAMP=905671754 file name=/oradata3/PRODQA/pvwd01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=101 STAMP=905671754 file name=/oradata3/PRODQA/pvwx01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=102 STAMP=905671754 file name=/oradata3/PRODQA/pvwdocs01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=103 STAMP=905671754 file name=/oradata3/PRODQA/pvwd02.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=104 STAMP=905671754 file name=/oradata3/PRODQA/pvwx02.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=105 STAMP=905671754 file name=/oradata3/PRODQA/undotbs02.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=106 STAMP=905671754 file name=/oradata3/PRODQA/pvwdocs02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=107 STAMP=905671754 file name=/oradata3/PRODQA/pvwdocs03.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=108 STAMP=905671754 file name=/oradata3/PRODQA/pvwd03.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=109 STAMP=905671754 file name=/oradata3/PRODQA/ignited01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=110 STAMP=905671754 file name=/oradata3/PRODQA/pvwdocs04.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=111 STAMP=905671755 file name=/oradata3/PRODQA/pvwdocs05.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=112 STAMP=905671755 file name=/oradata3/PRODQA/pvwx03.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=113 STAMP=905671755 file name=/oradata3/PRODQA/pvwdocs06.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=114 STAMP=905671755 file name=/oradata3/PRODQA/pvwd04.dbf

contents of Memory Script:
{
   set until time  "to_date('mar 03 2016 11:59:00','Mon DD YYYY HH24:MI:SS')";
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 05-MAR-16

starting media recovery

channel a1: starting archived log restore to default destination
channel a1: restoring archived log
archived log thread=1 sequence=11166
channel a1: reading from backup piece dblevel0_PRODPV.17566_1_905512797
channel a3: starting archived log restore to default destination
channel a3: restoring archived log
archived log thread=1 sequence=11167
channel a3: reading from backup piece dbarch_PRODPV.17568_1_905519956
channel a1: piece handle=dblevel0_PRODPV.17566_1_905512797 tag=DB_HOT_FULL_20160303103009
channel a1: restored backup piece 1
channel a1: restore complete, elapsed time: 00:05:26
archived log file name=/oraarc1/PRODQA/PRODQA_1_11166_851338030.arc thread=1 sequence=11166
channel clone_default: deleting archived log(s)
archived log file name=/oraarc1/PRODQA/PRODQA_1_11166_851338030.arc RECID=49682 STAMP=905672077
channel a3: piece handle=dbarch_PRODPV.17568_1_905519956 tag=ARCH_TAPE_20160303131910
channel a3: restored backup piece 1
channel a3: restore complete, elapsed time: 00:05:32
archived log file name=/oraarc1/PRODQA/PRODQA_1_11167_851338030.arc thread=1 sequence=11167
channel clone_default: deleting archived log(s)
archived log file name=/oraarc1/PRODQA/PRODQA_1_11167_851338030.arc RECID=49681 STAMP=905672072
media recovery complete, elapsed time: 00:00:04
Finished recover at 05-MAR-16

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  db_name =
 ''PRODQA'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area   21378957312 bytes

Fixed Size                     2213136 bytes
Variable Size              16911436528 bytes
Database Buffers            4294967296 bytes
Redo Buffers                 170340352 bytes
allocated channel: a1
channel a1: SID=421 device type=SBT_TAPE
channel a1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a3
channel a3: SID=436 device type=SBT_TAPE
channel a3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a6
channel a6: SID=451 device type=SBT_TAPE
channel a6: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

sql statement: alter system set  db_name =  ''PRODQA'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area   21378957312 bytes

Fixed Size                     2213136 bytes
Variable Size              16911436528 bytes
Database Buffers            4294967296 bytes
Redo Buffers                 170340352 bytes
allocated channel: a1
channel a1: SID=421 device type=SBT_TAPE
channel a1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a3
channel a3: SID=436 device type=SBT_TAPE
channel a3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
allocated channel: a6
channel a6: SID=451 device type=SBT_TAPE
channel a6: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PRODQA" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      500
  MAXINSTANCES     8
  MAXLOGHISTORY     1168
 LOGFILE
  GROUP  1 ( '/oralog2/PRODQA/redo_g1_m2.rdo', '/oralog1/PRODQA/redo_g1_m1.rdo' ) SIZE 256 M  REUSE,
  GROUP  2 ( '/oralog2/PRODQA/redo_g2_m2.rdo', '/oralog1/PRODQA/redo_g2_m1.rdo' ) SIZE 256 M  REUSE,
  GROUP  3 ( '/oralog1/PRODQA/redo_g3_m1.rdo', '/oralog2/PRODQA/redo_g3_m2.rdo' ) SIZE 256 M  REUSE,
  GROUP  4 ( '/oralog1/PRODQA/redo_g4_m1.rdo', '/oralog2/PRODQA/redo_g4_m2.rdo' ) SIZE 256 M  REUSE
 DATAFILE
  '/oradata3/PRODQA/system01.dbf'
 CHARACTER SET WE8MSWIN1252


contents of Memory Script:
{
   set newname for tempfile  1 to
 "/oratemp1/PRODQA/temp01.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "/oradata3/PRODQA/sysaux01.dbf",
 "/oradata3/PRODQA/undotbs01.dbf",
 "/oradata3/PRODQA/users01.dbf",
 "/oradata3/PRODQA/pvwd01.dbf",
 "/oradata3/PRODQA/pvwx01.dbf",
 "/oradata3/PRODQA/pvwdocs01.dbf",
 "/oradata3/PRODQA/pvwd02.dbf",
 "/oradata3/PRODQA/pvwx02.dbf",
 "/oradata3/PRODQA/undotbs02.dbf",
 "/oradata3/PRODQA/pvwdocs02.dbf",
 "/oradata3/PRODQA/pvwdocs03.dbf",
 "/oradata3/PRODQA/pvwd03.dbf",
 "/oradata3/PRODQA/ignited01.dbf",
 "/oradata3/PRODQA/pvwdocs04.dbf",
 "/oradata3/PRODQA/pvwdocs05.dbf",
 "/oradata3/PRODQA/pvwx03.dbf",
 "/oradata3/PRODQA/pvwdocs06.dbf",
 "/oradata3/PRODQA/pvwd04.dbf";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /oratemp1/PRODQA/temp01.dbf in control file

cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/sysaux01.dbf RECID=1 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/undotbs01.dbf RECID=2 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/users01.dbf RECID=3 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwd01.dbf RECID=4 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwx01.dbf RECID=5 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwdocs01.dbf RECID=6 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwd02.dbf RECID=7 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwx02.dbf RECID=8 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/undotbs02.dbf RECID=9 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwdocs02.dbf RECID=10 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwdocs03.dbf RECID=11 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwd03.dbf RECID=12 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/ignited01.dbf RECID=13 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwdocs04.dbf RECID=14 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwdocs05.dbf RECID=15 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwx03.dbf RECID=16 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwdocs06.dbf RECID=17 STAMP=905672142
cataloged datafile copy
datafile copy file name=/oradata3/PRODQA/pvwd04.dbf RECID=18 STAMP=905672142

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=905672142 file name=/oradata3/PRODQA/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=905672142 file name=/oradata3/PRODQA/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=905672142 file name=/oradata3/PRODQA/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=905672142 file name=/oradata3/PRODQA/pvwd01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=905672142 file name=/oradata3/PRODQA/pvwx01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=905672142 file name=/oradata3/PRODQA/pvwdocs01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=905672142 file name=/oradata3/PRODQA/pvwd02.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=905672142 file name=/oradata3/PRODQA/pvwx02.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=905672142 file name=/oradata3/PRODQA/undotbs02.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=905672142 file name=/oradata3/PRODQA/pvwdocs02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=905672142 file name=/oradata3/PRODQA/pvwdocs03.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=905672142 file name=/oradata3/PRODQA/pvwd03.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=905672142 file name=/oradata3/PRODQA/ignited01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=905672142 file name=/oradata3/PRODQA/pvwdocs04.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=15 STAMP=905672142 file name=/oradata3/PRODQA/pvwdocs05.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=16 STAMP=905672142 file name=/oradata3/PRODQA/pvwx03.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=17 STAMP=905672142 file name=/oradata3/PRODQA/pvwdocs06.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=18 STAMP=905672142 file name=/oradata3/PRODQA/pvwd04.dbf

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 05-MAR-16
released channel: t1
released channel: t3
released channel: t5
released channel: a1
released channel: a3
released channel: a6

Recovery Manager complete.

[1]+  Done                    nohup rman target sys/passwd@PRODPV auxiliary sys/passwd@PRODQA cmdfile=CRQ000000123456.cmd log=CRQ000000123456.log
[oracle@usnode dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 08:11:47 2016

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


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

SQL> select open_mode , name from v$Database;

OPEN_MODE            NAME
-------------------- ---------
READ WRITE           PRODQA

SQL> select global_name g1, sysdate g2 from global_name;

G1
--------------------------------------------------------------------------------
G2
---------
PRODQA
05-MAR-16

SQL> connect / as sysdba
Connected.
SQL> alter user system identified by passwd;

User altered.

SQL> connect system/passwd
Connected.

SQL> select dbid from v$database;

      DBID
----------
   6356493

SQL> select sum(bytes)/1024/1024/1024 from dba_data_files;

SUM(BYTES)/1024/1024/1024
-------------------------
               176.320313

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@usnode dbs]$ sqlplus rmant_11g/rmand@RMANCATAMER

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 08:46:47 2016

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


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

SQL> select * from dict where table_name like '%RC%';

TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
USER_CUBE_HIERARCHIES
OLAP Hierarchies owned by the user in the database

USER_DIM_HIERARCHIES
Representation of a dimension hierarchy

USER_FLASHBACK_ARCHIVE
Description of the flashback archives available to the user


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
USER_FLASHBACK_ARCHIVE_TABLES
Information about the user tables that are enabled for Flashback Archive

USER_RESOURCE_LIMITS
Display resource limit of the user

USER_RSRC_CONSUMER_GROUP_PRIVS
Switch privileges for consumer groups for the user


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
USER_RSRC_MANAGER_SYSTEM_PRIVS
system privileges for the resource manager for the user

USER_SOURCE
Source of stored objects accessible to the user

USER_SOURCE_AE
Source of stored objects accessible to the user


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
USER_SOURCE_TABLES
Source tables available for Change Data Capture

ALL_CHANGE_SOURCES
Change Data Capture change sources

ALL_CUBE_HIERARCHIES
OLAP Hierarchies in the database accessible by the user


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
ALL_DIM_HIERARCHIES
Representation of a dimension hierarchy

ALL_SOURCE
Current source on stored objects that user is allowed to create

ALL_SOURCE_AE
Current source on stored objects that user is allowed to create


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
RESOURCE_COST
Cost for each resource

V$RSRC_CONSUMER_GROUP
Synonym for V_$RSRC_CONSUMER_GROUP

V$RSRC_CONSUMER_GROUP_CPU_MTH
Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
V$RSRC_CONS_GROUP_HISTORY
Synonym for V_$RSRC_CONS_GROUP_HISTORY

V$RSRC_PLAN
Synonym for V_$RSRC_PLAN

V$RSRC_PLAN_CPU_MTH
Synonym for V_$RSRC_PLAN_CPU_MTH


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
V$RSRC_PLAN_HISTORY
Synonym for V_$RSRC_PLAN_HISTORY

V$RSRC_SESSION_INFO
Synonym for V_$RSRC_SESSION_INFO

GV$RSRC_CONSUMER_GROUP
Synonym for GV_$RSRC_CONSUMER_GROUP


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
GV$RSRC_CONSUMER_GROUP_CPU_MTH
Synonym for GV_$RSRC_CONSUME_GROUP_CPU_MTH

GV$RSRC_CONS_GROUP_HISTORY
Synonym for GV_$RSRC_CONS_GROUP_HISTORY

GV$RSRC_PLAN
Synonym for GV_$RSRC_PLAN


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
GV$RSRC_PLAN_CPU_MTH
Synonym for GV_$RSRC_PLAN_CPU_MTH

GV$RSRC_PLAN_HISTORY
Synonym for GV_$RSRC_PLAN_HISTORY

GV$RSRC_SESSION_INFO
Synonym for GV_$RSRC_SESSION_INFO


TABLE_NAME
------------------------------
COMMENTS
--------------------------------------------------------------------------------
ALL_SOURCE_TABLES
Synonym for USER_SOURCE_TABLES


31 rows selected.

SQL> desc rc_database
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DB_KEY                                    NOT NULL NUMBER
 DBINC_KEY                                          NUMBER
 DBID                                      NOT NULL NUMBER
 NAME                                      NOT NULL VARCHAR2(8)
 RESETLOGS_CHANGE#                         NOT NULL NUMBER
 RESETLOGS_TIME                            NOT NULL DATE

SQL> !ps -ef|grep pmon
oracle    8409     1  0 Jan27 ?        00:01:57 ora_pmon_PVXQA
oracle   10738     1  0 Jan23 ?        00:02:15 ora_pmon_PVXPRD
oracle   18195     1  0 07:35 ?        00:00:00 ora_pmon_PRODQA
oracle   20606     1  0  2015 ?        00:18:19 ora_pmon_PRODPV
oracle   26151 19245  0 08:48 pts/0    00:00:00 /bin/bash -c ps -ef|grep pmon
oracle   26155 26151  0 08:48 pts/0    00:00:00 grep pmon
oracle   28803     1  0  2015 ?        00:05:12 ora_pmon_O1S17392
oracle   30606     1  0  2015 ?        00:05:12 ora_pmon_O1P17392

SQL>  select name,dbid from rc_database where NAME='PRODQA' ;

NAME           DBID
-------- ----------
PRODQA   4247010533
PRODQA   4277918464

SQL>  select name,dbid,RESETLOGS_TIME from rc_database where NAME='PRODQA' ;

NAME           DBID RESETLOGS
-------- ---------- ---------
PRODQA   4247010533 27-JUN-14
PRODQA   4277918464 13-JUN-15

[oracle@usnode dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 09:09:47 2016

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


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

SQL> select name from v$database;

NAME
---------
PRODQA

SQL> shutdown immediate

ORA-01013: user requested cancel of current operation

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount pfile=initPRODQA.ora
ORACLE instance started.

Total System Global Area 2.1379E+10 bytes
Fixed Size                  2213136 bytes
Variable Size            1.6911E+10 bytes
Database Buffers         4294967296 bytes
Redo Buffers              170340352 bytes
SQL> exit
[oracle@usnode dbs]$ rman target / catalog rmant_11g/rmand@RMANCATAMER

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 5 09:48:04 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRODQA (not mounted)
connected to recovery catalog database

RMAN> set DBID=4247010533;

executing command: SET DBID
database name is "PRODQA" and DBID is 4247010533

RMAN> list backup summary ;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
29991124 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991125 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991126 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991127 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991128 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991129 B  A  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
30000435 B  A  A SBT_TAPE    11-JUN-15       1       1       NO         ARCH_TAPE_20150611130303
30008257 B  A  A SBT_TAPE    11-JUN-15       1       1       NO         ARCH_TAPE_20150611190302
30017011 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612010303
30017012 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612010303
30017013 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612010303
30028562 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612070323
30029478 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029479 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029481 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029482 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029483 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029484 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029485 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029486 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029487 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30039702 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612130303
30049725 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612190302
30063193 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         ARCH_TAPE_20150613010302
30063194 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         ARCH_TAPE_20150613010302
30063195 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         ARCH_TAPE_20150613010302
30071562 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071563 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071564 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071565 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071566 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071567 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071568 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071569 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071570 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071571 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318

RMAN> set DBID=4277918464;

executing command: SET DBID
database name is "PRODQA" and DBID is 4277918464

RMAN> list backup summary ;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
29991124 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991125 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991126 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991127 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991128 B  0  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
29991129 B  A  A SBT_TAPE    11-JUN-15       1       1       NO         DB_HOT_FULL_20150611070723
30000435 B  A  A SBT_TAPE    11-JUN-15       1       1       NO         ARCH_TAPE_20150611130303
30008257 B  A  A SBT_TAPE    11-JUN-15       1       1       NO         ARCH_TAPE_20150611190302
30017011 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612010303
30017012 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612010303
30017013 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612010303
30028562 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612070323
30029478 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029479 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029481 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029482 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029483 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029484 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029485 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029486 B  1  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30029487 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         DB_HOT_INCR_20150612070745
30039702 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612130303
30049725 B  A  A SBT_TAPE    12-JUN-15       1       1       NO         ARCH_TAPE_20150612190302
30063193 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         ARCH_TAPE_20150613010302
30063194 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         ARCH_TAPE_20150613010302
30063195 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         ARCH_TAPE_20150613010302
30071562 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071563 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071564 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071565 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071566 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071567 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071568 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071569 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071570 B  0  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318
30071571 B  A  A SBT_TAPE    13-JUN-15       1       1       NO         DB_HOT_FULL_20150613023318

RMAN>

Recovery Manager complete.
[oracle@usnode dbs]$
[oracle@usnode dbs]$ cd /l3logs/dba/log
[oracle@usnode rman]$ cd PRODQA
[oracle@usnode PRODQA]$ ls -ltr
total 1536
-rw-r--r-- 1 oracle dba  6322 Feb 12 13:33 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-12_13h33_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 12 19:32 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-12_19h32_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 13 00:27 rman_backup_log.10470.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 13 00:27 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-13_00h27_S.log
-rw-r--r-- 1 oracle dba  7734 Feb 13 01:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-13_01h17_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 13 07:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-13_07h02_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 13 07:59 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-13_07h59_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 13 13:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-13_13h02_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 13 19:03 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-13_19h03_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 14 00:24 rman_backup_log.30328.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 14 00:24 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-14_00h24_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 14 01:03 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-14_01h03_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 14 07:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-14_07h17_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 14 08:06 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-14_08h06_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 14 13:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-14_13h17_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 14 19:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-14_19h17_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 15 00:27 rman_backup_log.27534.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 15 00:27 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-15_00h27_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 15 01:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-15_01h19_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 15 07:15 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-15_07h15_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 15 07:59 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-15_07h59_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 15 13:24 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-15_13h24_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 15 19:16 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-15_19h16_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 16 00:22 rman_backup_log.6680.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 16 00:22 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-16_00h22_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 16 01:21 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-16_01h21_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 16 07:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-16_07h19_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 16 08:13 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-16_08h13_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 16 13:22 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-16_13h22_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 16 19:18 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-16_19h18_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 17 00:25 rman_backup_log.14618.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 17 00:25 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-17_00h25_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 17 01:20 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-17_01h20_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 17 07:03 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-17_07h03_S.log
-rw-r--r-- 1 oracle dba 12987 Feb 17 07:42 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-17_07h42_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 17 13:01 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-17_13h01_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 17 19:01 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-17_19h01_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 18 00:47 rman_backup_log.9553.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 18 00:47 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-18_00h47_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 18 01:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-18_01h02_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 18 07:27 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-18_07h27_S.log
-rw-r--r-- 1 oracle dba 12646 Feb 18 09:33 gis_rman_backup_PRODQA_db_full_tape_hot_2016-02-18_09h33_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 18 13:30 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-18_13h30_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 18 19:37 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-18_19h37_S.log
-rw-r--r-- 1 oracle dba 34395 Feb 19 00:22 rman_backup_log.10913.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 19 00:22 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-19_00h22_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 19 01:36 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-19_01h36_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 19 07:16 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-19_07h16_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 19 08:10 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-19_08h10_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 19 13:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-19_13h19_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 19 19:27 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-19_19h27_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 20 00:24 rman_backup_log.4779.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 20 00:24 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-20_00h24_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 20 01:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-20_01h17_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 20 07:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-20_07h02_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 20 08:04 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-20_08h04_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 20 13:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-20_13h02_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 20 19:13 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-20_19h13_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 21 00:27 rman_backup_log.23512.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 21 00:27 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-21_00h27_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 21 01:03 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-21_01h03_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 21 07:16 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-21_07h16_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 21 07:56 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-21_07h56_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 21 13:15 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-21_13h15_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 21 19:15 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-21_19h15_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 22 00:25 rman_backup_log.27842.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 22 00:25 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-22_00h25_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 22 01:15 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-22_01h15_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 22 07:21 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-22_07h21_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 22 08:08 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-22_08h08_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 22 13:31 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-22_13h31_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 22 19:32 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-22_19h32_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 23 00:26 rman_backup_log.21504.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 23 00:26 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-23_00h26_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 23 01:24 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-23_01h24_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 23 07:20 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-23_07h20_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 23 08:12 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-23_08h12_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 23 13:28 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-23_13h28_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 23 19:28 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-23_19h28_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 24 00:27 rman_backup_log.14649.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 24 00:27 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-24_00h27_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 24 01:20 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-24_01h20_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 24 07:16 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-24_07h16_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 24 08:10 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-24_08h10_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 24 13:22 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-24_13h22_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 24 19:24 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-24_19h24_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 25 00:33 rman_backup_log.6761.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 25 00:33 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-25_00h33_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 25 01:22 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-25_01h22_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 25 07:05 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-25_07h05_S.log
-rw-r--r-- 1 oracle dba   706 Feb 25 07:48 gis_rman_backup_PRODQA_db_full_tape_hot_2016-02-25_07h48_F.err
-rw-r--r-- 1 oracle dba 13493 Feb 25 07:48 gis_rman_backup_PRODQA_db_full_tape_hot_2016-02-25_07h48_F.log
-rw-r--r-- 1 oracle dba 12646 Feb 25 09:45 gis_rman_backup_PRODQA_db_full_tape_hot_2016-02-25_09h45_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 25 13:01 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-25_13h01_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 25 19:01 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-25_19h01_S.log
-rw-r--r-- 1 oracle dba 38105 Feb 26 00:22 rman_backup_log.8493.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 26 00:22 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-26_00h22_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 26 01:01 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-26_01h01_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 26 07:15 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-26_07h15_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 26 08:15 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-26_08h15_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 26 13:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-26_13h19_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 26 19:16 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-26_19h16_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 27 00:27 rman_backup_log.28707.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 27 00:27 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-27_00h27_S.log
-rw-r--r-- 1 oracle dba  6996 Feb 27 01:16 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-27_01h16_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 27 07:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-27_07h19_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 27 08:37 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-27_08h37_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 27 13:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-27_13h19_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 27 19:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-27_19h19_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 28 00:29 rman_backup_log.23795.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 28 00:29 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-28_00h29_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 28 01:19 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-28_01h19_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 28 07:18 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-28_07h18_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 28 07:57 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-28_07h57_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 28 13:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-28_13h17_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 28 19:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-28_19h17_S.log
-rw-r--r-- 1 oracle dba  3434 Feb 29 00:25 rman_backup_log.3252.lst.rman
-rw-r--r-- 1 oracle dba  2020 Feb 29 00:25 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-02-29_00h25_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 29 01:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-29_01h17_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 29 07:17 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-29_07h17_S.log
-rw-r--r-- 1 oracle dba 12539 Feb 29 08:00 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-02-29_08h00_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 29 13:22 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-29_13h22_S.log
-rw-r--r-- 1 oracle dba  6322 Feb 29 19:33 gis_rman_backup_PRODQA_arch_tape_hot_2016-02-29_19h33_S.log
-rw-r--r-- 1 oracle dba  3432 Mar  1 00:25 rman_backup_log.17443.lst.rman
-rw-r--r-- 1 oracle dba  2020 Mar  1 00:25 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-03-01_00h25_S.log
-rw-r--r-- 1 oracle dba  6994 Mar  1 01:18 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-01_01h18_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  1 07:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-01_07h02_S.log
-rw-r--r-- 1 oracle dba 12537 Mar  1 09:36 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-01_09h36_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  1 13:14 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-01_13h14_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  1 19:14 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-01_19h14_S.log
-rw-r--r-- 1 oracle dba  3432 Mar  2 00:30 rman_backup_log.15909.lst.rman
-rw-r--r-- 1 oracle dba  2020 Mar  2 00:30 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-03-02_00h30_S.log
-rw-r--r-- 1 oracle dba  7732 Mar  2 01:25 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-02_01h25_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  2 07:03 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-02_07h03_S.log
-rw-r--r-- 1 oracle dba 12985 Mar  2 07:40 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-02_07h40_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  2 13:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-02_13h02_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  2 19:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-02_19h02_S.log
-rw-r--r-- 1 oracle dba  3432 Mar  3 00:29 rman_backup_log.19701.lst.rman
-rw-r--r-- 1 oracle dba  2020 Mar  3 00:29 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-03-03_00h29_S.log
-rw-r--r-- 1 oracle dba  6994 Mar  3 01:03 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-03_01h03_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  3 07:13 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-03_07h13_S.log
-rw-r--r-- 1 oracle dba 12644 Mar  3 08:17 gis_rman_backup_PRODQA_db_full_tape_hot_2016-03-03_08h17_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  3 13:18 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-03_13h18_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  3 19:14 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-03_19h14_S.log
-rw-r--r-- 1 oracle dba 34758 Mar  4 00:33 rman_backup_log.6266.lst.rman
-rw-r--r-- 1 oracle dba  2020 Mar  4 00:33 gis_rman_backup_PRODQA_delete_obsolete__tape__2016-03-04_00h33_S.log
-rw-r--r-- 1 oracle dba  6994 Mar  4 01:14 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-04_01h14_S.log
-rw-r--r-- 1 oracle dba  1508 Mar  4 07:01 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-04_07h01_S.log
-rw-r--r-- 1 oracle dba 12537 Mar  4 07:44 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-04_07h44_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  4 13:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-04_13h02_S.log
-rw-r--r-- 1 oracle dba  6320 Mar  4 19:02 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-04_19h02_S.log
-rw-r--r-- 1 oracle dba  6994 Mar  5 01:34 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-05_01h34_S.log
-rw-r--r-- 1 oracle dba  1528 Mar  5 07:15 gis_rman_backup_PRODQA_arch_tape_hot_2016-03-05_07h15_S.log
-rw-r--r-- 1 oracle dba   745 Mar  5 07:23 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-05_07h23_F.err
-rw-r--r-- 1 oracle dba  7242 Mar  5 07:23 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-05_07h23_F.log
-rw-r--r-- 1 oracle dba   814 Mar  5 09:10 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-05_09h10_F.err
-rw-r--r-- 1 oracle dba 11837 Mar  5 09:10 gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-05_09h10_F.log
[oracle@usnode PRODQA]$ vi gis_rman_backup_PRODQA_db_incr_tape_hot_2016-03-05_09h10_F.log
[oracle@usnode PRODQA]$ vi gis_rman_backup_PRODQA_arch_tape_hot_2016-03-05_07h15_S.log
[oracle@usnode PRODQA]$ cat gis_rman_backup_PRODQA_db_full_tape_hot_2016-03-03_08h17_S.log
Thu Mar  3 07:29:25 EST 2016 || # ==========================================================================
Thu Mar  3 07:29:25 EST 2016 || # Script   : gis_rman_backup.sh SID=PRODQA operation=db method=hot medium=tape level=full force=yes
Thu Mar  3 07:29:25 EST 2016 || # Version  :  1.71
Thu Mar  3 07:29:25 EST 2016 || # Host     : usnode.com
Thu Mar  3 07:29:25 EST 2016 || # Time     : 2016/03/03, 07:29
Thu Mar  3 07:29:25 EST 2016 || # ==========================================================================
Thu Mar  3 07:29:25 EST 2016 || OK       [Configuration] Database found in oratab file
Thu Mar  3 07:29:25 EST 2016 || info     [Operation] DB backup requested.
Thu Mar  3 07:29:25 EST 2016 || info     [Operation] Full backup requested.
Thu Mar  3 07:29:25 EST 2016 || info     [Method] Hot backup requested.
Thu Mar  3 07:29:25 EST 2016 || OK       [Method] DB is running.
Thu Mar  3 07:29:25 EST 2016 || OK       [Method] DB is in archive log mode.
Thu Mar  3 07:29:25 EST 2016 || OK       [Check User] oracle detected.
Thu Mar  3 07:29:26 EST 2016 || info     [Config File] Using default configuration file.
Thu Mar  3 07:29:26 EST 2016 || OK       [Conf File Dir] Default Configuration file directory exists.
Thu Mar  3 07:29:26 EST 2016 || OK       [Config File] Default configuration file exists : /opt/oracle/admin/PRODQA/pfile/.rman.conf.
Thu Mar  3 07:29:26 EST 2016 || OK       [Validate Conf File] Configuration file is in same version than template.
Thu Mar  3 07:29:26 EST 2016 || OK       [NBU Policy] Found P-A11-BE-ORAL-INCR NBU Policy for database PRODQA incrementals db backups.
Thu Mar  3 07:29:26 EST 2016 || info     [RMAN Commands] Generating RMAN commands file.
Thu Mar  3 07:29:26 EST 2016 || info     [Generate Channels] Generating channel for db backups.
connected to target database: PRODQA (DBID=4277918464)

RMAN> RUN {
2> ALLOCATE CHANNEL t0 TYPE 'SBT_TAPE' PARMS='BLKSIZE=1048576,ENV=(NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
3> ALLOCATE CHANNEL t1 TYPE 'SBT_TAPE' PARMS='BLKSIZE=1048576,ENV=(NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
4> ALLOCATE CHANNEL t2 TYPE 'SBT_TAPE' PARMS='BLKSIZE=1048576,ENV=(NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
5> ALLOCATE CHANNEL t3 TYPE 'SBT_TAPE' PARMS='BLKSIZE=1048576,ENV=(NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
6> ALLOCATE CHANNEL t4 TYPE 'SBT_TAPE' PARMS='BLKSIZE=1048576,ENV=(NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
7> ALLOCATE CHANNEL t5 TYPE 'SBT_TAPE' PARMS='BLKSIZE=1048576,ENV=(NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
8> setlimit channel t0 maxopenfiles 1;
9> setlimit channel t1 maxopenfiles 1;
10> setlimit channel t2 maxopenfiles 1;
11> setlimit channel t3 maxopenfiles 1;
12> setlimit channel t4 maxopenfiles 1;
13> setlimit channel t5 maxopenfiles 1;
14> delete NOPROMPT ARCHIVELOG ALL BACKED UP 1 times to SBT_TAPE ;
15> BACKUP
16> INCREMENTAL LEVEL=0
17> format 'dblevel0_%d.%s_%p_%t'
18> filesperset=10
19> TAG=db_hot_full_20160303072926
20> DATABASE INCLUDE CURRENT CONTROLFILE SPFILE plus ARCHIVELOG ;
21> delete NOPROMPT ARCHIVELOG ALL BACKED UP 1 times to SBT_TAPE ;
22> }
23>
using target database control file instead of recovery catalog
allocated channel: t0
channel t0: SID=481 device type=SBT_TAPE
channel t0: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t1
channel t1: SID=511 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t2
channel t2: SID=526 device type=SBT_TAPE
channel t2: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t3
channel t3: SID=541 device type=SBT_TAPE
channel t3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t4
channel t4: SID=556 device type=SBT_TAPE
channel t4: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t5
channel t5: SID=571 device type=SBT_TAPE
channel t5: Veritas NetBackup for Oracle - Release 7.0 (2010070800)







specification does not match any archived log in the repository


Starting backup at 2016/03/03 07:29:31
current log archived
channel t0: starting archived log backup set
channel t0: specifying archived log(s) in backup set
input archived log thread=1 sequence=1971 RECID=1971 STAMP=905498971
channel t0: starting piece 1 at 2016/03/03 07:29:32
channel t0: finished piece 1 at 2016/03/03 07:35:17
piece handle=dblevel0_PRODQA.4036_1_905498971 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t0: backup set complete, elapsed time: 00:05:45
Finished backup at 2016/03/03 07:35:17

Starting backup at 2016/03/03 07:35:17
channel t0: starting incremental level 0 datafile backup set
channel t0: specifying datafile(s) in backup set
input datafile file number=00018 name=/oradata3/PRODQA/pvwdocs06.dbf
input datafile file number=00009 name=/oradata3/PRODQA/pvwx02.dbf
input datafile file number=00016 name=/oradata3/PRODQA/pvwdocs05.dbf
input datafile file number=00001 name=/oradata3/PRODQA/system01.dbf
channel t0: starting piece 1 at 2016/03/03 07:35:18
channel t1: starting incremental level 0 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00007 name=/oradata3/PRODQA/pvwdocs01.dbf
input datafile file number=00010 name=/oradata3/PRODQA/undotbs02.dbf
input datafile file number=00002 name=/oradata3/PRODQA/sysaux01.dbf
input datafile file number=00017 name=/oradata3/PRODQA/pvwx03.dbf
channel t1: starting piece 1 at 2016/03/03 07:35:18
channel t2: starting incremental level 0 datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00008 name=/oradata3/PRODQA/pvwd02.dbf
input datafile file number=00019 name=/oradata3/PRODQA/pvwd04.dbf
input datafile file number=00012 name=/oradata3/PRODQA/pvwdocs03.dbf
input datafile file number=00004 name=/oradata3/PRODQA/users01.dbf
channel t2: starting piece 1 at 2016/03/03 07:35:18
channel t3: starting incremental level 0 datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00005 name=/oradata3/PRODQA/pvwd01.dbf
input datafile file number=00003 name=/oradata3/PRODQA/undotbs01.dbf
input datafile file number=00013 name=/oradata3/PRODQA/pvwd03.dbf
input datafile file number=00020 name=/oradata3/PRODQA/pvwd05.dbf
channel t3: starting piece 1 at 2016/03/03 07:35:18
channel t4: starting incremental level 0 datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00011 name=/oradata3/PRODQA/pvwdocs02.dbf
input datafile file number=00006 name=/oradata3/PRODQA/pvwx01.dbf
input datafile file number=00015 name=/oradata3/PRODQA/pvwdocs04.dbf
input datafile file number=00014 name=/oradata3/PRODQA/ignited01.dbf
channel t4: starting piece 1 at 2016/03/03 07:35:18
channel t5: starting incremental level 0 datafile backup set
channel t5: specifying datafile(s) in backup set
including current control file in backup set
channel t5: starting piece 1 at 2016/03/03 07:35:19
channel t5: finished piece 1 at 2016/03/03 07:37:04
piece handle=dblevel0_PRODQA.4042_1_905499318 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t5: backup set complete, elapsed time: 00:01:45
channel t5: starting incremental level 0 datafile backup set
channel t5: specifying datafile(s) in backup set
including current SPFILE in backup set
channel t5: starting piece 1 at 2016/03/03 07:37:05
channel t5: finished piece 1 at 2016/03/03 07:37:50
piece handle=dblevel0_PRODQA.4043_1_905499425 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t5: backup set complete, elapsed time: 00:00:45
channel t5: starting incremental level 0 datafile backup set
channel t5: specifying datafile(s) in backup set
including current SPFILE in backup set
channel t5: starting piece 1 at 2016/03/03 07:37:50
channel t5: finished piece 1 at 2016/03/03 07:38:35
piece handle=dblevel0_PRODQA.4044_1_905499470 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t5: backup set complete, elapsed time: 00:00:45
channel t1: finished piece 1 at 2016/03/03 08:13:56
piece handle=dblevel0_PRODQA.4038_1_905499318 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t1: backup set complete, elapsed time: 00:38:38
channel t0: finished piece 1 at 2016/03/03 08:15:46
piece handle=dblevel0_PRODQA.4037_1_905499317 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t0: backup set complete, elapsed time: 00:40:28
channel t2: finished piece 1 at 2016/03/03 08:15:46
piece handle=dblevel0_PRODQA.4039_1_905499318 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t2: backup set complete, elapsed time: 00:40:28
channel t4: finished piece 1 at 2016/03/03 08:16:26
piece handle=dblevel0_PRODQA.4041_1_905499318 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t4: backup set complete, elapsed time: 00:41:08
channel t3: finished piece 1 at 2016/03/03 08:16:46
piece handle=dblevel0_PRODQA.4040_1_905499318 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t3: backup set complete, elapsed time: 00:41:28
Finished backup at 2016/03/03 08:16:46

Starting backup at 2016/03/03 08:16:46
current log archived
channel t0: starting archived log backup set
channel t0: specifying archived log(s) in backup set
input archived log thread=1 sequence=1972 RECID=1972 STAMP=905501806
channel t0: starting piece 1 at 2016/03/03 08:16:47
channel t0: finished piece 1 at 2016/03/03 08:17:32
piece handle=dblevel0_PRODQA.4045_1_905501807 tag=DB_HOT_FULL_20160303072926 comment=API Version 2.0,MMS Version 5.0.0.0
channel t0: backup set complete, elapsed time: 00:00:45
Finished backup at 2016/03/03 08:17:32

deleted archived log
archived log file name=/oraarc1/PRODQA/PRODQA_1_1971_882266836.arc RECID=1971 STAMP=905498971
deleted archived log
archived log file name=/oraarc1/PRODQA/PRODQA_1_1972_882266836.arc RECID=1972 STAMP=905501806
Deleted 2 objects

released channel: t0
released channel: t1
released channel: t2
released channel: t3
released channel: t4
released channel: t5

Recovery Manager complete.
Thu Mar  3 08:17:33 EST 2016 || OK       [Run RMAN] Backup ended successfully.
Thu Mar  3 08:17:33 EST 2016 || info     [Catalog] Synchro requested.

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Mar 3 08:17:33 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRODQA (DBID=4277918464)
connected to recovery catalog database

RMAN>
starting full resync of recovery catalog
full resync complete

RMAN>

Recovery Manager complete.
Thu Mar  3 08:17:39 EST 2016 || OK       [Catalog] Synchro ended successfully.
Thu Mar  3 08:17:39 EST 2016 || ########## gis_rman_backup.sh ending on host usnode.com ##########
Thu Mar  3 08:17:39 EST 2016 || info     [Log File] Purging log files older than retention duration : 21 days.
Thu Mar  3 08:17:39 EST 2016 || info     [Log File] Log file has been saved to : /l3logs/dba/log/rman/PRODQA/gis_rman_backup_PRODQA_db_full_tape_hot_2016-03-03_08h17_S.log

[oracle@usnode dbs]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 09:57:48 2016

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 2.1379E+10 bytes
Fixed Size                  2213136 bytes
Variable Size            1.6911E+10 bytes
Database Buffers         4294967296 bytes
Redo Buffers              170340352 bytes
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


[oracle@usnode dbs]$ rman target sys/passwd@PRODQA catalog rmant_11g/rmand@RMANCATAMER

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 5 10:02:50 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRODQA (not mounted)
connected to recovery catalog database

RMAN> set DBID=4277918464;

executing command: SET DBID
database name is "PRODQA" and DBID is 4277918464

RMAN> list incarnation ;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
924780  924781  O2T10157 32879496         CURRENT 1          01-JUN-13
627601  627602  DSSDT5   78033211         CURRENT 1          15-AUG-14
33129712 33129729 PACKAGES 94101523         PARENT  1          01-FEB-09
33129712 33129730 PACKAGES 94101523         PARENT  10604770687892 10-JUN-11
33129712 33129713 PACKAGES 94101523         CURRENT 11712472070804 10-SEP-15
230393  230394  O1S15022 95012584         CURRENT 1          01-AUG-13
31887463 31888160 O2Z10346 96953371         PARENT  972274     18-OCT-11
31887463 31887464 O2Z10346 96953371         CURRENT 14427571602592 31-JUL-15
31386075 31386076 O1D22242 125871947        CURRENT 1          22-JUN-15
43495093 43495094 O3T11684 144995676        CURRENT 1          04-NOV-15
490748  490749  O2S15110 176857073        CURRENT 1          16-SEP-14
876626  876643  O1T11118 214425957        PARENT  1          25-NOV-11
876626  876627  O1T11118 214425957        CURRENT 11710048840378 07-APR-13
28147979 28147980 O1S21470 233643793        CURRENT 1          12-APR-15
99742   100859  CSMERV   235976268        PARENT  945184     07-DEC-10
99742   100860  CSMERV   235976268        PARENT  977120     07-DEC-10
99742   100861  CSMERV   235976268        PARENT  996264     07-DEC-10
99742   99743   CSMERV   235976268        CURRENT 397791534  19-SEP-13
537708  538138  CCSBL81S 255682416        PARENT  13362524485997 27-MAR-14
537708  537709  CCSBL81S 255682416        CURRENT 13362524486001 27-MAR-14
216622  216623  ESFSDV4  286322713        CURRENT 1          19-NOV-13
34229357 34230077 O5T10346 295908420        PARENT  14436291493266 05-OCT-15
34229357 34229358 O5T10346 295908420        CURRENT 14436293238744 08-OCT-15
32757666 32757667 PACKAGES 304974383        CURRENT 1          24-AUG-15
29136910 29136911 O1T21500 330246511        CURRENT 1          06-MAY-15
28319098 28319111 O1T20653 355711651        PARENT  1          24-AUG-13
28319098 28319099 O1T20653 355711651        CURRENT 925702     17-APR-15
1124060 1124061 O3S20103 377738533        CURRENT 1          09-FEB-15
30249861 30249862 O1S20712 383435490        CURRENT 1          16-JUN-15
29563403 29563420 O3S10405 391644101        PARENT  1          05-SEP-10
29563403 29563404 O3S10405 391644101        CURRENT 972274     26-MAY-15
8954425 8954610 TRWSDD6  402573773        PARENT  1          11-NOV-10
8954425 8954427 TRWSDD6  402573773        CURRENT 13963649712837 22-OCT-14
1344405 1344406 O1T2001  433186849        CURRENT 1          08-SEP-14
187372  187393  O1S17451 487673546        PARENT  1          21-OCT-11
187372  187373  O1S17451 487673546        CURRENT 895207     15-APR-14
935098  935116  TIDALQ   510294350        PARENT  1          11-SEP-08
935098  935117  TIDALQ   510294350        PARENT  880332     13-OCT-09
935098  935099  TIDALQ   510294350        CURRENT 1793359    21-OCT-09
665486  665487  O4Z18526 533822723        CURRENT 1          31-OCT-14
201600862 201600978 PVW4TST  541399504        PARENT  13560730527891 27-JUN-14
201600862 201600864 PVW4TST  541399504        CURRENT 14456002232755 15-FEB-16
27389746 27389820 O4Z18526 545606740        PARENT  14111908518802 11-MAR-15
27389746 27389747 O4Z18526 545606740        CURRENT 14111908624574 12-MAR-15
932405  932447  PVW4TST  575815501        PARENT  9847523032241 09-DEC-10
932405  932406  PVW4TST  575815501        CURRENT 13331367487901 06-FEB-14
303017  303018  O1Z13606 599927524        CURRENT 1          22-APR-13
7660100 7660566 BGZCPI   615224971        PARENT  5965203456458 21-NOV-10
7660100 7660103 BGZCPI   615224971        CURRENT 5966154702715 20-FEB-13
28950370 28950371 O1T20709 648270962        CURRENT 1          27-APR-15
29248489 29248490 IQTST05  652303236        CURRENT 1          17-APR-15
30742273 30742274 O1Z22297 656406358        CURRENT 1          03-JUL-15
8807770 8807857 TRWSBX1  670218555        PARENT  13900025933717 01-OCT-14
8807770 8807771 TRWSBX1  670218555        CURRENT 14111899322817 16-FEB-15
29247   29248   O1T10144 672501916        PARENT  1          05-MAY-11
29247   80029993 O1T10144 672501916        CURRENT 14441743491223 01-DEC-15
508346  508347  O1S17871 732880178        CURRENT 1          11-APR-14
495022  495023  O1S17855 733001162        CURRENT 1          12-APR-14
29653050 29653051 IQTST02  735095953        CURRENT 1          17-APR-15
30289623 30289624 O1S20709 771728657        CURRENT 1          16-JUN-15
29335787 29335788 IQTST03  773853498        CURRENT 1          17-APR-15
488430  488431  O1Z11743 836206792        CURRENT 1          15-JAN-14
28507596 28507597 IQTST01  851116540        CURRENT 1          16-APR-15
30996238 30996239 ESAMPLS  875019429        CURRENT 1          16-JUN-15
1344129 1344130 O1T20422 886417179        CURRENT 1          11-FEB-15
34290174 34290175 O2Z23809 895860978        CURRENT 1          18-SEP-15
1437823 1437824 CRTGDATA 916239452        CURRENT 1          10-DEC-13
29731564 29731565 O1S20653 929266199        CURRENT 1          03-JUN-15
34215494 34215943 O3T10346 949784792        PARENT  13513276   01-DEC-11
34215494 34215495 O3T10346 949784792        CURRENT 14436539391743 06-OCT-15
30525936 30525937 IQTRAC3  950944031        CURRENT 1          03-JUN-15
82930   82931   ORT1003  958427573        CURRENT 1          08-JAN-15
137455  137456  O1S14898 995604162        CURRENT 1          30-JUL-13
24710119 24710120 PLWQA    996759281        CURRENT 1          25-FEB-15
1263168 1263169 O1T19675 1015356806       PARENT  1          09-FEB-15
1263168 35044612 O1T19675 1015356806       CURRENT 14436797837902 13-OCT-15
307089  307090  O2T13606 1022970702       CURRENT 1          21-APR-13
31690469 31690945 CCSBL81Q 1028903211       PARENT  13362524486001 27-MAR-14
31690469 31690470 CCSBL81Q 1028903211       CURRENT 14427936567145 29-JUL-15
38889877 38889915 MAMD     1029804179       PARENT  1046792    15-JUL-10
38889877 38889916 MAMD     1029804179       PARENT  2338556    06-AUG-10
38889877 38889878 MAMD     1029804179       CURRENT 14438606958190 25-OCT-15
8809450 8809535 TRWSBX2  1051774666       PARENT  13900025933717 01-OCT-14
8809450 8809451 TRWSBX2  1051774666       CURRENT 14111898861798 16-FEB-15
38890837 38890856 JOURNALD 1083141305       PARENT  1          18-JUN-08
38890837 38890857 JOURNALD 1083141305       PARENT  10688204641912 23-JAN-13
38890837 38890838 JOURNALD 1083141305       CURRENT 14438607387879 25-OCT-15
28484370 28484371 TSIB     1120605523       CURRENT 1          20-APR-15
31971215 31971216 PLAT06V  1124637338       CURRENT 1          06-AUG-15
27533133 27533134 O5D20103 1142200815       CURRENT 1          17-MAR-15
791180  791181  O1S13172 1144496318       CURRENT 1          02-JUL-13
33742251 33742252 O1T23203 1203370117       CURRENT 1          26-SEP-15
320550  320618  VSHSDV5  1211113992       PARENT  1          04-JUN-10
320550  320619  VSHSDV5  1211113992       ORPHAN  13040025486327 14-NOV-13
320550  320551  VSHSDV5  1211113992       CURRENT 13070992482398 28-NOV-13
34216607 34217327 O5T10346 1216059324       PARENT  972274     18-OCT-11
34216607 34216608 O5T10346 1216059324       CURRENT 14436291493266 05-OCT-15
1413078 1413079 O1T00003 1222170467       CURRENT 1          02-FEB-12
34147520 34147521 O1T23216 1232041468       CURRENT 1          06-OCT-15
117675566 117675568 O1T23216 1235724849       CURRENT 1          18-NOV-15
60903   60904   O2S11583 1246986298       CURRENT 1          18-AUG-14
104960740 104960741 O2T23216 1257143095       CURRENT 1          15-DEC-15
28673744 28673873 CCSBL81T 1269762859       PARENT  12129411447048 19-SEP-13
28673744 28673745 CCSBL81T 1269762859       CURRENT 14378588399061 28-APR-15
884234  884235  O1T11134 1277823396       CURRENT 1          07-DEC-11
568112  568465  CCSBLS1  1312375796       PARENT  1          08-JUN-07
568112  568113  CCSBLS1  1312375796       CURRENT 13362244300676 24-MAR-14
672890  673172  O2S10346 1342878047       PARENT  1          05-SEP-10
672890  672891  O2S10346 1342878047       CURRENT 972274     10-AUG-11
67816718 67816739 CCISS    1405728558       PARENT  2338556    06-AUG-10
67816718 67816740 CCISS    1405728558       PARENT  10523466615137 19-NOV-10
67816718 67816719 CCISS    1405728558       CURRENT 14441922395081 23-NOV-15
33467899 33467900 O1T17392 1437675710       CURRENT 1          17-NOV-14
67722   67723   O1Z16184 1443105744       CURRENT 1          21-MAY-14
213672850 213672852 MIRSTG   1473548711       CURRENT 1          06-FEB-16
28175763 28175764 O1Z21597 1507505773       CURRENT 1          11-APR-15
959878  959879  AIMSQA   1509067818       CURRENT 1          27-OCT-14
32417466 32417467 PVXTEST  1518877358       CURRENT 1          20-AUG-15
692169  692188  O6S10346 1523861314       PARENT  1          05-SEP-10
692169  692170  O6S10346 1523861314       CURRENT 972274     23-MAY-12
31888928 31888947 O1Z10346 1531716854       PARENT  1          24-AUG-13
31888928 31888929 O1Z10346 1531716854       CURRENT 925702     02-AUG-15
1410251 1410252 O11G0002 1563912942       CURRENT 1          19-JAN-13
1252940 1252941 O3T10085 1642611717       CURRENT 1          31-MAY-14
31627305 31627407 O2T10489 1653441701       PARENT  14419261928984 06-JUL-15
31627305 31627306 O2T10489 1653441701       CURRENT 14426439352071 16-JUL-15
891518  891519  O1Z11466 1687438737       CURRENT 1          27-FEB-12
30968086 30968087 HCPCREQ  1716218038       CURRENT 1          15-JUN-15
33216012 33216013 O1T21959 1746943445       CURRENT 1          12-SEP-15
314263  314392  CCSBL81D 1835314019       PARENT  11717103248043 05-AUG-13
314263  314393  CCSBL81D 1835314019       PARENT  12129332499108 03-SEP-13
314263  314264  CCSBL81D 1835314019       CURRENT 12129411447048 19-SEP-13
29279202 29279613 O5S10346 1880198898       PARENT  13513276   01-DEC-11
29279202 29279203 O5S10346 1880198898       CURRENT 14408082769285 20-MAY-15
32082552 32082553 O3Z10085 1881597733       CURRENT 1          07-AUG-15
1340882 1340883 O1Z19675 1940805240       PARENT  1          11-FEB-15
1340882 33017695 O1Z19675 1940805240       CURRENT 14432177141020 07-SEP-15
1340882 33015176 O1Z19675 1940805240       ORPHAN  14432180506336 07-SEP-15
310696  310697  O2Z13606 1948261354       CURRENT 1          22-APR-13
32333252 32333253 O1T22923 1986609818       CURRENT 1          15-AUG-15
191857175 191857177 O3Z23809 2014801368       CURRENT 1          31-JAN-16
61210506 61210507 FDMSTG   2017933827       CURRENT 1          21-NOV-15
188699540 188699542 TTSST    2042805058       CURRENT 1          16-JAN-16
946172  946173  CRTRESDB 2047096669       CURRENT 1          13-DEC-13
34115165 34115166 PATHQA   2053751494       CURRENT 1          05-OCT-15
28809205 28809222 ESCHATS  2153872893       PARENT  945184     09-JUN-10
28809205 28809223 ESCHATS  2153872893       PARENT  1015038    09-JUN-10
28809205 28809206 ESCHATS  2153872893       CURRENT 14247255253675 04-MAY-15
32389792 32389793 O1T23173 2184403639       CURRENT 1          20-AUG-15
582726  582727  O1Z19835 2198218023       CURRENT 1          03-NOV-14
32333720 32333721 O1S22923 2204879783       CURRENT 1          15-AUG-15
83173   83174   ORT10002 2209107096       CURRENT 1          24-SEP-14
67936679 67936696 MAMS1    2240277493       PARENT  1          15-AUG-09
67936679 67936697 MAMS1    2240277493       PARENT  945184     29-SEP-10
67936679 67936680 MAMS1    2240277493       CURRENT 14441767045481 24-NOV-15
210558  210572  O1Z15732 2241984279       PARENT  1          29-NOV-11
210558  210559  O1Z15732 2241984279       CURRENT 97776867   04-NOV-13
649236  649305  O2Z18526 2256937437       PARENT  1          21-FEB-14
649236  649237  O2Z18526 2256937437       CURRENT 13502601371331 16-JUL-14
34222072 34222073 O1Z23809 2271152475       CURRENT 1          18-SEP-15
33173075 33173106 PLAT06R  2285253466       PARENT  1          17-SEP-11
33173075 33173107 PLAT06R  2285253466       PARENT  995548     08-NOV-13
33173075 33173076 PLAT06R  2285253466       CURRENT 876171554  10-SEP-15
188698356 188698357 DSHSTG   2287614913       CURRENT 1          15-JAN-16
33371847 33371848 O1T23072 2291886362       CURRENT 1          16-SEP-15
30478725 30478726 HCPPORTS 2302578244       CURRENT 1          16-JUN-15
31888818 31888834 O4Z10346 2311498375       PARENT  1          24-AUG-13
31888818 31888819 O4Z10346 2311498375       CURRENT 925702     03-AUG-15
874090  874091  O1S11118 2505814033       CURRENT 1          11-NOV-12
31889732 31890183 O3Z10346 2571449471       PARENT  13513276   01-DEC-11
31889732 31889733 O3Z10346 2571449471       CURRENT 14427658804984 31-JUL-15
38890408 38890425 CCISD1   2597225913       PARENT  1          10-FEB-11
38890408 38890409 CCISD1   2597225913       CURRENT 14438606944395 25-OCT-15
38895413 38895535 RMDAD1   2601577404       PARENT  1          06-JAN-10
38895413 38895536 RMDAD1   2601577404       PARENT  10688120625685 23-JAN-13
38895413 38895414 RMDAD1   2601577404       CURRENT 14438607112790 24-OCT-15
213327  213328  O2T11743 2668275750       CURRENT 1          01-MAY-12
630158  630159  O1Z18526 2677241982       CURRENT 1          08-JUL-14
76919639 76919642 O1Z21786 2681581942       CURRENT 1          06-JUL-15
164454  164455  O1S11903 2693901588       CURRENT 1          28-MAY-12
1       2       AIMSTRN  2703725083       CURRENT 1          27-AUG-14
30169537 30169538 O1Z20653 2706666055       CURRENT 1          16-JUN-15
73282   73301   AIMSTRN  2716569932       PARENT  1          27-OCT-14
73282   73283   AIMSTRN  2716569932       CURRENT 14111898051361 21-JAN-15
30450810 30450811 O1Z22242 2719817887       CURRENT 1          22-JUN-15
39303785 39303786 O1S23926 2724844855       CURRENT 1          13-OCT-15
29085913 29085914 O1Z21630 2742562861       CURRENT 1          12-MAY-15
34217937 34217958 O4T10346 2770109193       PARENT  972274     14-OCT-11
34217937 34217938 O4T10346 2770109193       CURRENT 14429203247694 05-OCT-15
3167    3168    O1TPAM11 2778502291       CURRENT 1          10-JUN-14
1124742 1124743 O4S20103 2815061925       CURRENT 1          09-FEB-15
187375  187376  O1T16038 2846515560       CURRENT 1          18-NOV-13
697811  697812  O1S12573 2872956859       CURRENT 1          29-AUG-13
245250  245251  O1T15237 2876169246       CURRENT 1          21-AUG-13
827328  827329  O1DQQ888 2880614994       CURRENT 1          11-SEP-14
286935  286936  O1T13622 2883033212       CURRENT 1          19-SEP-13
775745  775746  O1T11583 2891856398       CURRENT 1          21-APR-12
289914  289915  O1T14436 2909922280       CURRENT 1          18-JUN-13
907822  907839  O1S10405 2965813286       PARENT  1          05-SEP-10
907822  907823  O1S10405 2965813286       CURRENT 972274     04-AUG-14
219240  219289  O1S13534 2981720024       PARENT  1          03-APR-13
219240  219241  O1S13534 2981720024       CURRENT 34845992   07-OCT-13
191875207 191875209 O4Z23809 2988673772       CURRENT 1          04-FEB-16
33337197 33337213 O4S10405 3008331963       PARENT  1          05-SEP-10
33337197 33337198 O4S10405 3008331963       CURRENT 972274     01-SEP-15
70411   70412   O1S12977 3030417798       CURRENT 1          02-JAN-13
1215790 1215791 O1S14449 3038215944       CURRENT 1          14-JUN-13
179356  179362  O1S12472 3047904065       CURRENT 1          25-SEP-12
295207  295208  O1T15859 3052618611       CURRENT 1          15-NOV-13
574505  574526  ACESCOGS 3065015979       PARENT  1          27-AUG-13
574505  574506  ACESCOGS 3065015979       CURRENT 11712344667065 22-MAR-14
140392  140393  O2T10450 3069811714       CURRENT 1          02-AUG-11
29065625 29065626 O1T15804 3080012781       CURRENT 1          11-MAY-15
783568  783569  O1T13781 3110701364       CURRENT 1          18-MAY-13
31254535 31254566 PLAT06TU 3121445235       PARENT  1          17-SEP-11
31254535 31254567 PLAT06TU 3121445235       PARENT  995548     10-OCT-13
31254535 31254536 PLAT06TU 3121445235       CURRENT 150083012  17-JUL-15
126304  126372  O1T13723 3126088862       PARENT  1          21-OCT-11
126304  126305  O1T13723 3126088862       CURRENT 1022598    15-JUL-13
589062  589063  WHSDT5   3136034021       CURRENT 1          15-AUG-14
161345  161346  O2Z10157 3173885149       CURRENT 1          19-AUG-13
65782   65783   O2S10359 3180370856       CURRENT 1          21-JUN-11
33753776 33753894 O1T13723 3196652169       PARENT  1022598    07-JUN-13
33753776 33753777 O1T13723 3196652169       CURRENT 14435367111929 26-SEP-15
293097  293098  O1T15455 3199138582       CURRENT 1          05-SEP-13
31919969 31919970 IQTEST24 3199344259       CURRENT 1          05-AUG-15
31921408 31921409 IQTEST24 3199351054       CURRENT 1          05-AUG-15
31928755 31928756 IQTEST24 3199369215       CURRENT 1          05-AUG-15
32501015 32501016 GZTWT741 3227121102       CURRENT 1          24-JUL-15
223430  223431  O1S13925 3228331504       CURRENT 1          28-AUG-13
579349  579402  CCGENS1  3261055693       PARENT  10689275299483 28-AUG-13
579349  579350  CCGENS1  3261055693       CURRENT 10689339622676 22-MAR-14
33593846 33593847 O3S10085 3281372309       CURRENT 1          22-SEP-15
529137  529138  MIUAT    3291407628       CURRENT 1          06-AUG-14
577281  577315  CCGENS2  3299629048       PARENT  10689259976515 28-AUG-13
577281  577282  CCGENS2  3299629048       CURRENT 10689277591900 22-MAR-14
64333   64334   O1S10359 3302695989       CURRENT 1          15-JUL-11
31850661 31850662 O1Z22978 3316906201       CURRENT 1          30-JUL-15
1410116 1410131 NBUTEST  3327868552       PARENT  1          24-OCT-13
1410116 1410117 NBUTEST  3327868552       CURRENT 631464     28-OCT-13
682815  682958  O2T10346 3350549355       PARENT  1          05-SEP-10
682815  682816  O2T10346 3350549355       CURRENT 972274     21-JUN-13
184063  184064  O1T12645 3357883979       CURRENT 1          01-NOV-12
27773001 27773002 O2P10085 3360716282       CURRENT 1          24-MAR-11
1214605 1214606 O1T16184 3370085709       CURRENT 1          15-JAN-14
721679  721680  O1T15422 3393476785       CURRENT 1          18-MAY-14
256010  256011  O1T15240 3401799930       CURRENT 1          21-AUG-13
894883  894884  O1S12456 3403637863       CURRENT 1          16-OCT-12
29279751 29280445 O2T10346 3412049775       PARENT  972274     18-OCT-11
29279751 29279752 O2T10346 3412049775       CURRENT 14407993566587 20-MAY-15
28426854 28426855 QSIB     3423189083       CURRENT 1          20-APR-15
28257238 28257239 O2T19558 3426789405       CURRENT 1          15-APR-15
28275595 28275596 O2T19558 3426828573       CURRENT 1          15-APR-15
827991  827992  O1S10809 3430995809       CURRENT 1          18-OCT-11
31559033 31559066 O1T15422 3431541129       PARENT  1          24-MAY-14
31559033 31559034 O1T15422 3431541129       CURRENT 14427558832690 25-JUL-15
767511  767512  O1T11525 3431576113       CURRENT 1          20-MAR-12
886710  886711  O1T11437 3450534932       CURRENT 1          16-FEB-12
694464  694465  O1S12560 3453515170       CURRENT 1          29-AUG-13
592876  592877  O1T13925 3458403060       CURRENT 1          03-JUL-13
700883  700884  O1S18063 3484551117       CURRENT 1          10-MAY-14
210808  210811  O1T11613 3498541897       CURRENT 1          02-APR-12
941623  941624  O1S15888 3503968892       CURRENT 1          04-NOV-13
584542  584543  O2T11583 3532873610       CURRENT 1          25-JUN-14
1266219 1266220 O1Z00003 3533257179       CURRENT 1          28-OCT-11
668365  668389  O1S10346 3548721647       PARENT  1          05-SEP-10
668365  668390  O1S10346 3548721647       PARENT  972274     04-AUG-11
668365  668366  O1S10346 3548721647       CURRENT 4680746    26-AUG-11
34217863 34217892 O1T10346 3549582707       PARENT  1410360    29-SEP-11
34217863 34217864 O1T10346 3549582707       CURRENT 14429326449768 02-OCT-15
1123715 1123716 O2S20103 3565547457       CURRENT 1          09-FEB-15
687862  687878  O4S10346 3579305940       PARENT  1          05-SEP-10
687862  687863  O4S10346 3579305940       CURRENT 972274     10-AUG-11
30518755 30518756 TEST1234 3620244025       CURRENT 1          04-JUN-15
265206  265207  O2Z10085 3638577041       CURRENT 1          16-AUG-13
759393  759394  O1T11512 3646160690       CURRENT 1          08-MAR-12
830476  830477  O1S10812 3653311864       CURRENT 1          18-OCT-11
171565165 171565167 PVXQA    3694360064       CURRENT 1          27-JAN-16
222819  222820  O1Z10144 3714664362       PARENT  1          25-FEB-12
222819  80110399 O1Z10144 3714664362       CURRENT 14441743465311 01-DEC-15
656117  656118  O3Z18526 3726323284       CURRENT 1          21-OCT-14
32269416 32269417 O6S20103 3738064349       CURRENT 1          17-AUG-15
27457924 27457991 O3Z18526 3738988916       PARENT  14111908556351 13-MAR-15
27457924 27457925 O3Z18526 3738988916       CURRENT 14111908565969 13-MAR-15
742195  742196  O2T10072 3755388719       CURRENT 1          04-APR-11
115490  115491  O1T13710 3755972226       CURRENT 1          06-MAY-13
24758710 24758711 O1T19923 3776217072       CURRENT 1          26-FEB-15
937904  937905  CRIXMD1  3783705214       CURRENT 1          14-NOV-13
31699814 31699912 O1T10489 3786198916       PARENT  1          30-JAN-13
31699814 31699913 O1T10489 3786198916       PARENT  14419261928984 06-JUL-15
31699814 31699815 O1T10489 3786198916       CURRENT 14427805668473 29-JUL-15
1239294 1239459 O3S10346 3817293739       PARENT  1          05-SEP-10
1239294 1239460 O3S10346 3817293739       PARENT  972274     09-AUG-11
1239294 1239295 O3S10346 3817293739       CURRENT 4101028    26-AUG-11
33134838 33135072 O1T13710 3830778590       PARENT  1          20-JUN-13
33134838 33134839 O1T13710 3830778590       CURRENT 14431274954688 04-SEP-15
27339579 27339878 O4Z18526 3844754943       PARENT  1          01-OCT-14
27339579 27339580 O1P18526 3844754943       CURRENT 14111908518802 11-MAR-15
188694403 188694405 COG84S   3849342651       CURRENT 1          16-JAN-16
32372572 32372573 PACKAGED 3851776058       CURRENT 1          14-AUG-15
27537099 27537100 O5S20103 3925649327       CURRENT 1          17-MAR-15
282164  282165  O1T13606 3931364238       CURRENT 1          19-APR-13
871473  871474  O1S11381 3947440617       CURRENT 1          08-FEB-12
32372771 32372786 DEV      3963937113       PARENT  1          19-DEC-06
32372771 32372787 DEV      3963937113       PARENT  564488     20-JUL-15
32372771 32372772 DEV      3963937113       CURRENT 681761     23-JUL-15
263785  263786  O1T15501 3966010596       CURRENT 1          14-OCT-13
809235  809236  O2T10085 4016365444       CURRENT 1          12-APR-11
31850449 31850450 O1D22978 4020719705       CURRENT 1          30-JUL-15
215088  215089  O1T12701 4023008405       CURRENT 1          15-NOV-12
786570  786571  O1S13781 4036766145       CURRENT 1          18-MAY-13
94610   94611   O1S17392 4037538734       CURRENT 1          03-DEC-14
135687  135755  O1S13723 4045741712       PARENT  1          21-OCT-11
135687  135688  O1S13723 4045741712       CURRENT 1022598    03-MAY-13
789680  789681  O1S11583 4075341560       CURRENT 1          21-APR-12
1195698 1195699 O1S13736 4087248631       CURRENT 1          04-JUN-13
31223800 31223831 PLAT06TU 4103639597       PARENT  70138573   16-JUL-15
31223800 31223801 PLAT06TU 4103639597       CURRENT 70142108   16-JUL-15
30645340 30645458 O1S13723 4113206441       PARENT  1022598    07-JUN-13
30645340 30645341 O1S13723 4113206441       CURRENT 14411441970264 09-JUN-15
5716    5717    O2T10144 4133990364       CURRENT 1          05-MAY-11
166123  166124  O1S12469 4143987976       CURRENT 1          25-SEP-12
188696240 188696241 COGNOS8S 4145563496       CURRENT 1          15-JAN-16
166120  166121  O1S11802 4147099685       CURRENT 1          07-MAY-12
803016  803017  O1T13534 4151764515       CURRENT 1          06-APR-13
97028   97070   PRODQA   4247010533       PARENT  13560730527891 27-JUN-14
97028   97029   PRODQA   4247010533       CURRENT 13560863854610 27-JUN-14
168775595 168775596 O1S23216 4250137309       CURRENT 1          13-JAN-16
33876456 33877405 CSMERT   4251150855       PARENT  1          01-NOV-10
33876456 33876457 CSMERT   4251150855       CURRENT 185978726  25-SEP-13
203197349 203197699 O1S11802 4268334420       PARENT  1          07-MAY-12
203197349 203197351 O1S11802 4268334420       CURRENT 14455975526403 15-FEB-16
30098858 30098901 PRODQA   4277918464       PARENT  13560730527891 27-JUN-14
30098858 30098859 PRODQA   4277918464       CURRENT 14415051153279 13-JUN-15
39062619 39062620 O1D22330 4288657528       CURRENT 1          24-JUN-15

RMAN> RESET DATABASE TO INCARNATION  30098859 ;

database reset to incarnation 30098859

RMAN> list backup summary ;


List of Backups
===============
Key     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
230575966 B  0  A SBT_TAPE    03-03-2016 07:36:54 1       1       NO         DB_HOT_FULL_20160303072926
230575968 B  0  A SBT_TAPE    03-03-2016 07:38:31 1       1       NO         DB_HOT_FULL_20160303072926
230575969 B  0  A SBT_TAPE    03-03-2016 08:13:55 1       1       NO         DB_HOT_FULL_20160303072926
230575970 B  0  A SBT_TAPE    03-03-2016 08:15:39 1       1       NO         DB_HOT_FULL_20160303072926
230575971 B  0  A SBT_TAPE    03-03-2016 08:15:40 1       1       NO         DB_HOT_FULL_20160303072926
230575972 B  0  A SBT_TAPE    03-03-2016 08:16:20 1       1       NO         DB_HOT_FULL_20160303072926
230575973 B  0  A SBT_TAPE    03-03-2016 08:16:40 1       1       NO         DB_HOT_FULL_20160303072926
230575974 B  A  A SBT_TAPE    03-03-2016 08:17:27 1       1       NO         DB_HOT_FULL_20160303072926
230961203 B  A  A SBT_TAPE    03-03-2016 13:18:46 1       1       NO         ARCH_TAPE_20160303131310
231395642 B  A  A SBT_TAPE    03-03-2016 19:14:16 1       1       NO         ARCH_TAPE_20160303191301
231849090 B  A  A SBT_TAPE    04-03-2016 01:14:01 1       1       NO         ARCH_TAPE_20160304011312
231849092 B  A  A SBT_TAPE    04-03-2016 01:14:03 1       1       NO         ARCH_TAPE_20160304011312
232384522 B  A  A SBT_TAPE    04-03-2016 07:02:23 1       1       NO         DB_HOT_INCR_20160304070116
232384523 B  1  A SBT_TAPE    04-03-2016 07:04:00 1       1       NO         DB_HOT_INCR_20160304070116
232384524 B  1  A SBT_TAPE    04-03-2016 07:04:56 1       1       NO         DB_HOT_INCR_20160304070116
232384525 B  1  A SBT_TAPE    04-03-2016 07:05:42 1       1       NO         DB_HOT_INCR_20160304070116
232384526 B  1  A SBT_TAPE    04-03-2016 07:39:49 1       1       NO         DB_HOT_INCR_20160304070116
232384527 B  1  A SBT_TAPE    04-03-2016 07:42:21 1       1       NO         DB_HOT_INCR_20160304070116
232384528 B  1  A SBT_TAPE    04-03-2016 07:42:21 1       1       NO         DB_HOT_INCR_20160304070116
232384529 B  1  A SBT_TAPE    04-03-2016 07:42:29 1       1       NO         DB_HOT_INCR_20160304070116
232384530 B  1  A SBT_TAPE    04-03-2016 07:43:02 1       1       NO         DB_HOT_INCR_20160304070116
232384531 B  A  A SBT_TAPE    04-03-2016 07:44:08 1       1       NO         DB_HOT_INCR_20160304070116
232785053 B  A  A SBT_TAPE    04-03-2016 13:02:15 1       1       NO         ARCH_TAPE_20160304130105
233236495 B  A  A SBT_TAPE    04-03-2016 19:02:28 1       1       NO         ARCH_TAPE_20160304190112
233521359 B  A  A SBT_TAPE    05-03-2016 01:33:44 1       1       NO         ARCH_TAPE_20160305013103
233521360 B  A  A SBT_TAPE    05-03-2016 01:33:45 1       1       NO         ARCH_TAPE_20160305013103


RMAN>exit

Recovery Manager complete.
[oracle@usnode dbs]$ cd /oralog1/PRODQA/
[oracle@usnode PRODQA]$ ls -ltr
total 2894704
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo01a.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo02a.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo03a.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo04a.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo05a.log
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g7_m01.rdo
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g6_m01.rdo
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g2_m01.rdo
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g8_m01.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 07:36 redo_g4_m1.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 08:46 redo_g1_m1.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 08:47 redo_g2_m1.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 09:11 redo_g3_m1.rdo
[oracle@usnode PRODQA]$ rm *
[oracle@usnode PRODQA]$ cd /oralog2/PRODQA/
[oracle@usnode PRODQA]$ ls -ltr
total 2894704
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo01b.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo02b.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo03b.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo04b.log
-rw-r----- 1 oracle dba 209715712 Oct 11  2014 redo05b.log
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g7_m02.rdo
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g6_m02.rdo
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g2_m02.rdo
-rw-r----- 1 oracle dba 209715712 Jun 13  2015 redo_g8_m02.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 07:36 redo_g4_m2.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 08:46 redo_g1_m2.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 08:47 redo_g2_m2.rdo
-rw-r----- 1 oracle dba 268435968 Mar  5 09:11 redo_g3_m2.rdo
[oracle@usnode PRODQA]$ rm *

[oracle@usnode PRODQA]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 10:36:26 2016

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


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

SQL> shut

SQL>
SQL> select name from v$database ;

NAME
---------
PRODQA

SQL> shut abort
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 2.1379E+10 bytes
Fixed Size                  2213136 bytes
Variable Size            1.6911E+10 bytes
Database Buffers         4294967296 bytes
Redo Buffers              170340352 bytes
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@usnode PRODQA]$ rman target sys/passwd@PRODQA catalog rmant_11g/rmand@RMANCATAMER

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 5 10:37:14 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRODQA (not mounted)
connected to recovery catalog database

RMAN> set DBID=4277918464;

executing command: SET DBID
database name is "PRODQA" and DBID is 4277918464

RMAN> run
2> {
allocate channel t1 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
3> 4> allocate channel t3 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-INCR)';
5> allocate channel t5 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-ARCH)';
restore controlfile from tag 'DB_HOT_FULL_20160303072926';
6> 7> }

allocated channel: t1
channel t1: SID=421 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t3
channel t3: SID=436 device type=SBT_TAPE
channel t3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t5
channel t5: SID=451 device type=SBT_TAPE
channel t5: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

Starting restore at 05-03-2016 10:37:26

channel t1: starting datafile backup set restore
channel t1: restoring control file
channel t1: reading from backup piece dblevel0_PRODQA.4042_1_905499318
channel t1: piece handle=dblevel0_PRODQA.4042_1_905499318 tag=DB_HOT_FULL_20160303072926
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:01:05
output file name=/oradata1/PRODQA/control01.ctl
output file name=/oradata2/PRODQA/control02.ctl
output file name=/oradata3/PRODQA/control03.ctl
Finished restore at 05-03-2016 10:38:32
released channel: t1
released channel: t3
released channel: t5

RMAN>

Recovery Manager complete.
[oracle@usnode PRODQA]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 10:38:44 2016

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


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

SQL> alter database  mount
  2  ;

Database altered.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@usnode PRODQA]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 10:41:19 2016

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


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

SQL> alter database datafile 4,5,6,7,8,9,11,12,13,14,15,16,17,18,19,20 offline;

Database altered.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@usnode PRODQA]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 10:44:50 2016

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


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

SQL> desc v$datafile
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE#                                              NUMBER
 CREATION_CHANGE#                                   NUMBER
 CREATION_TIME                                      DATE
 TS#                                                NUMBER
 RFILE#                                             NUMBER
 STATUS                                             VARCHAR2(7)
 ENABLED                                            VARCHAR2(10)
 CHECKPOINT_CHANGE#                                 NUMBER
 CHECKPOINT_TIME                                    DATE
 UNRECOVERABLE_CHANGE#                              NUMBER
 UNRECOVERABLE_TIME                                 DATE
 LAST_CHANGE#                                       NUMBER
 LAST_TIME                                          DATE
 OFFLINE_CHANGE#                                    NUMBER
 ONLINE_CHANGE#                                     NUMBER
 ONLINE_TIME                                        DATE
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 CREATE_BYTES                                       NUMBER
 BLOCK_SIZE                                         NUMBER
 NAME                                               VARCHAR2(513)
 PLUGGED_IN                                         NUMBER
 BLOCK1_OFFSET                                      NUMBER
 AUX_NAME                                           VARCHAR2(513)
 FIRST_NONLOGGED_SCN                                NUMBER
 FIRST_NONLOGGED_TIME                               DATE
 FOREIGN_DBID                                       NUMBER
 FOREIGN_CREATION_CHANGE#                           NUMBER
 FOREIGN_CREATION_TIME                              DATE
 PLUGGED_READONLY                                   VARCHAR2(3)
 PLUGIN_CHANGE#                                     NUMBER
 PLUGIN_RESETLOGS_CHANGE#                           NUMBER
 PLUGIN_RESETLOGS_TIME                              DATE

SQL> desc v$tablespace
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TS#                                                NUMBER
 NAME                                               VARCHAR2(30)
 INCLUDED_IN_DATABASE_BACKUP                        VARCHAR2(3)
 BIGFILE                                            VARCHAR2(3)
 FLASHBACK_ON                                       VARCHAR2(3)
 ENCRYPT_IN_BACKUP                                  VARCHAR2(3)

SQL> select name from v$tablespace ;

NAME
------------------------------
SYSTEM
TEMP
SYSAUX
UNDOTBS1
USERS
PVWD
PVWX
PVWDOCS
IGNITED

9 rows selected.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@usnode PRODQA]$ rman target sys/passwd@PRODQA catalog rmant_11g/rmand@RMANCATAMER

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 5 10:46:19 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRODQA (DBID=4277918464, not open)
connected to recovery catalog database

RMAN> run
2> {
set until time "to_date('03-03-2016 08:30:00','DD-MM-YYYY HH24:MI:SS')";
3> allocate channel t1 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-FULL)';
4> 5> allocate channel t3 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-INCR)';
allocate channel t5 type 'SBT_TAPE' PARMS='ENV=(NB_ORA_CLIENT=usnode.com,NB_ORA_POLICY=P-A11-BE-ORAL-ARCH)';
6> RECOVER DATABASE SKIP tablespace USERS,PVWD,PVWX,PVWDOCS,IGNITED ;
}7> 8>

executing command: SET until clause

allocated channel: t1
channel t1: SID=421 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t3
channel t3: SID=436 device type=SBT_TAPE
channel t3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

allocated channel: t5
channel t5: SID=451 device type=SBT_TAPE
channel t5: Veritas NetBackup for Oracle - Release 7.0 (2010070800)

Starting recover at 05-03-2016 10:46:29

Executing: alter database datafile 4 offline
Executing: alter database datafile 5 offline
Executing: alter database datafile 8 offline
Executing: alter database datafile 13 offline
Executing: alter database datafile 19 offline
Executing: alter database datafile 20 offline
Executing: alter database datafile 6 offline
Executing: alter database datafile 9 offline
Executing: alter database datafile 17 offline
Executing: alter database datafile 7 offline
Executing: alter database datafile 11 offline
Executing: alter database datafile 12 offline
Executing: alter database datafile 15 offline
Executing: alter database datafile 16 offline
Executing: alter database datafile 18 offline
Executing: alter database datafile 14 offline
starting media recovery

channel t1: starting archived log restore to default destination
channel t1: restoring archived log
archived log thread=1 sequence=1972
channel t1: reading from backup piece dblevel0_PRODQA.4045_1_905501807
channel t3: starting archived log restore to default destination
channel t3: restoring archived log
archived log thread=1 sequence=1973
channel t3: reading from backup piece dbarch_PRODQA.4046_1_905519595
channel t1: piece handle=dblevel0_PRODQA.4045_1_905501807 tag=DB_HOT_FULL_20160303072926
channel t1: restored backup piece 1
channel t1: restore complete, elapsed time: 00:00:55
archived log file name=/oraarc1/PRODQA/PRODQA_1_1972_882266836.arc thread=1 sequence=1972
channel t3: piece handle=dbarch_PRODQA.4046_1_905519595 tag=ARCH_TAPE_20160303131310
channel t3: restored backup piece 1
channel t3: restore complete, elapsed time: 00:01:06
archived log file name=/oraarc1/PRODQA/PRODQA_1_1973_882266836.arc thread=1 sequence=1973
media recovery complete, elapsed time: 00:00:00
Finished recover at 05-03-2016 10:47:45
released channel: t1
released channel: t3
released channel: t5

RMAN>

Recovery Manager complete.
s[oracle@usnode PRODQA]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 5 10:47:53 2016

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


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

SQL> alter database open read only ;

Database altered.

SQL> desc user$;
 Name                                                                     Null?    Type
 ------------------------------------------------------------------------ -------- -------------------------------------------------
 USER#                                                                    NOT NULL NUMBER
 NAME                                                                     NOT NULL VARCHAR2(30)
 TYPE#                                                                    NOT NULL NUMBER
 PASSWORD                                                                          VARCHAR2(30)
 DATATS#                                                                  NOT NULL NUMBER
 TEMPTS#                                                                  NOT NULL NUMBER
 CTIME                                                                    NOT NULL DATE
 PTIME                                                                             DATE
 EXPTIME                                                                           DATE
 LTIME                                                                             DATE
 RESOURCE$                                                                NOT NULL NUMBER
 AUDIT$                                                                            VARCHAR2(38)
 DEFROLE                                                                  NOT NULL NUMBER
 DEFGRP#                                                                           NUMBER
 DEFGRP_SEQ#                                                                       NUMBER
 ASTATUS                                                                  NOT NULL NUMBER
 LCOUNT                                                                   NOT NULL NUMBER
 DEFSCHCLASS                                                                       VARCHAR2(30)
 EXT_USERNAME                                                                      VARCHAR2(4000)
 SPARE1                                                                            NUMBER
 SPARE2                                                                            NUMBER
 SPARE3                                                                            NUMBER
 SPARE4                                                                            VARCHAR2(1000)
 SPARE5                                                                            VARCHAR2(1000)
 SPARE6                                                                            DATE

SQL> 
SQL> col password format a50
SQL> select 'alter user '||name||' identified by '||password||' ; ' from user$ where password != 'NULL';
alter user SYS identified by 5D4AF2A3A91A28FA ;


329 rows selected.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.1379E+10 bytes
Fixed Size                  2213136 bytes
Variable Size            1.6911E+10 bytes
Database Buffers         4294967296 bytes
Redo Buffers              170340352 bytes
Database mounted.
SQL> alter database open resetlogs;

Database altered.

SQL> SET LONG 2000000
SQL> select dbms_metadata.get_ddl('USER', u.username) AS ddl from   dba_users u;
ERROR:
ORA-01187: cannot read from file  because it failed verification tests
ORA-01110: data file 201: '/oratemp1/PRODQA/temp01.dbf'
ORA-06512: at "SYS.DBMS_LOB", line 664
ORA-06512: at "SYS.DBMS_METADATA", line 3825
ORA-06512: at "SYS.DBMS_METADATA", line 5678
ORA-06512: at line 1



no rows selected

SQL>  CREATE TEMPORARY TABLESPACE temp01 tempfile '/oratemp1/PRODQA/temp011.dbf' size 1G;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp01;

Database altered.

SQL> select dbms_metadata.get_ddl('USER', u.username) AS ddl from   dba_users u;

   ALTER USER "SYS" IDENTIFIED BY VALUES 'S:18DD01906ACD04BCCC5B6BEBDB2B4C3B2AE2
A53270494ACED13FB624C650;5D4AF2A3A91A28FA'
      TEMPORARY TABLESPACE "TEMP01"

 

Comments

Popular posts from this blog

upgrade database oracle 10g to oracle 11g

Installing DBMS_JAVA package in Oracle and calling UTL_DBWS web services through Oracle database

Starting background process GTX4 and GLOBAL_TXN_PROCESSES