|
|
|
|
|
|
|
|
|
|
|
|
|
Re: RMAN Incremental Backup [message #514381 is a reply to message #514367] |
Mon, 04 July 2011 06:51 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
This
Quote:RMAN> connect TARGET sys/oracle@target AUXILIARY / won't work because you MUST connect to the auxiliary with SQLNet. This is in the docs:
Quote:For active database duplication, you must connect to the source database as TARGET and to the auxiliary instance as AUXILIARY. You must use the same SYSDBA password for both instances and must supply the net service name to connect to the AUXILIARY instance. A recovery catalog connection is optional. Trust me, I know from experience that if you use IPC to connect to the auxiliary rather than using a net service name, the duplicate will fail.
This
Quote:connect target sys/oracle@target auxiliary sys/oracle@dupli fails because the syntax is wrong, make your two connections in two commands, not one.
|
|
|
|
Re: RMAN Incremental Backup [message #514390 is a reply to message #514385] |
Mon, 04 July 2011 07:37 |
|
dkdms2124
Messages: 369 Registered: April 2010 Location: INDIA
|
Senior Member |
|
|
Hi All,
I am able to run all the steps successfully, at last when I issued final command I got below mentioned Error:
RMAN> run
2> {
3> allocate auxiliary channel c1 device type disk;
4> allocate auxiliary channel c2 device type disk;
5> allocate auxiliary channel c3 device type disk;
6> duplicate target database to dup
7> pfile='F:\app\dsharma\product\11.2.0\dbhome_1\database\initdup.ora';
8> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=10 devtype=DISK
allocated channel: c2
channel c2: sid=135 devtype=DISK
allocated channel: c3
channel c3: sid=11 devtype=DISK
Starting Duplicate Db at 04-JUL-11
contents of Memory Script:
{
set until scn 555679;
set newname for datafile 1 to
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF";
set newname for datafile 2 to
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF";
set newname for datafile 3 to
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF";
set newname for datafile 4 to
"E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF";
restore
check readonly
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
Starting restore at 04-JUL-11
channel c2: starting datafile backupset restore
channel c2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF
restoring datafile 00004 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF
channel c2: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131PYL7_.BKP
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF
restoring datafile 00003 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF
channel c1: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131QDV1_.BKP
channel c1: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131QDV1_.BKP tag=TAG20110704T145444
channel c1: restore complete, elapsed time: 00:00:25
channel c2: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131PYL7_.BKP tag=TAG20110704T145444
channel c2: restore complete, elapsed time: 00:00:28
Finished restore at 04-JUL-11
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\REDO01.LOG' ) SIZE 50 M REUSE,
GROUP 2 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\REDO02.LOG' ) SIZE 50 M REUSE,
GROUP 3 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\REDO03.LOG' ) SIZE 50 M REUSE
DATAFILE
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=755630153 filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=755630153 filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=755630153 filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF
contents of Memory Script:
{
set until scn 555679;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 04-JUL-11
channel c1: starting incremental datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF
destination for restore of datafile 00004: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF
channel c1: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MBHJ_.BKP
channel c2: starting incremental datafile backupset restore
channel c2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF
destination for restore of datafile 00003: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF
channel c2: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MSY5_.BKP
channel c1: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MBHJ_.BKP tag=TAG20110704T150953
channel c1: restore complete, elapsed time: 00:00:01
channel c2: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MSY5_.BKP tag=TAG20110704T150953
channel c2: restore complete, elapsed time: 00:00:01
starting media recovery
archive log thread 1 sequence 9 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_9_7132R46G_.ARC
archive log thread 1 sequence 10 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_10_7132RBJP_.AR
archive log thread 1 sequence 11 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_11_7132RG8W_.AR
archive log thread 1 sequence 12 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_12_7132RLH8_.AR
archive log thread 1 sequence 13 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_13_7132RM03_.AR
archive log thread 1 sequence 14 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_14_7132RQGR_.AR
archive log thread 1 sequence 15 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_15_7132RQT0_.AR
archive log thread 1 sequence 16 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_16_7132RWXF_.AR
archive log thread 1 sequence 17 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_17_7132RXBD_.AR
archive log thread 1 sequence 18 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_18_7132S2MO_.AR
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_9_7132R46G_.ARC thread=1 sequence=9
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_10_7132RBJP_.ARC thread=1 sequence=10
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_11_7132RG8W_.ARC thread=1 sequence=11
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_12_7132RLH8_.ARC thread=1 sequence=12
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_13_7132RM03_.ARC thread=1 sequence=13
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_14_7132RQGR_.ARC thread=1 sequence=14
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_15_7132RQT0_.ARC thread=1 sequence=15
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_16_7132RWXF_.ARC thread=1 sequence=16
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_17_7132RXBD_.ARC thread=1 sequence=17
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_18_7132S2MO_.ARC thread=1 sequence=18
media recovery complete, elapsed time: 00:00:06
Finished recover at 04-JUL-11
contents of Memory Script:
{
shutdown clone;
startup clone nomount pfile= 'F:\app\dsharma\product\11.2.0\dbhome_1\database\initdup.ora';
}
executing Memory Script
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/04/2011 18:16:05
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation
RMAN>
Any suggestion why this error occurred.
Thanks & Regards
Deepak
|
|
|
|
|
Re: RMAN Incremental Backup [message #514694 is a reply to message #514537] |
Tue, 05 July 2011 23:43 |
|
dkdms2124
Messages: 369 Registered: April 2010 Location: INDIA
|
Senior Member |
|
|
Hey I do not know the reason why the process stop in between earlier.
Here are the final logs of the successful run..
RMAN> run
2> {
3> allocate auxiliary channel c1 device type disk;
4> allocate auxiliary channel c2 device type disk;
5> duplicate target database to "TEST"
6> pfile='F:\app\dsharma\product\11.2.0\dbhome_1\database\inittest.ora';
7> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=10 device type=DISK
allocated channel: c2
channel c2: SID=135 device type=DISK
Starting Duplicate Db at 05-JUL-11
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 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 243271080 bytes
Database Buffers 528482304 bytes
Redo Buffers 5259264 bytes
allocated channel: c1
channel c1: SID=133 device type=DISK
allocated channel: c2
channel c2: SID=9 device type=DISK
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''TEST'' 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
sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''TEST'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 243271080 bytes
Database Buffers 528482304 bytes
Redo Buffers 5259264 bytes
allocated channel: c1
channel c1: SID=134 device type=DISK
allocated channel: c2
channel c2: SID=9 device type=DISK
Starting restore at 05-JUL-11
channel c1: starting datafile backup set restore
channel c1: restoring control file
channel c1: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_07_05\O1_MF_S_755701755_715HX4DL_.BKP
channel c1: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_07_05\O1_MF_S_755701755_715HX4DL_.BKP tag=TAG20110705T130915
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:03
output file name=F:\APP\DSHARMA\ORADATA\TEST\CONTROL01.CTL
output file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\TEST\CONTROL02.CTL
Finished restore at 05-JUL-11
database mounted
contents of Memory Script:
{
set until scn 2856090;
set newname for datafile 1 to
"F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF";
set newname for datafile 2 to
"F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF";
set newname for datafile 3 to
"F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF";
set newname for datafile 4 to
"F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF";
set newname for datafile 5 to
"F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF";
set newname for datafile 6 to
"F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF";
set newname for datafile 7 to
"F:\APP\DSHARMA\ORADATA\TEST\TEST01.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
Starting restore at 05-JUL-11
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00003 to F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF
channel c1: restoring datafile 00005 to F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF
channel c1: restoring datafile 00006 to F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF
channel c1: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CH6HW_.BKP
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00002 to F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF
channel c2: restoring datafile 00007 to F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF
channel c2: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG2F8_.BKP
channel c1: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CH6HW_.BKP tag=TAG20110705T115254
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:46
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF
channel c1: restoring datafile 00004 to F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF
channel c1: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG4PN_.BKP
channel c2: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG2F8_.BKP tag=TAG20110705T115254
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:53
channel c1: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG4PN_.BKP tag=TAG20110705T115254
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:36
Finished restore at 05-JUL-11
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=9 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=10 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=11 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=12 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=13 STAMP=755709878 file name=F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=14 STAMP=755709878 file name=F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=15 STAMP=755709878 file name=F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF
contents of Memory Script:
{
set until scn 2856090;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 05-JUL-11
starting media recovery
archived log for thread 1 with sequence 110 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_110_715FKS3F_.ARC
archived log for thread 1 with sequence 111 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_111_715FKSOZ_.ARC
archived log for thread 1 with sequence 112 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_112_715FKW1Y_.ARC
archived log for thread 1 with sequence 113 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_113_715FKWDP_.ARC
archived log for thread 1 with sequence 114 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_114_715FL0TD_.ARC
archived log for thread 1 with sequence 115 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_115_715FL15V_.ARC
archived log for thread 1 with sequence 116 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_116_715FL3Y9_.ARC
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_110_715FKS3F_.ARC thread=1 sequence=110
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_111_715FKSOZ_.ARC thread=1 sequence=111
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_112_715FKW1Y_.ARC thread=1 sequence=112
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_113_715FKWDP_.ARC thread=1 sequence=113
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_114_715FL0TD_.ARC thread=1 sequence=114
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_115_715FL15V_.ARC thread=1 sequence=115
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_116_715FL3Y9_.ARC thread=1 sequence=116
media recovery complete, elapsed time: 00:00:06
Finished recover at 05-JUL-11
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount pfile= 'F:\app\dsharma\product\11.2.0\dbhome_1\database\inittest.ora';
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 234882472 bytes
Database Buffers 536870912 bytes
Redo Buffers 5259264 bytes
allocated channel: c1
channel c1: SID=134 device type=DISK
allocated channel: c2
channel c2: SID=10 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( 'F:\APP\DSHARMA\ORADATA\TEST\REDO01.LOG' ) SIZE 50 M REUSE,
GROUP 2 ( 'F:\APP\DSHARMA\ORADATA\TEST\REDO02.LOG' ) SIZE 50 M REUSE,
GROUP 3 ( 'F:\APP\DSHARMA\ORADATA\TEST\REDO03.LOG' ) SIZE 50 M REUSE
DATAFILE
'F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for tempfile 1 to
"F:\APP\DSHARMA\ORADATA\TEST\TEMP01.DBF";
switch clone tempfile all;
catalog clone datafilecopy "F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF",
"F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF",
"F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF",
"F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF",
"F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF",
"F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to F:\APP\DSHARMA\ORADATA\TEST\TEMP01.DBF in control file
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF RECID=1 STAMP=755709896
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF RECID=2 STAMP=755709896
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF RECID=3 STAMP=755709897
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF RECID=4 STAMP=755709897
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF RECID=5 STAMP=755709897
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF RECID=6 STAMP=755709897
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=755709896 file name=F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=755709896 file name=F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 05-JUL-11
released channel: c1
released channel: c2
Thanks & Regards
Deepak
|
|
|
|
|
|
|