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
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’
This will complete the recovery process and you will realize that no
data will get lost i.e. everything that you entered or changed after the
last whole database backup will get recovered by Oracle by applying all
the redo log files.
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: