|
Category :
Database
Resources -> Backup and Recovery
DB Version
:
Oracle 9i
OS Details :
Sun Solaris9
Following
are the steps that need to be done in order to recover from the loss
of SYSTEM tablespace datafile or datafiles from tablespaces containing
rollback segments. The database needs to be in archivelog mode for
these steps to work.
Step 1:
Shutdown the database. It will
most likely be a shutdown abort
Step 2:
Repair or replace the hardware
that caused the datafile loss
Step 3:
Restore only the lost or
damaged file from the most recent full database backup.
Step 4:
Startup and mount the database
but do not open it.
SQL> connect / as sysdba
SQL> startup mount
Step 5:
Make sure the archived log
files from the time when the last full database backup was taken (the point
in time from which files were restored in step 3 above) exists
on the machine where recovery's being done and start the recovery
process.
SQL> recover automatic
database;
Step 6:
After a successful recovery
process, shut down the database and take a full backup of the
database.
SQL> shutdown
or
SQL> shutdown immediate
Step 7:
After the backup, open the
database and make it available for the users.
SQL> startup open
.
|
