RE: Backup/Restore

I would like to suggest Robert Freeman's book "Oracle9i RMAN Backup & Recovery"
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).