For -Rachel Carmichael - re Rman recovery...

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Tue, 04 Mar 2003 06:23:49 -0800
Message-ID: <F001.0055F738.20030304062349@fatcity.com>

Rachel,

 Did you ever determine if the unix "crossmount" or such to be the complete  problem....?  

 Did the Rman backup turn out to be ok after all- no corruptions?

 Ever find out if they run validate command?

Thanks Rachel,
Brian Spears

-----Original Message-----
Sent: Monday, March 03, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L

now you know why I script everything and run it as a background job on the database server itself. :)

That I know of, there is no way to restart an import... unless you have primary key or unique constraints on all objects and you are will to do "ignore=y" so that you get constraint errors on every existing row but do load all the remaining ones.

There isn't anything "clean" that I know of though. Sorry

• Scott Canaan <srcdco_at_ritvax.rit.edu> wrote:
  > I ran into a problem yesterday afternoon. I had exported a
  > production database, via a full database export, and ftp'd it to
  > another
  > machine to import it there and make that the new production machine.
  > It
  > was a long import (about 8 hours) and about 2/3 through it, my
  > network
  > connection was dropped. I was running it in a ssh shell. When the
  > connection disappeared, the import died. Since I had to get the job
  > done by morning, I chose to drop the database, rebuild it, then
  > re-import. That worked.
  > What I am wondering is: Is there a way to resume an import, once
  > it
  > has been interrupted? I have been looking in metalink and on the net
  > and haven't found anything that says how to do it. I tried technet,
  > but
  > it was way too slow. Any thoughts would be greatly appreciated.
  >
  > Thank you,
  >
  > --
  > Scott Canaan (srcdco_at_rit.edu)
  > (585) 475-7886
  > "Life is like a sewer, what you get out of it depends on what you put
  > into it." - Tom Lehrer.
  >
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: Scott Canaan
  > INET: srcdco_at_ritvax.rit.edu
  >
  > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  > San Diego, California -- Mailing list and web hosting services
  > ---------------------------------------------------------------------
  > 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).
  >
  

  ---

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Spears, Brian
  INET: BSpears_at_Limitedbrands.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Tue Mar 04 2003 - 08:23:49 CST