Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN madness !!

RE: RMAN madness !!

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Mon, 08 Apr 2002 11:25:08 -0800
Message-ID: <F001.0043ECD3.20020408112508@fatcity.com> 





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 :  samir.sarkar_at_nottingham.sema.slb.com


            ssarkar2_at_slb.com 


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 :  samir.sarkar_at_nottingham.sema.slb.com


            ssarkar2_at_slb.com


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: Samir.SARKAR_at_nottingham.sema.slb.com

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: ListGuru_at_fatcity.com (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: john.hallas_at_hcresources.co.uk

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: ListGuru_at_fatcity.com (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: Samir.SARKAR_at_nottingham.sema.slb.com

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: ListGuru_at_fatcity.com (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).


Received on Mon Apr 08 2002 - 14:25:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US