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 NOARCHIVELOG
Mode
In NOARCHIVELOG mode the recovery is very simple. All you have to do is
to restore the database files from your backup to the original location
and start the database.
Let’s suppose one of your data file got corrupted. The time try to start
the Oracle Instance, it will give you an error. In this case shutdown
the database. Restore all the data files; redo log files and control
file back to their original location from your last whole/complete cold
backup.
Then start the Oracle database again by first running SQL and then
connecting as SYSDBA. This time you will not get any error.
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: