using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=63 RECID=38 STAMP=881437711
output file name=/DBArchive2/archive/1_63_878860684.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 03-JUN-15
cataloged archived log
archived log file name=/DBArchive2/archive/1_63_878860684.dbf RECID=38 STAMP=881437696
datafile 1 switched to datafile copy
input datafile copy RECID=3 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=4 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/users01.dbf
contents of Memory Script:
{
? set until scn? 1338740;
? recover
? clone database
? ? delete archivelog
? ;
}
executing Memory Script
executing command: SET until clause
Starting recover at 03-JUN-15
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 63 is already on disk as file /DBArchive2/archive/1_63_878860684.dbf
archived log file name=/DBArchive2/archive/1_63_878860684.dbf thread=1 sequence=63
media recovery complete, elapsed time: 00:00:00
Finished recover at 03-JUN-15
Oracle instance started
Total System Global Area? ? 954155008 bytes
Fixed Size? ? ? ? ? ? ? ? ? ? 1368632 bytes
Variable Size? ? ? ? ? ? ? ? 306187720 bytes
Database Buffers? ? ? ? ? ? 641728512 bytes
Redo Buffers? ? ? ? ? ? ? ? ? 4870144 bytes
contents of Memory Script:
{
? sql clone "alter system set? db_name =
?''WOO'' 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
sql statement: alter system set? db_name =? ''WOO'' 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? ? 954155008 bytes
Fixed Size? ? ? ? ? ? ? ? ? ? 1368632 bytes
Variable Size? ? ? ? ? ? ? ? 306187720 bytes
Database Buffers? ? ? ? ? ? 641728512 bytes
Redo Buffers? ? ? ? ? ? ? ? ? 4870144 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "WOO" RESETLOGS ARCHIVELOG
? MAXLOGFILES? ? 16
? MAXLOGMEMBERS? ? ? 3
? MAXDATAFILES? ? ? 100
? MAXINSTANCES? ? 8
? MAXLOGHISTORY? ? ? 292
?LOGFILE
? GROUP? 1 ( '/DBSoft/oracle/oradata/woo/redo01.log' ) SIZE 50 M? REUSE,
? GROUP? 2 ( '/DBSoft/oracle/oradata/woo/redo02.log' ) SIZE 50 M? REUSE,
? GROUP? 3 ( '/DBSoft/oracle/oradata/woo/redo03.log' ) SIZE 50 M? REUSE
?DATAFILE
? '/DBSoft/oracle/oradata/woo/system01.dbf'
?CHARACTER SET WE8MSWIN1252
?
contents of Memory Script:
{
? set newname for tempfile? 1 to
?"/DBSoft/oracle/oradata/woo/temp01.dbf";
? switch clone tempfile all;
? catalog clone datafilecopy? "/DBSoft/oracle/oradata/woo/sysaux01.dbf",
?"/DBSoft/oracle/oradata/woo/undotbs01.dbf",
?"/DBSoft/oracle/oradata/woo/users01.dbf";
? switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /DBSoft/oracle/oradata/woo/temp01.dbf in control file
ca