Re: Simple Backups
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