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
Post a Comment