Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Backup Script

Re: Backup Script

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 25 Jul 2002 20:01:07 +0100
Message-ID: <3d405602_1@mk-nntp-1.news.uk.worldonline.com>


"Charles J. Fisher" <cfisher_at_rhadmin.org> wrote in message news:Pine.LNX.4.44.0207251047340.30545-100000_at_galt.rhadmin.org...
> Hi, Howard.
>
> I'm attaching my own backup script that you can forward to this guy if you
> want. I've used it successfully both in cloning and in "oh my god the disk
> died" situations.
>
> Advantages:
>
> 1. My script doesn't use a lot of shell functions; the logic is easier to
> follow.
> 2. My script can use compression utilities. I use both gzip and bzip2 in
> production, but a really big database should go with compress.
> I know that you don't like compression.
> 3. I use sqlplus /nolog - Oracle on most UNIX platforms hides passwords in
> ps -ef, but this didn't used to be the case. Do examine hide.c on
> metalink if this is a problem for you.
> 4. I do clean up the archived logs, and my script will deal with 10,000
> logs in the archive dest (when ls * fails with "too many files").
> 5. I use a little more whiz-bang Korn shell functionality.
> 6. I get pretty bored at work sometimes, so it's documented up the wazoo.
>
>
> Disadvantages:
>
> 1. I do take the tablespace in and out of backup mode for each datafile.
> Since I'm compressing, this seems like a good idea.
> 2. Most Linux systems don't come with the Korn shell; download it at
> http://kornshell.com.
> 3. I do make hot copies of online redo, which is *very* useful for
> cloning, but causes the heads of Oracle purists to spin (I hate the
> sound of snapping vertebra in the morning). Using hot-copied redo will
> prevent you from rolling forward through logs (assuming that recovery
> works at all).
> 4. I don't skip anything.
>

<snip sig and script>

Charles,

Looks like a useful and well documented script, but what about: connect / as sysdba
or
sqlplus '/ as sysdba' (most unix I think)?

Paul Received on Thu Jul 25 2002 - 14:01:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US