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: Hi!!

RE: Hi!!

From: Michael Milligan <Michael.Milligan_at_ingenix.com>
Date: Thu, 15 Jan 2004 09:29:26 -0800
Message-ID: <F001.005DCEF4.20040115092926@fatcity.com>








Teresita,
 
The first thing I would do is to make sure and make full, cold backups by shutting down the database and doing a tape backup of the disk your database files are on. This will keep you out of trouble immediately.
 
Then, since you said you were using Oracle 9.2.0.2, set up your backups to go every night using RMAN, straight to the tape device. Oracle RMAN handles this. It includes a driver for Veritas. There is an excellent book on RMAN. It's called Oracle9i RMAN Backup & Recovery by Robert G. Freeman and Matthew Hart. It's an Oracle Press book that you can get on amazon.com or Borders, Barnes & Noble, etc. That will guide you through the process. Here is the link: http://www.amazon.com/exec/obidos/tg/detail/-/0072226625/qid=1074186675/sr=1-2/ref=sr_1_2/103-6635244-7274242?v=glance&s=books
 
You can do this. Just start with protecting your data immediately with cold backups, then move on to using RMAN for full backups. Then move on to incremental backups.
 
I hope that helps.
 

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
michael.milligan@ingenix.com


 


This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  INET: Michael.Milligan_at_ingenix.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 Thu Jan 15 2004 - 11:29:26 CST

Original text of this message

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