Database Reference
In-Depth Information
Then start the Oracle database again by first running SQL and
then connecting as SYSDBA. This time you will not get any
error.
User-Managed Complete Recovery in ARCHIVELOG Mode
Let's suppose one of your data file got corrupted/deleted. The
time you try to start the Oracle Instance, it will give you an error
with the name and location of the data files. If the Oracle server
is up and running and you don't want to shut it down then follow
the following steps.
Step 1: Take the corrupted data file offline
Use the following SQL statement to take the corrupted/deleted
data file offline.
ALTER DATABASE DATAFILE 'c:\oracle\oradata\test\users01.dbf'
OFFLINE;
Step 2: Restore the corrupted data file
Restore the corrupted data file by copy it from the backed up
location and pasting it to the original location at the operating
system level or in other words using operating systems
commands like 'copy' in windows or 'cp' in Unix/Linux.
Step 3: Recover Data File
Recover the restored data file using the RECOVER DATAFILE
statement. Then apply all the available Redo Log files by
pressing “Enter” button on the keyboard whenever asked.
C:\> sqlplus /nolog
SQL>connect / as sysdba
SQL>recover datafile
'c:\oracle\oradata\test\users01.dbf'
Search WWH ::
Custom Search