Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id hBCKCDh21675 for ; Fri, 12 Dec 2003 14:12:13 -0600 X-ClientAddr: 66.27.56.212 Received: from www3.fatcity.com (rrcs-west-66-27-56-212.biz.rr.com [66.27.56.212]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id hBCKCCo21670 for ; Fri, 12 Dec 2003 14:12:12 -0600 Received: (from root@localhost) by www3.fatcity.com (8.11.6/8.11.6) id hBCKG6p20597 for oracle-l@orafaq.com; Fri, 12 Dec 2003 12:16:06 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D9B38; Fri, 12 Dec 2003 12:09:25 -0800 Message-ID: Date: Fri, 12 Dec 2003 12:09:25 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Ron Rogers" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Ron Rogers" Subject: Re: automate backup and export Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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@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@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@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).