Re: Backup an ORACLE database

There are books devoted just to back up. The mode you need depends on how you need to recover and your tolerance for loss.

Logical (export) is the simplest but has the highest rate of data loss. Hot back up using RMAN is the next best. A cold back up provides a complete clone of a database, meaning a file restore and restart brings the database back from where it was at the time of the backup with minimal fuss.
Archive log gives point in time recovery up to the last log switch. The loss tolerance depends on where logs are written to and preserved. Hot standby requires Archive log and provides fail over. Replication preserves data up to the last successful commit and sync.

All of these methods have pros and cons and different administrative issues. You need to spend some time assessing your needs before moving forward.

Make sure you have a disposable "play" area when testing backups and restores. Chances are that you will mess up the database a couple of times before you get it right.

Good Luck

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Weiss
mailto:chris_at_hpdbe.com
www.hpdbe.com
High Performance Database Engineering
Available for long and short term contracts

"Cefio" <support_at_cefio.fr> wrote in message news:abtiks$1g0$1_at_wanadoo.fr...


> Hi.

>

> Can you tell me please how to backup a database ??

>

> I am a bit novice in ORACLE managing.

>

>

> Thierry.

>

>

>