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 Offline Backup
The other names given to this kind of backup are Closed/Cold/Consistent
Database backup. No recovery is needed in this kind of backup during the
restore process.
Step 1:
Shut down the database
Connect to database as SYSDBA and then use the SHUTDOWN statement with
NORMAL, IMMEDIATE or TRANSACTIONAL clause.
C:\> sqlplus /nolog
SQL>connect / as sysdba
SQL> SHUTDOWN NORMAL;
Remember that if there is any single user connected with the database
and you have used the NORMAL clause with the SHUTDOWN statement then
database will never shutdown unless the user closes the session.
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: