Re: What to backup in Oracle?

PS, a great source of information on exp and imp can be found on the Oracle Technical Network web site (http://otn.oracle.com). Look for the online version of the Oracle Utility User's Guide. It covers exp, imp, and SQL*Loader. (and it's free!)

On Fri, 23 Feb 2001 13:18:49 GMT, "user Linux" <kankossa_at_free.fr> wrote:

>Dans l'article <pYel6.1043$02M1.41549906_at_news.xtra.co.nz>, "Jason Seeley"
><me_at_127.0.0.1> a écrit :
>
>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
>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
>>> 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 Sat Feb 24 2001 - 01:33:50 CET