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
Backup and Recovery
|
63
1.
Ensure that the database has been shut down:
SHUTDOWN IMMEDIATE;
or
SHUTDOWN ABORT;
2.
Copy your datafile from a good backup.
3.
Start the database in mount mode:
STARTUP MOUNT;
4.
Recover the corrupt datafile through SQL*Plus:
RECOVER TABLESPACE tablespace_name;
or
RECOVER DATAFILE datafile_name;
5.
Open the database:
ALTER DATABASE OPEN;
Restoring the control file
If you have specified multiple copies of your control file with
the initialization parameter CONTROL_FILES, you can
restore an individual copy of it by shutting down the data-
base with the SHUTDOWN ABORT command; copying one
of your other, undamaged control files to replace the dam-
aged copy; and then bringing the database back up.
If a media failure has made the location of the damaged con-
trol file unavailable, follow the same procedure, but before
bringing the database back up, edit the CONTROL_FILES
initialization parameter to reflect the new location.
If you have to restore a single copy of a control file or if all
copies of a multiplexed control file have been damaged, you
must perform the following steps:
1.
Shut down the database with the SHUTDOWN ABORT
command.
2.
Copy the backup of the control file to the appropriate
location.
3.
Mount the database with the STARTUP MOUNT
command.
64
|
Oracle DBA Pocket Guide
4.
Issue the following ...
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