Re: Simple Backups

From: Bill Bearden <bbearden_at_quincy.glenayre.com>
Date: 1997/06/12
Message-ID: <01bc7738$3cd66a10$1d51e69d_at_qcy_erp_6>#1/1


The simplest real backup is called the 'cold' backup. This works with ARCHIVE_LOG_MODE turned off or on.

Step 1. Shut down the database
Step 2. Backup all database files (all control files, datafiles, and online redo log files) and init<SID>.ora files. Step 3. Start the database up

The database can now be restored, with full consistency, to the state of the database when it was shut down.

Now a 'hot' backup... much better but more complicated.

Bill Bearden
Consultant

Corin Lanser <c.lanser_at_ukerna.ac.uk> wrote in article <339E699C.307A_at_ukerna.ac.uk>...
> Hi,
>
> I am using Oracel 7.3.2 and currently backup all Oracle Datafiles and
> Control files daily using UNIX backup methods. I would like to know if
> there are any simple ways to backup with Oracle facilities, ensuring
> that individual parts of the database can be recovered without risk of
> incompatibilities such as some data older than others, etc.
>
> Help appreciated,
>
> Corin. (c.lanser_at_ukerna.ac.uk)
>
Received on Thu Jun 12 1997 - 00:00:00 CEST

Original text of this message