Re: What to backup in Oracle?

[Quoted] Mate you better start reading a least a couple of manuals, if you keep [Quoted] asking similar questions you're going to start annoying some of the people here - and believe me you won't like it when their annoyed 8-0

I'm no expert but AFAIK an export script creates a file containing the data [Quoted] and structures of your database. The files it creates are not so much restored as they are "imported" at a later date or into another database should you wish. Sybrand called this a logical backup because the files it [Quoted] creates are on your harddrive. If you then backed this up onto tape then you [Quoted] [Quoted] would be creating a physical backup (which could then be stored seperate from your machine)

The reason the script didn't have to mention your oracle sid (bas 1) is [Quoted] because its a variable and when you ran the script Oracle would have looked for that variable to determine what your sid was (if you don't know what a [Quoted] variable is try typing in set at the command prompt to see a list of variables that currently have values set for them. And perhaps you need to [Quoted] [Quoted] find a book on linux 8-) Try "Teach yourself linux in 21 days" I understand its very good for people just starting out.

Hopefully I have answered some of your questions - I intended this to be [Quoted] [Quoted] read in good humor - I was not trying to be nasty or insulting.

Cheers

user Linux <kankossa_at_free.fr> wrote in message news:d_cl6.3068$Yj2.4934760_at_nnrp6.proxad.net...
> Dans l'article <gtla9tg0kh7nqed6crmj95ctjmlc0juegm_at_4ax.com>, "Sybrand
> Bakker" <postbus_at_sybrandb.demon.nl> a écrit :
>
> > On Thu, 22 Feb 2001 16:41:48 GMT, "user Linux" <kankossa_at_free.fr> wrote:
> >
> >>Hello,
> >>
> >>I find the following script for backup the oracle database. But I don't
> >>know what to do exactly.
> >>
> >>#!/bin/sh
> >>PATH=$PATH:$ORACLE_HOME/bin export PATH echo "BEGIN: $(date)"
> >>file1="YOUR_DATABASE_$(date +%Y%m%d).dmp" file2="YOUR_DATABASE_$(date
> >>+%Y%m%d).log" exp userid=login/password file=$file1 log=$file2 full=yes
> >>echo "END: $(date)"
> >>
> >>I know that my instance has the same name as th db_name both called
> >>"bas1" as I can see from initbas1.ora in /pfile directory.
> >>However in can't find where this base lies physical, grep, find can not
> >>find it. What to replace in place of "YOUR_DATABASE" in the above
> >>script? Can somebody helping me?
> >
> >
> > This in an export script. Export is *logical* backup, not *physical*, so
> > in this case the location of your files is completely irrelevant. The
> > script assumes the env var ORACLE_SID has been set. I would you this
> > variable for YOUR_DATABASE warning: export as logical backup can not
> > replace a physical backup
> >
> > Hth,
> >
> >
> > Sybrand Bakker, Oracle DBA
>
> Thanks for reply.
> My ORACLE_SID=bas1. Now when I replace "YOUR_DATABASE" by any file like
> "somthing", the script works and backup me a file called
> somthing_20010222.dmb and somthing_20010222.log. Is this means that the
> DB has been effectivelly backup even if I dont mentionne "bas1" anywhere
> in the script?
> How I can restore?
>
> What the difference between logical and physical backup?
> In the case of physical backup, where is the emplacement of the my
> database "bas1".
>
> Thanks so.
Received on Thu Feb 22 2001 - 21:53:24 CET