Re: Backing up Data in Oracle 9.2

On Sun, 27 Jul 2003 08:53:15 +0200, "Can Oezdemir" <no_at_spam.net> wrote:

>Hi,
>
>> There are a number of secondary questions you need to ask & answer before
>a
>> satsifactory response can be provided. You might be looking for 'export',
>or
>> 'recovery manager' or simply a normal copy of >>all<< relevant files when
>the
>> database is shut down.
>>
>> I advise you read some documents first so you get an understandng of your
>> environment and you can pose the specific question you need answered.
>The
>> documents are located at http://docs.oracle.com - go the the version of
>your
>> database, 'view' the documents and 'list books' ... the books you need to
>read
>> are: 1) Concepts Manual and 2) Administrator's Guide (especially the
>backup
>> and recovery sections). Then you might want to read the Recovery Manager
>> document(s) either to understand how to use RMAN or for additional insight
>on
>> the solution areas. (Export is covered in the Utilities User Guide - same
>> place).
>>
>>
>
>Thanks for the replies...I've read some stuff, and think that I need a full
>export. The only question arises in the following passage:
>
>"It is a prerequisite that oraenv or coraenv (if you are working in a
>c-shell) was executed before you export, import data. Consider, if you
>stored data in the database by using an national language support (NLS)
>other than AMERICAN you have to change your environment before import,
>export.
>Example for a german environment:
>NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
>export NLS_LANG"
>
>Now where to change that? In the command line? It could be that I've got
>german language support...
>
>Thanks,
> Can
>

an export does NOT constitute a physical backup. Please brush up your shell skills

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Jul 27 2003 - 03:54:10 CDT