Sure John......here it is :
run
{
set until time "to_date('20-MAR-2002 20:00:00','DD-MON-YYYY HH24:MI:SS')";
allocate auxiliary channel dupdb_d1 type 'SBT_TAPE';
setlimit channel c_dlt1 kbytes 67108864 maxopenfiles 128 readrate 256;
setlimit channel dupdb_d1 kbytes 67108864 maxopenfiles 128 readrate 256;
set newname for datafile
'/disk01/oradata/sid1/data/system01sid1.dbf' to
'/disk01/oradata/test/data/system01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/rbs01sid1.dbf' to
'/disk01/oradata/test/data/rbs01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/rbslarge01sid1.dbf' to
'/disk01/oradata/test/data/rbslarge01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/temp01sid1.dbf' to
'/disk01/oradata/test/data/temp01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/tools01sid1.dbf' to
'/disk01/oradata/test/data/tools01sid1.dbf';
set newname for datafile
'/disk01/oradata/sid1/data/users01sid1.dbf' to
'/disk01/oradata/test/data/users01sid1.dbf';
duplicate target database to "test"
logfile
group 1 ('/disk03/oradata/test/logs/log01a01sid1.dbf') size 180M,
group 2 ('/disk03/oradata/test/logs/log02a01sid1.dbf') size 180M,
group 3 ('/disk03/oradata/test/logs/log03a01sid1.dbf') size 180M;
}
By the way, Jay suggested that I will have to set the NLS_DATE_FORMAT to
YYYYMONDDHH24MISS and
issue the command
set until time '20020320200000';
He referred to this as a bug. He also asked me to set the NLS_LANG. Any idea
of how to set this ??
I do not think it is set in the parameter file. My character set is
WE8ISO8859P1.
Thanks and Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
-----Original Message-----
Sent: 08 April 2002 19:59
To: Multiple recipients of list ORACLE-L
I am a bit confused now Samir. Your earlier script did not mention a
I cannot see where you have the line ---- duplicate target database to
"test"
Can you post you're revised script and we can check it out
John
-----Original Message-----
Sent: 08 April 2002 19:04
To: Multiple recipients of list ORACLE-L
Hi All,
I am back again........and yes, my script didn't work completely. It did
write the data files
to the respective locations but it returned the following error during the
process of duplicating
the db :
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel dupdb_d1: starting datafile backupset restore
RMAN-08502: set_count=335 set_stamp=456984311 creation_time=20-MAR-2002
RMAN-08089: channel dupdb_d1: specifying datafile(s) to restore from backup
set
RMAN-08523: restoring datafile 00001 to
/disk01/oradata/test/data/system01sid1.dbf
RMAN-08523: restoring datafile 00002 to
/disk01/oradata/test/data/rbs01sid1.dbf
RMAN-08523: restoring datafile 00003 to
/disk01/oradata/test/data/rbslarge01sid1.dbf
RMAN-08523: restoring datafile 00004 to
/disk01/oradata/test/data/temp01sid1.dbf
RMAN-08523: restoring datafile 00005 to
/disk01/oradata/test/data/tools01sid1.dbf
RMAN-08523: restoring datafile 00006 to
/disk01/oradata/test/data/users01sid1.dbf
RMAN-08023: channel dupdb_d1: restored backup piece 1
RMAN-08511: piece handle=DB_BKUP_INCR_0_SID1_456984311_335_1
tag=DB_BKUP_INCR_0 params=NULL
RMAN-08024: channel dupdb_d1: restore complete
RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "test"
RESETLOGS ARCHIVELOG
MAXLOGFILES 48
MAXLOGMEMBERS 2
MAXDATAFILES 1000
MAXINSTANCES 10
MAXLOGHISTORY 2042
LOGFILE
GROUP 1 ( '/disk03/oradata/test/logs/log01a01sid1.dbf' ) SIZE 188743680
,
GROUP 2 ( '/disk03/oradata/test/logs/log02a01sid1.dbf' ) SIZE 188743680
,
GROUP 3 ( '/disk03/oradata/test/logs/log03a01sid1.dbf' ) SIZE 188743680
DATAFILE
'/disk01/oradata/test/data/system01sid1.dbf'
CHARACTER SET WE8ISO8859P1
RMAN-03027: printing stored script: Memory Script
{
switch clone datafile all;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: switch
RMAN-03023: executing command: switch
RMAN-08015: datafile 2 switched to datafile copy
RMAN-08507: input datafilecopy recid=1 stamp=458671845
filename=/disk01/oradata/test/data/rbs01sid1.dbf
RMAN-08015: datafile 3 switched to datafile copy
RMAN-08507: input datafilecopy recid=2 stamp=458671845
filename=/disk01/oradata/test/data/rbslarge01sid1.dbf
RMAN-08015: datafile 4 switched to datafile copy
RMAN-08507: input datafilecopy recid=3 stamp=458671845
filename=/disk01/oradata/test/data/temp01sid1.dbf
RMAN-08015: datafile 5 switched to datafile copy
RMAN-08507: input datafilecopy recid=4 stamp=458671845
filename=/disk01/oradata/test/data/tools01sid1.dbf
RMAN-08015: datafile 6 switched to datafile copy
RMAN-08507: input datafilecopy recid=5 stamp=458671845
filename=/disk01/oradata/test/data/users01sid1.dbf
RMAN-08015: datafile 7 switched to datafile copy
RMAN-03027: printing stored script: Memory Script
{
set until time 'to_date(''20-MAR-2002 20:00:00'',''DD-MON-YYYY
HH24:MI:SS'')';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code: 600
RMAN-03013: command type: Duplicate Db
RMAN-00600: internal error, arguments [15120] [] [] [] []
RMAN-01005: syntax error: found "single-quoted-string": expecting one of:
";"
RMAN-01007: at line 2 column 30 file: Memory Script
Any ideas anybody ?????? My head is all mitered by now.
Thanks and Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
___________________________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received
this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Hallas
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SARKAR, Samir
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
