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: Backup Advice.

RE: Backup Advice.

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 29 Mar 2001 04:18:38 -0800
Message-ID: <F001.002DB364.20010329040113@fatcity.com>

Any suggestions for a particular product?

-----Original Message-----
Sent: Wednesday, March 28, 2001 06:16
To: Multiple recipients of list ORACLE-L

Mark,
 I might suggest that you look into a "Ghost" product for making an image of your PC. I "ghost" my pc and keep the image on the network where it is backed up each night and stored on tape. If I have problems with my PC I load the image to the second drive and I have access to all of the original files.
My 2 bits.
ROR mm

>>> mark_at_cool-tools.co.uk 03/28/01 10:30AM >>>
Hi there :)

After a rather interesting start of my week, I have a question for you about the backup of local PC test databases.

<Rant>

At the end of last week I deleted my current test database along with all Oracle files, and went for a fresh install, due to having some rather interesting ora-600's and a corrupted SYSTEM datafile! Now that was fun to say the least I can tell you!

I then went on to try and install Oracle again from a copy of 8.1.6 for Windows NT/2000, which was downloaded from technet, and burned on to a cd, to save disk space.. I had originally installed 8.1.6 from this download, but when I went to decompress the files from the zip, on the CD, I had corruption on the CD!!

Now, I dreamed of corrupted datafiles, corrupted CD's, even corrupted politicians over the weekend, and came in early this week to start downloading 8.1.7 (The only bonus in this little story:) which is in fact a download of 584mb. This is now STILL downloading right now at a rate of 4.5kbs, and is scheduled to finish in 17hours, and 37 minutes :<( What a joy it is to have to download these extraordinarily huge files over a 56k modem. Even ADSL isn't available here until September..

<\Rant>

The point? Well, I was wondering what you guys do out there to backup any local PC test databases you may have? I have no tape to backup too, and no real experience with backup or recovery situations. I have never backed up Oracle either :)

The databases are all pretty static, as we just load up some data exported from our Access tracking system. The database is pretty much used for QA of our performance tools.

What files should I backup first of all? There is no real need to have this database running in ARCHIVELOG MODE is there?
Also, where would you reccomend backing up to? CD (aahhemmm!!), network drives, seperate directory?

I'm really just trying to avoid the fun and games I've had this week, any advice?

Thanks guys

Mark

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
  INET: mark_at_cool-tools.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: Ron Rogers
  INET: RROGERS_at_galottery.org

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: Mark Leith
  INET: mark_at_cool-tools.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).
Received on Thu Mar 29 2001 - 06:18:38 CST

Original text of this message

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