| |
Donald K. Burleson
Normal system backups, referred to as either hot
or cold backups, are used to protect the system from media failure.
Each can and should be used when required.
A cold backup, that is, one done with the
database in a shutdown state, provides a complete copy of the
database that can be restored exactly. The generalized procedure for
using a cold backup is as follows:
- Using the shutdown script(s) provided,
shutdown the Oracle instance(s) to be backed up.
- Ensure that there is enough backup media to
back up the entire database.
- Mount the first volume of the backup media (9
track, WORM, 4mm, 8mm, etc.) using the proper operating system
mount command:
For example on
OpenVMS:
The
above-mentioned script is available in Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
On
UNIX:
The
above-mentioned script is available in Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
- Issue the proper Operating System backup
command to initiate the backup.
For example on
OpenVMS:
The
above-mentioned script is available in Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
- Once the backup is complete, be sure all
backup volumes are properly labeled and stored, away from the
computer. The
final volume is dismounted from the tape drive using the
appropriate operating system DISMOUNT command:
For example on
OpenVMS:
The
above-mentioned script is available in Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
On UNIX:
The
above-mentioned script is available in Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
- Restart the Oracle instances using the
appropriate startup script(s).
The above text is an excerpt from Mike Ault’s Oracle
DBA Made Simple by Rampant TechPress.
Oracle Utilities
Deep inside the operating system
executables there are many utilities at the fingertips of Oracle
professionals, but until now there has been no advice on how to use
these utilities. From tnsping.exe to dbv.exe to
wrap.exe, Dave Moore describes each utility and has working
examples in the online code depot. Your time savings from a single
script is worth the price of this great book.
Get your copy of Oracle
Utilities today and receive immediate access to
the Online Code Depot! It’s only $19.95 (I don’t think it is right
to charge a fortune for books!) and you can buy it right now and get
immediate access to the online code depot:
http://www.rampant-books.com/book_0801_oracle_utilities.htm
|
