Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
30
|
Oracle DBA Pocket Guide
WARNING
Although the SPFILE looks like a plain text file, it is very
important to realize that the SPFILE must not be edited
directly. If you edit your SPFILE (with a text editor, for ex-
ample), then the next attempt to start your database will
result in a failure. You will be unable to start your data-
base unless you have created a backup INIT.ORA file
(which is a good practice for just this reason).
Dynamic and Static Parameters
While most initialization parameters are static, taking their
values from the initialization file as it exists at the time of
database startup, some may be dynamically modified while
the instance is up and the database is open.
Dynamic modification is different from dynamic storage of a
changed value in the SPFILE. In all versions of Oracle, you
can dynamically modify a setting using the ALTER SYSTEM
or ALTER SESSION command. These changes may also be
dynamically stored in the SPFILE, depending on the value of
the SCOPE clause of the ALTER command.
NOTE
Remember that if you use an INIT.ORA file, dynamic
changes to parameters will never be saved to it; you must
edit the INIT.ORA file yourself (or recreate it from the
SPFILE).
Backup and Recovery
Even with redundant hardware, you will still need to back up
your database. You can do this through a logical backup
(export) or a physical backup at the datafile level. As you’d
expect, there are trade-offs
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843