 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 13 - Oracle RAC Backup and Recovery
Cold Backup Using Scripts
Cold backup
using scripts can backup an Oracle Database 10g RAC database whether
it is in archive log mode or not. A cold backup means that the
database is shutdown and all files are backed up via a manually
created script.
Generally
speaking, you can always recover from a cold backup unless something
happens to your backup media or files. However, unless the database is
in archive log mode, a cold backup is a point-in-time backup. If a
database is archive logging (all filled redo logs are copied to an
archive log before being reused), then the cold backup can be restored
to the server, and archive logs applied, to make the database as
nearly current as possible.
The
drawbacks to cold backups are that the database must be shutdown in
order to perform a cold backup, a cold backup can take a long period
of time (depending on database size), and the DBA has to manually
maintain the backup scripts. Another problem is that Cold backup on
raw partitions on UNIX or Linux involves the command dd; Cold backup,
by nature, defeats the very purpose of high available 24/7 RAC
database solution.
For more information,
see the book
Oracle 11g Grid and Real Application Clusters - 30% off if
you buy it directly from Rampant TechPress .
Written by top
Oracle experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
Customized Oracle Training
Classes
Burleson Consulting offers
on-site
Oracle courses
year-round in a variety of Oracle topics. All on-site Oracle training can be
custom fit to
meet your specific training needs. For
customized
syllabus development or a price quote, please visit
www.fast-track.cc or email
 .
|
