
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.