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 2:
Backup all the data files
Once the database gets completely shutdown backup all the data files
associated with the database at the operating system level or in other
worlds using operating system commands e.g. copy in Windows and cp in
case of Unix.
Step 3:
Backup Parameter File, Redo Log Files and Archived Redo Log Files
Backup all these files too using operating system command. It’s highly
recommended and provides greater fault tolerance in case of database
failures.
Step 4:
Startup Oracle Database with MOUNT option
Start the oracle instance and mount the database but don’t open.
C:\>sqlplus /nolog
SQL>connect / as sysdba
SQL>startup mount;
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: