Re: automate backup and export

The scripts depend on your set up and environment.

Cold backup..
Shutdown database
copy all datafile,controlfiles,.ora files, etc to a separate disk startup database

Hot backup..
place the tablespace in backup mode
copy the datafile to a different disk
place the tablespace in normal mode
...
copy archivelogs to separate disks.
..
exports...
Create parfiles with the export commands you want. use cron to execute the exp command with the parfile..

Use RMAN as an easy and effective alternative.

Ron

>>> sc00170_at_cc.uoi.gr 12/12/2003 2:04:46 PM >>>
Do you know any script for doing export and backup of Oracle 9i R2 server?

My oracle is on a SuSE linux.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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