Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 9: Oracle Backup & Recovery -Simple Technique
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.
Chapter 9: Oracle Backup & Recovery -Simple Technique
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Share with others: