Backup/Restore

From: OraCop <oracop_at_yahoo.com>
Date: Tue, 12 Nov 2002 12:28:59 -0800
Message-ID: <F001.005015F0.20021112122859@fatcity.com>

Hello,

   I need to comeup with backup strategy for my    production oracle systems running 9iR2 on Solaris9.

   I do have veritas Netbackup installed. I would    really appreciate if someone can answer these    important questions for me.

    1- Do I need to install Veritas Oracle agent for

       backup?
    2- What are COMPLETE steps involved to

       backup/restore if I want to use Veritas for
       this purpose? 

    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)

run {
allocate channel c1 type disk;
backup
full
#incremental level 2 # 0 1 2 or up
skip inaccessible
tag hot_db_bk_level0
filesperset 5
# recommended format
format '/data/oraidx/backup/bk_%s_%p_%t'
(database);

sql 'alter system archive log current'; # backup all archive logs
backup
filesperset 20
format '/data/oraidx/backup/al_%s_%p_%t'
(archivelog all

delete input);
release channel c1;
}      

   4- What is the procedure to restore using files

      created as output of above script?    5- Any ideas/links to help improve backup

      strategy, using veritas and RMAN.
Thanks.

OraCop

---

Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraCop
  INET: oracop_at_yahoo.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 Tue Nov 12 2002 - 14:28:59 CST