RE: Veritas Backup Question

To do incremental backups of Oracle databases via NetBackup you need to purchase the Veritas Agent for Oracle, which is an add-on to the NetBackup client. Veritas charges for this component, per server. You have to hand over more money to Veritas. This may not be an option at your site.

Without the Veritas Agent for Oracle as far as I know you cannot use RMAN with NetBackup (hopefully can prove me wrong so I can start using RMAN too).

Without the Veritas Agent for Oracle, you are forced to use Oracle 7.3 methods to back up your database.

1. Don't Want Database To Be Down Because People Log In or Jobs Need To Run.

Hot backups --> using scripts, put each tablespace in backup mode, then trigger NetBackup to back up that tablespace's datafile(s). Put the tablespace back online. Do all the tablespaces, one after the other. The database will remain available while the tablespace is offline, Oracle logs changes during that time and applies them in a hurry once the tablespace is back online. The less workload at night the better.

2) I Don't Care If My Database Is Down At Night -- I Won't Lose Any Sleep.

Cold Backups -- shutdown abort, startup restrict, shutdown immediate. Tell NetBackup (using a script) to back up your datafiles. Once done, the script should restart the Oracle database (On Windows, net start OracleServiceXXX will usually work, but you may want to use a cript to log in as / as DBA or as internal, and issue a startup statement from within -- Windows memory allocation is slow enough that I have seen databases not completely come up by themselves).

There are tech notes in Metalink on how to do this on UNIX and on Windows.

I haven't tried, but if you use the OEM (Oracle Enterprise Manager) it may be possible to issue these commands via OEM jobs. I haven't tested that on any platform, I would definitely test rigorously against the Windows platform. I have noticed that sometimes on Windows the networking side of it clogs up if the demand is too high.

To schedule jobs on the Windows platform I use an old freeware utility called Crontab for Windows. It was developed for NT Server 4 but it works on Windows2000. I like it because you can, in one line, tell a script to run every 5 minutes, Mon - Fri, 7AM - 5PM. You can't do that with AT or WinAT (GUI version of AT). There may be freeware utilities on the 'net equivalent to crontab for windows.

Scripting is a pain in Windows, because Windows assumes there is always someone sitting there at the console clicking on buttons etc. If you have an old DOS 6 Commands book you're half way there. <grin>

I also noticed that the MCSEs who know how or are willing to write command line scripts for Windows servers are rare. If you find one grab him/her and don't let go.

Patrice.

-----Original Message-----
Sent: January 14, 2004 11:09 PM
To: Multiple recipients of list ORACLE-L

OK, Teresita, what is your question? Do you have MLM? Did you put the database in the backup
mode? Did you save archives? How about the control files? Did you backup control files? I doubt that
this forum is an appropriate place for a backup & recovery course, but it seems that you have a good incentive
to learn. First advice is to try to restore database and see whether you can actually recover. If you can,
well, you're a pro. If you can't .... get backup and recovery book, one of Rama Velpuri's, if possible. My
favorite is V7 book, because it's not too thick, it's very clear and well written and I like the color of copper.
The most important thing about backup and recovery is never to allow yourself to run out of coffee.

On 2004.01.14 21:14, Teresita Castro wrote:
>
> 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
>

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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).