RE: Veritas Backup Question

If you have the room, I would suggest doing a daily export of the database until you get all the problems ironed out with Netbackup. Especially if you are trying to do incremental backups. That way you will at least have something to restore with if you find out your Netbackup plan wasn't working. Also, don't trust any backup plan until you have backed it up every which way AND restored it using the backups.

I export every day and then run the export through WinZip to save space. I keep the export around for at least a week.

Good Luck!

R. Smith

-----Original Message-----
Sent: Thursday, January 15, 2004 11:50 AM To: Multiple recipients of list ORACLE-L

Teresita,

You've gotten some good comments...even a quick tutorial on backups. My recommendation to you (especially if you don't have any backups at all) is
that until you're more familiar with the tools you have that you should initially avoid the complexities of incremental backups and immediately arrange for a regular "cold" (database down) backup. Minimally this should
include all datafiles, control files, online redologs, and archived redologs
(you didn't say whether or not you are in archivelog mode). But don't stop
with these files. Check documentation CD. It will have a section on backup
and recovery.

Kip   

|Hi!!
|My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle
|just to make queries, funtions some updates and create indexes or
|tables, that all.
 

|Now I am in a little difficult situation, here we have a DBA that do
|not have much experience. He has been working with Veritas NetBackup
|4.5 for Windows for three moths with out results. We still can not
|make a backup of our data bases. The situation is that because of that
|my boss make me work with him in this task, of course I don't know
|anything about the issue and my priority for tomorrow is to make and
|investigation of how other people make their backups with Veritas.
|Our DBA explain us that it was a way that he saw in a book, first make
a
|complete backup of our databases on Sunday then from Monday thru
Wednesday
|made a incremental backup, then from Thursday thru Saturday make
another
|incremental backup, but this one will be done from the last incremental
|backup of Wednesday to the day we are.
 

|-
|---
|-------
| -
| ------
| ----------
| Complete backup
|1 2 3 4 5 6 7
 

|1-Monday
|7- Sunday
 

|I am really lost in this task because the person that is suppose to
|teach about Veritas is really reluctant , but my boss what results. If
|any one can help me telling was is the better way to do a backup using
|Veritas that will be great. I also need to learn Veritas so if you have

|any page or document that can help I will appreciate it. We really need

|to make this work because in the last weeks we are having troubles with

|our server, with out explication it gets crushes. I am using Oracle
|9.2.0.2 in a Windows Server with Windows 2000 SP3 and
|And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows
Server
|with Windows 2000 SP4
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Kip.Bryant_at_Vishay.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: Smith, Ron L.
  INET: rlsmith_at_kmg.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).