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: Another RMAN Problem ---> Urgent !!

RE: Another RMAN Problem ---> Urgent !!

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 08 Apr 2002 06:03:20 -0800
Message-ID: <F001.0043E367.20020408060320@fatcity.com> 





Samir,



It looks like your Rman commands are not being passed to Rman, and are
instead being executed by ksh.



Try moving all of your Rman command into a separate file, and changing your
rman command to:



rman target / catalog rman_sid1/rman_sid1_at_rman817 auxiliary / cmdfile (rman
command file name) msglog {output log file name)



I know there is ane asier way to do this within ksh, but this would be the
fastest way for me.



hope this helps.



Tom Mercadante


Oracle Certified Professional




-----Original Message-----


Sent: Monday, April 08, 2002 9:44 AM


To: Multiple recipients of list ORACLE-L




Dear All,



I am totally out of my depth here and this is a production db which needs to
be restored urgently.


I shall explain my scenario first. Our application team had lost some data
after last Wednesday night's 


backup. They have a tool to have a dump of the data from the database from
which they can extract the 


data if needed. This dump was taken on Thursday morning. Due to some ***hole
they lost some more data


on Thursday during the day. They recovered this data from the database dump
which they had taken on


Thursday morning.


They now want the data which was lost on Wednesday. Since there was no
database dump available prior to


this, I suggested that we can create a duplicate database upto a point of
time (as on Wednesday night) to a 


different location on the server. They could then take a database dump with
their tool and extract the lost records.
This is my script which I compiled with help from Metalink and an old 
post from John Hallas (the backup of our target database is taken on tape
with Veritas Netbackup) :



 #!/bin/ksh



rman target / catalog rman_sid1/rman_sid1_at_rman817 auxiliary /



run {



set until time "to_date('20-MAR-2002 20:00:00','DD-MON-YYYY HH24:MI:SS)";  



allocate channel c_dlt1 type 'SBT_TAPE';



allocate auxiliary channel dupdb_d1 type disk;



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/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;


}



What happens is that RMAN connects to the target, catalog and auxiliary
database and goes into the 


RMAN prompt and just hangs there........after some time, when I type 'exit'
there out of frustration, I 


get the following errors :



 ./create_dupdb.sh[5]: run:  not found


./create_dupdb.sh[9]: allocate:  not found

./create_dupdb.sh[11]: allocate:  not found

./create_dupdb.sh[13]: setlimit:  not found

./create_dupdb.sh[14]: setlimit:  not found

./create_dupdb.sh[17]: /disk01/oradata/sid1/data/system01sid1.dbf: cannot

execute


./create_dupdb.sh[18]: to:  not found

./create_dupdb.sh[21]: /disk01/oradata/sid1/data/rbs01sid1.dbf: cannot

execute


./create_dupdb.sh[22]: to:  not found

./create_dupdb.sh[29]: /disk01/oradata/sid1/data/temp01sid1.dbf: cannot

execute


./create_dupdb.sh[30]: to:  not found

./create_dupdb.sh[33]: /disk01/oradata/sid1/data/tools01sid1.dbf: cannot

execute


./create_dupdb.sh[34]: to:  not found

./create_dupdb.sh[37]: /disk01/oradata/sid1/data/users01sid1.dbf: cannot

execute


./create_dupdb.sh[38]: to:  not found

./create_dupdb.sh[77]: duplicate:  not found

./create_dupdb.sh[79]: logfile:  not found

./create_dupdb.sh[80]: group: cannot execute

./create_dupdb.sh[81]: group: cannot execute

./create_dupdb.sh[82]: group: cannot execute

./create_dupdb.sh[83]: syntax error at line 84 : `}' unexpected




Could anybody please help me in identifying what is the problem and why does
it say 'run:not found'  and the 


other subsequent lines ?? This is highly urgent for me !!



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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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 - 09:03:20 CDT












Original text of this message













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