Re: What to backup in Oracle?

[Quoted] Dans l'article <pYel6.1043$02M1.41549906_at_news.xtra.co.nz>, "Jason Seeley" [Quoted] <me_at_127.0.0.1> a écrit :

[Quoted] I find that you are rude. How You can tell something like this? How You can speak behalf people which are devoted to answer freely anyone [Quoted] and give their time and effort to do that? If you having 20 years experienced as DBA of oracle and more for Unix/Linux I'm soo happy for your. This is not my case, I came just to begin with oracle and linux.
Only note, I don't forced you to answers me!. This is the sense fortunatly of news!

Thanks anyway, for your answer on my questions.

 are
> Mate you better start reading a least a couple of manuals, if you keep
> 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 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 creates are on your harddrive. If you then backed this up
> onto tape then you 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
> 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 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 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
> 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
[Quoted] >> 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
[Quoted] >> >>+%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
[Quoted] >> >>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
[Quoted] [Quoted] >> > 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
[Quoted] [Quoted] >> 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.