Re: Backup/Restore

Thank you Dennis, I was just going to do that. :)

It covers Net Backup as well as RMAN.

Jared

On Wednesday 13 November 2002 06:08, DENNIS WILLIAMS wrote:
> I would like to suggest Robert Freeman's book "Oracle9i RMAN Backup &
> Recovery"
> http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
>0 H&isbn=0072226625
> It has a chapter on Veritas, as well as how to backup to disk.
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, November 13, 2002 7:09 AM
> To: Multiple recipients of list ORACLE-L
>
> > 1- Do I need to install Veritas Oracle agent for
> > backup?
>
> Not required, but recommended. There are a couple of
> ways to go about making backups without the Oracle agent.
>
> These both require you to create a couple of scripts on the client.
> bpstart_notify_<POLICY_NAME>.bat
> bpend_notify_<POLICY_NAME>.bat
>
> These go in the NBU_HOME/bin directory.
>
> My NetBackup experience is mostly with NT/Win2k, but I seem to
> recall that the unix layouts and operations are pretty much the same.
>
> So the above script names likely don't have a '.bat' extension.
>
> The 'start' script is run prior to the backups taking place, and the
> 'end' script is run when the backups are completed.
>
> You can use the start/end pair to either put your database in
> hot backup mode or just shut it down prior to the backup, and
> then restart your database or take it out of backup mode.
>
> If you use hot backup, you must put all of the tablespaces in hot backup
> mode at the same time.
>
> To clean up archive log files, use the veritas bparchive command.
>
> > 2- What are COMPLETE steps involved to
> > backup/restore if I want to use Veritas for
> > this purpose?
>
> RTFM my friend. The docs are all online at veritas.com.
>
> Setup a test environment. Backup some test databases, destroy
> them, restore them. Find an unused or underutilized server somewhere
> to play with, or even a workstation. Become very friendly with your SA
> and she may give you root on a box.
>
> > 3- I am using following script to create backup on
> >
> > the local disk. This script does not delete the
> > archive log files after backing 'em up. Why
> > not? I am using this script at RMAN prompt.
> > (connect to recvcat)
>
> See above. If you don't have the Oracle agent installed, where
> are your backup files going? I don't know your environment, so
> they *may* be going to tape.
>
> They sure aren't being put in the Net Backup catalog however.
> That won't happen with RMAN unless you are using the Oracle Agent.
>
> Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).